Хотел создать новый раздел в своей галерее и залить фоток…
Нажал на главной странице “галерея”, затем “моя галерея” (уже залогиненный) и выпала такая ошибка:
Общая ошибка
Error in obtaining photos info
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 ‘AND c.type=1 AND p.approved=1’ at line 23
SELECT p.id, p.user_id, p.date as date, p.title, p.description, p.bigimage as bigimage, p.width, p.height, p.filesize, p.views as views, p.medwidth, p.medheight, p.medsize, p.approved, p.lastpost as lastpost, p.rating as rating, p.votes as votes FROM photo_photos p, photo_photos_cat pc, photo_categories c WHERE p.bigimage!=‘’ AND p.id=pc.photo_id AND c.id=pc.cat_id AND p.user_id= AND c.type=1 AND p.approved=1
Line : 298
File : /var/www/gallery.rcdesign.ru/www/showgallery.php
проверял на 2х компах + браузерах Опера и ИЕ…
Выйти\войти в разделе галереи пробовал…
Спасибо. Потом посмотрим.
Исправлено
{"assets_hash":"a8b26fa7f6e768b07a72c8c9aadb9422","page_data":{"users":{"39c21abc3df9550077797d18":{"_id":"39c21abc3df9550077797d18","hid":349,"name":"Vitaly","nick":"Vitaly","avatar_id":null,"css":""},"420b30643df955007779233c":{"_id":"420b30643df955007779233c","hid":6009,"name":"Stray_Cat","nick":"Stray_Cat","avatar_id":null,"css":""}},"settings":{"can_see_ip":false,"can_report_abuse":false,"can_see_hellbanned":false,"forum_can_view":true,"forum_can_reply":false,"forum_edit_max_time":30,"forum_can_close_topic":false,"forum_show_ignored":false,"forum_mod_can_delete_topics":false,"forum_mod_can_hard_delete_topics":false,"forum_mod_can_see_hard_deleted_topics":false,"forum_mod_can_edit_posts":false,"forum_mod_can_pin_topic":false,"forum_mod_can_edit_titles":false,"forum_mod_can_close_topic":false,"can_vote":false,"forum_mod_can_add_infractions":false,"forum_topic_title_min_length":10,"forum_reply_old_post_threshold":30,"votes_add_max_time":168,"forum_show_post_interval":7,"can_see_deleted_users":false},"section":{"_id":"61c9a54c3df9550077bb511a","hid":49,"title":"Пыльный чулан","parent":"61c9a54c3df9550077bb50c6","description":"Решенные вопросы / потерявшие актуальность / то чем никто не собирается заниматься / что накрылось медным тазом. Для истории.","is_category":false,"is_votable":true,"is_writable":false,"cache":{"topic_count":1150,"post_count":9668,"last_post":"63b9a721563b07d603ea9a67","last_topic":"63b558ee5050bcde79aafb48","last_topic_hid":571698,"last_topic_title":"Не могу отредактировать пост в блоге","last_ts":"2023-01-07T17:08:49.356Z","last_user":"3bc09af03df9550077797e57"}},"topic":{"_id":"443b49b59970730077fd7615","hid":39603,"title":"Ошибка в \"моей галерее\"","views_count":2048,"last_post_counter":3,"cache":{"post_count":3,"first_post":"443b49b59970730077fd7d83","first_ts":"2006-04-11T06:16:21.000Z","first_user":"420b30643df955007779233c","last_post":"447d71799970730077fd7d87","last_post_hid":3,"last_ts":"2006-05-31T10:35:37.000Z","last_user":"39c21abc3df9550077797d18"},"st":1,"section":"61c9a54c3df9550077bb511a"},"subscription":null,"pagination":{"total":3,"per_page":25,"chunk_offset":0},"posts_list_before_post":["paginator","datediff"]},"locale":"en-US","user_id":"000000000000000000000000","user_hid":0,"user_name":"","user_nick":"","user_avatar":null,"is_member":false,"settings":{"can_access_acp":false,"can_use_dialogs":false,"hide_heavy_content":false},"unread_dialogs":false,"footer":{"rules":{"to":"common.rules"},"contacts":{"to":"rco-nodeca.contacts"}},"navbar":{"tracker":{"to":"users.tracker","autoselect":false,"priority":10},"forum":{"to":"forum.index"},"blogs":{"to":"blogs.index"},"clubs":{"to":"clubs.index"},"market":{"to":"market.index.buy"}},"recaptcha":{"public_key":"6LcyTs0dAAAAADW_1wxPfl0IHuXxBG7vMSSX26Z4"},"layout":"common.layout"}
