|
installation error 4 Years, 3 Months ago
|
Karma: 0
|
i tried to install and i got this error:
| Code: |
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 'ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=238' at li SQL=CREATE TABLE IF NOT EXISTS
`jos_aw_ext` ( `id` int(11) NOT NULL auto_increment,
`extension` varchar(10) NOT NULL, `server` varchar(50) NOT
NULL, `notfound` varchar(30) NOT NULL, `inmodule`
tinyint(1) NOT NULL default '0', `checked` tinyint(1) NOT
NULL default '0', `ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=238 ;
SQL =
CREATE TABLE IF NOT EXISTS `jos_aw_ext` (
`id` int(11) NOT NULL auto_increment,
`extension` varchar(10) NOT NULL,
`server` varchar(50) NOT NULL,
`notfound` varchar(30) NOT NULL,
`inmodule` tinyint(1) NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238 ;
|
<br><br>Post edited by: admin, at: 2007/10/30 09:12 |
|
|
|
|
|
|
Re:installation error 4 Years, 3 Months ago
|
Karma: 2
|
Please let me know the following:
- which version of AjaxWhois you tried to install?
- make sure that you are using Joomla ver 1.0.12+.
Admin |
|
|
|
|
|
|
Re:installation error 4 Years, 3 Months ago
|
Karma: 0
|
|
im using joomla 1.0.13 and i was trying to install com_ajaxwhois v0.2.31 beta<br><br>Post edited by: vndesire, at: 2007/10/30 09:19
|
|
|
|
|
|
|
Re:installation error 4 Years, 3 Months ago
|
Karma: 1
|
|
Hi,
@vndesire: if you have already installed the first version of ajax_whois component go to "ajaxwhois.xml" file and delete the rows with the sql query. It`s located in line 12.
Then you can fix that install problem. If you don´t have installed any version aof ajax whois bevore you have to wait for a fix from the admin.<br><br>Post edited by: milos, at: 2007/10/30 14:51
|
|
|
|
|
|
|
Re:installation error 4 Years, 3 Months ago
|
Karma: 2
|
Run this query manually:
| Code: |
CREATE TABLE IF NOT EXISTS `jos_aw_ext` (
`id` int(11) NOT NULL auto_increment,
`extension` varchar(10) NOT NULL,
`server` varchar(50) NOT NULL,
`notfound` varchar(30) NOT NULL,
`inmodule` tinyint(1) NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238;
|
Now try to install the component. |
|
|
|
|
|
|
Re:installation error 4 Years, 3 Months ago
|
Karma: 1
|
Install runs now how it should. Good work. Fast fix!  |
|
|
|
|
|
|
