Mysql error 1064: You have an error in your SQL syntax..

Постим сюда все найденые ошибки
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Mysql error 1064: You have an error in your SQL syntax..

Post 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 )
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by admin »

Скиньте плз админку и что где как именно делать что б увидеть проблему
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Mysql error 1064: You have an error in your SQL syntax..

Post 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)
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by admin »

run update plz
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by S_Flash »

(c) SmartCJ Pro V 2.1 Your Build 201902041303 (Current build: 201902041303 )
Вроде версия не поменялась. Или это не всегда актуально?
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by admin »

Оно номер версии проверяет раз в день
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Mysql error 1064: You have an error in your SQL syntax..

Post 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)
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by admin »

sorry my fault. Please, run update
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by S_Flash »

Done.
Fixed!
Thanks.
admin
Site Admin
Posts: 37247
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: You have an error in your SQL syntax..

Post by admin »

Сорри за задержку.
Don't forget to run script update
Post Reply