Welcome, Guest
Please Login or Register.    Lost Password?

SQL error on installation [Solved]
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!


Go to bottomPage: 1
TOPIC: SQL error on installation [Solved]
#227
SQL error on installation [Solved] 6 Months ago Karma: 0
Edit: NEVER MIND! I was trying to install the 4-5 upgrade rather than the actual 5 release!
(original post below)
------------------------

I just purchased the plugin, downloaded it and was unable to install. Then discovered I needed to download the RAR file, which I did. I unrarred it, then attempted to install the component.

However I received the error message below. To troubleshoot, I've checked my permissions according to another post I saw, and all folders are writable.

I have a number of components, plugins, and modules in joomla... (all installed with no issues).

Please advise. Thanks.
(PS I xxed out mysql number)

Code:


JInstaller::install: SQL Error. DB function failed with error number 1146
Table 'admin_mysqlxxxxxxxxxxxxxxxxxxx.jos_grids' doesn't exist SQL=ALTER TABLE `jos_grids` ADD `secOrder` VARCHAR( 63 ) NOT NULL, ADD `nrRecSelect` TINYINT( 1 ) NOT NULL, ADD `link` VARCHAR( 63 ) NOT NULL , ADD `img` VARCHAR( 63 ) NOT NULL , ADD `columnWidth` VARCHAR( 63 ) NOT NULL , ADD `lineHeight` INT( 3 ) NOT NULL, CHANGE `sortField` `typejx` VARCHAR( 4 ) NOT NULL, CHANGE `sortDirection` `default_order` VARCHAR( 63 ) NOT NULL;
SQL = 
ALTER TABLE `jos_grids` 
ADD `secOrder` VARCHAR( 63 ) NOT NULL,
ADD  `nrRecSelect` TINYINT( 1 ) NOT NULL,
ADD `link` VARCHAR( 63 ) NOT NULL ,
ADD `img` VARCHAR( 63 ) NOT NULL ,
ADD `columnWidth` VARCHAR( 63 ) NOT NULL ,
ADD `lineHeight` INT( 3 ) NOT NULL, 

CHANGE `sortField` `typejx` VARCHAR( 4 ) NOT NULL,

CHANGE `sortDirection` `default_order` VARCHAR( 63 )  NOT NULL;Component Install: SQL Error. DB function failed with error number 1146
Table 'admin_mysqlxxxxxxxxxxxxxxxxxxxx.jos_grids' doesn't exist SQL=ALTER TABLE `jos_grids` ADD `secOrder` VARCHAR( 63 ) NOT NULL, ADD `nrRecSelect` TINYINT( 1 ) NOT NULL, ADD `link` VARCHAR( 63 ) NOT NULL , ADD `img` VARCHAR( 63 ) NOT NULL , ADD `columnWidth` VARCHAR( 63 ) NOT NULL , ADD `lineHeight` INT( 3 ) NOT NULL, CHANGE `sortField` `typejx` VARCHAR( 4 ) NOT NULL, CHANGE `sortDirection` `default_order` VARCHAR( 63 ) NOT NULL;
SQL = 
ALTER TABLE `jos_grids` 
ADD `secOrder` VARCHAR( 63 ) NOT NULL,
ADD  `nrRecSelect` TINYINT( 1 ) NOT NULL,
ADD `link` VARCHAR( 63 ) NOT NULL ,
ADD `img` VARCHAR( 63 ) NOT NULL ,
ADD `columnWidth` VARCHAR( 63 ) NOT NULL ,
ADD `lineHeight` INT( 3 ) NOT NULL, 

CHANGE `sortField` `typejx` VARCHAR( 4 ) NOT NULL,

CHANGE `sortDirection` `default_order` VARCHAR( 63 )  NOT NULL;

wdemilly
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/07 04:19 By viljem.
The administrator has disabled public write access.
 
#228
Re:SQL error on installation 5 Months, 4 Weeks ago Karma: 1
Nevermind, it happens.

Best regards,
Viljem
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting