Bug 524778 – www-apps/joomla-3.3.3 - 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 = ''

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description tot-to 2014-10-08 18:01:57 UTC]

I try to to use www-apps/joomla-3.3.3 with dev-db/postgresql-server-9.2.9, but get the database error (see below)

Reproducible: Always

Steps to Reproduce:
1. USE=postgres emerge joomla
2. webapp-config -I -h example.com joomla 3.3.3
3. createuser -U postgres -P -e joomla
4. createdb -U postgres -e -O joomla joomla
5. navigate web-browser to http://example.com/installation/
6. configure joomla
7. Click on "Extra steps: Install languages" button on the page titled "Congratulations! Joomla! is now installed."
6. Choose a language (I choose Russian) and click "Next"
Actual Results:  
On 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 = ''

Expected Results:  
Successful installation of language pack. No database errors.

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

[Comment 1 Harold Anderson 2014-10-09 10:35:26 UTC]

I will try to reproduce this.  Please paste the results of 

emerge --info

Also, just so you know, mysql is supported better that postgresql in Joomla.  In case that is an option for you.

[Comment 2 Harold Anderson 2014-10-09 10:37:28 UTC]

Please also list the results of this command:

eselect locale list

[Comment 3 tot-to 2014-10-09 11:06:14 UTC]

Created attachment 386292 [details]
most of "emerge --info" output

[Comment 4 tot-to 2014-10-09 11:07:36 UTC]

Available targets for the LANG variable:
  [1]   C
  [2]   POSIX
  [3]   en_US.utf8
  [4]   en_US.UTF-8 *
  [ ]   (free form)

[Comment 5 tot-to 2014-10-14 11:51:24 UTC]

I have opened a bug on joomla's tracker.
http://issues.joomla.org/tracker/joomla-cms/4650

(for some reason this Gentoo bugzilla says this url is not valid to be added to "See Also" section).

[Comment 6 Harold Anderson 2014-10-14 11:53:40 UTC]

Please keep me updated if this is an upstream bug.

[Comment 7 Harold Anderson 2014-10-14 11:56:28 UTC]

See Also URLs should point to one of:

    show_bug.cgi in a Gentoo's Bugzilla installation.
    A bug on launchpad.net
    An issue on code.google.com.
    A bug on bugs.debian.org.
    An issue in a JIRA installation.
    A ticket in a Trac installation.
    A bug in a MantisBT installation.
    A bug on sourceforge.net.
    An issue on github.com.

[Comment 8 Harold Anderson 2014-10-15 18:56:45 UTC]

For what it is worth, this bug only occurs with postgres.  With mysql, it works flawlessly.

[Comment 9 tot-to 2014-10-15 20:16:59 UTC]

According to the current discussion, they have had this bug reported before, but accidentally closed it as a duplicate of some other bug, which was something else, but not really duplicate.

The initial bug has been reported on Debian. So, it's not Gentoo-specific. Do you usually close bugs as "Resolved-Upstream" in such cases?

[Comment 10 Harold Anderson 2014-10-15 20:25:32 UTC]

Yeah, I was the one who pointed that out to upstream :).

I think the appropriate thing would be to change the status to CONFIRMED and leave it open.   That way, we know there are problems.

I am trying to get permission to be able to mark it as CONFIRMED.

[Comment 11 Harold Anderson 2014-12-03 16:34:37 UTC]

This bug has been resolved in joomla-3.4.0_alpha, which is in my overlay (hnaparst), and will shortly be added to portage.

I have confirmed that the bug is fixed by installing a fresh copy of Joomla and setting the language to Russian using a Postgres 9.3.5 backend.  If you want to access the example site, let me know.