heh dzis zobaczyłem, że jak edytuje posty to wywala mi taki błąd
Cytuj:
Error in posting
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 'WHERE post_id = 14' at line 1
UPDATE phpbb_posts_text SET post_text = '[img:3d4f89c555]http://images4.fotosik.pl/284/1ae84bba2bba0135.gif[/img:3d4f89c555] - top [img:3d4f89c555]http://images12.fotosik.pl/10/a58e01ac827026a9.gif[/img:3d4f89c555] - whoisonline [img:3d4f89c555]http://images11.fotosik.pl/17/6ff4c2203326104a.gif[/img:3d4f89c555] [img:3d4f89c555]http://images14.fotosik.pl/10/182f8a4873e99d27.gif[/img:3d4f89c555] [img:3d4f89c555]http://images11.fotosik.pl/17/fe342cee809f0dc6.gif[/img:3d4f89c555]', bbcode_uid = '3d4f89c555', post_subject = 'grafika dla forum', mods_notice = '', WHERE post_id = 14
Line : 269
File : functions_post.php
nie wiem po jaki modzie , moje liniki :
255-275
[php]<?php
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain post information', '', __LINE__, __FILE__, $sql);
}
$mods_notice = $db->sql_fetchrow($result);
$mods_notice_text = $mods_notice['mods_notice'];
$mn_bbcode_uid = $mods_notice['bbcode_uid'];
$mods_notice_text = str_replace($mn_bbcode_uid , $bbcode_uid, $mods_notice_text);
$sql = ($mode != 'editpost') ? "INSERT INTO " . POSTS_TEXT_TABLE . " (post_id, post_subject, bbcode_uid, post_text) VALUES ($post_id, '$post_subject', '$bbcode_uid', '$post_message')" : "UPDATE " . POSTS_TEXT_TABLE . " SET post_text = '$post_message', bbcode_uid = '$bbcode_uid', post_subject = '$post_subject', mods_notice = '$mods_notice_text', WHERE post_id = $post_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
add_search_words('single', $post_id, stripslashes($post_message), stripslashes($post_subject));
//
// Add poll
?>[/php]
[php]<?php
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
?>[/php] < --- 269, gdzi błąd??

[/phpbb]