phpBB2 by Przemo

[Rudy_102]

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?

[Gadatliwa Kasia]

[spy]

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]

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]

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]

Juz se poradzilem