Could everyone answer this error for me? Thanks so much!

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
picachu_140988
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Jan 14, 2011 4:13 am

Could everyone answer this error for me? Thanks so much!

Post by picachu_140988 » Fri Jan 14, 2011 4:18 am

Step 4: Make Database and Next. This error appears:

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 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`

 
User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Could everyone answer this error for me? Thanks so much!

Post by dpacadmin » Fri Jan 14, 2011 4:29 am

You are using the latest MySQL version which has replaced TYPE with ENGINE. If you are using Wampserver 2.1 uninstall it and install Wampserver 2.0i instead.

User avatar
kurchania
Joomla! Hero
Joomla! Hero
Posts: 2070
Joined: Mon Sep 21, 2009 6:56 am
Location: indore,india
Contact:

Re: Could everyone answer this error for me? Thanks so much!

Post by kurchania » Fri Jan 14, 2011 4:36 am

hi picachu_140988,
as an alternate also you can edit 2 file
1. installation\sql\mysql\joomla.sql
2. installation\sql\mysql\joomla_backword.sql
Replace
TYPE=MyISAM;
with
ENGINE = MyISAM

Make Sense.

Regards
Abhijeet
abhijeet kurchania
The future depends on what you do today

picachu_140988
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Jan 14, 2011 4:13 am

Re: Could everyone answer this error for me? Thanks so much!

Post by picachu_140988 » Fri Jan 14, 2011 8:46 pm

Thank you! dpacadmin. I uninstall Wampserver 2.1 and install Wampserver 2.0i, Joomla actived. Thanks kurchania! Give my Best Wishes to all of you!

daalouw
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Tue Oct 20, 2009 11:19 pm

Re: Could everyone answer this error for me? Thanks so much!

Post by daalouw » Wed Feb 09, 2011 5:10 am

Hi Kurchania.

I have the same issue described here (I have XAMPP 1.7.4). I followed your suggestion of updating those 2 files and it removed some of my errors. My errors now are less.

My error now reads as follows:
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 CHARACTER SET `utf8`' at line 11 SQL=CREATE TABLE `jos_bannerclient` ( `cid` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `contact` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `extrainfo` text NOT NULL, `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` time default NULL, `editor` varchar(50) default NULL, PRIMARY KEY (`cid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Regards
Deon

daalouw
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Tue Oct 20, 2009 11:19 pm

SOLVED: Could everyone answer this error for me? Thanks so m

Post by daalouw » Wed Feb 09, 2011 5:14 am

Sorry.. my bad. I just realized that there are several instances of that text in each file. I only changed the first instance. I'm good now.

Thank you.
Deon

User avatar
kurchania
Joomla! Hero
Joomla! Hero
Posts: 2070
Joined: Mon Sep 21, 2009 6:56 am
Location: indore,india
Contact:

Re: Could everyone answer this error for me? Thanks so much!

Post by kurchania » Wed Feb 09, 2011 5:26 am

hi deon,
dpacadmin create that sql rar.anyone else get this problem can also download this file:-
http://forum.joomla.org/viewtopic.php?p ... 9#p2382319

Best wishes
Abhijeet Kurchania
abhijeet kurchania
The future depends on what you do today

User avatar
indrajitch
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Wed Dec 03, 2008 9:25 am

Re: Could everyone answer this error for me? Thanks so much!

Post by indrajitch » Wed Mar 02, 2011 5:29 am

Well for me, replacing the "TYPE" with "ENGINE" did solve the installation part.

However on starting the site it throws a huge number of "Strict Standards: Non-static method JRequest:" errors -

I am trying Joomla 1.5.22 with XAMPP 1.7.4 that has My SQL 5.5.8

Looks like there is some issue with MySQL latest version and Joomla, but is there any Joompa Pro who solved this problem?

User avatar
kurchania
Joomla! Hero
Joomla! Hero
Posts: 2070
Joined: Mon Sep 21, 2009 6:56 am
Location: indore,india
Contact:

Re: Could everyone answer this error for me? Thanks so much!

Post by kurchania » Wed Mar 02, 2011 5:38 am

abhijeet kurchania
The future depends on what you do today

User avatar
indrajitch
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Wed Dec 03, 2008 9:25 am

Re: Could everyone answer this error for me? Thanks so much!

Post by indrajitch » Wed Mar 02, 2011 6:12 am

Thanks Abhijeet !

as I mentioned in the other thread too -


Though initially editing the php.ini was not giving me the result - then realized I might need to restart the Apache for the ini file to take effect - and Voila !

edek
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Mar 26, 2011 8:16 pm

Re: Could everyone answer this error for me? Thanks so much!

Post by edek » Fri Apr 22, 2011 10:43 am

Just want to say thank you very much

kurchania wrote:hi picachu_140988,
as an alternate also you can edit 2 file
1. installation\sql\mysql\joomla.sql
2. installation\sql\mysql\joomla_backword.sql
Replace
TYPE=MyISAM;
with
ENGINE = MyISAM

Make Sense.

Regards
Abhijeet

webmystery
Joomla! Apprentice
Joomla! Apprentice
Posts: 24
Joined: Tue Aug 05, 2008 10:59 pm

Re: Could everyone answer this error for me? Thanks so much!

Post by webmystery » Tue Feb 12, 2013 7:18 pm

THANK YOU Abhijeet - You are a lifesaver!
I only had to edit joomla.sql changing all TYPE=MyISAM to ENGINE=MyISAM

 

Locked

Return to “Installation 1.5”