Pagina 1 van 1

Probleem met Catagories mod.

Geplaatst: 05 okt 2003, 16:02
door 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.

Geplaatst: 05 okt 2003, 17:21
door 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 . ")";

Geplaatst: 05 okt 2003, 17:58
door micha3L
mm nu heb ik een hele rare fout, pb me ff voor de admin w8woord en username, dan kun je ff kijken.

Geplaatst: 05 okt 2003, 19:03
door Carlo Claessen
File : c:\server\files\phpbbsupport\admin\admin_forums.php
ik denk dat je het op dat forum moet gaan proberen!!!!

topic gesloten!!!