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

Постим сюда все найденые ошибки
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

(c) SmartCJ Pro V 2.1 Your Build 201902041303 (Current build: 201902041303 )

2019-02-04 12:16:12 : 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: 37202
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
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

сори,
сегодня утром обновил мастер Build 201810260807 , затем установил и подключил новый слейв Build 201902041303 , на слейве на морде не показываются тумбы, на категориях всё ок ну и эта ошибка-
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: 37202
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
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

Варнинг появляется когда я жму Rotation > Specials > Category Thumbs

На индексе теги

<category order=clicks num=1-120 min_gallery_count=5>
<div class="preview">
<div class="prev">
<?php
$my_var = str_replace('x', '*', '<!--THUMB_LINK-->');
?>
<a href="http://site.com/<!--CATEGORY_NAME-->/"><div class="thumb">
<img src="<!--THUMB_URL-->" alt="<!--CATEGORY_NAME-->">
<div class="icon-bg"><div class="icon"><i class="fa fa-eye"></i></div></div>
</div>
<div class="name"><!--CATEGORY_NAME--></div></a>

</div>
</div>
</category>
admin
Site Admin
Posts: 37202
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
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

Варнинг в админке

На индексе нету тумб, а в категориях есть тумбы
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

Может админку скинуть?
admin
Site Admin
Posts: 37202
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
ztraffic
Posts: 90
Joined: Tue Apr 16, 2013 2:13 pm

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

Post by ztraffic »

Отправли в личку
Post Reply