13
« on: December 23, 2002, 01:39:08 AM »
Sometime today I made a change that has created a problem. Everything is working okay except registration. When I try to register a new user, it gives me this sql error:
DB Error: Bad SQL Query: INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_lastvisit, user_comments, user_homepage) VALUES (3, 1, 'newuser', '008c5926ca861023c1d2a36653fd88e2', 'newuser@selfdefensearts.com', 1, 1, 0, 1040603379, '7941b8b3725b09cef91fb301f77cbb7c', 1040603379, 1040603379, 0, '', )
You have an error in your SQL syntax near ')' at line 4
This has also happened since I added a new user into the database by inserting a row since I had no email address for the person I needed to enter. Once I tried to add another new user through register.php I started getting errors and that other entry has disappeared. I don't know if this has anything to do with my error now.
I've made a lot of changes in the files and don't want to start all over again. Somebody please help!