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 = ''
Gentoo GNU/Linux with linux 3.10.41-gentoo-r1
apache-2.2.27-r4
php-5.5.16
postgresql-9.2.9
In case if I skip the laguage pack installation and try to install it from the admin interface, I get the same error.
Try that again: http://joomlacode.org/gf/project/joomla/tracker/%3Faction=TrackerItemEdit&tracker_item_id=17430/?action=TrackerItemEdit&tracker_item_id=33675&start=8775
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4650.
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.
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
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.
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.
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.
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.
Labels |
Added:
?
|
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.
OK I've got postgres set up on my laptop - I'll try and replicate this!
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.
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.
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.
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?
I tested this one using PostreSQL-9.3.5 on Centos 6.5 with php 5.4.16. What I did:
So I did a second attempt, same as above, with setting addionally the
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!!
Status | New | ⇒ | Closed |
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-12-02 23:06:27 |
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.
Set to "closed" on behalf of @wilsonge by The JTracker Application at issues.joomla.org/joomla-cms/4650
Labels |
Added:
?
Removed: ? |
This bug is a duplicate of
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.