|
Vain
|
 |
« Reply #60 on: September 04, 2008, 03:27:10 PM » |
|
I am getting Duplicate entry '0' for key 2
when trying to register...
Any suggestions?
|
|
|
|
|
Logged
|
|
|
|
|
Vain
|
|
« Reply #61 on: September 04, 2008, 04:05:01 PM » |
|
It lets me register the initial person but after that I get the Duplicate entry '0' for key 2 whenever someone else tries to register.
The problem is that when a new user registers it doesnt assign a value to the char_id table. it leaves it at 0, so the next person to register gets the error.
|
|
|
|
« Last Edit: September 04, 2008, 04:27:04 PM by Vain »
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #62 on: September 05, 2008, 12:27:23 AM » |
|
the id field should be auto incremental
code that makes it looks ok, ill do some testing tomorrow
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
Mardonge
Freshman
 Offline
Posts: 3
|
|
« Reply #63 on: September 10, 2008, 07:41:12 AM » |
|
Interesting work here, I'll have to try this one out when I get home from work if my line is up again by then.
Just one question... What phpBB versions are supported for user db? 2.x or 3.x?
|
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #64 on: September 10, 2008, 07:46:40 AM » |
|
this doesnt user the DB for phpBB all the data required was in the arrays provided by forum
this was made useing 3.x no idea if will work with 2.x
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Vain
|
|
« Reply #65 on: September 10, 2008, 02:39:15 PM » |
|
the id field should be auto incremental
code that makes it looks ok, ill do some testing tomorrow
Any word Temar? |
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #66 on: September 10, 2008, 03:05:19 PM » |
|
well i check my table just and id is set to auto incremental, please check you table
if its not set, set it to autoincremental
if the problem is not caused by this it will prob be the module its self and ill check it
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Vain
|
|
« Reply #67 on: September 11, 2008, 05:35:21 PM » |
|
well i check my table just and id is set to auto incremental, please check you table
if its not set, set it to autoincremental
if the problem is not caused by this it will prob be the module its self and ill check it
users.char_id or users.id? users.id is set to autoincrement but users.char_id is not. Let me clear a few things up. it is using the same table that the bot uses for org members. Is it supposed to have its own table? |
|
|
|
« Last Edit: September 11, 2008, 05:37:32 PM by Vain »
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #68 on: September 11, 2008, 05:38:01 PM » |
|
char_id ? i dont use a column called that and never have as far as i can remember
|
|
|
|
« Last Edit: September 11, 2008, 05:39:53 PM by Temar »
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Temar
|
|
« Reply #69 on: September 11, 2008, 05:41:14 PM » |
|
its has its own table lol :p
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Vain
|
|
« Reply #70 on: September 11, 2008, 05:48:52 PM » |
|
ok i must have my settings wrong.... $this -> settings["forum_sql_server"] = 'localhost';
$this -> settings["forum_sql_username"] = 'Bebot';
$this -> settings["forum_sql_password"] = 'xxxxx';
$this -> settings["bot_sql_server"] = 'localhost';
$this -> settings["bot_sql_username"] = 'Bebot';
$this -> settings["bot_sql_password"] = 'xxxxx';
$this -> settings["forum_pre"] = '';
$this -> settings["forum_db"] = 'bebot';
$this -> settings["orgbot_db"] = 'bebot';
$this -> settings["orgbot_name"] = 'Havocbot';
$this -> settings["online_orgbot_names"] = 'Havocbot';
$this -> settings["orgbot_names"] = 'Havocbot;Havocbot';
$this -> settings["twc_db"] = 'twc';
$this -> settings["twc_pre"] = '';
$this -> settings["login_table"] = '';
$this -> settings["loginbots_prefix"] = '';
$this -> settings["orgchat"] = TRUE;
$this -> settings["loginchat"] = FALSE;
$this -> settings["forum_root"] = '/var/www/twc';
$this -> settings["twc_root"] = '/var/www/twc';
$this -> settings["twc_url"] = 'http://xxx.xxx.193.108';
$this -> settings["user_data"] = 3;
$this -> settings["allow_new"] = FALSE; For some reason its using the bebot table. |
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #71 on: September 11, 2008, 05:57:19 PM » |
|
$this -> settings["forum_db"] = 'bebot';
this is the DB setting for the user table, yes i know there is also a twc_db ill fix it soon :p
If useing twc user mode and not a forum
all forum setting like database are used for the user table it makes
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Vain
|
|
« Reply #72 on: September 11, 2008, 06:00:38 PM » |
|
Thanks Temar!
I changed the forum db to twc and it works great now.
I was unaware that for a forumless install this is where the users are stored.
|
|
|
|
|
Logged
|
|
|
|
|
Vain
|
|
« Reply #73 on: September 11, 2008, 06:03:50 PM » |
|
Although when i goto the install script script, I see an option for create superadmin.
When I click on the link i get:
Fatal error: Cannot redeclare select() (previously declared in /var/www/twc/sql.php:42) in /var/www/twc/sql.php on line 42
|
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #74 on: September 11, 2008, 06:05:00 PM » |
|
yer im currently in the process of rewriting it alot, this issue will no longer exists when im done
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Content
Total Members: 1243
