Nov
19
2011
Joomla

Installing Joomla 1.5 on a MySQL 5.5 Server

Author An article by CMS Bloke    Comments 8 Comments

One thing that crops up every now and then is a failure when trying to install Joomla 1.5 on the latest servers with newer versions of MySQL.

J1.5 is quite old now and the installation script uses “TYPE=MyISAM” all over the place. TYPE has been deprecated and replaced with ENGINE. No wonder the installer fails.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 29 SQL=CREATE TABLE `xxx_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(90) NOT NULL default 'banner', `name` TEXT 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(150) 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

Understandably many people just give up at this stage as the message is not all that helpful. So what to do? No need to downgrade your rdbms to 5.0. Instead go to your Joomla installation folder, i.e. yoursite/installation/sql and open the joomla.sql file. Use notepad++ or your text/code editor of choice and do a replace of all “TYPE=MyISAM” changing it to “ENGINE=MyISAM”. Save the file and upload.

Run the installer again and the error will be gone, i.e. the database created correctly.

If you were looking for information on installing Joomla check this post: Installing Joomla

or if you want to know just what the heck this Joomla thing is then check this post: What is Joomla?

Tags: , , ,

Related Posts

About the Author:

8 Comments + Add Comment

  • Renda Loring November 30, 2011 at 6:05 am

    I’d constantly want to be update on new posts on this web site, bookmarked!

    Reply
  • aspirateur balai January 5, 2012 at 7:07 am

    Hello there! Interesting blog post! I happen to be a regular website visitor (alot more like addict :P ) on your website yet I had a question. I am far from being totally sure if it is the right place to ask, but you’ve got no spam comments. I get comments day-to-day. Are able to you assist me? Gives thanks!

    Reply
    • CMS Bloke January 10, 2012 at 11:39 pm

      Actually I’m getting about 200 spam comments a week – I just don’t approve them :-P Haven’t logged in for a couple of days and have 96 comments awaiting approval but 99% of them are spam.

      Reply
      • CMS Bloke January 10, 2012 at 11:39 pm

        hmm, judging by Google serps that was a spam comment as well

        Reply
  • here January 9, 2012 at 9:43 am

    Heya i’m for the first time here. I came across this board and I find It truly useful & it helped me out much. I hope to give something back and aid others like you aided me.

    Reply
  • Jonathon Krossen January 27, 2012 at 6:47 pm

    I truly value your work , Great post.

    Reply
  • Fabian Homrich February 16, 2012 at 5:56 am

    Hi, Neat post. There’s a problem along with your website in web explorer, might check this… IE nonetheless is the marketplace leader and a big component to other people will leave out your wonderful writing because of this problem.

    Reply
    • CMS Bloke February 16, 2012 at 10:27 am

      Oops, thanks for that. Looks like a cufon problem in IE. Time for a theme change anyway!

      Reply

Leave a comment