Feeling Lucky
?
[#6326] - PostgreSQL - sql error save category with tag
- Closed
- 9 Jul 2015
- Medium
- Build: staging
- # 6326
- Diff
- alikon:patch-9
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Steps to reproduce the issue
go to the category manager and create or edit a category In the tags field create or add a tag then click "Save".
Expected result
The category is saved with the tag
Actual result
the tag field is cleared and the category is not saved
System information
PostgreSQL 9.3.5
Joomla 3.4.0
Additional comments
added a sanity check for NOT NULL FIELDS
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Category | ⇒ | Postgresql SQL |
| Category | Postgresql SQL | ⇒ | Postgresql SQL Tags |
brianteeman
- comment
- 23 May 2015
Issue confirmed
Tested with this PR an #6314
Issue resolved
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6326.
| Status | Pending | ⇒ | Ready to Commit |
zero-24
- comment
- 26 Jun 2015
RTC based on testing 
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6326.
| Labels |
Added:
?
|
||
| Status | Ready to Commit | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-07-09 08:04:38 |
| Closed_By | ⇒ | Kubik-Rubik |
| Labels |
Removed:
?
|
||
@alikon Please try the following test cases:
mssql gives this error message:
23000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'core_xreference', table 'joomla34.dbo.ufv5y_ucm_content'; column does not allow nulls. INSERT fails.SQL=INSERT INTO ufv5y_ucm_content VALUES ('com_content.category','Joomla!','joomla','','1','1','{"category_layout":"","image":"","image_alt":""}','{"author":"","robots":""}','247','2011-01-01 00:00:00.000','2015-03-05 20:26:38','*','19','{}','{}','0','1','','','14','5')