Glossword is a system written in PHP to create and publish online multilingual dictionary, glossary, or encyclopedia. It features installation wizard, UTF-8 support, visual themes, export/import dictionaries in XML/CSV format, delayed postings, history of changes, and more.
I am trying to install the latest version of the glossword on joomla 1.5.15 but it is returning following error.
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 'COMPACT' at line 11 SQL=CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; SQL = CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; 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 'COMPACT' at line 11 SQL=CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; SQL = CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
8 коммент.:
I am trying to install the latest version of the glossword on joomla 1.5.15 but it is returning following error.
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 'COMPACT' at line 11 SQL=CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
SQL =
CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` (
`id_sess` char(32) NOT NULL,
`id_user` int(10) unsigned NOT NULL DEFAULT '1',
`is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1',
`mdate` datetime NOT NULL,
`sess_settings` blob,
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`ua` varchar(255) NOT NULL,
PRIMARY KEY (`id_sess`),
KEY `changed` (`mdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
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 'COMPACT' at line 11 SQL=CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` ( `id_sess` char(32) NOT NULL, `id_user` int(10) unsigned NOT NULL DEFAULT '1', `is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1', `mdate` datetime NOT NULL, `sess_settings` blob, `ip` int(10) unsigned NOT NULL DEFAULT '0', `ua` varchar(255) NOT NULL, PRIMARY KEY (`id_sess`), KEY `changed` (`mdate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
SQL =
CREATE TABLE IF NOT EXISTS `jos_gw_sessions_jos` (
`id_sess` char(32) NOT NULL,
`id_user` int(10) unsigned NOT NULL DEFAULT '1',
`is_remember` tinyint(1) unsigned NOT NULL DEFAULT '1',
`mdate` datetime NOT NULL,
`sess_settings` blob,
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`ua` varchar(255) NOT NULL,
PRIMARY KEY (`id_sess`),
KEY `changed` (`mdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
Could yo please help in solving this??
Too old version of mysql.
Solution http://code.google.com/p/glossword/issues/detail?id=139
[URL=http://imgwebsearch.com/35348/link/online%20dating/1_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/1_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/online%20dating/2_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/2_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/online%20dating/3_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/3_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/online%20dating/1_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/1_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/online%20dating/2_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/2_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/online%20dating/3_dating6.html][IMG]http://imgwebsearch.com/35348/img0/online%20dating/3_dating6.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/1_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/1_pharma10.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/2_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/2_pharma10.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/3_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/3_pharma10.png[/IMG][/URL]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/coNz4o]Online Casino Gambling[/url]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/9q4tTo]Online Sports Gambling[/url]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/1_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/1_pharma10.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/2_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/2_pharma10.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/herbal%20weight%20loss/3_pharma10.html][IMG]http://imgwebsearch.com/35348/img0/herbal%20weight%20loss/3_pharma10.png[/IMG][/URL]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/coNz4o]Online Casino Gambling[/url]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/9q4tTo]Online Sports Gambling[/url]
[URL=http://imgwebsearch.com/35348/link/mesothelioma/1_pharma4.html][IMG]http://imgwebsearch.com/35348/img0/mesothelioma/1_pharma4.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/mesothelioma/2_pharma4.html][IMG]http://imgwebsearch.com/35348/img0/mesothelioma/2_pharma4.png[/IMG][/URL]
[URL=http://imgwebsearch.com/35348/link/mesothelioma/3_pharma4.html][IMG]http://imgwebsearch.com/35348/img0/mesothelioma/3_pharma4.png[/IMG][/URL]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/coNz4o]Online Casino Gambling[/url]
[url=http://bit.ly/ac01je]Online Gambling[/url]
[url=http://bit.ly/9q4tTo]Online Sports Gambling[/url]
Отправить комментарий