Hello, I have been using EE2 since the public beta, and recently deleted a comment which was followed up with my inability to visit the “Edit Content” section of my site.
I am given the following screen:

A Database Error Occurred
Error Number: 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 ‘) ORDER BY entry_date desc’ at line 5

SELECT exp_channel_titles.entry_id, exp_channel_titles.channel_id, exp_channel_titles.title, exp_channel_titles.author_id, exp_channel_titles.status, exp_channel_titles.entry_date, exp_channel_titles.dst_enabled, exp_channel_titles.comment_total, exp_channels.live_look_template, exp_members.username, exp_members.email, exp_members.screen_name FROM (exp_channel_titles) LEFT JOIN exp_channels ON exp_channel_titles.channel_id = exp_channels.channel_id LEFT JOIN exp_members ON exp_members.member_id = exp_channel_titles.author_id WHERE exp_channel_titles.entry_id IN ) ORDER BY entry_date desc

This shows up when attempting to view http://paravisinicoffee.com/mgmt/index.php?S=4b5689516b21b0e15b8d69d6da630c2ca8b01f5f&D=cp&C=content_edit

I have not recently installed or changed any addons, modified my database, or changed any expression engine files in anyway.
Any help is greatly appreciated. Thanks!

Sorry, I am currently using 2.1.0, I had updated from the public beta the day 2.1 came out, and did not make that clear. This issue just sprang up today.

Could you post the page instead of the link to the entry in the control panel?  Thanks!

The public facing site has no errors, the error comes up in the Edit Content section of my control panel.

jparavisini, can you confirm the build you’re using? Just to be safe can you temporarily disable extensions using the button in the upper-right of Addons > Extensions?

Same Error for me… It seems there is an error in the SQL-Statement…? I use the latest Build of EE 2.1.0 (20100810)

One note: The same installation on a local MAMP-Webserver worked properly (mysql version: 5.1.37). It seems the problem is located on the webhoster (mysql version: 5.0.51a).

Any suggestions?

jparavisini and thomasaull,

Can you check to see if your host’s MySQL server is running in Strict mode, and if so, try turning that off please?

My Webhoster (allinkl.de) said that Strict-Mode is off.

Are there other possible reasons?

I’m seeing the same error on occasion when attempting to administer via the control panel.
It first occurred when deleting a comment for me as well, but now occurs randomly.

I’m running v2.1.0 Build 20100810.
(Haven’t had time to update!)

Published site seems fine.

Text of error below:

A Database Error Occurred
Error Number: 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 ‘) ORDER BY entry_date desc’ at line 5

SELECT exp_channel_titles.entry_id, exp_channel_titles.channel_id, exp_channel_titles.title, exp_channel_titles.author_id, exp_channel_titles.status, exp_channel_titles.entry_date, exp_channel_titles.dst_enabled, exp_channel_titles.comment_total, exp_channels.live_look_template, exp_members.username, exp_members.email, exp_members.screen_name FROM (exp_channel_titles) LEFT JOIN exp_channels ON exp_channel_titles.channel_id = exp_channels.channel_id LEFT JOIN exp_members ON exp_members.member_id = exp_channel_titles.author_id WHERE exp_channel_titles.entry_id IN ) ORDER BY entry_date desc

thomasaull, mhale0,

Can you share the exact steps you took to replicate this error?
Are any of you using add-ons.
Were you all upgrades or fresh installs?
Are you all using the Comments Module?

Its difficult to replicate the error, cause it appears only when i´m using ExpressionEngine on my Webspace on allinkl.de, but this is the procedure:

1. Install a fresh Version of Expression Engine 2.1 (latest Build 20100810).
2. Create a Channel and write an entry for that.
3. Click on Content -> Edit.

=> The Error occurs.

I looks like a SQL-Syntax-Error for me, which is ignored by some/most mySQL-Servers.

I had removed the Comment-Module, the Error is still there.
I have some Plugins installed (Allow EE-Code, Gravatar, Image Sizer).

Plugins:
URL and Email Auto-linker
ER Tweet Me
ImageSizer
Magpie RSS Parser
Twitter Timeline
XML Encode

Also using the comment module

Most any attempt to edit content leads to the error.

Fresh install.

Thanks!

thomasaull, mhale0,

I haven’t been able to reproduce this. What are your channel’s group assignments for categories, custom fields and statuses? Can you post a screenshot?

Here’s a screenshot of my config.

Thanks

Hmmm.. noticed you haven’t specified a Status Group. Did you create one? Let’s have you set one and see if that makes a difference.

I tried this, but no success…

I think the key is the SQL-Statement:

SELECT exp_channel_titles.entry_id, exp_channel_titles.channel_id, exp_channel_titles.title, exp_channel_titles.author_id, exp_channel_titles.status, exp_channel_titles.entry_date, exp_channel_titles.dst_enabled, exp_channel_titles.comment_total, exp_channels.live_look_template, exp_members.username, exp_members.email, exp_members.screen_name FROM (exp_channel_titles) LEFT JOIN exp_channels ON exp_channel_titles.channel_id = exp_channels.channel_id LEFT JOIN exp_members ON exp_members.member_id = exp_channel_titles.author_id WHERE exp_channel_titles.entry_id IN ) ORDER BY entry_date desc

After the bold “IN” the statements for the table and the fields are missing. If i delete “IN )” the SQL-Query has no more errors.

Can you all run our Server Wizard please to rule out anything there.

This is quite hard to troubleshoot as we are unable to replicate it. There must be a common denominator like something in your hosting environment that links you all.

Here is a Screenshot of the Server-Wizard´s result page

thomasaull, mhale0,

Okay, so you both encounter this on fresh installs, without the Agile Records theme, correct? Are you creating and deleting any entries beforehand? You just make a single entry, go to Publish > Edit and immediately get the error?