Rudy_102 - 13-11-2005, 15:20 Mam ten sam problem, jestem zielony, nie rozumie za wiele z tego i nie wiem gdzie robie blad. Uruchomilem ten path i wyskoczylo mi cos takiego: 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 'FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ' at line 3 Line : 230 File : admin_mysql.php Naprawde nie wiem co z tym zrobic 
mozecie zamiescic poprawny kod? spy - 13-11-2005, 15:30 Przeklikałem u siebie cały album, zanim umieściłem tego patcha. Nie było błędów. Może zróbmy tak, opisz dokładnie co klikasz, gdzie i podaj tutaj adres, który pojawia Ci się w przeglądarce, gdy dostajesz ten błąd. To naprawdę bardzo pomaga w lokalizacji błędu. Podaj też adres forum. Wtedy może da się coś poradzić. Rudy_102 - 13-11-2005, 22:02 Po uruchomieniu tego duzego kodu wyswietle sie cos takiego: Nie mogę wykonać: ### [OPEN] album.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM ((((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_cat.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM (((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_comment_delete.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM ((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_comment_edit.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM ((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_modcp.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM (((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_page.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM (((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_personal.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM ((". ALBUM_TABLE ." AS p LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_portal.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id ### [REPLACE WITH] FROM ((((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id) ### [OPEN] album_rate.php ### [FIND] FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id ### [REPLACE WITH] FROM ((". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id) LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id) ### [OPEN] posting.php ### [FIND] $sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM " . GROUPS_TABLE . " g, " . USERS_TABLE . " u ### [REPLACE WITH] $sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM (" . GROUPS_TABLE . " g, " . USERS_TABLE . " u) ### [OPEN] report.php ### [FIND] FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id ### [REPLACE WITH] FROM (((" . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt) LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id) LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id) ### [FIND] FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id ### [REPLACE WITH] FROM (((" . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt) LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id) LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id) ### [OPEN] includes/usercp_register.php ### [FIND] $sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u ### [REPLACE WITH] $sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM (" . GROUPS_TABLE . " g, ".USERS_TABLE." u); Kliknij Tutaj żeby powrócić. 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 'FROM ". ALBUM_TABLE ." AS p LEFT JOIN ". USERS_TABLE ." AS u O' at line 3 Line : 230 File : admin_mysql.php to wszystko. Adres mojego forum to: http://www.teatrepidemia.haa.pl chelloPL - 13-11-2005, 22:49 A mówią, że głupota ludzka nie ma granic  Mają rację!
Rudy_102, zastanów się przez 10 sekund co zrobiłeś... To nie jest kod do klejenia do SQL 
Rudy_102 - 17-11-2005, 20:28 Juz se poradzilem 
|
||||||
