Subforum

Marioow · Bericht door **Marioow** » 21 okt 2006, 15:12

Ik heb net simple subforum gedaan op mijn site, ook exrerm style 2.X en alles werkt op een ding na. Als ik nu een subforum wil aanmaken kirjg ik de volgende fout :

Code: Selecteer alles

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 ' , '', 60, 0, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1)' at line 2

INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_parent, 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) VALUES ('12', 'test', , , '', 60, 0, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1)

Line : 481
File : admin_forums.php

Weet iemand wat ik hier aan kan doen ?

Bericht door **Paul** » 21 okt 2006, 15:14

loop admin_forums.php nog eens na, ik vermoed dat je iets verkeerd hebt gedaan

Marioow · Bericht door **Marioow** » 21 okt 2006, 15:34

heb ik net gedaan, maar hij geeft nog steeds dezelfde fout

svenn · Bericht door **svenn** » 21 okt 2006, 15:48

van dat bestand admin_forums.php regels 470-490 graag eens posten.

Marioow · Bericht door **Marioow** » 21 okt 2006, 15:50

Code: Selecteer alles

$value_sql .= ", $value";

			}

			// There is no problem having duplicate forum names so we won't check for it.
			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $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 . ")";

			
			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_parent, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . $new_cat . ', ' . $new_parent . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
			}

			if( $HTTP_POST_VARS['prune_enable'] )
			{

				if( $HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "")
				{
					message_die(GENERAL_MESSAGE, $lang['Set_prune_data']);

Marioow · Bericht door **Marioow** » 21 okt 2006, 17:30

Het is al gelukt, hij had iets vekreerd gekopieert