xoops forums

keshavarz

Just popping in
Posted on: 2013/4/7 20:19
keshavarz
keshavarz (Show more)
Just popping in
Posts: 24
Since: 2005/4/7 1
#1

Problem with upgrading from 2.2.4 to 2.5.5

PHP: 5.3.13
Apache: 2.2.22
MySql: 5.5.24

I want to upgrade from xoops 2.2.4 to 2.5.5 in my local computer. When I run upgrade script, in the bottom section of the page this error appears:
0.002935 SHOW COLUMNS FROM `cache_modelLIKE 'cache_data' Error number1146 Error messageTable 'keshavar_xoops.pabxd_cache_model' doesn't exist


If I ignore this error and continue to upgrade in the page "Performing cnt-2.2.x-to-2.3.0 upgrade" this error appears:
0.000269 CREATE TABLE newblocks bid mediumint(8unsigned NOT NULL auto_incrementmid smallint(5unsigned NOT NULL default '0'func_num tinyint(3unsigned NOT NULL default '0'options varchar(255NOT NULL default ''name varchar(150NOT NULL default ''title varchar(255NOT NULL default ''content textside tinyint(1unsigned NOT NULL default '0'weight smallint(5unsigned NOT NULL default '0'visible tinyint(1unsigned NOT NULL default '0'block_type char(1NOT NULL default ''c_type char(1NOT NULL default ''isactive tinyint(1unsigned NOT NULL default '0'dirname varchar(50NOT NULL default ''func_file varchar(50NOT NULL default ''show_func varchar(50NOT NULL default ''edit_func varchar(50NOT NULL default ''template varchar(50NOT NULL default ''bcachetime int(10unsigned NOT NULL default '0'last_modified int(10unsigned NOT NULL default '0'PRIMARY KEY (bid), KEY mid (mid), KEY visible (visible), KEY isactive_visible_mid (isactive,visible,mid), KEY mid_funcnum (mid,func_num) ) TYPE=MyISAMError number1064 Error messageYou have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 27


The image of the page is:
Resized Image


If I continue, after upgrading to 2.5.5, I have not any blocks in the admin area. The reason is that the table newblocks has been removed by the upgrading script.
What's the problem? Am I doing something wrong?

Cesagonchu

Moderator
Posted on: 2013/4/7 20:42
Cesagonchu
Cesagonchu (Show more)
Moderator
Posts: 877
Since: 2010/2/1 2
#2

Re: Problem with upgrading from 2.2.4 to 2.5.5

One of your error is very simple to solve and the solution was given hundred times (even Google gives it).

Download notepad++, open one file from your ancient xoops, CTRL F and replace all :

TYPE=MyISAM


with

ENGINE=MyISAM


in the files from your old xoops.

keshavarz

Just popping in
Posted on: 2013/4/7 21:28
keshavarz
keshavarz (Show more)
Just popping in
Posts: 24
Since: 2005/4/7 1
#3

Re: Problem with upgrading from 2.2.4 to 2.5.5

Thank you
I changed only the index.php file in \upgrade\cnt-2.2.x-to-2.3.0 folder and the second error disappeared.

Cesagonchu

Moderator
Posted on: 2013/4/8 7:17
Cesagonchu
Cesagonchu (Show more)
Moderator
Posts: 877
Since: 2010/2/1 2
#4

Re: Problem with upgrading from 2.2.4 to 2.5.5

Great!