[#4809] - postgresql sql errors on a new site with blog sample data
- Closed
- 23 Nov 2014
- Medium
- Build: master
- # 4809
Steps to reproduce the issue
Install J3.3.6 with blog sample data in a postgresql db
Go to the frontend and so should see this error message:
0 Database query failed (error # %s): %s SQL=SELECT EXTRACT (MONTH FROM "created") AS created_month,created, id, title,EXTRACT (YEAR FROM "created") AS created_year FROM d7rx1_content WHERE state = 2 AND checked_out = 0 GROUP BY created_year DESC, created_month DESC LIMIT 10
Expected result
Actual result
System information (as much as possible)
J3.3.6 or J3.3.7-dev
Postgresql 9.3.5
php 5.4.16
Centos 6.5
Additional comments
Votes
nicksavov
- | Labels |
Added:
?
|
||
| Status | New | ⇒ | Confirmed |
| Priority | Low | ⇒ | Medium |
I retested this one with the current staging branche and didn´t experience this problem any more. I only noticed this character - Â - in some of the articles eg. "About your home page" or "Your Modules" or "Your Template". But that´s another story.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4809.
As this is no longer valid with 3.4alpha I am closing this as it ha obv been resolved elsewehere
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4809.
zero-24
- | Status | Confirmed | ⇒ | Closed |
Set to "closed" on behalf of @brianteeman by The JTracker Application at issues.joomla.org/joomla-cms/4809
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-11-23 21:50:35 |
| Labels |
Added:
?
Removed: ? |
||
I get a completely different sql error in a different module if I install with the test data
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4809.