stblink VIP
Total posts: 501
03 Июнь 2013 19:18

Pressing insert record on usermenu OR creating a direct menu link to submit returns the error:

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 'BEETWEEN '2013-06-04 00:00:00' AND '2013-06-04 23:59:59' AND user_id = 877' at line 3 SQL=SELECT count(*) FROM qnoy7_js_res_record WHERE section_id = 2 AND type_id = 2 AND ctime BEETWEEN '2013-06-04 00:00:00' AND '2013-06-04 23:59:59' AND user_id = 877

Последние изменения: 02 Март 2014


Konstantin
Total posts: 1,113
04 Июнь 2013 00:13

Thank you for report. Its bug, correct will be 'BETWEEN'. Fixed this. You can wait release or fix this by yourself in filt 'components/com_cobalt/models/section.php' on line 83.


stblink VIP
Total posts: 501
04 Июнь 2013 08:21

thanks for the quick fix!


wolverine VIP
Total posts: 102
01 Сен 2013 11:07

I have this error to how can I fix this ??


Konstantin
Total posts: 1,113
01 Сен 2013 23:06

You can update component or use fix in first comment.


wolverine VIP
Total posts: 102
02 Сен 2013 06:01

yes but how to fix this ??

Now when I have nuild my computer shop I get this 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 user_id = 964' at line 3 SQL=SELECT id as value, title as text FROM cjqsk_js_res_record WHERE published = 1 AND hidden = 0 AND section_id = 2 AND type_id IN() AND user_id = 964

Its works for my other sections but not here


Sergey
Total posts: 13,748
02 Сен 2013 07:18

Just wait for next update on Thursday.


wolverine VIP
Total posts: 102
07 Сен 2013 05:45

ok but how shuld I uppdate ??


Sergey
Total posts: 13,748
08 Сен 2013 02:38

Download Cobalt pack everything and install it in Joomla extension manager.

Работает на Cobalt