|
Unofficial modifications nieoficjalne modyfikacje for?w phpBB by Przemo |
|
Problemy z dzia?aniem forum - b??dy mysql - Po wgraniu moda Forum Images i Beer Mod
kidzior - Wto 30 Maj, 2006 Temat postu: Po wgraniu moda Forum Images i Beer Mod Hey
B?edy wyst?puj? dwa:
1. Pierwszy ilustruje zdj?cie poni?ej.
Z tego co pami?tam, powinien by? jeszcze gdzie? chyba opis Forum
2. Po klikni?ciu na Wy?lij mam B??d Og?lny:
Kod | B??d Og?lny
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 ' 390, 0, 'SORT_FPDATE', '', '', 0, 0, 0, 2, 1, 0, '', 0, 0, 0, 3, 0, 0, '', 0, 0' at line 2
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc,forum_image_url, forum_image_url_new, forum_order, forum_status, forum_sort, password, forum_color, forum_moderate, no_count, forum_trash, forum_separate, forum_show_ga, prune_enable, forum_link, forum_link_internal, forum_link_hit_count, forum_tree_req, forum_tree_grade, forum_no_helped, forum_no_split, topic_tags, locked_bottom, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_globalannounce, auth_vote, auth_pollcreate, auth_attachments, auth_download, main_type) VALUES ('33', 'xxx', 1, '','', '',, 390, 0, 'SORT_FPDATE', '', '', 0, 0, 0, 2, 1, 0, '', 0, 0, 0, 3, 0, 0, '', 0, 0, 0, 1, 0, 1, 1, 3, 3, 5, 1, 1, 1, 0, 'c')
Line : 825
File : admin_forums.php |
Wklejam linie 820-830 z pliku admin_forums.php
PHP Code: | <?php
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc,forum_image_url, forum_image_url_new, forum_order, forum_status, forum_sort, password, forum_color, forum_moderate, no_count, forum_trash, forum_separate, forum_show_ga, prune_enable, forum_link, forum_link_internal, forum_link_hit_count, forum_tree_req, forum_tree_grade, forum_no_helped, forum_no_split, topic_tags, locked_bottom" . $field_sql . ")
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', $cat_id, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "','" . str_replace("\'", "''", $HTTP_POST_VARS['forumimageurl']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumimageurlnew']) . "',, $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumsort']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['password']) . "', '" . str_replace("\'", "''", str_replace("#", "", $HTTP_POST_VARS['forum_color'])) . "', $post_moderate, $post_no_count, $forum_trash, " . intval($HTTP_POST_VARS['forum_separate']) . ", " . intval($HTTP_POST_VARS['forum_show_ga']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . ", '$forum_link', $forum_link_internal, $forum_link_hit_count, " . intval($HTTP_POST_VARS['forum_tree_req']) . ", " . intval($HTTP_POST_VARS['forum_tree_grade']) . ", " . intval($HTTP_POST_VARS['forum_no_helped']) . ", " . intval($HTTP_POST_VARS['forum_no_split']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['topic_tags']) . "', $locked_bottom" . $value_sql . ")";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
}
sql_cache('clear', 'multisqlcache_forum');
sql_cache('clear', 'forum_data');
admin_check_cat();
get_user_tree($userdata);
?> |
No i co si? mog?o spsu?
qbs - Wto 30 Maj, 2006
co to za forum_image_url_new? a odnosnie braku pola opis - zle przerobiony plik stylu
kidzior - Wto 30 Maj, 2006
qbs napisał/a | co to za forum_image_url_new? |
Zmodyfikowane nowe tematy. Ikonka si? mo?e np. migac przy nowych postach w danym forum. (Oczywi?cie przy obrazku odpowiednim migaj?cym si?.
qbs - Wto 30 Maj, 2006
a tak wogole to zauwazyles ze w zapytaniu masz 2 przecinki?
PHP Code: | <?php
$HTTP_POST_VARS['forumimageurlnew']) . "',,
?> |
kidzior - Sro 31 Maj, 2006
qbs napisał/a | a tak wogole to zauwazyles ze w zapytaniu masz 2 przecinki?
PHP Code: | <?php
$HTTP_POST_VARS['forumimageurlnew']) . "',,
?> |
|
Racja, racja. Poprawione i dzia?a. A gdzie mog?em co? popsu? konkretnie przy edytowaniu stylu?
Browarek si? nale?y.
qbs - Sro 31 Maj, 2006
zapewne usuneles czesc odpowiedzialna za edycje opisu
kidzior - Pon 12 Cze, 2006
qbs napisał/a | zapewne usuneles czesc odpowiedzialna za edycje opisu |
Gdzie mog?em zrobi? b??d konkretnie? Za??czam m?j pliczek forum_admin_body.tpl, mam nadziej?, ze to on i kto? b?dzie w stanie mi pom?c.
|
|