Can't insert records

Quote

Total posts: 501
03 Jun 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

Last Modified: 02 Mar 2014

Quote

Konstantin
Total posts: 1,113
04 Jun 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.

Quote

stblink

Total posts: 501
04 Jun 2013 08:21

thanks for the quick fix!

Quote

wolverine

Total posts: 102
01 Sep 2013 11:07

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

Quote

Konstantin
Total posts: 1,113
01 Sep 2013 23:06

You can update component or use fix in first comment.

Quote

wolverine

Total posts: 102
02 Sep 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

Quote