[0ptima]

Originally Posted by grecostimpy

Please share.....I'm using a modified php file to make the 3.0.x version still work on my 3.6.5 board. I'd rather update then continue this rather buggy band-aid.

I should have posted the steps I took when I did the conversion, but I did find some notes I took. I highly recommend that you test this out on a backup and use the following as a reference!

3.0 removal

//All old templates removed

//All old phrases removed

//Delete dfrom admin cp

DELETE FROM `settinggroup` WHERE CONVERT(`settinggroup`.`grouptitle` USING utf8) = 'timeslips' LIMIT 1;

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'allowtimeslipupload' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxwidth' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxheight' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdmaxsize' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'tdsliprequired' LIMIT 1;


//userfields to change..... (May only needed if you have the 3.0 - 3.05 version of the //hack. The 3.06 hack has these changes)

ALTER TABLE `userfield` CHANGE `field50` `field50` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field57` `field57` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field58` `field58` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field59` `field59` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field60` `field60` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field61` `field61` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field62` `field62` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field63` `field63` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `temp` `temp` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field64` `field64` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field65` `field65` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field68` `field68` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `field69` `field69` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL


RENAME TABLE `tmp`.`customtimeslippic` TO `tmp`.`customfile` ;

// may not be needed!!!!!!!! (dont remember why)
ALTER TABLE `customfile` CHANGE `timeslippicdata` `filedata` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL


// needed for 3.6
https://vborg.vbsupport.ru/showpost....&postcount=374


ALTER TABLE `profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid`

ALTER TABLE `profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title`

I also had to modify the product file, which I have attached
I remember having problem with the phrases and had to edit and re save one of them and then the all worked. Take a look at this post....
https://vborg.vbsupport.ru/showpost....&postcount=556