|
|
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo
|
|
wydzielony śmieć |
Autor |
Wiadomość |
Rudy_102
Posty: 6
|
Wysłany: 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? |
|
|
|
|
Gadatliwa Kasia
|
|
|
|
spy
Pomógł: 9 razy Posty: 147
|
Wysłany: 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
Posty: 6
|
Wysłany: 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
Pomógł: 413 razy Posty: 2544
|
Wysłany: 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 |
_________________ Zanim napiszesz do mnie na GG/PW, koniecznie przeczytaj zasady.
Sygnaturka to nie tablica z ogłoszeniami! PAMIĘTAJ o tym! Nadużywanie i celowe reklamowanie stron jest ZABRONIONE i karalne!
Gość, a czy Ty nie masz sobie nic do zarzucenia? |
|
|
|
|
Rudy_102
Posty: 6
|
Wysłany: 17-11-2005, 20:28
|
|
|
Juz se poradzilem |
|
|
|
|
|
Nie możesz pisać nowych tematów Możesz odpowiadać w tematach Nie możesz zmieniać swoich postów Nie możesz usuwać swoich postów Nie możesz głosować w ankietach Nie możesz załączać plików na tym forum Nie możesz ściągać załączników na tym forum
|
Dodaj temat do Ulubionych Wersja do druku
|
Kopiowanie wszelkich treści zawartych na forum, modyfikacji oraz instrukcji bez zgody administracji i autorów tematów/postów zabronione!
Powered by phpBB modified by Przemo © 2003 phpBB
| Strona wygenerowana w 0,1 sekundy. Zapytań do SQL: 13 | |
|
|