RayChill Posted February 1, 2007 Share Posted February 1, 2007 This error appears when registration is set to user or admin after the new member clicks submit to join the forum. Error inserting user group, group count DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 2235, 0)' at line 2 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (, 2235, 0) Line : 1080 File : usercp_register.php This is the line listed: message_die(GENERAL_ERROR, 'Error inserting user group, group count', '', __LINE__, __FILE__, $sql); Quote Link to comment Share on other sites More sharing options...
Silverado_NL Posted February 2, 2007 Share Posted February 2, 2007 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (, 2235, 0) i think the line needs to be INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES ("", 2235, 0) because in the Values clause the 1st value is not set it cant disappear. the query needs to see it has nog value Quote Link to comment Share on other sites More sharing options...
corbin Posted February 3, 2007 Share Posted February 3, 2007 If the field is auto incrementing, you do not need to insert anything for it at all if I remember... At least which ever version of MSSQL I last used that wasn't needed lol. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.