All of a sudden I am getting these errors...

[F5Hosting]

Cna you tell me what this means? Just started today but I have gotten like 6 of them:

Database error in vBulletin: Invalid SQL: SELECT *
FROM profilefield
WHERE editable = 1
ORDER BY displayorder
mysql error: Unknown column 'editable' in 'where clause'
mysql error number: 1054
Date: Monday 03rd of September 2001 05:50:41 PM
Script: /forums/member.php?s=&action=editprofile
Referer: http://128.241.205.135/forums/usercp.php?s=


and


Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO adminlog (adminlogid,userid,dateline,script,action,extrainfo,ipaddress) VALUES (NULL,'3',999564647,'index.php','','','24.3.221.14')
mysql error: Unknown column 'ipaddress' in 'field list'
mysql error number: 1054
Date: Monday 03rd of September 2001 05:50:47 PM
Script: /forums/admin/index.php?
Referer:


can anyone help?

[Mike Sullivan]

When you upgraded to 2.0.3 (from 2.0.1?), did you run upgrade11.php?

[F5Hosting]

Yep and then ran upgrade 12

[F5Hosting]

now getting this at the top of his pages :

Warning: Cannot add header information - headers already sent by (output started at /home/3dhq/public_html/forums/admin/config.php:40) in /home/3dhq/public_html/forums/admin/functions.php on line 1459


what is wrong here?

[tubedogg]

Your second error: http://www.vbulletin.com/forum/showt...threadid=21315

[F5Hosting]

Got this whol;e thing fixed by simply running the upgrade script that I thought I ran but didnt. Upgraded from 2.0.0 to 2.0.1, but when I went to run upgrade11.php, this is what I get:

Updating settings ....
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE profilefield ADD editable SMALLINT DEFAULT '1' NOT NULL
mysql error: Duplicate column name 'editable'
mysql error number: 1060
Date: Monday 03rd of September 2001 06:57:54 PM
Script: /forums/admin/upgrade11.php?step=2
Referer: http://128.241.205.135/forums/admin/upgrade11.php?



NOW what is wrong with it?

[Mike Sullivan]

Run this query:

ALTER TABLE profilefield DROP editable;

Then try upgrade11.php again.

[F5Hosting]

Did what you said up there, but it now gives me THIS error...

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE usergroup ADD canwhosonline SMALLINT DEFAULT '1' not null
mysql error: Duplicate column name 'canwhosonline'
mysql error number: 1060
Date: Thursday 06th of September 2001 01:26:33 PM
Script: /forums/admin/upgrade11.php?step=2
Referer: http://www.3dhq.net/forums/admin/upgrade11.php


I refresh it and the first error comes back!

[Mike Sullivan]

Do those errors in your first message still happen?

[F5Hosting]

nope...only the last errors are happening now. this is what I get BEFORE I do what you said to do to fix it:

Updating settings ....
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE profilefield ADD editable SMALLINT DEFAULT '1' NOT NULL
mysql error: Duplicate column name 'editable'
mysql error number: 1060
Date: Monday 03rd of September 2001 06:57:54 PM
Script: /forums/admin/upgrade11.php?step=2
Referer: http://128.241.205.135/forums/admin/upgrade11.php?


I do what you say do and run the upgrade11.php script again and get to step 2 and get this:

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE usergroup ADD canwhosonline SMALLINT DEFAULT '1' not null
mysql error: Duplicate column name 'canwhosonline'
mysql error number: 1060
Date: Thursday 06th of September 2001 01:26:33 PM
Script: /forums/admin/upgrade11.php?step=2
Referer: http://www.3dhq.net/forums/admin/upgrade11.php

I can then refresh the page or try to run it again and it goes back to the first error in this post. Not sure what I am doing wrong here, but I need to get this finished up.

Any ideas??

[F5Hosting]

I fixed it...for some reason, the version number at the bottom of the forums was wrong. I was trying to run update11.php for the second time after looking at the version number to see which one I needed to run. I just decided to try upgrade 12 and boom! it worked like a charm...so the version numbers screwed me up.

Thanks for all of the help, guys!