Joomla 1.5.17 and earlier and MySQL 5.5.x
- vsukhomlinov
- Joomla! Fledgling
- Posts: 4
- Joined: Sun May 02, 2010 4:56 pm
- Location: Russia, Moscow
Joomla 1.5.17 and earlier and MySQL 5.5.x
Just found an issue with out of the box installation on server with MySQL 5.5. Installation fails with error:
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`
Also, it's easy to fix by removing 'type=MyISAM' from joomla.sql
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`
Also, it's easy to fix by removing 'type=MyISAM' from joomla.sql
- RussW
- Joomla! Exemplar
- Posts: 9347
- Joined: Sun Oct 22, 2006 4:42 am
- Location: Sunshine Coast, Queensland, Australia
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
As far as I can determine, MySQL 5.5.x has depreciated the table_type_option construct of TYPE and has replaced it with " ENGINE = " ;
The following constructs are deprecated and will be removed in a future
MySQL release. Where alternatives are shown, applications should be
updated to use them.
* The table_type system variable (use storage_engine).
The TYPE table option to specify the storage engine for
CREATE TABLE or ALTER TABLE (use ENGINE).
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
- vsukhomlinov
- Joomla! Fledgling
- Posts: 4
- Joined: Sun May 02, 2010 4:56 pm
- Location: Russia, Moscow
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Yes, MySQL 5.1 allowed both ENGINE & TYPE for same purpose. With 5.4 it became deprecated, and removed in 5.5. So, as earlier versions supports 'ENGINE' its either should be changed to that or completely removed, using MySQL default settings. I'm also afraid about compatibility with MariaDB branch... Were there any benchmarks demonstrating MyISAM is better than InnoDB?
- RussW
- Joomla! Exemplar
- Posts: 9347
- Joined: Sun Oct 22, 2006 4:42 am
- Location: Sunshine Coast, Queensland, Australia
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
innoDB is now the default engine of choice for reasons of improved performance and improved feature-set (remember MySQL now has the might of Oracle of behind it and Oracle's "way of doing" things is a slightly different mind-set)
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sat Oct 23, 2010 1:09 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Hi.... Brand new here to joomla. I been trying to get Joomla 15 running on freebsd with mysql 5.5.x
Reading this post.....and a bit confused I see
Quote; Also, it's easy to fix by removing 'type=MyISAM' from joomla.sql
Is this file at domain/installation/sql/mysql/joomla.sql
if so I see 'type=MyISAM all over that file
Do I need to remove every instance?
Can you show me an example?
Reading this post.....and a bit confused I see
Quote; Also, it's easy to fix by removing 'type=MyISAM' from joomla.sql
Is this file at domain/installation/sql/mysql/joomla.sql
if so I see 'type=MyISAM all over that file
Do I need to remove every instance?
Can you show me an example?
- vsukhomlinov
- Joomla! Fledgling
- Posts: 4
- Joined: Sun May 02, 2010 4:56 pm
- Location: Russia, Moscow
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Hi, thats correct. You need to remove every instance of 'type=MyISAM' in this file.
lines like ") TYPE=MyISAM CHARACTER SET `utf8`;" should become:
") CHARACTER SET `utf8`;"
lines like ") TYPE=MyISAM CHARACTER SET `utf8`;" should become:
") CHARACTER SET `utf8`;"
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sat Oct 23, 2010 1:09 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Thank YOU for your help
Works now
Works now
- cybersalt
- Joomla! Enthusiast
- Posts: 126
- Joined: Thu Aug 25, 2005 10:36 pm
- Location: Victoria, Canada
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
"ENGINE=myisam" also works instead of "TYPE=myisam".
BTW, up-to and including Joomla version 1.5.21 will not install on mysql55 without the change.
Is anyone working on fixing this?
BTW, up-to and including Joomla version 1.5.21 will not install on mysql55 without the change.
Is anyone working on fixing this?
Tim Davis
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sat Dec 25, 2010 10:05 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Thank you,Thank you, Thank you. It worked perfectly!
If anyone has this problem. Trust me this is the fix. I tried all the others and this worked for me.
Open "joomla.sql" - from installation/sql/mysql
copy the this text: TYPE=MyISAM CHARACTER SET `utf8`;
with the "joomla.sql" file open got to EDIT- REPLACE and paste the text in to "FIND WHAT"
Then copy this textCHARACTER SET `utf8`;" into REPLACE WITH
Hit REPLACE ALL - save the file - and your done.
Close everything and start over, it should work.
PM me if you need further help.
If anyone has this problem. Trust me this is the fix. I tried all the others and this worked for me.
Open "joomla.sql" - from installation/sql/mysql
copy the this text: TYPE=MyISAM CHARACTER SET `utf8`;
with the "joomla.sql" file open got to EDIT- REPLACE and paste the text in to "FIND WHAT"
Then copy this textCHARACTER SET `utf8`;" into REPLACE WITH
Hit REPLACE ALL - save the file - and your done.
Close everything and start over, it should work.
PM me if you need further help.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sat Nov 19, 2005 1:09 am
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Looks like many other modules has a similar issue. I suggest to stay away from MySQL 5.5 for now.
-=Terence=-
-=Terence=-
- cybersalt
- Joomla! Enthusiast
- Posts: 126
- Joined: Thu Aug 25, 2005 10:36 pm
- Location: Victoria, Canada
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
I was thinking about staying away too, but I was playing around with Joomla 1.6rc1 and found that it is compatible with mysql5.5 - having "ENGINE=" instead of "TYPE=".kachan wrote:Looks like many other modules has a similar issue. I suggest to stay away from MySQL 5.5 for now.
-=Terence=-
So I'm going to stick with mysql5.5 and finding and replacing in the SQL files for extensions that create tables.
I've looked more into this issue and "TYPE=" has been deprecated since Mysql 4.0, was still supported for backward compatibility in MySQL 5.1, and has produced a warning since My SQL 5.1.8.
In fact, in the reference manual for MySQL 5.1.8 it says:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-8.htmlTYPE vs ENGINE . In order not to break legacy applications, support for TYPE = engine_name —deprecated since MySQL 4.0—has been restored, but now generates a warning.
Beginning with MySQL 5.5, TYPE = engine_name will no longer be available and will produce a syntax error.
You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use the ENGINE = engine_name syntax instead.
This is an issue not going away.
Tim Davis
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
- amilaudana
- Joomla! Apprentice
- Posts: 17
- Joined: Mon Nov 26, 2007 9:57 am
- Location: Colombo, Sri Lanka
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Yes,
use
For joomla 1.5 => mysql 5.1
For joomla 1.6 => mysql 5.5
if you are going to use mysql 5.5 with joomla 1.5 you will face the sql problems. you can modify mysql installation sql files, but what about thousands of extensions. it is better to use as above.
use
For joomla 1.5 => mysql 5.1
For joomla 1.6 => mysql 5.5
if you are going to use mysql 5.5 with joomla 1.5 you will face the sql problems. you can modify mysql installation sql files, but what about thousands of extensions. it is better to use as above.
- cybersalt
- Joomla! Enthusiast
- Posts: 126
- Joined: Thu Aug 25, 2005 10:36 pm
- Location: Victoria, Canada
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
MySQL55 is now stable so I've just resigned myself to editing the SQL instructions in extensions I want to install. This way I can take advantage of the incredible speed increase of 5.5.
Tim Davis
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
-
- Joomla! Fledgling
- Posts: 4
- Joined: Thu Mar 24, 2011 4:04 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Hi,
I've got a similar problem while migrating from Joomla 1.0.13 to Joomla 1.5.22. When I try to upload and execute the SQL migration script I get this error:
Error at the line 35: ) TYPE=MyISAM AUTOjos_INCREMENT=1 ;
Query:CREATE TABLE IF NOT EXISTS `#jos_jos_jfjos_content` (
`id` int(10) unsigned NOT NULL autojos_increment,
`languagejos_id` int(11) NOT NULL default '0',
`referencejos_id` int(11) NOT NULL default '0',
`referencejos_table` varchar(100) NOT NULL default '',
`referencejos_field` varchar(100) NOT NULL default '',
`value` text NOT NULL,
`originaljos_value` varchar(255) default NULL,
`originaljos_text` text,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modifiedjos_by` int(11) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTOjos_INCREMENT=1 ;
MySQL: 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 'autojos_increment, `languagejos_id` int(11) NOT NULL default '0', `reference' at line 2
I've spent hours searching for a solution on the web and nothing worked. I replaced "TYPE=MyISAM" by "ENGINE=MyISAM", and it didn't work (I've tried with several editors including Notepad++ and Wordpad). I've also tried just to remove "TYPE=MyISAM". I've tried ISO-8859-1 and UTF8 encodings (with UTF8 I get an iconv error, so I guess ISO-8859-1 is the right choice). I've tried to uncheck JoomFish! (the only 3rd party migrator I've installed) while creating the migration script. I've tried with XAMPP 1.5.4 (MySQL 5.0.24a) & 1.7.3 (with this server I get additionally a "Function ereg() is deprecated" error, so I guess it's useless to try again), WAMP 2.1 (MySQL 5.1.36), WAMP 2.0i (also the ereg error).
Nothing has worked! Always exactly the same error!
Some more information (I don't think it's useful but we never know...). The initial database has latin1_swedish_ci encoding, and the created one for Joomla 1.5 has utf8_general_ci encoding (all tables seem to have been successfully created but the installation fails).
Any idea what could be wrong? Hopefully an easy trick I've forgotten to try...
Thanks for your help
Philippe
I've got a similar problem while migrating from Joomla 1.0.13 to Joomla 1.5.22. When I try to upload and execute the SQL migration script I get this error:
Error at the line 35: ) TYPE=MyISAM AUTOjos_INCREMENT=1 ;
Query:CREATE TABLE IF NOT EXISTS `#jos_jos_jfjos_content` (
`id` int(10) unsigned NOT NULL autojos_increment,
`languagejos_id` int(11) NOT NULL default '0',
`referencejos_id` int(11) NOT NULL default '0',
`referencejos_table` varchar(100) NOT NULL default '',
`referencejos_field` varchar(100) NOT NULL default '',
`value` text NOT NULL,
`originaljos_value` varchar(255) default NULL,
`originaljos_text` text,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modifiedjos_by` int(11) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTOjos_INCREMENT=1 ;
MySQL: 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 'autojos_increment, `languagejos_id` int(11) NOT NULL default '0', `reference' at line 2
I've spent hours searching for a solution on the web and nothing worked. I replaced "TYPE=MyISAM" by "ENGINE=MyISAM", and it didn't work (I've tried with several editors including Notepad++ and Wordpad). I've also tried just to remove "TYPE=MyISAM". I've tried ISO-8859-1 and UTF8 encodings (with UTF8 I get an iconv error, so I guess ISO-8859-1 is the right choice). I've tried to uncheck JoomFish! (the only 3rd party migrator I've installed) while creating the migration script. I've tried with XAMPP 1.5.4 (MySQL 5.0.24a) & 1.7.3 (with this server I get additionally a "Function ereg() is deprecated" error, so I guess it's useless to try again), WAMP 2.1 (MySQL 5.1.36), WAMP 2.0i (also the ereg error).
Nothing has worked! Always exactly the same error!
Some more information (I don't think it's useful but we never know...). The initial database has latin1_swedish_ci encoding, and the created one for Joomla 1.5 has utf8_general_ci encoding (all tables seem to have been successfully created but the installation fails).
Any idea what could be wrong? Hopefully an easy trick I've forgotten to try...
Thanks for your help
Philippe
- RussW
- Joomla! Exemplar
- Posts: 9347
- Joined: Sun Oct 22, 2006 4:42 am
- Location: Sunshine Coast, Queensland, Australia
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
@pea8ch
I wouldn't say your problem is the same, your message is completely different, in future pleae open your own thread for a problem, not hijak someone elses.
It looks like your MySQL server versions are different and there is an unsupported statement, either the "NOT NULL" or mor elikely the "default '0'" statement.
Try exporting the initial database in "compatibility" mode
I wouldn't say your problem is the same, your message is completely different, in future pleae open your own thread for a problem, not hijak someone elses.
It looks like your MySQL server versions are different and there is an unsupported statement, either the "NOT NULL" or mor elikely the "default '0'" statement.
Try exporting the initial database in "compatibility" mode
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
-
- Joomla! Fledgling
- Posts: 4
- Joined: Thu Mar 24, 2011 4:04 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Sorry for that. I thought the problem was similar and it was better to post on an existing thread that creating a new one (as people tend to always create new threads for problems that have been already solved).
Anyway the problem is solved. It wasn't a compatibility problem as I thought. It was a stupid mistake that took me a long time to find out: I hadn't filled in the "old table prefix" field so the installation program replaced all "_" in the script by "jos_".
Anyway the problem is solved. It wasn't a compatibility problem as I thought. It was a stupid mistake that took me a long time to find out: I hadn't filled in the "old table prefix" field so the installation program replaced all "_" in the script by "jos_".
-
- Joomla! Apprentice
- Posts: 17
- Joined: Sun Dec 06, 2009 3:22 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
my demo site works now, but i get an error when i upload Easybook reloaded (extension)
Code: Select all
JInstaller::install: SQL Error. DB function failed with error number 1064
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 20 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
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 20 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
- cybersalt
- Joomla! Enthusiast
- Posts: 126
- Joined: Thu Aug 25, 2005 10:36 pm
- Location: Victoria, Canada
- Contact:
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Reintje111,
If your site is running on mysql5.5 you need to change the sql install script of any extension that is still using "TYPE=MyISAM" to "ENGINE=MyISAM"
I see that "TYPE=MyISAM" occurs a couple of times in the error message you have posted.
If your site is running on mysql5.5 you need to change the sql install script of any extension that is still using "TYPE=MyISAM" to "ENGINE=MyISAM"
I see that "TYPE=MyISAM" occurs a couple of times in the error message you have posted.
Tim Davis
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
Cybersalt | Basic Joomla Tutorials
https://www.cybersalt.com | https://www.[youtube].com/basicjoomla
-
- Joomla! Fledgling
- Posts: 1
- Joined: Fri Dec 30, 2011 5:18 am
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
I have been having the same problem for my joomla for the past 4 days. I have been to every forum and people have offered different solutions, none of which worked for me. Editing joomla.sql was finally what worked for me. I had thank you for your solution, I have been doing nothing but searching for solutions for the past 4 days. Thanks so much.9Iceman wrote:Thank you,Thank you, Thank you. It worked perfectly!
If anyone has this problem. Trust me this is the fix. I tried all the others and this worked for me.
Open "joomla.sql" - from installation/sql/mysql
copy the this text: TYPE=MyISAM CHARACTER SET `utf8`;
with the "joomla.sql" file open got to EDIT- REPLACE and paste the text in to "FIND WHAT"
Then copy this textCHARACTER SET `utf8`;" into REPLACE WITH
Hit REPLACE ALL - save the file - and your done.
Close everything and start over, it should work.
PM me if you need further help.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Mar 31, 2012 9:51 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Hi all,
I switch from TYPE to ENGINE, and I have the same result :
JInstaller::install: Erreur SQL. DB function failed with error number 1064
Erreur de syntaxe près de 'CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL' à la ligne 1 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Composant Installation: Erreur SQL ou fichier sql absent ou illisible. DB function failed with error number 1064
Erreur de syntaxe près de 'CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL' à la ligne 1 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Can you help me solve this?
Thanks in advance.
I switch from TYPE to ENGINE, and I have the same result :
JInstaller::install: Erreur SQL. DB function failed with error number 1064
Erreur de syntaxe près de 'CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL' à la ligne 1 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Composant Installation: Erreur SQL ou fichier sql absent ou illisible. DB function failed with error number 1064
Erreur de syntaxe près de 'CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL' à la ligne 1 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Can you help me solve this?
Thanks in advance.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Aug 07, 2012 8:37 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Dear All,
After upgrading from MySql 5.1 to MySql 5.5 all my Joomla! sites get down and corrupted, please once check this website: www.afghanvoip.com and all other websites going the same like www.yeget.net.
Can anyone please help me sort it out here.
I have Joomla 1.5.26 and 2.5.6 installed on the sites.
Thank you
Crypto
After upgrading from MySql 5.1 to MySql 5.5 all my Joomla! sites get down and corrupted, please once check this website: www.afghanvoip.com and all other websites going the same like www.yeget.net.
Can anyone please help me sort it out here.
I have Joomla 1.5.26 and 2.5.6 installed on the sites.
Thank you
Crypto
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Aug 07, 2012 8:37 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
Hello,
The issue has been resolved by turning the error reporting Off in Main >> Service Configuration >> PHP Configuration Editor
Thank you
The issue has been resolved by turning the error reporting Off in Main >> Service Configuration >> PHP Configuration Editor
Thank you
crypto3 wrote:Dear All,
After upgrading from MySql 5.1 to MySql 5.5 all my Joomla! sites get down and corrupted, please once check this website: http://www.afghanvoip.com and all other websites going the same like http://www.yeget.net.
Can anyone please help me sort it out here.
I have Joomla 1.5.26 and 2.5.6 installed on the sites.
Thank you
Crypto
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Dec 03, 2007 3:39 pm
Re: Joomla 1.5.17 and earlier and MySQL 5.5.x
I see all your sites are up now. What did you do to fix it. Did turning off the error report helped?crypto3 wrote:Dear All,
After upgrading from MySql 5.1 to MySql 5.5 all my Joomla! sites get down and corrupted, please once check this website: http://www.afghanvoip.com and all other websites going the same like http://www.yeget.net.
Can anyone please help me sort it out here.
I have Joomla 1.5.26 and 2.5.6 installed on the sites.
Thank you
Crypto