Summary


as the summary: if i install tests data, data installation fails

 


JLIB_DATABASE_QUERY_FAILED SQL=INSERT INTO "by4n2_tags" VALUES (1,0,0,1,0,'','ROOT','root','','',1,0,'1970-01-01 00:00:00',1,'{}','','','',0,'2011-01-01 00:00:01','',0,'1970-01-01 00:00:00','','',0,'*',1,'1970-01-01 00:00:00','1970-01-01 00:00:00'), (2,1,1,2,1,'red','Red','red','','',1,0,'1970-01-01 00:00:00',1,'{"tag_layout":"","tag_link_class":"label label-info","image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','','','{"author":"","robots":""}',716,'2013-10-15 14:52:40','',0,'1970-01-01 00:00:00','','',2,'*',1,'1970-01-01 00:00:00','1970-01-01 00:00:00'), (3,1,3,4,1,'yellow','Yellow','yellow','','',1,0,'1970-01-01 00:00:00',1,'{"tag_layout":"","tag_link_class":"label label-info","image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','','','{"author":"","robots":""}',716,'2013-10-15 14:52:53','',0,'1970-01-01 00:00:00','','',2,'*',1,'1970-01-01 00:00:00','1970-01-01 00:00:00'), (4,1,5,8,1,'green','Green','green','','',1,0,'1970-01-01 00:00:00',1,'{"tag_layout":"","tag_link_class":"label label-info","image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','','','{"author":"","robots":""}',716,'2013-10-15 14:53:14','',0,'1970-01-01 00:00:00','','',0,'*',1,'1970-01-01 00:00:00','1970-01-01 00:00:00'), (5,4,6,7,2,'green/lime','Lime','lime','','',1,0,'1970-01-01 00:00:00',1,'{"tag_layout":"","tag_link_class":"label label-info","image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}','','','{"author":"","robots":""}',716,'2013-10-15 14:53:36','',0,'1970-01-01 00:00:00','','',0,'*',1,'1970-01-01 00:00:00','1970-01-01 00:00:00')

JLIB_DATABASE_QUERY_FAILED SQL=INSERT INTO "by4n2_ucm_content" VALUES (1,'com_content.article','Joomla! Testing','joomla','

Thanks for helping us to test Joomla!
\r\n

We\'re getting ready for the release of Joomla and we appreciate you helping us find and fix problems as we work.
\r\n

If you haven\'t done testing before here are some tips.
\r\n

\r\n

Don\'t delete the installation folder when you finish installing! While we\'re working we turn that security feature off to make it easier to test.

\r\n

Go to global configuration and set Error Reporting to Development (that\'s on the server tab) and enable both debugging and language debugging (those are on the system tab). Don\'t worry when you see ** around words --that means Joomla translation is doing its job.

\r\n

\r\n

How to test
\r\n

\r\n

First, do the things you normally do and see if you spot any problems.

\r\n

Look at all of the front end views and record any problems

\r\n

Look at all the back end views and report any problems

\r\n

See more ideas below

\r\n

\r\n

What to look for
\r\n

\r\n

Any error messages that say things like Fatal Error or Strict or similar things that indicate that something is not working correctly.

\r\n

Untranslated strings. You will know these because they look like this: ?STRING_HERE?

\r\n

Problems of rendering--items not aligned correctly, missing or wrong images, pages that just don\'t look right.

\r\n

Unexpected behavior--anything that is working differently than it did in 2.5.

\r\n

\r\n

Report problems
\r\n

If you find a problem please report it to the CMS Issue Tracker. You will need to register for a joomlacode.org account if you don\'t have one.
\r\n

More Testing Ideas
\r\n

\r\n

Pick one module or view and test all of the parameters.

\r\n

Install an extension and see if anything breaks (report to the developer unless you are positive it is a core bug).

\r\n

Turn on caching with different options

\r\n

Try different session options

\r\n

Install a language and test all the layouts.

\r\n

Try different environments (like different servers which may have different version of PHP) or try you have IIS with MySQLi or SqlSrv. With millions of users Joomla needs to be ready for unusual environments.

\r\n

Try with SEF URLS on or off and also with Apache rewrite on or off (if you are on Apache).

\r\n

Try different combinations of browsers (Chrome, IE, FireFox, Opera to start) and operating systems (Mac, Windows, Linux).

\r\n

Yes grammar and spelling errors are bugs too -- just keep in mind that we use British spelling.

\r\n

Visit the Feature Tracker and test a new feature.

\r\n

\r\n

Testing changes
\r\n

You can also help Joomla by testing bug fixes and new features.  A useful tool is the patchtester component which helps to simplify and automate the process.  Report your feedbak on the  CMS Issue Tracker. If you enjoy helping Joomla this way, you may want to join the Joomla Bug Squad.
\r\n

Â
',1,'',0,1,'{"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":""}',1,'{"robots":"","author":"","rights":"","xreference":""}',716,'','2011-01-01 00:00:01',0,'2013-10-15 14:57:20','*','2011-01-01 00:00:01','1970-01-01 00:00:00',24,180,'{"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":""}',59,3,2,'','',19,'',1), (2,'com_content.article','Similar Tags','archive-module-3','

This module shows a list  of items that have a similar list of tags to the current item.Â
\r\n

{loadmodule tags_similar,Similar Tags}
',1,'',0,1,'{"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":""}',0,'{"robots":"","author":"","rights":"","xreference":""}',716,'','2011-01-01 00:00:01',0,'2013-10-15 14:58:27','*','2011-01-01 00:00:01','1970-01-01 00:00:00',72,182,'{"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":""}',1,3,0,'modules, content','',64,'',1)

 
Opened On:
6 Feb 2014, 15:11 by Andrea Zagli
Closed On:
19 Apr 2014, 6:59
Status:
Duplicate Report

Filed Under

  • Apache 2.2.x
  • No Platform Implications
  • PHP 5.5
  • Postgres
  • SQL Files

Responses

Posted on 4 Mar 2014, 4:44 by Brian Teeman

I'm unable to confirm this. Which sql server are you using and what release - eg Mysql v5.04
Posted on 20 Mar 2014, 9:33 by Andrea Zagli

postgresql (8.4 or 9.3)
Posted on 20 Mar 2014, 15:53 by Andrea Zagli

just tried joomla 3.2.3 with the same error
Posted on 4 Apr 2014, 3:39 by Andrea Zagli

just tried joomla 3.3 beta 1: same error
Posted on 5 Apr 2014, 8:08 by Brian Teeman

Updated title to show POSTGRES
Posted on 19 Apr 2014, 6:59 by Brian Teeman

I am closing this as a duplicate of http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=33466&start=0

Please can you help to test the fix there so that it can be commited
Posted on 4 Nov 2014, 17:55 by Mattes H

Hi,

still see a similar problem:

Joomla 3.3.6 PostgreSQL 8.4.20 (The fix mentioned is in)

use case: Sample data; active web page, login as admin; write an article including cat, title and text

Observation:

Save failed with the following error: Database query failed (error # %s): %s SQL=INSERT INTO "jxv4f_content" ("title","alias","introtext","fulltext","state","catid","created","created_by","created_by_alias","publish_up","publish_down","version","metakey","metadesc","access","featured","language") VALUES ('Noch Ein Test','noch-ein-test','
Hello World
','',1,27,'2014-11-04 23:15:18',990,'','2014-11-04 23:15:18','1970-01-01 00:00:00',1,'','',1,0,'*') RETURNING id

Note: doing the same from administrator platform works fine!

 
Posted on 5 Nov 2014, 1:05 by Tobias Zulauf

@Mattes H.

Please retest the current joomla master: https://github.com/joomla/joomla-cms/archive/master.zip

If the issues still exists please open a new issue here: http://issues.joomla.org/tracker/joomla-cms/add

This Tracker is not longer used / monitored.

 

Thanks for understanding