vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Failed update to Beta 4, now 3.8.4 has bugs. (https://vborg.vbsupport.ru/showthread.php?t=230101)

servermin 12-13-2009 12:21 PM

Failed update to Beta 4, now 3.8.4 has bugs.
 
I had someone that I help with a vbulletin install try to go to beta without backing up the database. :( We just moved to a new server so haven't done a new backup myself, as I had the old server until just recently.

Anyway, there were problems and we are getting a few errors. Vbulletin is saying a reinstall, but there seems to have to be another way, since we can see all the posts and everything.

Looking for some options and ideas if anyone has any.

Here is what we are getting in the admin panel initial screen. All the other pages within it work. Below is when trying to edit large posts or go to some of them. The site is zefron.com/forum

Quote:

Database error in vBulletin 3.8.4:

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

MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Friday, December 11th 2009 @ 06:19:53 PM
Error Date : Friday, December 11th 2009 @ 06:19:53 PM
Script : http://www.zefron.com/forum/admincp/index.php?do=home
Referrer : http://www.zefron.com/forum/admincp/index.php
IP Address : 68.58.46.209
Username : Kathryn
Classname : vB_Database
MySQL Version : 5.0.85-community
Here is what we are getting in large threads or when we edit large threads

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,6271951,6271966,6271998,6272038,6272085,6272152, 6272182,6272252,6272377)
ORDER BY attachmentid;

MySQL Error : Unknown column 'extension' in 'from clause'
Error Number : 1054
Request Date : Friday, December 11th 2009 @ 06:20:31 PM
Error Date : Friday, December 11th 2009 @ 06:20:31 PM
Script : http://www.zefron.com/forum/showthread.php?p=6272377
Referrer : http://www.zefron.com/forum/
IP Address : 68.58.46.209
Username : Kathryn
Classname : vB_Database
MySQL Version : 5.0.85-community

snakes1100 12-13-2009 01:04 PM

I'd ask this 1st, why are you trying to run a BETA version on a live production site?

It's called a BETA for a reason.

If the columns are missing, i would view the upgrade php files starting with the one after your old version 3.8.4, view each php upgrade script from that point on in a editor and search for those keywords, see what queries were supposed to be run and compare them to your db, most likely 1/2 of the upgrade queries weren't ran.

servermin 12-13-2009 01:34 PM

They did it without my knowledge. I wondered the same thing :)

What you describes seems above what I know how to do. I was just posting tonsee if there was something that could save the site. I didn't know if anyone would mind trying to try this if people think this would work. Thanks!

snakes1100 12-13-2009 01:47 PM

There is no reason it can't be saved, the errors appear to be simply missing columns in the table.

I assume you also inspected the currently upload php files and they are all for the beta version and not for 3.8.4?

Did you check the two tables above and confirm that those tables don't actually exist?

Lynne 12-13-2009 02:12 PM

They might have put the vB4 files on the server, but they didn't run the upgrade.php file because you can see the database has not been upgraded at all (it says 3.8.4).

servermin 12-13-2009 03:05 PM

They ran the upgrade then went back to 3.8.4. Would that be why?

Paul M 12-13-2009 03:17 PM

What exactly do you mean by "then went back to 3.8.4" ?

servermin 12-13-2009 03:27 PM

She said she tried the upgrade and it failed so ran the 3.8.4 install again.

Lynne 12-13-2009 04:32 PM

You can't do that. The database won't suddenly downgrade to 3.8.4 again. Either she ran the upgrade and the database was changed, or she didn't run it and the database was left as a 3.8.4 database. Or, and I'm not sure about this, she started to run it and only some of the database was changed except the version number was not yet changed.

servermin 12-13-2009 04:35 PM

Snakes 1100 is going to take a look at it. Thanks for all the ideas. We'll post results here, for future problems with others.


All times are GMT. The time now is 07:35 AM.

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.01003 seconds
  • Memory Usage 1,739KB
  • 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_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