need help plz -Database error

[jene]

Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;

MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Tuesday, January 26th 2010 @ 02:01:40 PM
Error Date : Tuesday, January 26th 2010 @ 02:01:40 PM
Script : http://www.offernissim1.net/vb/admin...ex.php?do=home
Referrer : http://www.offernissim1.net/vb/admincp/index.php
IP Address : 87.68.60.10

what this ?
its show in admin panel
and when i try to edit thread
help plzzzz

[Lynne]

That is from a modification (there is no field names filesize in the attachment table any longer). Disable the modification and the error will go away.

If you can't get into your admin cp, disable your modifications/plugins though config.php
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[jene]

tnx
but wich modfication i need to disable ?

[Lynne]

Originally Posted by jene

tnx
but wich modfication i need to disable ?

I do not know. You will have to figure that one out yourself by either looking at the plugin code or by disabling them one-by-one to see which is giving the error.

[jene]

i disable all plugins and its steel dosent work

[Lynne]

When you disabled them in the config.php file (per post 2), the site worked, right? So, it has to be a product or plugin causing the problem. Did you disable your *plugins* (in the Plugin Manager) as well as your *products* (in the Manage Products page)? You need to do *both* in order to figure out which one is causing the problem.

[jene]

i didnt disabled in the config.php - whrere i found this file in my ftp ?

i only turn off all *plugins* *products* and (in the Plugin Manager) and its dosent help ...

tnx

[Lynne]

Did you do what I suggested in post 2 - what was the result? The config.php file is in your includes directory.

[jene]

yes Lynne i do what you suggested in post 2
and its dosent work :/
the same problem ..

but yestrday i upgrae from 3.8 vb to 4.0.1vb and after that i install again 3.8vb
maybe this is the problem ?

tnx

[Lynne]

You can not run 3.8 files with a 4.0 database. Your database is upgraded to 4.0. You either need to upload the 4.0 files or you need to install a database backup from 3.8.