?
Related to # 2799
avatar nicksavov
nicksavov
6 Nov 2014

When installing an extension that triggers an installer error due to SQL issue, the following is displayed.

Warning
JLIB_INSTALLER_ERROR_SQL_ERROR
JLIB_INSTALLER_ABORT_COMP_INSTALL_SQL_ERROR

EDIT (by @zero-24):

OK, this should work to replicate it:

avatar nicksavov nicksavov - open - 6 Nov 2014
avatar nicksavov nicksavov - change - 6 Nov 2014
The description was changed
Rel_Number 2799
Relation Type Related to
avatar nicksavov
nicksavov - comment - 6 Nov 2014
avatar nicksavov
nicksavov - comment - 7 Nov 2014

Interesting, so it's probably just the strings don't get translated.

I'm not sure how to replicate it, but I'm guessing if you:

Hopefully you'll be able to replicate it.

avatar nicksavov
nicksavov - comment - 7 Nov 2014

OK, this should work to replicate it:

The same thing should be applicable for Joomla 3.

avatar zero-24 zero-24 - change - 7 Nov 2014
The description was changed
Title
Undefined JLIB_INSTALLER strings in 2.5
Undefined JLIB_INSTALLER strings
Build 2.5.27 staging & 2.5.x
avatar zero-24
zero-24 - comment - 9 Nov 2014

@nicksavov hmm i get a error 500 if i do so.

JDatabaseMySQLi::query: 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 'ALTyasdER TABLasdE `jos_asd` CHANasdGE `prosdfiasdle_vasdasdalue` `asd` TEasdX' at line 1 SQL=ALTyasdER TABLasdE `jos_asd` CHANasdGE `prosdfiasdle_vasdasdalue` `asd` TEasdXT NOT NUasdLL;

**Return to Control Panel**

Call stack  
#       Function        Location    
1       JAdministrator->dispatch()      Joomla-Web-Root\administrator\index.php:46  
2       JComponentHelper::renderComponent()     Joomla-Web-Root\administrator\includes\application.php:153  
3       JComponentHelper::executeComponent()        Joomla-Web-Root\libraries\joomla\application\component\helper.php:348   
4       require_once()      Joomla-Web-Root\libraries\joomla\application\component\helper.php:380   
5       JController->execute()      Joomla-Web-Root\administrator\components\com_installer\installer.php:18 
6       InstallerControllerInstall->install()       Joomla-Web-Root\libraries\joomla\application\component\controller.php:761   
7       InstallerModelInstall->install()        Joomla-Web-Root\administrator\components\com_installer\controllers\install.php:29   
8       JInstaller->install()       Joomla-Web-Root\administrator\components\com_installer\models\install.php:105   
9       JInstallerFile->install()       Joomla-Web-Root\libraries\joomla\installer\installer.php:472    
10      JInstaller->parseSchemaUpdates()        Joomla-Web-Root\libraries\joomla\installer\adapters\file.php:291    
11      JDatabaseMySQLi->execute()      Joomla-Web-Root\libraries\joomla\installer\installer.php:1145   
12      JError::raiseError()        Joomla-Web-Root\libraries\joomla\database\database\mysqli.php:396   
13      JError::raise()     Joomla-Web-Root\libraries\joomla\error\error.php:251

Can you paste the language files that are loaded?

    **Loaded** : JROOT\administrator/language/en-GB/en-GB.ini
    **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logout.ini
    **Loaded** : JROOT/administrator/language/en-GB/en-GB.lib_joomla.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.tpl_bluestork.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_installer.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_version.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_submenu.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_title.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_toolbar.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_status.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.mod_menu.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_banners.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_contact.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_messages.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_newsfeeds.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_finder.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_joomlaupdate.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_search.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_weblinks.sys.ini
    **Loaded** : JROOT\administrator/language/en-GB/en-GB.com_redirect.sys.ini
    **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_debug.ini

For me all looks ok as it is loaded.

Loaded : JROOT/administrator/language/en-GB/en-GB.lib_joomla.ini

avatar nicksavov
nicksavov - comment - 10 Nov 2014

Interesting. What are the exact steps you took?

avatar zero-24
zero-24 - comment - 14 Nov 2014

sorry @nicksavov for the late response.

I have done the following this steps:

--> Error 500

ALTyasdER TABLasdE `jos_asd` CHANasdGE `prosdfiasdle_vasdasdalue` `asd` TEasdX' at line 1 SQL=ALTyasdER TABLasdE `jos_asd` CHANasdGE `prosdfiasdle_vasdasdalue` `asd` TEasdXT NOT NUasdLL;
  • zip up the Joomla package
  • then install it as an extension

--> Error 500

avatar zero-24 zero-24 - close - 15 Nov 2014
avatar nicksavov
nicksavov - comment - 15 Nov 2014

Thanks Tobias! OK, I'm gong to go ahead and close it, until I can find some steps to replicate it or if someone else can. Thanks again!

avatar nicksavov nicksavov - close - 15 Nov 2014
avatar nicksavov nicksavov - change - 15 Nov 2014
Status New Closed
Closed_Date 0000-00-00 00:00:00 2014-11-15 19:29:01
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment