Cannot create forums

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
orij1nal
Registered User
Posts: 20
Joined: Wed Jul 11, 2007 8:24 pm

Cannot create forums

Post by orij1nal » Fri Jul 20, 2007 7:52 pm

I was trying to create a new forum but I got this error..
Couldn't insert row in forums table

Code: Select all

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

INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc, forum_desc_long, forum_order, forum_status, forum_icon prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('19', 'The Drive of Life - 歲月風雲', 4, 'Discuss about anything that is related to this series. ',forum_desc_long = '', 40, 0, '', 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1)

Line : 409
File : admin_forums.php
My site is http://www.hkmediaonline.com

Is there a way to fix this?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51870
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Cannot create forums

Post by Brf » Fri Jul 20, 2007 7:53 pm

You made an error when you installed your forum_icon mod. You have an error further along too, where it says "forum_desc_long="

orij1nal
Registered User
Posts: 20
Joined: Wed Jul 11, 2007 8:24 pm

Re: Cannot create forums

Post by orij1nal » Fri Jul 20, 2007 8:02 pm

what should i do to fix this?

orij1nal
Registered User
Posts: 20
Joined: Wed Jul 11, 2007 8:24 pm

Re: Cannot create forums

Post by orij1nal » Fri Jul 20, 2007 8:06 pm

nvm, fixed it, just needed to add the comma between forum_icon and prune. thanks btw though

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51870
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Cannot create forums

Post by Brf » Fri Jul 20, 2007 8:08 pm

You still have an error in your long_descrption mod though.

orij1nal
Registered User
Posts: 20
Joined: Wed Jul 11, 2007 8:24 pm

Re: Cannot create forums

Post by orij1nal » Fri Jul 20, 2007 8:15 pm

hmm? what is the error?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51870
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Cannot create forums

Post by Brf » Fri Jul 20, 2007 8:24 pm

forum_desc_long = ''
That should have the code containing the variable for your long description.
I have no idea what it should look like. You would need to ask in the support thread for that mod.

Locked

Return to “2.0.x Support Forum”