Thread

I’ve been using version 1.6 with no problems, but today when I click on the Edit tab, I get the following error:

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 ‘90WICHnp-uCpRP2lFKu9Ua0p-gxJI2bv8R93ZbXCK7U.’ at line 2

Query: SELECT exp_weblog_titles.entry_id FROM exp_weblog_titles LEFT JOIN exp_weblogs ON exp_weblog_titles.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members ON exp_members.member_id = exp_weblog_titles.author_id WHERE exp_weblogs.site_id = ‘1’ AND exp_weblog_titles.weblog_id IN (‘3’,‘10’,‘9’,‘6’,‘1’,‘2’) AND exp_weblog_titles.author_id = exp_members.member_id ORDER BY entry_date desc LIMIT 0, 90WICHnp-uCpRP2lFKu9Ua0p-gxJI2bv8R93ZbXCK7U.

I’m not very familiar with MySQL databases. I’ve tried running the query above in phpmyadmin but it returns with another error. Any thoughts? Thank you.

Hi, deanna—

What build are you running? You can find that at the bottom of your control panel.

Also - are you running and extensions? You can find them listed in Admin -> Utilities -> Extensions Manager.

Build:  20070622

No extensions.

Can I ask you to update to the latest build and see if that doesn’t help? We can go from there.  Thank you.

Ok, I’ve just updated to the latest build, still the same error.

Can you head here: distant, early morning ›  Admin ›  Utilities › SQL Manager and let me know your SQL info, please?

Database Type:    mysql
Database Version:    4.1.22-standard
Database Records:    795
Database Size:    825.1 KB
Database Uptime:    4 hours, 22 minutes

Was this happening 5 hours ago, do you happen to know?

I’m going to look into this with our team as well, as I’m not sure what would be causing this.  In the mean-time, you might try running a repair and optimize on all of your tables and let me know if that helps.

You know, can you head to Admin -> System Preferences -> Security and Session Preferences and let me know if you’re using sessions at all? If you are, can you try switching to cookies only and see if that alleviates the error?

I repaired and optimized all tables and changed Control Panel Session Type and User Session Type to “Cookies Only”. I wish I could report positive results, but it still gives the same error message.

By the way, I first noticed this problem about 12 hours ago.

Ok. It was worth a shot.  I need to look into this so   I’ll get back to you when I have more information =)

Thanks for you help!

Can you delete your cookies, deanna?  Sounds like one of them has some bad information.

Ahhh….it worked! Glad it was an easy fix. THANK YOU SO MUCH to Lisa and Derek. There really is no support out their like Expression Engine’s team. Thanks again.