?
avatar tot-to
tot-to
13 Oct 2014

Steps to reproduce the issue

  1. Install Joomla
  2. Crate user and database (owned by this user) for Joomla with PostgreSQL
  3. Navigate to http://example.com/installation/ and configure joomla using this database and db user, choosing English (UK) as language during the installation.
  4. On the page titled "Congratulations! Joomla! is now installed.", click on the button "Extra steps: Install languages"
  5. Choose a language (I choose Russian) and click "Next" #### Expected result Successful installation of language pack. No database errors. #### Actual result Accornig to the webpage language installation takes forever. In log file /var/lib/postgresql/9.2/data/postmaster.log the error message appears:

WARNING: nonstandard use of \ in a string literal at character 159
HINT: Use the escape string syntax for backslashes, e.g., E'\'.
ERROR: invalid input syntax for integer: "" at character 102
STATEMENT: SELECT "update_id"
FROM "jrece_updates"
WHERE element = 'ru-RU' AND type = 'language' AND client_id = '' AND folder = ''

System information (as much as possible)

Gentoo GNU/Linux with linux 3.10.41-gentoo-r1
apache-2.2.27-r4
php-5.5.16
postgresql-9.2.9

Additional comments

In case if I skip the laguage pack installation and try to install it from the admin interface, I get the same error.

See also:
https://bugs.gentoo.org/show_bug.cgi?id=524778

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
3.00

avatar tot-to tot-to - open - 13 Oct 2014
avatar hnaparst
hnaparst - comment - 15 Oct 2014

This bug is a duplicate of This Bug
That bug was marked as closed, because it was a duplicate of 33560, which does not appear to exist, or appears to be something else entirely.

Thus, this bug is still outstanding and has been outstanding for quite a while.

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar brianteeman
brianteeman - comment - 15 Oct 2014

You are correct that was my fault they are not the same - mistakes happen

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar nicksavov
nicksavov - comment - 16 Oct 2014

Thanks all! Could you submit a pull request for it? Here's a really easy way how:
http://docs.joomla.org/Using_the_Github_UI_to_Make_Pull_Requests

avatar hnaparst
hnaparst - comment - 16 Oct 2014

Unless I have missed something, this bug is unresolved and has no proposed fix.

Regards,
Harold Naparst

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar nicksavov
nicksavov - comment - 16 Oct 2014

Maybe I'm missing something, but it appears it's just syntax errors that are stopping the execution. Those syntax errors can be fixed and submitted as a pull request to get them permanently fixed in the Joomla core.

avatar hnaparst
hnaparst - comment - 16 Oct 2014

Great. Well to answer your question above then, no, I cannot submit a pull request, since I am not a developer. Neither is tot-to. We are just end users submitting this bug.

avatar nicksavov
nicksavov - comment - 16 Oct 2014

No problem (I'm not a developer either, so you're in good company). Thanks for submitting! I'm confident this will end up being a simple fix for a developer, so hopefully we should see it fixed soon.

avatar nicksavov nicksavov - change - 16 Oct 2014
Labels Added: ?
avatar wilsonge
wilsonge - comment - 17 Oct 2014

Can you guys try the fix at #1695 please?

avatar hnaparst
hnaparst - comment - 17 Oct 2014

Regarding https://github.com/yajiedesign/joomla-cms.git, it installed fine, but I cannot find any languages. Somehow, the connection to the language server doesn't work. Maybe I'm doing something wrong.

avatar wilsonge
wilsonge - comment - 17 Oct 2014

OK I've got postgres set up on my laptop - I'll try and replicate this!

avatar tot-to
tot-to - comment - 19 Oct 2014

I've tried to install patchtester extention in order to test your patch by uploading a zip file from my local computer and got this error on the web page:

0 Database query failed (error # %s): %s ERROR: current transaction is aborted, commands ignored until end of transaction block SQL=INSERT INTO "jrece_assets" ("name","title","rules","parent_id","level","lft","rgt") VALUES ('com_patchtester','com_patchtester','{}',1,1,105,106) RETURNING id

and here is how it looks in the log file:

ERROR: duplicate key value violates unique constraint "jrece_assets_pkey"
DETAIL: Key (id)=(1) already exists.
STATEMENT: INSERT INTO "jrece_assets"
("name","title","rules","parent_id","level","lft","rgt") VALUES
('com_patchtester','com_patchtester','{}',1,1,105,106)
RETURNING id
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT 1;
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jrece_modules AS m
LEFT JOIN jrece_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN jrece_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '1970-01-01 00:00:00' OR m.publish_up <= '2014-10-19 20:52:15') AND (m.publish_down = '1970-01-01 00:00:00' OR m.publish_down >= '2014-10-19 20:52:15') AND m.access IN (1,1,2,3,6) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT 1;
WARNING: nonstandard use of \ in a string literal at character 36
HINT: Use the escape string syntax for backslashes, e.g., E'\'.
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: UPDATE "jrece_session"
SET "data" = '__default|a:8:{s:15:"session.counter";i:7;s:19:"session.timer.start";i:1413751520;s:18:"session.timer.last";i:1413751893;s:17:"session.timer.now";i:1413751935;s:22:"session.client.browser";s:65:"Mozilla/5.0 (Windows NT 6.1; rv:22.0) Gecko/20130405 Firefox/22.0";s:8:"registry";O:24:"Joomla\Registry\Registry":1:{s:7:"\0\0\0data";O:8:"stdClass":2:{s:11:"application";O:8:"stdClass":1:{s:4:"lang";s:5:"en-GB";}s:13:"com_installer";O:8:"stdClass":2:{s:7:"message";s:0:"";s:17:"extension_message";s:0:"";}}}s:4:"user";O:5:"JUser":27:{s:9:"\0\0\0isRoot";b:1;s:2:"id";s:3:"362";s:4:"name";s:10:"Super User";s:8:"username";s:3:"zag";s:5:"email";s:20:"zag@ofme.phys.msu.ru";s:8:"password";s:60:"$2y$10$9Cc/rxxvXc7RBmeOISeN1uxJ3tErtVftuWeVevMycddnNTXDv7fQO";s:14:"password_clear";s:0:"";s:5:"block";s:1:"0";s:9:"sendEmail";s:1:"1";s:12:"registerDate";s:19:"2014-10-19 20:44:59";s:13:"lastvisitDate";s:19:"1970-01-01 00:00:00";s:10:"activation";s:1:"0";s:6:"params";s:0:"";s:6:"groups";a:1:{i:8;s:1:"8";}s:5:"guest";i:0;s:13:"lastResetTime";s:19:"1970-01-01 00:00:00";s:10:"resetCount";s:1:"0";s:12:"requireReset";s:1:"0";s:10:"\0\0\0_params";O:24:"Joomla\Registry\Registry":1:{s:7:"\0\0\0data";O:8:"stdClass":0:{}}s:14:"\0\0\0_authGroups";a:2:{i:0;i:1;i:1;i:8;}s:14:"\0\0\0_authLevels";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:"\0\0\0_authActions";N;s:12:"\0\0\0_errorMsg";N;s:10:"\0\0\0_errors";a:0:{}s:3:"aid";i:0;s:6:"otpKey";s:0:"";s:4:"otep";s:0:"";}s:13:"session.token";s:32:"75fb49fe4cdebedffb3ce91faf3b979d";}'
, "time" = '1413751935'
WHERE "session_id" = '6v0jhuq04gsu6las37m49vum07'
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT 1;

Is there a way to download a file that can be used with patch utility in the installation dir? I would try that.
Should I post another bug report on extention installation?

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar tot-to
tot-to - comment - 19 Oct 2014

Oh, I didn't noticed that there my username, e-mail and password hash are included in the error message. Could anyone please mask them?

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar wilsonge
wilsonge - comment - 19 Oct 2014

#4650 go to github here. And you can edit your post

avatar wilsonge
wilsonge - comment - 19 Oct 2014

on the original issue your reporting though - are you using postgres or mssql?

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar tot-to
tot-to - comment - 19 Oct 2014

Thanks! I've managed to edit my previous comment.

As I indicated in the origial report, I use PostgreSQL-9.2.9 on Gentoo Linux. Why did you decide I could be using Microsoft SQL server?

avatar wilsonge
wilsonge - comment - 19 Oct 2014

Because I completely missed you were the person who initially reported the issue :D The patchester bug has been fixed. I'm just waiting for @mbabker to release a new version of it!

avatar waader
waader - comment - 23 Oct 2014

I tested this one using PostreSQL-9.3.5 on Centos 6.5 with php 5.4.16. What I did:

  • install the current staging branch
  • changed in libraries/cms/installer/adapter/language.php the line as done in #1695; the other line in administrator/components/com_admin/sql/updates/postgresql/3.0.3.sql is already change in the current staging branch
  • did a fresh install with the "Extra step: Install language"
  • set "Activate the multilingual feature" to No and leave the rest unchanged Result: the installation went fine.

So I did a second attempt, same as above, with setting addionally the

  • "Install localised content" to Yes Result: the progress bar run forever and the installation did not finish successfully.

One thing that I also noticed:
With the current staging branche I get the following error, when I try to install a language in the backend (Extensions -> Language Manager -> Install Language etc.):

0 Database query failed (error # %s): %s SQL=SELECT "update_id" FROM "abcd_updates" WHERE element = 'de-DE' AND type = 'language' AND client_id = '' AND folder = ''

With the one line change in libraries/cms/installer/adapter/language.php the error goes away!!

avatar zero-24 zero-24 - close - 2 Dec 2014
avatar wilsonge wilsonge - change - 2 Dec 2014
Status New Closed
avatar jissues-bot jissues-bot - close - 2 Dec 2014
avatar jissues-bot jissues-bot - change - 2 Dec 2014
Status New Closed
Closed_Date 0000-00-00 00:00:00 2014-12-02 23:06:27
avatar wilsonge
wilsonge - comment - 2 Dec 2014

This has been fixed in 3.4 alpha 1. So I am closing this. Thanks everyone for the report and testing of potential fixes!!

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.

avatar jissues-bot
jissues-bot - comment - 2 Dec 2014

Set to "closed" on behalf of @wilsonge by The JTracker Application at issues.joomla.org/joomla-cms/4650

avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?
Removed: ?

Add a Comment

Login with GitHub to post a comment