kreischweide

Visitors
  • Content count

    1
  • Joined

  • Last visited


kreischweide's Activity

  1. kreischweide added a record in IP.Content   

    SQL error in "Manage Articles"
    On my fresh hosted suite I can no longer IP.Content > Manage Articles. The SQL Logfile shows me that there is an error in the folowing query backtrace. Looks like some dev forgot to include the columnname for the second order by clause. Is it possible to fix that?

    [code] ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Sun, 19 Feb 2012 21:00:26 +0000
    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 'desc LIMIT 0,25' at line 1
    IP Address: 79.255.103.176 - /admin/index.php?adsess=f717d511bec53c8363e62dcf2b92f2ac&app=ccs&module=articles&section=articles&do=articles
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT r.* FROM ccs_custom_database_1 r LEFT JOIN ccs_database_categories c ON ( c.category_id=r.category_id ) ORDER BY r.record_pinned DESC, r. desc LIMIT 0,25
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin/applications_addon/ips/ccs/modules_admin/articles/articles.php | [admin_ccs_databases_records]._listRecords | 613 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin/applications_addon/ips/ccs/modules_admin/articles/articles.php | [admin_ccs_articles_articles]._listRecords | 165 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin/sources/base/ipsController.php | [admin_ccs_articles_articles].doExecute | 302 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    [/code]
    • 0 replies
    • 0 views

About Me

Status Feed