Hi,
On my demo site, I have upgraded/tested vb4 so many times up to now, there was no error. But on live site, it makes me crazy.
Please, assist me where I do wrong;
1- Backup all database and files trhough ssh..
2- Disable all plugins via config file or product manager.
3- upload all files to forum root, and rewrite all over
4- change to config file as it must be
5- run the upgrade script
So the errors I ve got;
P.S. I tried to upgrade my live site three times, all with db errors.
On my demo site, I have upgraded/tested vb4 so many times up to now, there was no error. But on live site, it makes me crazy.
Please, assist me where I do wrong;
1- Backup all database and files trhough ssh..
2- Disable all plugins via config file or product manager.
3- upload all files to forum root, and rewrite all over
4- change to config file as it must be
5- run the upgrade script
So the errors I ve got;
P.S. I tried to upgrade my live site three times, all with db errors.
vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)
Step 3) Misc Table Alterations (3/3) (Step 3 of 12)
Database error in vBulletin 3.8.4:
Invalid SQL:
INSERT INTO forumtagcontent
(tagid, contenttypeid, contentid, userid, dateline)
SELECT tagid, 2, threadid, userid, dateline
FROM forumtagthread;
MySQL Error : Duplicate entry '1-2-9853' for key 1
Error Number : 1062
Request Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Error Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Script : http://wwwxxxxxxxxx/forum/install/up...0a1.php?step=3
Referrer : http://www.xxxxxx/forum/install/upgr...0a1.php?step=2
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a
_________________________________________
vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)
Step 8) Albums System Alterations (Step 8 of 12)
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT filedataid, attachmentid
FROM forumattachment
WHERE
filedataid = 1
AND
posthash = ''
AND
contentid = 0;
MySQL Error : Unknown column 'filedataid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Error Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Script : http://www.xxxxxxcom/forum/install/u...0a1.php?step=8
Referrer : http://www.xxxxxxxxcom/forum/install...0a1.php?step=7
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a
__________________________________________________
vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)
Step 1) Misc Table Alterations (Step 1 of 2)
Database error in vBulletin 4.0.0 Alpha 6:
Invalid SQL:
ALTER TABLE forumattachment ADD INDEX contenttypeid (contenttypeid,contentid,attachmentid);
MySQL Error : Key column 'contenttypeid' doesn't exist in table
Error Number : -1
Request Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Error Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Script : http://wwwxxxxxxcom/forum/install/up...0b1.php?step=1
Referrer : http://wwwxxxxxxxxxxcom/forum/install/upgrade_400b1.php
IP Address : 88.228.49.199
Username :
Classname : vB_Database
MySQL Version :
(Please be patient as some parts may take some time)
Step 3) Misc Table Alterations (3/3) (Step 3 of 12)
Database error in vBulletin 3.8.4:
Invalid SQL:
INSERT INTO forumtagcontent
(tagid, contenttypeid, contentid, userid, dateline)
SELECT tagid, 2, threadid, userid, dateline
FROM forumtagthread;
MySQL Error : Duplicate entry '1-2-9853' for key 1
Error Number : 1062
Request Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Error Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Script : http://wwwxxxxxxxxx/forum/install/up...0a1.php?step=3
Referrer : http://www.xxxxxx/forum/install/upgr...0a1.php?step=2
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a
_________________________________________
vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)
Step 8) Albums System Alterations (Step 8 of 12)
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT filedataid, attachmentid
FROM forumattachment
WHERE
filedataid = 1
AND
posthash = ''
AND
contentid = 0;
MySQL Error : Unknown column 'filedataid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Error Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Script : http://www.xxxxxxcom/forum/install/u...0a1.php?step=8
Referrer : http://www.xxxxxxxxcom/forum/install...0a1.php?step=7
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a
__________________________________________________
vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)
Step 1) Misc Table Alterations (Step 1 of 2)
Database error in vBulletin 4.0.0 Alpha 6:
Invalid SQL:
ALTER TABLE forumattachment ADD INDEX contenttypeid (contenttypeid,contentid,attachmentid);
MySQL Error : Key column 'contenttypeid' doesn't exist in table
Error Number : -1
Request Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Error Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Script : http://wwwxxxxxxcom/forum/install/up...0b1.php?step=1
Referrer : http://wwwxxxxxxxxxxcom/forum/install/upgrade_400b1.php
IP Address : 88.228.49.199
Username :
Classname : vB_Database
MySQL Version :
Comment