vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Getting this 1054 Error in the ACP. (https://vborg.vbsupport.ru/showthread.php?t=239156)

Fungsten 03-26-2010 05:11 PM

Getting this 1054 Error in the ACP.
 
Quote:

Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;
MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Thursday, March 25th 2010 @ 04:09:47 PM
Error Date : Thursday, March 25th 2010 @ 04:09:47 PM
Script : http://blahblahblah/forum/admincp/index.php?do=home
Referrer : http://www.blahblahblah.com/forum/ad...dex.php?do=nav
IP Address : XXX.XXX.XXX.XXX
Username : XXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.89-community
Here's some background on what happened:

What happened was I was updating one website and had inadvertantly used the username, passwords, etc. from another site I own! After I noticed that the update stalled so I checked the PW, database name, etc and corrected them and that site's working fine. Now I am still getting the above error in the AdminCP from which I erroneously took the PW's from; the other site that I tried to update - the one that had the wrong passwords is fine! It's the site that I got the wrong PWs from that I'm having the problems with. Also I tried to reinstall VBulletin and I cannot get past step two when choosing to update; 404 Error. In the AdminCP I can access items from the CP but I cannot get the forum's listing or re-install VBulletin - 404 Error on step 3. Please help!!

TIA.

Lynne 03-27-2010 02:12 PM

I'm not sure what you did, but there is supposed to be a field called filesize in the attachment table. If you don't have it, then you need to add it.

Code:

filesize INT UNSIGNED NOT NULL DEFAULT '0'

Fungsten 03-27-2010 03:07 PM

Quote:

Originally Posted by Lynne (Post 2011088)
I'm not sure what you did, but there is supposed to be a field called filesize in the attachment table. If you don't have it, then you need to add it.

Code:

filesize INT UNSIGNED NOT NULL DEFAULT '0'

Where should I add it in the template? TIA.

On Edit:

I put it at the top of the template but it didn't work.

Lynne 03-27-2010 05:41 PM

That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.

Fungsten 03-27-2010 08:09 PM

Quote:

Originally Posted by Lynne (Post 2011172)
That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.


:up:

--------------- Added [DATE]1269727890[/DATE] at [TIME]1269727890[/TIME] ---------------

Quote:

Originally Posted by Lynne (Post 2011172)
That is information for you to add the field in your database. You did something and it got deleted. You need to add it back. If you don't know how to do this, you may have to ask your host.

This is the error I got when I ran it:

Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'filesize INT UNSIGNED NOT NULL DEFAULT '0'' at line 1

Fungsten 04-02-2010 12:39 AM

Lynne. Did you want to make a few bucks and try to fix the DB problems?

Lynne 04-02-2010 01:44 PM

You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.

Fungsten 04-02-2010 03:25 PM

Quote:

Originally Posted by Lynne (Post 2014640)
You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.


It didn't work though. Is there a way to re-build/add the table info?

Fungsten 04-07-2010 03:07 PM

Quote:

Originally Posted by Lynne (Post 2014640)
You cannot just run that one line since it doesn't have the table information in it. I thought you were just gonna add it manually through phpMyAdmin and that is the information needed for the field.

Lynne, did you want to make a few bucks fixing the problem?


All times are GMT. The time now is 02:44 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.00992 seconds
  • Memory Usage 1,737KB
  • 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
  • (2)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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