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:
Rel_Number | ⇒ | 2799 | |
Relation Type | ⇒ | Related to |
@nicksavov can you add test instructions?
Both strings are in the lang files for 2.5.x too.
JLIB_INSTALLER_ABORT_COMP_INSTALL_SQL_ERROR
https://github.com/joomla/joomla-cms/blob/2.5.x/language/en-GB/en-GB.lib_joomla.ini#L427
https://github.com/joomla/joomla-cms/blob/2.5.x/administrator/language/en-GB/en-GB.lib_joomla.ini#L427
JLIB_INSTALLER_ERROR_SQL_ERROR
https://github.com/joomla/joomla-cms/blob/2.5.x/language/en-GB/en-GB.lib_joomla.ini#L567
https://github.com/joomla/joomla-cms/blob/2.5.x/administrator/language/en-GB/en-GB.lib_joomla.ini#L567
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.
OK, this should work to replicate it:
The same thing should be applicable for Joomla 3.
Title |
|
||||||
Build | 2.5.27 | ⇒ | staging & 2.5.x |
@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
Interesting. What are the exact steps you took?
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;
--> Error 500
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!
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-11-15 19:29:01 |
Labels |
Added:
?
|
Related to:
http://issues.joomla.org/tracker/joomla-cms/2799
#2799
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5006.