|
|
Auteur |
|
Message |
leogeats
Sexe: Inscrit le: 26 Sep 2007 Messages: 41 Localisation: Bordeaux
Âge: 52
|
|
Posté: Lun 23 Avr 2012 20:48
Sujet du message: Probleme technique
|
|
|
Voici le message que je lis pour chaque livre :
Echec de la requête
DEBUG MODE
SQL Error : 145 Table './jmandre@002dago2/agora_works' is marked as crashed and should be repaired
SELECT b.*, bi.*, i.*, u.username, pt.post_text, SUM(IF(b2.book_topic_id>0,1,0)) as note_count, w.work_id, w.work_title, w.work_authors, COUNT(b2.book_id) as work_book_count, ROUND(AVG(b2.book_rating)) as work_average FROM agora_books b LEFT JOIN agora_bookinfos bi ON b.book_id = bi.bookinfo_bookid LEFT JOIN agora_isbn i ON b.book_isbn13 = i.isbn_isbn LEFT JOIN phpbb_topics t ON t.topic_id = b.book_topic_id LEFT JOIN phpbb_posts_text pt ON t.topic_first_post_id = pt.post_id LEFT JOIN phpbb_users u ON b.book_user_id = u.user_id LEFT JOIN agora_mapping_works mw ON mw.mw_book_id = b.book_id LEFT JOIN agora_works w ON w.work_id = mw.mw_work_id LEFT JOIN agora_mapping_works mw2 ON mw2.mw_work_id = mw.mw_work_id LEFT JOIN agora_books b2 ON b2.book_id = mw2.mw_book_id WHERE b.book_id = 80687 AND b2.book_user_id <> -1 GROUP BY w.work_id LIMIT 1
Line : 141
File : agora_book.php
|
|
|
|
|
|
|
Auteur |
|
Message |
mamoune
Sexe: Inscrit le: 24 Sep 2005 Messages: 2131 Localisation: Ste Foy les Lyon (69)
Âge: 62
|
|
|
|
| | |