ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Database error when deleting a channel...

May 31, 2012 7:46pm

Subscribe [1]
  • #1 / May 31, 2012 7:46pm

    FCWebTeam

    4 posts

    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 ') AND ct.site_id=1 AND ct.status='submitted' ORDER BY ct.edit_date DESC LIMI' at line 3
    
    SELECT ct.entry_id, ct.channel_id, ct.author_id, ct.title, ct.edit_date FROM exp_channel_titles ct WHERE ct.channel_id IN () AND ct.site_id=1 AND ct.status='submitted' ORDER BY ct.edit_date DESC LIMIT 9
    
    Filename: /usr/share/expressionengine/codeigniter/system/database/DB_driver.php
    
    Line Number: 330

    For some reason when deleting one of my channels named “Events” I end up with this error after trying to login or anything. What gives? Any idea how to troubleshoot the cause?

  • #2 / May 31, 2012 7:54pm

    FCWebTeam

    4 posts

    Here’s a bit of the log. Mostly unhelpful, might I add EE should name said “Model Class” in the debug information for it to be helpful.

    DEBUG - 2012-05-31 18:51:56 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:56 --> Language file loaded: language/english/homepage_lang.php
    DEBUG - 2012-05-31 18:51:56 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:56 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:56 --> Addons class already loaded. Second attempt ignored.
    DEBUG - 2012-05-31 18:51:56 --> Language file loaded: language/english/field_editor_lang.php
    DEBUG - 2012-05-31 18:51:57 --> File loaded: /srv/http/edyoung.com/www/admin/expressionengine/views/_shared/menu/item_parent.php
    DEBUG - 2012-05-31 18:51:57 --> File loaded: /srv/http/edyoung.com/www/admin/expressionengine/views/_shared/menu/item.php
    DEBUG - 2012-05-31 18:51:57 --> File loaded: /srv/http/edyoung.com/www/admin/expressionengine/views/_shared/menu/item_divider.php
    DEBUG - 2012-05-31 18:51:57 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:57 --> Helper loaded: file_helper
    DEBUG - 2012-05-31 18:51:57 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:57 --> Language file loaded: language/english/cp_analytics_lang.php
    DEBUG - 2012-05-31 18:51:57 --> Model Class Initialized
    DEBUG - 2012-05-31 18:51:57 --> DB Transaction Failure
    ERROR - 2012-05-31 18:51:57 --> Query error: 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 ct.site_id=1 AND ct.status='submitted'
      ORDER BY ct.edit_date DESC
      LIMI' at line 3
    DEBUG - 2012-05-31 18:51:57 --> Language file loaded: language/english/db_lang.php

     

  • #3 / Jun 01, 2012 4:56pm

    Dan Decker

    7338 posts

    Hi FCWebTeam,

    Sorry for the trouble you are having with ExpressionEngine.

    When submitting a support thread, it is helpful to have the version information along with your errors. Can you tell me what version of ExpressionEngine you are using?

    Are you using persistent database connections? Has you host made any changes to the way MySQL runs on your server?

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases