|
|
|
installation error 8 Months, 1 Week 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
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
admin (Admin)
Admin
Posts: 143
|
|
Re:installation error 8 Months, 1 Week ago
|
Karma: 3
|
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
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:installation error 8 Months, 1 Week 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
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
milos (User)
Fresh Boarder
Posts: 6
|
|
Re:installation error 8 Months, 1 Week 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
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
admin (Admin)
Admin
Posts: 143
|
|
Re:installation error 8 Months, 1 Week ago
|
Karma: 3
|
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.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
milos (User)
Fresh Boarder
Posts: 6
|
|
Re:installation error 8 Months, 1 Week ago
|
Karma: 1
|
Install runs now how it should. Good work. Fast fix! 
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|