error installing J1521 Topic is solved

[antonios]

Hi
I am reinstalling J1521 (which was the latest working version) on my laptop using XAMPP (with the idea to upgrate to 1526 and then to J3.x) and when I am at step 4: DB configuration I receive the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Don't know how to go about solving this. It seems related to the collation type which I initially set to UTF8 when created the database...
Any help appreciated
Cheers

[mjparadac]

Hola antonios

Have you followed these guidelines?
https://docs.joomla.org/Planning_Migrat ... a_1.5_to_3
https://docs.joomla.org/Joomla_1.5_to_3 ... _Migration

Regards,

[antonios]

I am not there yet! Right now I need to reinstall the 1.5.21 version on localhost, then I can start the migration process as per the notes you suggested
Thanks

[antonios]

Hi all
so, I am still struggling to know how can I solve this. I have tried several versions of XAMPP (both older and new) and I either get the initial error for which I wrote the post or I get an

Unable to connect to the database:Could not connect to MySQL

I read all the posts I found on this issue but to no avail, and I need to reinstall the old database in order to migrate otherwise I'll loose my website...or will have to start from scratch with basically no content after 15 year of contributions.

Any help would be appreciated

[Per Yngve Berg]

'TYPE=MyISAM' was changed to 'ENGINE=MyISAM' some time ago. What version of Mysql are you running.


PS. I presume you mean Joomla verison 1.5.21

[antonios]

Yes I meant J 1.5.21

As for the versions of XAMPP I used: 5.5.34-0-VC11, 5.6.8-0-VC11, 5.6.14-4-VC11 and 7.2.6-0-VC15
in the last one the installation process for J1.5.21 would call some function inside the framework.php which was apparently no longer supported by php and crashed. (I think it was "set_magic_quotes_runtime()" )

As for the mysql versions, right now I have the 5.0.11 running.

[Per Yngve Berg]

magic_quotes was only present on php 5.3

1.5.26 will run on php up to 5.6.

What are you trying to install? Is it an old backup taken with Akeeba backup?

[antonios]

yes, an old backup with Akeeba

[Per Yngve Berg]

Did you try an older XAMPP (version 1.8 and before)?

The version scheme changed in 2014 and the next one was 5.6

Otherwise and edit of the sql files should make them import. Change "TYPE=" to "ENGINE="

[antonios]

Hi
I just installed XAMPP 1.7.7 and the same thing happens.
In case I try to modify the sql files which ones should I modify?

Also, when I create the data base before starting the installation I create it with the collation type "utf_general_ci" is this correct?

Also I am modifying the my.ini file to include user and password variables for mysql to access the DB like in:

Code: Select all

# The following options will be passed to all MySQL clients
[client] 
user = root1521
password = admin 
port            = 3306 
socket          = "D:/xampp3/mysql/mysql.sock"

is this correct?

[Per Yngve Berg]

https://stackoverflow.com/questions/222 ... ql-version

[antonios]

Thanks for pointing me to this. I finally managed to understand this bit. I realized that I had to make the change into the file ../installation/sql/mysql/joomla.sql

So now I can proceed with the installation process
Best regards