Database Errors

  • timscullin

    (@timscullin)


    13 years, 7 months ago

    Hey I had some issues with one of my pages using wp ecommerce. I used debug bar plugin and it was giving me the following error message:

    TOTAL QUERIES:
    198
    TOTAL DB ERRORS:
    1
    SAVEQUERIES must be defined to show the query log.
    Database Errors

    select DISTINCT t1.term_id as tag_id, t1.name as tag_name, null as tag_link, ttx.taxonomy as taxonomy from wp_terms as t1

    LEFT JOIN wp_term_taxonomy as ttx on (t1.term_id =ttx.term_id)

    LEFT JOIN wp_term_relationships as tr on(ttx.term_taxonomy_id=tr.term_taxonomy_id)

    where ttx.taxonomy=’product_tag’ and tr.object_id IN(2944,2953,2959,2966,2971,2978,2989,2996,4034,3018,3027,3037,3055,3119,3126,3172,3265,3247,3134,3044,3084,3092,3114,4663,3002,3099,3107,,,3809,4463) ORDER by tag_name
    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 ‘,3809,4463) ORDER by tag_name’ at line 7

    Does anyone know how I fix this?

The topic ‘Database Errors’ is closed to new replies.