[#3087] - Cannot add article in Joomla 3.2 with PostgreSQL
- Closed
- 17 Oct 2014
- Medium
- Build: master
- # 3087
Joomla Version: 3.2.2
PostgreSQL version: 9.1+
OS: Ubuntu 12.04 and 13.10
PHP version: 5.3.10 (ubuntu 12.04) and 5.5.3 (Ubuntu 13.10)
Error
Save failed with the following error: Database query failed (error # %s): %s SQL=INSERT INTO "rvyni_content" ("id","title","alias","introtext","fulltext","state","catid","created","created_by","created_by_alias","modified","publish_up","publish_down","images","urls","attribs","version","metakey","metadesc","access","metadata","featured","language","xreference") VALUES (0,'Test Title','test-title','
Test Description
','',1,2,'2014-02-11 14:57:35',509,'','1970-01-01 00:00:00','2014-02-11 14:57:35','1970-01-01 00:00:00','{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}','{"show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}',1,'','',1,'{"robots":"","author":"","rights":"","xreference":""}',0,'*','') RETURNING id
Votes
I solved this problem using joomla 3.1.5 and Postgres 8.4 database.
check in Postgres table and click the "rvyni_content" then you need to clear the values of "NOT NULL" the following columns:
- images
- attribs
- metadata
- urls
good luck and backup the DB before.
You may blame the J!Tracker Application for transmitting this comment.
Can you verify if this is still an issue with Joomla 3.3.1? I think we had a few fixes for Postgres databases lately.
Yes
On Mon, Jun 16, 2014 at 10:22 PM, Thomas Hunziker notifications@github.com
wrote:
Can you verify if this is still an issue with Joomla 3.3.1? I think we had
a few fixes for Postgres databases lately.—
Reply to this email directly or view it on GitHub
#3087 (comment).
| Status | New | ⇒ | Pending |
| Category | ⇒ | Postgresql |
Just to confirm that this is still an issue with joomla 3.3.6 and Postgres 9.3.5.0
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/3087.
Joomla! 3.3.6
PostgreSQL version: 9.3.5
OS: Vista
PHP version: 5.5.9
The problem arise only on frontend on backend seems to work (except for tags)
A quick fix for frontend content submission could be as suggested:
ALTER TABLE #__content ALTER COLUMN images DROP NOT NULL
,ALTER COLUMN urls DROP NOT NULL
,ALTER COLUMN attribs DROP NOT NULL
,ALTER COLUMN metadata DROP NOT NULL
;
For a proper fix we need to decide the "nature" of these fields are they nullable or not
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/3087.
| Status | Pending | ⇒ | Confirmed |
Setting this issue as confirmed as I didn't find any fix for this yet.
| Status | Confirmed | ⇒ | Pending |
nicksavov
- | Labels |
Added:
?
|
||
Closing this in favour of 4687
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/3087.
zero-24
- 
Set to "closed" on behalf of @brianteeman by The JTracker Application at issues.joomla.org/joomla-cms/3087
| Status | Pending | ⇒ | Closed |
| Rel_Number | ⇒ | 4687 | |
| Relation Type | ⇒ | Related to |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-10-17 00:07:15 |
| Labels |
Added:
?
|
||
Hi we have the same issue here. Have you already solved it?
You may blame the J!Tracker Application for transmitting this comment.