Lookup Domain

.comUSD $8.95 .netUSD $8.95 .orgUSD $8.95

Login

1820 Members
0 Members Online
0 Guests Online
3733 Downloads
121403 Domains Served
FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
Re:SQL Error DB function failed with error number 106 (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:SQL Error DB function failed with error number 106
#290
carbonero (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
SQL Error DB function failed with error number 106 3 Months, 2 Weeks ago Karma: 0  
I was trying to install getting the following notice in Joomla-Backend:


QUOTE:
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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=238' at line 16 SQL=CREATE TABLE IF NOT EXISTS `hin_aw_ext` ( `id` int(11) NOT NULL auto_increment, `extension` varchar(10) NOT NULL, `price` varchar(10) NOT NULL, `server` varchar(50) NOT NULL, `notfound` varchar(30) NOT NULL, `incomponent` tinyint(1) NOT NULL default '0', `checkedc` tinyint(1) NOT NULL default '0', `orderingc` int(11) NOT NULL default '0', `inmodule` tinyint(1) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `registerP` tinyint(1) NOT NULL default '1', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238;
SQL =

CREATE TABLE IF NOT EXISTS `hin_aw_ext` (
`id` int(11) NOT NULL auto_increment,
`extension` varchar(10) NOT NULL,
`price` varchar(10) NOT NULL,
`server` varchar(50) NOT NULL,
`notfound` varchar(30) NOT NULL,
`incomponent` tinyint(1) NOT NULL default '0',
`checkedc` tinyint(1) NOT NULL default '0',
`orderingc` int(11) NOT NULL default '0',
`inmodule` tinyint(1) NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`registerP` tinyint(1) NOT NULL default '1',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238;


The Database Prefix is different from _jos. Might that be the problem?

- Joomla 1.0.15

Thanks for an answer,

Carbonero
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#291
admin (Admin)
Admin
Posts: 143
graph
User Online Now Click here to see the profile of this user
Re:SQL Error DB function failed with error number 106 3 Months, 2 Weeks ago Karma: 3  
Unzip the Ajax Whois zip file. Remove DEFAULT CHARSET=latin1, Zip again and install.

Admin
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#292
carbonero (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error DB function failed with error number 106 3 Months, 2 Weeks ago Karma: 0  
Perfect - thank you very much!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Warning: fopen(/home/softuff/public_html/components/com_sef/cache/shCacheContent.php) [function.fopen]: failed to open stream: Permission denied in /home/softuff/public_html/components/com_sef/shCache.php on line 74