https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


SQL error on installation [Solved]

  • wdemilly
  • wdemilly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 2 months ago #227

Edit: NEVER MIND! :unsure: 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)
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;
:unsure:

Last edit: 14 years 2 months ago by user62.

Please Log in or Create an account to join the conversation.

More
14 years 2 months ago #228

Nevermind, it happens.

Best regards,
Viljem

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.164 seconds

Contact Us

Contact us on Discord

Contact us on Facebook