Page 1 of 2
Mysql error 1064: You have an error in your SQL syntax..
Posted: Mon Feb 04, 2019 10:08 pm
by S_Flash
(c) SmartCJ Pro V 2.1 Your Build 201902041303 (Current build: 201902041303 )
При добавлении галерей:
2019-02-04 17:05:11 : Mysql 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 'LIMIT 1' at line 1 (SELECT * FROM rot_gallery_data1 WHERE gallery_id = LIMIT 1 )
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Tue Feb 05, 2019 4:02 am
by admin
Скиньте плз админку и что где как именно делать что б увидеть проблему
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Wed Feb 06, 2019 9:45 am
by S_Flash
UPD: (c) SmartCJ Pro V 2.1 Your Build 201902041303 (Current build: 201902041303 )
База когда-то переносилась\конвертилась с версии 1.
2019-02-06 04:43:11: Create Category thumbs (set ) (0.012403964996338, 0.0013420581817627)
2019-02-06 04:43:11: Cat shift 1 (0.012798070907593, 0.00039410591125488)
2019-02-06 04:43:11: Updating Cat0 (Array
(
[cat0_type] => cat0
[set_id] => 0
[thumb_shift] => 1
[content_type] => 0
[site_id] => 1
[site_stat_id] => 1
)
) (0.013142108917236, 0.00034213066101074)
2019-02-06 04:43:11: Select best cat thumbs for Amateur (id: 4), shift 1 (0.2198851108551, 0.2067391872406)
2019-02-06 04:43:11: Select data for thumb_id 58278 (0.22309112548828, 0.0032029151916504)
2019-02-06 04:43:11: Mysql 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 'LIMIT 1' at line 1 (SELECT * FROM rot_gallery_data1 WHERE gallery_id = LIMIT 1 ) (0.2233681678772, 0.00027680397033691)
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Wed Feb 06, 2019 7:08 pm
by admin
run update plz
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Wed Feb 06, 2019 7:11 pm
by S_Flash
(c) SmartCJ Pro V 2.1 Your Build 201902041303 (Current build: 201902041303 )
Вроде версия не поменялась. Или это не всегда актуально?
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Wed Feb 06, 2019 7:59 pm
by admin
Оно номер версии проверяет раз в день
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Wed Feb 06, 2019 8:26 pm
by S_Flash
(c) SmartCJ Pro V 2.1 Your Build 201902062207 (Current build: 201902062207 )
Категорийные тумбы не появляются уже час, как проапдейтил.
Кеш не подключал.
Немколько раз нажимал на "Create category thumbs".
Ошибка перестала появляться.
Rotation -> List Thumbs -> Category Thumbs - Пусто
rotation.log
2019-02-06 15:44:11: Check if we have to create Rotation - Pages (0.0063979625701904, 0.00020408630371094)
2019-02-06 15:44:11: Create Category thumbs (set ) (0.0073509216308594, 0.00094914436340332)
2019-02-06 15:44:11: Cat shift 1 (0.0081188678741455, 0.00076794624328613)
2019-02-06 15:44:11: Updating Cat0 (Array
(
[cat0_type] => cat0
[set_id] => 0
[thumb_shift] => 1
[content_type] => 0
[site_id] => 1
[site_stat_id] => 1
)
) (0.0082869529724121, 0.0001671314239502)
2019-02-06 15:44:11: Select best cat thumbs for Amateur (id: 4), shift 1 (0.13076400756836, 0.12247490882874)
2019-02-06 15:44:11: Select data for thumb_id 58278 (0.1417338848114, 0.010967016220093)
2019-02-06 15:44:11: Mysql 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 'LIMIT 1' at line 1 (SELECT * FROM rot_gallery_data1 WHERE gallery_id = LIMIT 1 ) (0.14204096794128, 0.00030708312988281)
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Thu Feb 07, 2019 8:21 am
by admin
sorry my fault. Please, run update
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Thu Feb 07, 2019 9:36 am
by S_Flash
Done.
Fixed!
Thanks.
Re: Mysql error 1064: You have an error in your SQL syntax..
Posted: Thu Feb 07, 2019 12:39 pm
by admin
Сорри за задержку.