Could not insert data into users table

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
digitalhome
Registered User
Posts: 38
Joined: Sun Apr 07, 2002 4:11 pm
Contact:

Could not insert data into users table

Post by digitalhome »

HI,
Everything seems to work and users can add posts but whenever a new user trys to register, get the following error message

Could not insert data into users table.

Help is greatly appreciated!
Kage Musha
Registered User
Posts: 444
Joined: Sun Dec 23, 2001 10:03 pm
Location: Someone's Heart
Contact:

Post by Kage Musha »

could you post these lines:

Code: Select all

$sql = "UPDATE " . USERS_TABLE . "
and the 2 lines after this?

and also

Code: Select all

 $sql = "INSERT INTO " . USERS_TABLE . 
the whole line and the line after this line.

Find these lines in include/usercp_register.php
https://www.rpggarden.com Development: Battle Mod
Released: PS2 Theme
Image Search b4 asking (less work for us :lol: )
Plz do not abuse my IM mediums or I'll have to block ya :evil:
User avatar
rmang
Registered User
Posts: 285
Joined: Fri Aug 24, 2001 10:33 pm

Post by rmang »

http://www.phpbb.com/phpBB/viewtopic.php?t=10263

Announcement Forum addresses this. ;)

Rob M.
Kage Musha
Registered User
Posts: 444
Joined: Sun Dec 23, 2001 10:03 pm
Location: Someone's Heart
Contact:

Post by Kage Musha »

or that lol :lol:
haven't thought of that >_<
:oops:
https://www.rpggarden.com Development: Battle Mod
Released: PS2 Theme
Image Search b4 asking (less work for us :lol: )
Plz do not abuse my IM mediums or I'll have to block ya :evil:
Der Robe
Registered User
Posts: 54
Joined: Fri Apr 05, 2002 10:10 pm
Contact:

Post by Der Robe »

I am having the same problem as above plus I am not allowed to update existing user profiles. Where am I suppost to post that code at. (please be as exact a possible)
WANTED:
Artists and debaters

The Pit
User avatar
digitalhome
Registered User
Posts: 38
Joined: Sun Apr 07, 2002 4:11 pm
Contact:

Post by digitalhome »

$sql = "UPDATE " . USERS_TABLE . "
SET user_active = 1, user_actkey = ''" . $sql_update_pass . "
WHERE user_id = " . $row['user_id'];
User avatar
digitalhome
Registered User
Posts: 38
Joined: Sun Apr 07, 2002 4:11 pm
Contact:

Post by digitalhome »

rmang, thanks, I apologize because i had done a search and did not see that thread.
Der Robe
Registered User
Posts: 54
Joined: Fri Apr 05, 2002 10:10 pm
Contact:

Post by Der Robe »

I am extremely sorry but that link you posted where do I run that command from? Somewhere in in the forum? Or somewhere else? I have never really used mysql. Can you give me a step by step on what I need to do from the root directory. I am running e-smith server if that helps.
WANTED:
Artists and debaters

The Pit
Locked

Return to “2.0.x Support Forum”