SQL error

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
frontpage2
Registered User
Posts: 25
Joined: Fri Dec 08, 2006 9:41 pm

SQL error

Post by frontpage2 »

I get this error when trying to make a new part of forum(like offtopic and stuff)

Couldn't insert row in forums table

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 'prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delet' at line 1

INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status,forum_external, forum_redirect_url, forum_ext_newwin, forum_ext_image prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate)VALUES ('15', 'Movies', 3, 'Welke film heb jij vandaag gezien? ', 50, 0, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1)

Line : 399
File : admin_forums.php
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53398
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf »

Code: Select all

, forum_ext_image prune_enable

You did a mod, and forgot a comma. You forgot some other stuff in that statement too.
User avatar
Jim_UK
Former Team Member
Posts: 18480
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Post by Jim_UK »

Well I also count 21 fields but only 17 data entries - something sadly gone wrong there. Check any recently added mods.

Jim
The truth is out there.
Unfortunately they will not let you anywhere near it!
frontpage2
Registered User
Posts: 25
Joined: Fri Dec 08, 2006 9:41 pm

Post by frontpage2 »

Well, i got so many of them :s , i seriously dunno what to do :s
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53398
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf »

Some mod concerning changing forum names into links...
Locked

Return to “2.0.x Support Forum”