We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Error Number: 1064

Development and Programming

thinkinglucky's avatar
thinkinglucky
34 posts
16 years ago
thinkinglucky's avatar thinkinglucky

Hi there I am getting the following error message on one Weblog:

MySQL ERROR: Error Number: 1064 Description: 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 f.group_id=w.field_group AND f.field_type=’cbox” at line 1 Query: SELECT f.field_id, f.field_name, f.field_pre_populate, f.field_pre_blog_id, f.field_pre_field_id FROM exp_weblog_fields AS f, exp_weblogs AS w WHERE w.weblog_id= AND f.group_id=w.field_group AND f.field_type=’cbox’

I’ve taken down then the template to as little as:

{exp:weblog:entries weblog="prem" orderby="date" sort="asc" limit="9999"}
{prem6}
{/exp:weblog:entries}

And are still getting the problem. I do have the following extensions installed:

LG SAEF File Upload Multi Drop Down List (this is disabled) JQuery for Cpanel Foxee Extension User (v2.0.8) LG Live Look (this is disabled) LG Add Sitename LG Member Form Customiser Checkbox (v1.0.1)

I did have field frame installed but I thought that was the culprit and I deleted it and removed it from the server. Still no joy….

I’m on version 1.6.7. Any thoughts would be much appreciated.

Many Thanks Matt

       
Ingmar's avatar
Ingmar
29,245 posts
16 years ago
Ingmar's avatar Ingmar

Please try to disable all extensions for testing purposes. If that doesn’t solve the issue you should replace your files with a fresh set, upgrading to 1.6.8 in the process.

       
thinkinglucky's avatar
thinkinglucky
34 posts
16 years ago
thinkinglucky's avatar thinkinglucky

Hi there The culprit is definitely Checkbox (v1.0.1), so I’ll look there for support. Annoying as it just solved a problem for me!

Thanks for the quick response.

Thanks Matt

       
Adam Dorsey's avatar
Adam Dorsey
1,439 posts
16 years ago
Adam Dorsey's avatar Adam Dorsey

Hi Matt-

Glad to see you were able to track down the culprit 😉

I am going to move this thread to “Extensions: Discussion and Questions” to see if you can get some additional assistance from the community.

Thanks!

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.