Joomla Templates Club 406,261 posts

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#165252

Keep getting the following when trying to install the quickstart…
Running on localhost (XAMPP), windows.

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 41 SQL=CREATE TABLE `jos_weblinks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT ‘0’, `sid` int(11) NOT NULL DEFAULT ‘0’, `title` varchar(250) NOT NULL DEFAULT ”, `alias` varchar(255) NOT NULL DEFAULT ”, `url` varchar(250) NOT NULL DEFAULT ”, `description` text NOT NULL, `date` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `hits` int(11) NOT NULL DEFAULT ‘0’, `state` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out` int(11) NOT NULL DEFAULT ‘0’, `checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `ordering` int(11) NOT NULL DEFAULT ‘0’, `archived` tinyint(1) NOT NULL DEFAULT ‘0’, `approved` tinyint(1) NOT NULL DEFAULT ‘1’, `access` int(11) NOT NULL DEFAULT ‘1’, `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT ”, `created` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `created_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `created_by_alias` varchar(255) NOT NULL DEFAULT ”, `modified` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `modified_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint(3) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Set if link is featured.’, `xreference` varchar(50) NOT NULL COMMENT ‘A reference to enable linkages to external data sets.’, `publish_up` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `publish_down` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) TYPE=MyISAM ;

[Arvind Chauhan Moderator Arvind ChauhanJoin date: September 2014Posts: 3835Downloads:74Uploads:92 Thanks: 1240 Thanked: 1334 times in 848 posts]

#396525

HI markus,

I downloaded and installed JA Cloris J 1.6 on my localhost using wampp and it installed perfectly. Just followed the default installation. Can you explain on which step does this error throw up? and your xampp version? that will help in the debugging process.

Regards

Arvind

[judeur Friend judeurJoin date: June 2011Posts: 13Downloads:0Uploads:2 Thanks: 3 Thanked: 1 times in 1 posts]

#396561

I had the exact same problem; tried the quickstart both on mamp and on wamp and got the exact same error message (also at line 41). A regular joomla installation, and then the template upload, is no problem, but this won’t include the modules, for instance.

[judeur Friend judeurJoin date: June 2011Posts: 13Downloads:0Uploads:2 Thanks: 3 Thanked: 1 times in 1 posts]

#396660

I suppose markus and I have the same problem, and I’ll answer your question.
This problem occurred at the stage where a database should have been populated. I tried it both with MAMP (1.9.6) and the latest WAMP server (on a different computer). I created an empty database beforehand.

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#396723

Exactly the same problem! 🙂 Good.. so then it´s not just me 😉

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#396727

It is because all those systems are using a too late version of MySQL.I do not use Xampp but use Wamp and it is vary simple to switch to an earlier version using that.

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#396729

So the “fix” is to downgrade the database? isn´t there some thing we can do with the sql instead? 🙂

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#396738

Upgrades will be done, we are talking a short term fix for those using local installs. It will almost certainly be only those using those same local installs that will be affected by this. Almost all hosts I know of do not use this version of mysql at present. You can edit the slq file as per below too. Many extensions are not yet compatible and have this same problem. Not even sure if Joomla 1.5.x has been updated yet. I know this problem was present even on the RC of Joomla 1.6 but I have not looked at recent version to check.

Open “joomla.sql” – from installation/sql/mysql
copy the this text: TYPE=MyISAM
with the “joomla.sql” file open got to EDIT- REPLACE and paste the text in to “FIND WHAT”
Then copy this CHARACTER SET `utf8`;” into REPLACE WITH
Hit REPLACE ALL – save the file – and your done.

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#396740

There is no “TYPE=MyISAM CHARACTER SET `utf8`;” in my joomla.sql
only “TYPE=MyISAM”..

tried to replace that but no luck…

[judeur Friend judeurJoin date: June 2011Posts: 13Downloads:0Uploads:2 Thanks: 3 Thanked: 1 times in 1 posts]

#396742

So, replace TYPE=MyISAM with TYPE=MyISAM CHARACTER SET `utf8`, or replace TYPE=MyISAM with CHARACTER SET `utf8`?

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#396752

replace TYPE=MyISAM with CHARACTER SET `utf8`

🙂

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#396754

Sorry for the typo (edited).

I would still downgrade MySql personally. There are just too many extensions that you may have similar problems with. I

[judeur Friend judeurJoin date: June 2011Posts: 13Downloads:0Uploads:2 Thanks: 3 Thanked: 1 times in 1 posts]

#396756

Here http://www.devraju.com/programming/joomla-1-5-22-installation-sql-problem-typemyisam-solution-enginemyisam/
possibly helpful instructions:
“So I just find and replaced all the occurrences of ‘TYPE=MyISAM’ to ‘ENGINE=MyISAM’ and tried to install Joomla then it worked like a charm.”
And here http://www.wampserver.com/phorum/read.php?2,70078
some similar instructions.
Didn’t try it yet.

[markusthiel Friend markusthielJoin date: October 2010Posts: 61Downloads:0Uploads:0]

#396760

Worked like a charm! 🙂

Big cudos!

[judeur Friend judeurJoin date: June 2011Posts: 13Downloads:0Uploads:2 Thanks: 3 Thanked: 1 times in 1 posts]

#396772

@markus: which one did, the ENGINE or the CHARACTER SET? I have no luck with either, not on MAMP, at least. Will try on my PC with WAMP.

[Author]

Posts