[Faskis]

For those of you who updated to vB 4.2.2 and are getting the following error:

Warning: Function split() is deprecated in ..../displaystaff.php on line 23
Warning: Function split() is deprecated in ..../displaystaff.php on line 29

Change the split() functions in all three files (addstaff.php, deletestaff.php, displaystaff.php) to explode().




Also, upgrading from 1.2 to 1.3 yields these errors:

Database error in vBulletin 4.2.2:

Invalid SQL:

CREATE TABLE `threadcomment` (
`threadcommentid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`threadid` INT(10) UNSIGNED NOT NULL,
`userid` INT(10) UNSIGNED NOT NULL,
`username` VARCHAR(100) NOT NULL,
`dateline` INT(10) UNSIGNED NOT NULL,
`comment` TEXT NOT NULL
);

MySQL Error : Table 'threadcomment' already exists
Error Number : 1050
Request Date : Sunday, October 27th 2013 @ 01:25:46 PM
Error Date : Sunday, October 27th 2013 @ 01:25:47 PM
Script : http://--/forums/admincp/plugin.php?do=productimport
Referrer : http://--/forums/admincp/plugin.php?do=productadd
IP Address : --
Username : --
Classname : vB_Database
MySQL Version : 5.1.70-cll

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE `thread` ADD `threadcomments` INT( 10 ) UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'threadcomments'
Error Number : 1060
Request Date : Sunday, October 27th 2013 @ 01:28:15 PM
Error Date : Sunday, October 27th 2013 @ 01:28:16 PM
Script : http://--/forums/admincp/plugin.php?do=productimport
Referrer : http://--/forums/admincp/plugin.php?do=productadd
IP Address : --
Username : --
Classname : vB_Database
MySQL Version : 5.1.70-cll

Simple checks to see if they exist should suffice here. I simply deleted the table and column and had the script recreate it to finish the updates.