The Arcive of vBulletin Modifications Site.

Invalid SQL:FROM adv_modules ORDER BY modcol · **Released**: 08-14-2007

hi i got this eror when i checked admin cp VBadvanced CMPS links. Also there is nothin in my portal it is only empty page. Can you some help me please.

Thanx in advance

Code:

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
Date         : Tuesday, August 14th 2007 @ 06:12:35 PM
Script       : http://www.xxxxxxx.net/forum/admincp/vba_cmps_admin.php?do=editpage&pageid=1
Referrer     : http://www.xxxxxxx.net/forum/admincp/vba_cmps_admin.php?do=listpages
IP Address   : xxxxxxxxxxxxxxxxxxx
Username     : xxxxxxx
Classname    : vb_database

sinisterpain · #2 08-20-2007, 07:51 PM

Quote:

Originally Posted by katilkuzu

hi i got this eror when i checked admin cp VBadvanced CMPS links. Also there is nothin in my portal it is only empty page. Can you some help me please.

Thanx in advance

Code:

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
Date         : Tuesday, August 14th 2007 @ 06:12:35 PM
Script       : http://www.xxxxxxx.net/forum/admincp/vba_cmps_admin.php?do=editpage&pageid=1
Referrer     : http://www.xxxxxxx.net/forum/admincp/vba_cmps_admin.php?do=listpages
IP Address   : xxxxxxxxxxxxxxxxxxx
Username     : xxxxxxx
Classname    : vb_database

Did you recently upgrade to a newer version of CMPS?

katilkuzu · #3 08-21-2007, 08:08 PM

i was using and uninstall it 1 mounth ago. In few days ago i try to install new version i got this eror...