|
Installation problem 16 Years, 6 Months ago
|
Karma: 0
|
Hi,
I just purchased your ARIquiz, but the installation failed... Please tell me what to do.
| Code: |
* JInstaller::install: SQL fout. 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 11 SQL=CREATE TABLE IF NOT EXISTS `jos_arigenerictemplate` ( `TemplateId` int(10) unsigned NOT NULL auto_increment, `BaseTemplateId` int(11) NOT NULL, `TemplateName` varchar(255) NOT NULL, `Value` text, `Created` datetime NOT NULL, `CreatedBy` int(10) unsigned NOT NULL default '0', `Modified` datetime default NULL, `ModifiedBy` int(10) unsigned default '0', PRIMARY KEY (`TemplateId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_arigenerictemplate` (
`TemplateId` int(10) unsigned NOT NULL auto_increment,
`BaseTemplateId` int(11) NOT NULL,
`TemplateName` varchar(255) NOT NULL,
`Value` text,
`Created` datetime NOT NULL,
`CreatedBy` int(10) unsigned NOT NULL default '0',
`Modified` datetime default NULL,
`ModifiedBy` int(10) unsigned default '0',
PRIMARY KEY (`TemplateId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
* component Installeer: SQL fout. 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 11 SQL=CREATE TABLE IF NOT EXISTS `jos_arigenerictemplate` ( `TemplateId` int(10) unsigned NOT NULL auto_increment, `BaseTemplateId` int(11) NOT NULL, `TemplateName` varchar(255) NOT NULL, `Value` text, `Created` datetime NOT NULL, `CreatedBy` int(10) unsigned NOT NULL default '0', `Modified` datetime default NULL, `ModifiedBy` int(10) unsigned default '0', PRIMARY KEY (`TemplateId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_arigenerictemplate` (
`TemplateId` int(10) unsigned NOT NULL auto_increment,
`BaseTemplateId` int(11) NOT NULL,
`TemplateName` varchar(255) NOT NULL,
`Value` text,
`Created` datetime NOT NULL,
`CreatedBy` int(10) unsigned NOT NULL default '0',
`Modified` datetime default NULL,
`ModifiedBy` int(10) unsigned default '0',
PRIMARY KEY (`TemplateId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
Re:Installation problem 16 Years, 6 Months ago
|
Karma: 760
|
|
Please tell us which version of MySQL do you use?
|
|
|
|
|
|
|
Re:Installation problem 16 Years, 6 Months ago
|
Karma: 0
|
|
MySQL4.0
|
|
|
|
|
|
|
Re:Installation problem 16 Years, 6 Months ago
|
Karma: 760
|
|
Our specialist is looking into this problem. I hope we'll have the solution soon.
|
|
|
|
|
|
|
|
|
|
Last Edit: 2008/10/17 12:08 By admin.
|
|
|
Re:Installation problem 16 Years, 6 Months ago
|
Karma: 0
|
|
I upgraded the MySQL and installed the component.
Hope everything will be fine like this.
Thanks for your quick support!
Thomas
|
|
|
|
|
|
|
