Error on PHPBB 2.0.10 Help Please

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
paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Error on PHPBB 2.0.10 Help Please

Post by paulburgman »

My board suffers from a couple of problems, but it is not consistant. When a new user registers, it is usually OK, however once in a while it produces this error

DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

INSERT INTO groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0)

Line : 542
File : /home/f8andbecom/public_html/includes/usercp_register.php


And a null value is placed in the groups table, then every newly registered member gets the same message, change the groups record to the next incrememnt or delete the null value and it all seems to start working again, until a day or two later it does it again.

Also anyone that registers whilts the fault is happening, can't have their group membership or permissions changed, I just get this error

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 ' 1, 1, 1, 1, 1, 1, 1, 0)' at line 2

INSERT INTO auth_access (forum_id, group_id, auth_read, auth_post, auth_reply, auth_edit, auth_pollcreate, auth_attachments, auth_download, auth_mod) VALUES (24, , 1, 1, 1, 1, 1, 1, 1, 0)

Line : 391
File : /home/f8andbecom/public_html/admin/admin_ug_auth.php



I'd be grateful for any assistance

CHEERS
Kind regards


Paul Burgman
www.f8andbethere.com
paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Post by paulburgman »

I have changed the value of the MySQL database for the groups table group_id values from default=0 to autoincrement and have tested adding newusers and deleteing them without (yet) any problems.

I am sure that this isn't the answer so any suggestions greatefully received
Kind regards


Paul Burgman
www.f8andbethere.com
espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

Actually, it is the correct way to fix it - the PHPBB code assumes that the group_id field will auto-increment.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Post by paulburgman »

Thanks for your reply, I thought it might have been a little more obscure than that, however I will have problems I am sure as members have joined after the error message (will they not have a valid goup_id?) any ideas on fixing that?

Cheers
Kind regards


Paul Burgman
www.f8andbethere.com
espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

Try re-running the group_id fix script, and it should fix any joined-since-fix problems.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Post by paulburgman »

Sorry to a be complete dimwit, where do I find the group_id fix script?

Cheers
Last edited by paulburgman on Wed Apr 06, 2005 7:25 pm, edited 1 time in total.
Kind regards


Paul Burgman
www.f8andbethere.com
geocator
Registered User
Posts: 16242
Joined: Fri Jan 09, 2004 11:56 pm
Location: On dry land
Contact:

Post by geocator »

paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Post by paulburgman »

Tried the script and all I get is

Tried running the script and I get the following error
Error Message wrote: Parse error: parse error, unexpected T_STRING in /home/f8andbecom/public_html/fix.php on line 20

line 20 wrote:     message_die(GENERAL_ERROR, 'Could not obtain user list', '', __LINE__, __FILE__, $sql);


Any help appreciated
Kind regards


Paul Burgman
www.f8andbethere.com
The Techboy
Registered User
Posts: 207
Joined: Tue May 04, 2004 7:37 pm

Post by The Techboy »

Just as an extra note, upgrade from version 2.0.10 to 13.
Eat recycled food. It's good for the environment and OK for you.
paulburgman
Registered User
Posts: 53
Joined: Tue May 04, 2004 3:01 pm
Location: Surrey
Contact:

Post by paulburgman »

I am planning on doing the upgrade next monday when I have enough time (I have already warned the users that I will be doing it then)

Cheers
Kind regards


Paul Burgman
www.f8andbethere.com
espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

I just copy/pasted the script from the referenced message into a file on my system, and it ran fine. How did you save it on your system?

I would have sent you to this topic which has a script that does the same thing.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
Locked

Return to “2.0.x Support Forum”