Upgrading to Beta = Crashed my Site

[Cky47]

Can someone help me out... I was using the upgrade script for the new Beta, then like on the 3rd step i hit a mysql error becasue my mysql version was outdated. Now nothing works on my site.

I need some help badly, and I will pay if needed.


I just want my site back :(

[1996 328ti]

Can someone help me out... I was using the upgrade script for the new Beta, then like on the 3rd step i hit a mysql error becasue my mysql version was outdated. Now nothing works on my site.

I need some help badly, and I will pay if needed.


I just want my site back :(I guess you do not have a backup of your original files and database? Maybe your host has backups?

[Cky47]

I have godaddy hosting. They claim they have no backups.

I have my backup from right before I used the update script, but the file is too big to upload to my phpmyadmin. I would have to break it into like 45 different files.

Any chance it would be somethign besides the mysql? it isnt showing any mysql errors...

www.boardingscene.com

[Cky47]

I used the backup... but its still giving the database error thing...

[COBRAws]

I have godaddy hosting. They claim they have no backups.

I have my backup from right before I used the update script, but the file is too big to upload to my phpmyadmin. I would have to break it into like 45 different files.

Any chance it would be somethign besides the mysql? it isnt showing any mysql errors...

www.boardingscene.com
Upload the big SQL file to some folder in your hosting account and submit a ticket to GoDaddy hosting support asking them to dump it into the database.

Next time, copy the current DB into a new one, leave the old as is, and upgrade your board with the newly created DB ;)
If something goes wrong, you can allways switch back to the old VB DB with a small change in the config.php.

Cya!

[COBRAws]

I used the backup... but its still giving the database error thing...
Did you re-upload the old VB php's?

[Cky47]

I am doing that now... I hope it works.

[Cky47]

YAY... I love your guys.

I got it about 3/4 the way restored. The other stuff may have already been screwed up though. The only thing that isnt working is the vba cmps, but that is proably becasue the stock index.php rewrote it.

[Cky47]

I am getting this mysql error and a few others now though...


Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

, IF(SUM(photoplog_fileuploads.moderate) > 0 AND 1 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplo g_fileuploads.moderate)) AS photoplog_filecount, journals.journaldesc, journals.journal_id
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid) LEFT JOIN journals AS journals ON (journals.journalist_id=post.userid)
WHERE post.postid IN (0,3795,3796,3797,3798) GROUP BY post.postid
ORDER BY post.dateline;

MySQL Error : Table 'boardingscene.post_parsed' doesn't exist
Error Number : 1146
Date : Thursday, June 8th 2006 @ 08:02:17 PM
Script : http://www.boardingscene.com/showthread.php?t=697
Referrer : http://www.boardingscene.com/news/
IP Address : 24.239.218.251
Username : Cky47
Classname : vb_database

[Cky47]

Im thinking maybe I missed a table or something when i restored the old mysql. Let me look.

[Cky47]

Ok... thats what it was, but now the avatars arent working. I guess this is going to be hell for the next few days lol

[Gomjaba]

Try to hide your IP address in those errors - you never know :)