Forum Problem with upgrade 3.8.x to 4.0

محروم.كوم · #1 07-20-2010, 05:30 AM

Alright, this is a stupid problem, I did try to look in the sticky posts for a similar error, if there was I must have missed it and I apologies for this in advance.

The importing went alright, untill step 11 of the upgrade_400a1.php file. It actually did complete everything except this part (see below). Now I realize that it only got to filedataid 163809 instead of finishing. And before someone says it, yes I have been patient and been waiting, but my firefox decided to crash (even though I was not surfing anything else) and after restoring the session. It showed the other steps as completed but displayed a Database Error (as below) for last thing.

I did make a SQL Back up, however. I got 1.5M attachments on my forum and it took me already a good 12 hours to process all these attachments through the upgrade script. Seeing this forum has to stay online for me to make any sort of money for hosting back. I was wondering or it would be possible to fix this problem with a sql query or something along these lines to continue on with the upgrade process that it was trying to complete. So I can on to step 12?

I hope someone has an idea, I thank you in advance for your time.

Error:
Quote:
Database error in vBulletin 3.8.5:

Invalid SQL:
UPDATE attachment SET filedataid = 163809 WHERE filedataid IN ();

MySQL Error : 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 ')' at line 1
Error Number : 1064
Request Date : Tuesday, July 20th 2010 @ 02:33:46 AM
Error Date : Tuesday, July 20th 2010 @ 02:34:07 AM
Script : http://forumurl/install/upgrade_400a1.php?step=11
Referrer : http://forumurl/install/upgrade_400a...10&startat=746
IP Address : xx.xxx.x.47
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community-log

Part it crashed at:
Quote:
$db->query_write("UPDATE " . TABLE_PREFIX . "filedata SET refcount = $refcount WHERE filedataid = $filedataid");
$db->query_write("UPDATE " . TABLE_PREFIX . "attachment SET filedataid = $filedataid WHERE filedataid IN (" . implode(",", array_keys($killfiles)) . ")");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "filedata WHERE filedataid IN (" . implode(",", array_keys($killfiles)) . ")");
foreach ($killfiles AS $filedataid => $userid)
{
if ($vbulletin->GPC['attachtype'] == ATTACH_AS_FILES_NEW)
{
$path = $vbulletin->options['attachpath'] . '/' . implode('/', preg_split('//', $userid, -1, PREG_SPLIT_NO_EMPTY));
}
else
{
$path = $vbulletin->options['attachpath'] . '/' . $userid;
}
@unlink($path . '/' . $filedataid . '.attach');
@unlink($path . '/' . $filedataid . '.thumb');
}
}
}

if ($vbulletin->GPC['step'] == 12)
{
$db->query_write("
UPDATE " . TABLE_PREFIX . "setting

SET value = 'ssl'
WHERE varname = 'smtp_tls' AND value = '1'
"); __DEFINE_LIKE_SHARE__