good evening

sorry for my poor english

i ve joomla 1.5.12 and i like to install bearleague on my football website

i ve this message when i try to install throught my joomla backend:


JInstaller::install: Erreur SQL. 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 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` ( `photo_id` int(11) NOT NULL default '0', `cat_id` int(11) NOT NULL default '0', `cat_type` int(11) NOT NULL default '0', PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
SQL =
CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` (
`photo_id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`cat_type` int(11) NOT NULL default '0',
PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8Composant Installation: Erreur SQL. 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 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` ( `photo_id` int(11) NOT NULL default '0', `cat_id` int(11) NOT NULL default '0', `cat_type` int(11) NOT NULL default '0', PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
SQL =
CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` (
`photo_id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`cat_type` int(11) NOT NULL default '0',
PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

thank you for uour help

basdom

Dominique,

we sent you email

Regards,
team

Idem, please help me...

Con20,

fixed version available at Downloads -> Components

Regards,
john

Nothing, error with this version...

Code:

* JInstaller::install: Errore SQL. 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 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` ( `photo_id` int(11) NOT NULL default '0', `cat_id` int(11) NOT NULL default '0', `cat_type` int(11) NOT NULL default '0', PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
SQL =

CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` (
`photo_id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`cat_type` int(11) NOT NULL default '0',
PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

* componente Installa: Errore SQL. 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 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` ( `photo_id` int(11) NOT NULL default '0', `cat_id` int(11) NOT NULL default '0', `cat_type` int(11) NOT NULL default '0', PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
SQL =

CREATE TABLE IF NOT EXISTS `jos_bl_assign_photos` (
`photo_id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`cat_type` int(11) NOT NULL default '0',
PRIMARY KEY (`photo_id`,`cat_id`,`cat_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8



Joomla 1.5.14

Con20,

Have you used the 1.0.5 version?

regards,
john

No, i download 1.0.6

from:

http://beardev.com/downloads/components.html

confused...

have already tested.. no problem.. could you give us access to your Back-end?

john

Con20,

BearLeague component needs the MySQL version more then 4.1, therefore you have this error.

the problem is MySQL version less the 4.1 haven't 'DEFAULT CHARSET=utf8' command
But in your case i have deleted this command from xml file because Joomla 1.5.x require UTF8 charset as default and instal BearLeague.

If you have any problems with the charset - we will not be assume responsibility for it because you have MySQL version less than 4.1


regards,
John

thanks

Hi John!

Quote:
BearLeague component needs the MySQL version more then 4.1, therefore you have this error.

the problem is MySQL version less the 4.1 haven't 'DEFAULT CHARSET=utf8' command
But in your case i have deleted this command from xml file because Joomla 1.5.x require UTF8 charset as default and instal BearLeague.


I've the same installation error caused by the same problem (MySQL version is the 4.0.30); please, could you send me the modified file or package?

Tks in advance..

Alex

Hello,

it will be the custom solution, because officially we cannot support this MySQL version

Best Regards,
john

Hi John,

thank you for the answer..

I've understood this will be a custom solution, but unfortunately I can't change the MYSql version (my website is hosted on Aruba) and your component appears to be not only very good (I've read many good reviews), but either the only one to handle a ko tournament.

No way?

Alex

Hello,

We have only one way in this case - Customization

best regards,
john