vb.org Archive

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.


All times are GMT. The time now is 11:39 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02702 seconds
  • Memory Usage 1,729KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete