Couldn't insert row in forums table

[arnem]

Hi!

Wie kommt das mit einmal?

Ich wollte nur ein neues Forum installieren...

[Mister_X]

Hast du etwas an der deinPrefix_forums Tabelle verändert ? Hast du überhaupt in letzter Zeit was am Forum verändert ?

[arnem]

Hi!

Also:
- prefix ist unverändert (alle anderen Aktionen wie posten, User registrieren laufen)
- folgende Mods sind drauf gekommen:
At-a-Glance, MyCalender

Ich habe die beiden neuen Foren jetzt über den SQL-Admin eingetragen.

[Acid]

..aktiviere ma den Debug Modus und poste die genauere Meldung.

[arnem]

Code: Alles auswählen

Couldn't insert row in forums table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO mohaabb_forums (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, events_forum, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('11', 'test', 4, 'test', 50, 0, 0, 0, 0, 0, 0, 1, 1, 1, 3, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 3, 1, 1)

Line : 401
File : /xx/phpbb/admin/admin_forums.php

[Acid]

..kannst ma den kompletten INSERT INTO Block aus der admin_forums.php posten (etwa Zeile 395)?

..gehört "events_forum" zu At-A-Glance?

[arnem]

Code: Alles auswählen

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, events_forum" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ", " . intval($HTTP_POST_VARS['events_forum']) . $value_sql . ")";

if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
}

"events_forum" gehört zu Mycalendar

[Acid]

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, events_forum" . $field_sql . ")
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ", " . intval($HTTP_POST_VARS['events_forum']) . $value_sql . ")";

..lösch ma den blauen Teil (>> $value_sql . <<).

[arnem]

Läuft!!

Danke, Acid!

Wo habe ich mir das bloß eingefangen?