Wordpress error: Incorrect integer value: '' for column 'id' at row 1.

Powelly

Regular Member
Joined
Jan 1, 2010
Messages
205
Reaction score
30
Hi there,

We are having trouble with some of our blogs.

We setup Wordpress fine, however when displayed in the serp results it shows the meta description as 'Incorrect integer value: '' for column 'id' at row 1.'

Anyone else had similar experiences or know how to solve?
 
are you running any plugins that are generating the meta description for you?
 
the error itself is caused by either the theme or a plugin trying to send incorrectly formatted data to your mysql database. The database is running in strict mode so it throws up an error.

If you cannot see that error when you view the page, the page's html source or while in wp backend then I would say the error has been fixed by an update. If you do see the error your self it should give you a longer description so you can track down what is sending the wrong data.

The trouble with your google results is that the googlebot crawled that page while the error was on display, read it as the first text on the page and so used it for its snippet.

If you are no longer seeing the error on the site then you just need to get google to recrawl those pages affected
 
I tried disabling all plugins, and still the same load of errors in the admin dashboard on wordpress:
Deprecated: Assigning the return value of new by reference is deprecated in D:\Sites\sitename\public_html\wp-includes\class-simplepie.php on line 738

etc
 
The database is running in strict mode so it throws up an error.

Am working with this. I've never seen the error before except now on a server running 'mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 ' and hosted on a 'Windows NT H1784211 6.1 build 7601' server. I bet there is a strict mode in affect. To counter it I've modified all instances of INSERT queries that include the autoincriment id field but left the value blank... which normally we can do.
 
Back
Top