Code: Selecteer alles
#
#-----[ ACTION: EXECUTE]-----------------------------------
#
#
SQL QUERY:
ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100);
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);
#
#-----[ ACTION: ]------------------------------------------
# OPEN: language/lang_xxx/lang_main.php
[FIND]:
//
// That's all Folks!
[ADD AFTER]:
// Categories & Forum icon MOD
$lang['Icon'] = "Icon";
####### SAVE & CLOSE: language/lang_xxx/lang_main.php #######
#############################################################
Couldn't insert row in categories 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 ')' at line 2
INSERT INTO phpbb_categories (cat_title, cat_order, cat_icon) VALUES ('test', 20, )
Line : 511
File : admin_forums.php
Code: Selecteer alles
//
// There is no problem having duplicate forum names so we won't check for it.
//
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order, cat_icon)
VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order, $caticon)";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't insert row in categories table", "", __LINE__, __FILE__, $sql);
}Hoe bedoel je dit?svenn schreef:cat_icon is niet gegeven, moet je even opzoeken waar hij verloren gaat
Code: Selecteer alles
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order, cat_icon)
VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order, $caticon)";
Code: Selecteer alles
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order, cat_icon)
VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order, '" . $HTTP_POST_VARS['caticon'] . "')";