| Code:
|
ALTER TABLE `nuke_evo_userinfo` CHANGE `position` `position` INT(10) NOT NULL;
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
ALTER TABLE `nuke_blocks` CHANGE `view` `view` VARCHAR( 50 ) NOT NULL DEFAULT '0';
UPDATE `nuke_blocks` SET `view` = '4' WHERE `view` = '2';
ALTER TABLE `nuke_users` CHANGE `bio` `bio` TINYTEXT NULL;
ALTER TABLE `nuke_users` CHANGE `ublock` `ublock` TINYTEXT NULL;
INSERT INTO `nuke_bbconfig` VALUES ('image_resize_height', '400');
INSERT INTO `nuke_evolution` VALUES ('img_height', '300');
UPDATE `nuke_counter` SET `type` = 'os' WHERE `var` = 'Linspire';
ALTER TABLE `nuke_bbgroups` ADD `group_count` INT( 4 ) UNSIGNED NOT NULL DEFAULT '99999999', ADD `group_count_max` INT( 4 ) UNSIGNED NOT NULL DEFAULT '99999999', ADD `group_count_enable` SMALLINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
UPDATE `nuke_evolution` SET `evo_value` = '0' WHERE `evo_field` = 'collapsetype';
ALTER TABLE `nuke_bbsearch_wordlist` CHANGE `word_text` `word_text` varchar(255) binary NOT NULL DEFAULT '';
|
| Technocrat wrote (View Post):
|
Run this SQL, it will take you to 2.0.1 then follow the steps from there.
| Code:
|
ALTER TABLE `nuke_evo_userinfo` CHANGE `position` `position` INT(10) NOT NULL;
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
ALTER TABLE `nuke_blocks` CHANGE `view` `view` VARCHAR( 50 ) NOT NULL DEFAULT '0';
UPDATE `nuke_blocks` SET `view` = '4' WHERE `view` = '2';
ALTER TABLE `nuke_users` CHANGE `bio` `bio` TINYTEXT NULL;
ALTER TABLE `nuke_users` CHANGE `ublock` `ublock` TINYTEXT NULL;
INSERT INTO `nuke_bbconfig` VALUES ('image_resize_height', '400');
INSERT INTO `nuke_evolution` VALUES ('img_height', '300');
UPDATE `nuke_counter` SET `type` = 'os' WHERE `var` = 'Linspire';
ALTER TABLE `nuke_bbgroups` ADD `group_count` INT( 4 ) UNSIGNED NOT NULL DEFAULT '99999999', ADD `group_count_max` INT( 4 ) UNSIGNED NOT NULL DEFAULT '99999999', ADD `group_count_enable` SMALLINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
UPDATE `nuke_evolution` SET `evo_value` = '0' WHERE `evo_field` = 'collapsetype';
ALTER TABLE `nuke_bbsearch_wordlist` CHANGE `word_text` `word_text` varchar(255) binary NOT NULL DEFAULT '';
|
|
| Code:
|
Error
SQL query:
INSERT INTO `nuke_bbconfig`
VALUES (
'loginpage', '1'
);
MySQL said:
#1062 - Duplicate entry 'loginpage' for key 1
|
| Code:
|
ALTER TABLE `nuke_evo_userinfo` CHANGE `position` `position` INT(10) NOT NULL;# Affected rows: 126
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
|
| Rodmar wrote (View Post):
|
|
You need to go trough each upgrade so this means from 2.0.0 to 2.0.1. Then from 2.0.1 to 2.0.3, from 2.0.3 to 2.0.4 and finally from 2.0.4 to 2.0.5. The first upgrade seems not to be included in the latest Evo package but all the rest is in there. All you need from Evo 2.0.0 to 2.0.1 should be explained here in this post:
|
| Rodmar wrote (View Post):
|
|
You need to go trough each upgrade so this means from 2.0.0 to 2.0.1. Then from 2.0.1 to 2.0.3, from 2.0.3 to 2.0.4 and finally from 2.0.4 to 2.0.5. The first upgrade seems not to be included in the latest Evo package but all the rest is in there.
|
| Eyecu wrote (View Post):
|
|
News is usually the default home module.
|