Error from error_log

levani · #1 (**permalink**) 03-20-09, 09:35

Hi

Yesterday I saw my error_log and was very astonished. There were more than 10000 errors, and only this:

Quote:

[18-Mar-2009 02:03:55] WordPress database 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 taxonomy = 'category'' at line 1 for query SELECT * FROM wp_term_taxonomy WHERE term_taxonomy_id = AND taxonomy = 'category' made by require, require_once, include, include

Does anyone know what it means? It's a wordpress database.

Thanks

buckeye234 · #2 (**permalink**) 03-20-09, 10:08

I know nothing of Wordpress, but look at the following SQL statement from your error log and tell me what is wrong with it:

Code:

SELECT * 
FROM wp_term_taxonomy 
WHERE term_taxonomy_id = 
AND taxonomy = 'category'

r937 · #3 (**permalink**) 03-20-09, 10:10

yes, it means there's a syntax error in your query

let me revise your query slightly to be more readable...

Code:

SELECT * 
  FROM wp_term_taxonomy 
 WHERE term_taxonomy_id = 
   AND taxonomy = 'category'

can you spot the error now?

r937 · #4 (**permalink**) 03-20-09, 10:12

argghh, sniped again!!! by a full two minutes!!

nice one, buckeye

levani · #5 (**permalink**) 03-20-09, 14:26

As I guess you're about the empty value after term_taxonomy_id, is that right?

buckeye234 · #6 (**permalink**) 03-20-09, 15:36

Quote:

Originally Posted by levani

As I guess you're about the empty value after term_taxonomy_id, is that right?

Correct! Someone, or something, must be repeatedly submmitting this improper query. Your job, should you decide to accept it, is to find the cause of this massively annoying error message and stamp it out.

This post will self destruct in 30 seconds.

levani · #7 (**permalink**) 03-22-09, 05:20

This is the code which gets data from database:

Quote:

$mtladmtavari = $wpdb->get_row("SELECT * FROM $wpdb->term_taxonomy WHERE term_taxonomy_id = $araperi AND taxonomy = 'category' ");

As you see there is $araperi variable after term_taxonomy_id and it seems this variable doesn't always have any value.

Will this code prevent database query if the $araperi variable is empty?

Quote:

<?php
if ( $araperi != NULL ) {
$mtladmtavari = $wpdb->get_row("SELECT * FROM $wpdb->term_taxonomy WHERE term_taxonomy_id = $araperi AND taxonomy = 'category' ");
} ?>

Have you got any better ideas?

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech