Could everyone answer this error for me? Thanks so much!
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.
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.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Fri Jan 14, 2011 4:13 am
Could everyone answer this error for me? Thanks so much!
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`
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`
- dpacadmin
- 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!
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.
- kurchania
- 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!
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
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
The future depends on what you do today
-
- Joomla! Fledgling
- Posts: 2
- Joined: Fri Jan 14, 2011 4:13 am
Re: Could everyone answer this error for me? Thanks so much!
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!
-
- Joomla! Apprentice
- Posts: 47
- Joined: Tue Oct 20, 2009 11:19 pm
Re: Could everyone answer this error for me? Thanks so much!
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
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
-
- Joomla! Apprentice
- Posts: 47
- Joined: Tue Oct 20, 2009 11:19 pm
SOLVED: Could everyone answer this error for me? Thanks so m
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
Thank you.
Deon
- kurchania
- 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!
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
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
The future depends on what you do today
- indrajitch
- Joomla! Apprentice
- Posts: 16
- Joined: Wed Dec 03, 2008 9:25 am
Re: Could everyone answer this error for me? Thanks so much!
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?
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?
- kurchania
- 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!
abhijeet kurchania
The future depends on what you do today
The future depends on what you do today
- indrajitch
- Joomla! Apprentice
- Posts: 16
- Joined: Wed Dec 03, 2008 9:25 am
Re: Could everyone answer this error for me? Thanks so much!
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 !
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 !
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Mar 26, 2011 8:16 pm
Re: Could everyone answer this error for me? Thanks so much!
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
-
- Joomla! Apprentice
- Posts: 24
- Joined: Tue Aug 05, 2008 10:59 pm
Re: Could everyone answer this error for me? Thanks so much!
THANK YOU Abhijeet - You are a lifesaver!
I only had to edit joomla.sql changing all TYPE=MyISAM to ENGINE=MyISAM
I only had to edit joomla.sql changing all TYPE=MyISAM to ENGINE=MyISAM