 | [Solved]Error When i create the forum |  |
 Posted: 07/29/2007 4:02 AM |
 |
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Oct 29, 2006
Local time: 8:25 AM
Location: Klang, Malaysia
|
|
|
|
|
 |
Hi , i want create a new forum on Management, but when i click sumit ,it got a error msg as like below.
| Code:
|
General Error
Couldn't insert row in forums table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_parent, forum_desc, forum_order, forum_status, allow_bump, bump_time, bump_time_period, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_download) VALUES ('103', 'phpbb Support ', 24, 0, 'Tech support for phpbb', 10, 0, 1, 0, 4, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 1, 1, 0)
Line : 551
File : admin_forums.php
|
|
|
Last edited by masteranu84 on 07/29/2007 6:45 AM; edited 1 time in total |
|
|
|
| Back to Top |
|
|
| Re: Error When i create the forum | |
| Posted: 07/29/2007 6:14 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:25 AM
Location: St Pete, FL
|
|
|
|
|
|
This was caused by a flaw in the Specify topic bumping MOD. The MOD author failed to include some code for a SQL query. So this is what I did to correct the problem:
OPEN
admin/admin_forums.php
FIND
| Code:
|
|
$sql = "INSERT INTO " . FORUMS_TABLE
|
IN-LINE FIND
IN-LINE AFTER, ADD
 |
|
|
|
|
| Back to Top |
|
|
| Re: Error When i create the forum | |
| Posted: 07/29/2007 6:44 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 8:25 AM
Location: Klang, Malaysia
|
|
|
|
|
|
huh, you has fix it for me? Thanks~~ I still follow the step and want to add the code..but i seen it already added, Thanks so much !!! I think this is the SQL problem just now..  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved]Error When i create the forum | |
| Posted: 07/30/2007 9:50 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:25 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, I fixed it. I just wanted you to know what needed to be done. It wouldn't have made sense for me to do all that research to figure out what the MOD author forgot to include in his MOD, then leave it unfixed...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
