v3.0 Dtabase Error

[MoB Dudditz MD]

PROBLEM RESOLVED
I had to do a complete reinstall. Fortunately, I had just begun so I didnt lose much.


UPDATE I found the db error was in relation to FTP transfer but no modules are active when I finally did a complete reinstall.
Also get the following error in the admincp Main Options
Warning: max() [function.max]: Array must contain atleast one element in /includes/vba_cmps_adminfunctions.php on line 700

I upgraded to the latest release and have many errors including the following
database errors when attempting to add or edit modules or pages.
bold print below simply obscures domain, user and ip

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT identifier, title FROM vb_adv_modules WHERE identifier != '' ORDER BY modcol, displayorder;

MySQL Error : Unknown column 'modcol' in 'order clause'
Error Number : 1054
Date : Monday, May 21st 2007 @ 12:13:12 AM
Script : http://MY_DOMAIN.com/forum/admincp/vba_cmps_admin.php?do=addmodule&type=php_file
Referrer : http://MY_DOMAIN.com/forum/admincp/vba_cmps_admin.php?do=newmodule
IP Address : my ip address
Username : my username
Classname : vb_database


I browsed through my database to find that I do not even have a field titled 'modcol'
The following are my vb_adv_modules fields:
modid
title
identifier
filename
inctype
templatelist
userperms
parent
active
colspan
formcode
useshell
altshell
link
options
code_parsed

Am I missing something??
TY
attached are a couple pics with weird areas in admin sections

[Brian]

I'm guessing you figured this out, but those errors are the result of trying to use the v2.0 files on your server after upgrading to v3.0.

[DannyITR]

I have the same error after upgrade. I have DB errors in the admincp and modules do not appear on the page. I will attempt to re-upload.

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM adv_modules ORDER BY modcol, displayorder;

MySQL Error : Unknown column 'modcol' in 'order clause'
Error Number : 1054

[DannyITR]

For some reason my FTP client did not overwrite any of the files. I manually uploaded each one replacing the old files and it fixed the problem.

[ckeins]

I have the same problems with "FlashFXP". I had problems with this ftp client with the upgrade from 2.2.0 to 2.2.1 too.

It works fine with WS FTP Pro 2007!

[ZapFlash]

so strange, i also used flashFXP and had the error, now i uploaded evertything again but with Ace FTP and everything works :)