search

Guite / MostGenerator

Transformation cartridges for generating Symfony bundles from ModuleStudio models.
https://modulestudio.de
23 stars 2 forks source link

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-4' for key 'PRIMARY'Error! Update attempt failed. #275

Closed rallek closed 11 years ago

rallek commented 11 years ago

following steps I have made:

Opening an initial item of my module for edit, change something, submit the item.

State is approved (fine so far)

now I edit the same item again change something, update Now I get the following error message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-4' for key 'PRIMARY'Error! Update attempt failed.

Going back to my list the item is changed

rallek commented 11 years ago

same if I unpublish or publish the item

Guite commented 11 years ago

Are there any relationships involved with this item?

rallek commented 11 years ago

yes m:n

rallek commented 11 years ago

I choose from my table m two items of n. Than I do have this error.

There in in the dropdown of table n a first empty row. If I choose this one I get the following error:

Could not load the 'kleinanzeigen' module at 'edit'.
[Syntax Error] line 0, col 131: Error: Expected Literal, got ')'

Exception Trace
#0 Exception thrown in /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/QueryException.php, line 42.
#1 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(2157): Doctrine\ORM\Query\Parser->syntaxError('Literal')
#2 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(2172): Doctrine\ORM\Query\Parser->Literal()
#3 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(2569): Doctrine\ORM\Query\Parser->InParameter()
#4 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(2060): Doctrine\ORM\Query\Parser->InExpression()
#5 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(1994): Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
#6 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(1953): Doctrine\ORM\Query\Parser->ConditionalPrimary()
#7 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(1923): Doctrine\ORM\Query\Parser->ConditionalFactor()
#8 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(1899): Doctrine\ORM\Query\Parser->ConditionalTerm()
#9 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(1218): Doctrine\ORM\Query\Parser->ConditionalExpression()
#10 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(769): Doctrine\ORM\Query\Parser->WhereClause()
#11 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(738): Doctrine\ORM\Query\Parser->SelectStatement()
#12 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(210): Doctrine\ORM\Query\Parser->QueryLanguage()
#13 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query/Parser.php(281): Doctrine\ORM\Query\Parser->getAST()
#14 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query.php(213): Doctrine\ORM\Query\Parser->parse()
#15 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/Query.php(234): Doctrine\ORM\Query->_parse()
#16 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute()
#17 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/plugins/Doctrine/lib/vendor/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1)
#18 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Entity/Repository/Base/Kategorie.php(384): Doctrine\ORM\AbstractQuery->getResult()
#19 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Api/Base/Selection.php(84): Kleinanzeigen_Entity_Repository_Base_Kategorie->selectWhere('tbl.id IN ()', '', true, false)
#20 [internal function]: Kleinanzeigen_Api_Base_Selection->getEntities(Array)
#21 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/util/ModUtil.php(1091): call_user_func(Array, Array)
#22 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/util/ModUtil.php(1199): ModUtil::exec('Kleinanzeigen', 'selection', 'getEntities', Array, true, NULL)
#23 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Form/Plugin/Base/AbstractObjectSelector.php(382): ModUtil::apiFunc('Kleinanzeigen', 'selection', 'getEntities', Array)
#24 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Form/Plugin/Base/AbstractObjectSelector.php(364): Kleinanzeigen_Form_Plugin_Base_AbstractObjectSelector->fetchRelatedItems(Object(Zikula_Form_View), Array)
#25 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Form/Plugin/Base/RelationSelectorList.php(69): Kleinanzeigen_Form_Plugin_Base_AbstractObjectSelector->processRequestData(Object(Zikula_Form_View), 'POST')
#26 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/Zikula/Form/View.php(1257): Kleinanzeigen_Form_Plugin_Base_RelationSelectorList->decode(Object(Zikula_Form_View))
#27 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/Zikula/Form/View.php(1256): Zikula_Form_View->decodePlugins_rec(Array)
#28 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/Zikula/Form/View.php(1241): Zikula_Form_View->decodePlugins_rec(Array)
#29 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/Zikula/Form/View.php(273): Zikula_Form_View->decodePlugins()
#30 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/modules/Kleinanzeigen/lib/Kleinanzeigen/Controller/Base/Admin.php(260): Zikula_Form_View->execute('admin/kleinanze...', Object(Kleinanzeigen_Form_Handler_Admin_Kleinanzeige_Edit))
#31 [internal function]: Kleinanzeigen_Controller_Base_Admin->edit(Array)
#32 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/util/ModUtil.php(1091): call_user_func(Array, Array)
#33 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/lib/util/ModUtil.php(1173): ModUtil::exec('Kleinanzeigen', 'admin', 'edit', Array, false, NULL)
#34 /www/htdocs/w00dd23a/www/kleinanzeigen/Zikula/index.php(78): ModUtil::func('Kleinanzeigen', 'admin', 'edit', Array)
#35 {main}
Guite commented 11 years ago

Both fixed in 7764434397dd5f2f24b1ffcf5663de7134afcc14