Probleem met Catagories mod.

[micha3L]

Hallo,
Alles is goed gegaan met deze mod maar dan ga ik een forum aanmaken , klik op ok en krijg vervolgens deze fout:

Code: Selecteer alles

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_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count) VALUES ('2', 'sdfsd', 1, 'sdff', 30, 0, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 'c', '', 0, 0)

Line : 717
File : c:\server\files\phpbbsupport\admin\admin_forums.php

Dit is regel 717 van mn admin_forums.php:

Code: Selecteer alles

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', $cat_id, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

Alvast bedankt

PS; Misschien kan iemand ff admin_forums.php ff sturen die ook sub-forum mod gebruikt, want nu krijg ik overal fouten over dat bestand.

[WebSiteNet]

Probeer de query zo eens:

Code: Selecteer alles

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, main_type, forum_link, forum_link_internal, forum_link_hit_count) 
            VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', $cat_id, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

[micha3L]

mm nu heb ik een hele rare fout, pb me ff voor de admin w8woord en username, dan kun je ff kijken.

[Carlo Claessen]

File : c:\server\files\phpbbsupport\admin\admin_forums.php

ik denk dat je het op dat forum moet gaan proberen!!!!

topic gesloten!!!