Author Topic: SQL error on update? (Read 42 times)

pmuldoon · « **on:** January 26, 2012, 01:24:42 PM »

Hi Peter

After updating to 3.6.2 (WordPress 3.3.1), I am getting the following error message, which also shows as the first line on my site (I am sure there is a way to turn off error messages in my php settings but I don't remember how):

ALTER TABLE wp_terms ADD `avhec_term_order` INT( 4 ) NULL DEFAULT '0'

Is this something I can fix in the tables, or in some other way?

Thanks.

Patrick

Peter · « **Reply #1 on:** January 26, 2012, 01:41:33 PM »

You can manually add the field to the wp_terms table through phpMyadmin or something like phpMyadmin

I'm trying to think why you would get the message (is that the whole message?) and the only reason I can think of is that the user used to query the WordPress DB doesn't have the right to alter tables.

pmuldoon · « **Reply #2 on:** January 26, 2012, 02:20:41 PM »

Peter - I am logging in with Admin rights, so it shouldn't be a rights issue. Here is the terms table as is - see attachment. Do I still need to update this table do you think?

Thanks

Patrick

Peter · « **Reply #3 on:** January 26, 2012, 02:50:37 PM »

No it's there, no need to update.

What's the site that has problems?

pmuldoon · « **Reply #4 on:** January 26, 2012, 04:17:49 PM »

Peter - I had to log out and I am just coming back in and the error does not show up any more. Not sure what happened. Sorry to take up your time on that one!
Patrick

Peter · « **Reply #5 on:** January 26, 2012, 07:44:02 PM »

Not a problem Patrick,

Glad the problem is gone.

News:

SQL error on update?