mySWL Query Fehler nach update
Hallo!
Muss mich das beunruhigen?
Gruß
Thomas
Fehlertyp: Fehler
Fehlermeldung: Cannot run database query SELECT m.media_id, m.media_users_id, m.media_title, m.media_duration, UNIX_TIMESTAMP(m.media_upload_date) media_upload_timestamp, m.media_key, m.media_conversion_in
Datei: includes/class.database.php (127)
Trace
trigger_error in includes/class.database.php (315)
Parameter:
* string: Cannot run database query SELECT m.media_id, m.media_users_id, m.media_title, m.media_duration, UNIX_TIMESTAMP(m.media_upload_date) media_upload_timestamp, m.media_key, m.media_conversion_info, m.media_type, m.media_views, m.media_comments_count, m.media_accept_ratings, m.media_accept_comments, c2m.channels2media_channel_id, c2m.channels2media_media_id FROM ost_media m, ost_channels2media c2m WHERE c2m.channels2media_channel_id = '8' AND c2m.channels2media_media_id = m.media_id AND m.media_type = 'photo' AND (m.media_access='public') AND m.media_conversion_status = 'success' AND m.media_notified_status = 'legal' ORDER BY media_upload_date DESC LIMIT -12,28 Error: 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 '-12,28' at line 24
* integer: 256
DBaccess->_query in includes/class.database.php (228)
Parameter:
* string: SELECT m.media_id, m.media_users_id, m.media_title, m.media_duration, UNIX_TIMESTAMP(m.media_upload_date) media_upload_timestamp, m.media_key, m.media_conversion_info, m.media_type, m.media_views, m.media_comments_count, m.media_accept_ratings, m.media_accept_comments, c2m.channels2media_channel_id, c2m.channels2media_media_id FROM ost_media m, ost_channels2media c2m WHERE c2m.channels2media_channel_id = '8' AND c2m.channels2media_media_id = m.media_id AND m.media_type = 'photo' AND (m.media_access='public') AND m.media_conversion_status = 'success' AND m.media_notified_status = 'legal' ORDER BY media_upload_date DESC LIMIT -12,28
DBaccess->query in includes/class.mediainformation.php (756)
Parameter:
* string: SELECT m.media_id, m.media_users_id, m.media_title, m.media_duration, UNIX_TIMESTAMP(m.media_upload_date) media_upload_timestamp, m.media_key, m.media_conversion_info, m.media_type, m.media_views, m.media_comments_count, m.media_accept_ratings, m.media_accept_comments, c2m.channels2media_channel_id, c2m.channels2media_media_id FROM ost_media m, ost_channels2media c2m WHERE c2m.channels2media_channel_id = '8' AND c2m.channels2media_media_id = m.media_id AND m.media_type = 'photo' AND (m.media_access='public') AND m.media_conversion_status = 'success' AND m.media_notified_status = 'legal' ORDER BY media_upload_date DESC LIMIT -12,28
* string: medialist
MediaInformation->getListInformation in media.php (121)
Parameter:
* integer: 8
* string: photo
* integer: -12
* string: ratingregion=0region=0region=0region=0
- Anmelden um Kommentare zu schreiben

Hallo Thomas
Hmm - da scheint bei einer Blätteraktion im Photo Bereich etwas schief zu gehen (
LIMIT -12,28sollte sicherlichLIMIT 12,28lauten). Leider kann ich das hier nicht reproduzieren. Kannst Du mal nachforschen bei welcher Aktion genau das passiert?Grüsse
-- osTube Entwicklerteam, Karsten