Bitte HILFE! Letzter Fehler in Album
Verfasst: 04.06.2003 11:06
Verfasst am: Di Jun 03, 2003 11:44 pm Titel: Please help Album Mod Error
--------------------------------------------------------------------------------
Hallo,
das Meiste läuft jetzt (nach der 3 Installation) aber wenn ich als Admin ein neues Album hinzufüge krieg ich unten genannten Fehler, wenn ich vom index.php aus aufs Album gehen will.
Could not query recent pics information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpb' at line 1
SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 4
Line : 259
File : /mnt/ls6/16/200/00000012/htdocs/forum/album.php
-------------------------------------------------------------------------------------
Noch ein kleines Problem:
Wenn ich im Admin KEINE neue Galerie anlege, kann ich als User vom Index aus ins Album gehen, aber bei Auswahl "öffentliche Alben" kreig ich dann:
Error getting total galleries
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'DISTINCT u.user_id) AS total FROM phpbb_users AS u, phpbb_album AS p WHERE' at line 1
SELECT COUNT(DISTINCT u.user_id) AS total FROM phpbb_users AS u, phpbb_album AS p WHERE u.user_id <> -1 AND u.user_id = p.pic_user_id AND p.pic_cat_id = 0
Line : 179
File : /mnt/ls6/16/200/00000012/htdocs/forum/album_personal_index.php
_____________________________________________________________
Vielleicht kann jemand schnell man helfen.
THX Matthias
--------------------------------------------------------------------------------
Hallo,
das Meiste läuft jetzt (nach der 3 Installation) aber wenn ich als Admin ein neues Album hinzufüge krieg ich unten genannten Fehler, wenn ich vom index.php aus aufs Album gehen will.
Could not query recent pics information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpb' at line 1
SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 4
Line : 259
File : /mnt/ls6/16/200/00000012/htdocs/forum/album.php
-------------------------------------------------------------------------------------
Noch ein kleines Problem:
Wenn ich im Admin KEINE neue Galerie anlege, kann ich als User vom Index aus ins Album gehen, aber bei Auswahl "öffentliche Alben" kreig ich dann:
Error getting total galleries
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'DISTINCT u.user_id) AS total FROM phpbb_users AS u, phpbb_album AS p WHERE' at line 1
SELECT COUNT(DISTINCT u.user_id) AS total FROM phpbb_users AS u, phpbb_album AS p WHERE u.user_id <> -1 AND u.user_id = p.pic_user_id AND p.pic_cat_id = 0
Line : 179
File : /mnt/ls6/16/200/00000012/htdocs/forum/album_personal_index.php
_____________________________________________________________
Vielleicht kann jemand schnell man helfen.
THX Matthias
