vb.org Archive - need help plz -Database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - need help plz -Database error (https://vborg.vbsupport.ru/showthread.php?t=234193)

jene	01-26-2010 10:12 AM

need help plz -Database error

Quote:

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

01-26-2010 02:08 PM

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	01-26-2010 02:17 PM

tnx
but wich modfication i need to disable ?

Lynne

01-26-2010 02:24 PM

Quote:

Originally Posted by jene (Post 1967105)

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	01-26-2010 03:47 PM

i disable all plugins and its steel dosent work :(

Lynne

01-26-2010 04:30 PM

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	01-26-2010 05:42 PM

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

01-26-2010 06:07 PM

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

jene	01-26-2010 09:46 PM

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

01-26-2010 10:12 PM

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.

Fungsten

03-26-2010 06:56 PM

Sorry to bump but I'm getting the same error too. TIA.

borbole

03-26-2010 07:29 PM

Quote:

Originally Posted by Fungsten (Post 2010725)

Sorry to bump but I'm getting the same error too. TIA.

Did you upgrade your forum as well like OP? Did you follow the suggestions posted by Lynne above?

Fungsten

03-26-2010 07:55 PM

Quote:

Originally Posted by borbole (Post 2010746)

Did you upgrade your forum as well like OP? Did you follow the suggestions posted by Lynne above?

I turned off the plugins/products and it still appeared.

I am just reinstalling VB 3.8.5 since there was a messup in upgrading another one of my forums and I confused the passwords. Anyways I'm just trying to reinstall VB 3.5 and it goes to 404 error after Step 3.

TIA.

On Edit:

MySQL 5.0.89-community

PHP version5.3.1

Lynne

03-27-2010 02:05 AM

Quote:

Originally Posted by Fungsten (Post 2010758)

That sounds like a totally different problem. You should post your own thread and include as much information as possible.

Fungsten

03-27-2010 02:22 AM

Quote:

Originally Posted by Lynne (Post 2010900)

That sounds like a totally different problem. You should post your own thread and include as much information as possible.

Lynne, could you please move this thread to the vB3 Forum please? TIA.

https://vborg.vbsupport.ru/showthread.php?t=239156

I posted it in the wrong forum some time ago. TIA.

Marco van Herwaarden

03-27-2010 11:40 AM

This thread is about vB4, not vB3. If your problem is about vB3, then you should create your own thread in the correct forum.

Fungsten

03-27-2010 03:08 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 2011043)

This thread is about vB4, not vB3. If your problem is about vB3, then you should create your own thread in the correct forum.

Oooops. My mistake. Sorry Marco.

All times are GMT. The time now is 07:23 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01237 seconds Memory Usage 1,753KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (17)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: