Jump to content

Error on database record posting: EX1366


Go to solution Solved by Marc,

Recommended Posts

Posted

As postend in my last support request we changed the server. Since then following issue occurs:

When posting a new database record it comes to the error code:  EX1366 and the record is not saved, here is the content of the system log to that issue:

INSERT INTO `cms_custom_database_7` ( `record_publish_date`, `record_last_comment`, `member_id`, `record_last_comment_by`, `record_last_comment_name`, `record_last_review`, `category_id`, `record_approved`, `record_locked`, `record_views`, `record_pinned`, `record_featured`, `record_future_date`, `record_comments`, `record_reviews`, `record_comments_queued`, `record_comments_hidden`, `record_image`, `record_image_thumb`, `field_45`, `field_46`, `field_72`, `field_47`, `field_48`, `field_49`, `field_60`, `field_61`, `field_63`, `field_62`, `field_65`, `field_81`, `field_66`, `field_67`, `field_68`, `field_69`, `field_70`, `field_71`, `field_112`, `field_64`, `field_74`, `record_saved`, `record_updated`, `record_allow_comments`, `record_dynamic_furl`, `record_static_furl` ) VALUES ( 1645625790, 1645625790, 9, 9, 'testuser10', 1645625790, 82, 1, false, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'Test Titel', '<p>
	test test test test test
</p>', '', 'https://www.testseite.de/', '', '', 'aussehen_0', 'service_0', 'pl_0', 'social_0', 'konv_0', 'serviceangeboten_ohne_angabe', 'fotos_ohne_angabe', 'ontime_ohne_angabe', 'outfit_ohne_angabe', 'alter_ohne_angabe', 'beratung_ohne_angabe', 'time_ohne_angabe', 'key_ja', '', '', 1645625790, 1645625790, true, 'test-titel', NULL )
IPS\Db\Exception: Incorrect decimal value: '' for column `db15*******`.`cms_custom_database_7`.`field_64` at row 1 (1366)
#0 /home/www/doc/*****/mydomain.de/www/system/Db/Db.php(948): IPS\_Db->preparedQuery('/*db*****0022::...', Array)
#1 /home/www/doc/*****/mydomain.de/www/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('cms_custom_data...', Array)
#2 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Records/Records.php(1904): IPS\Patterns\_ActiveRecord->save()
#3 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Records/Records.php(1073): IPS\cms\_Records->save()
#4 /home/www/doc/*****/mydomain.de/www/system/Content/Item.php(397): IPS\cms\_Records->processForm(Array)
#5 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Records/Records.php(2354): IPS\Content\_Item::createFromForm(Array, Object(IPS\cms\Categories7), true)
#6 /home/www/doc/*****/mydomain.de/www/system/Content/Item.php(133): IPS\cms\_Records::createFromForm(Array, Object(IPS\cms\Categories7))
#7 /home/www/doc/*****/mydomain.de/www/applications/cms/modules/front/database/category.php(733): IPS\Content\_Item::create(Object(IPS\cms\Categories7))
#8 /home/www/doc/*****/mydomain.de/www/system/Dispatcher/Controller.php(90): IPS\cms\modules\front\database\_category->form()
#9 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Databases/Dispatcher.php(327): IPS\Dispatcher\_Controller->execute()
#10 /home/www/doc/*****/mydomain.de/www/applications/cms/widgets/Database.php(128): IPS\cms\Databases\_Dispatcher->run()
#11 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Pages/Page.php(1300): IPS\cms\widgets\_Database->render()
#12 /home/www/doc/*****/mydomain.de/www/applications/cms/sources/Pages/Page.php(2259): IPS\cms\Pages\_Page->getWidgets()
#13 /home/www/doc/*****/mydomain.de/www/applications/cms/modules/front/pages/page.php(227): IPS\cms\Pages\_Page->output()
#14 /home/www/doc/*****/mydomain.de/www/system/Dispatcher/Controller.php(90): IPS\cms\modules\front\pages\_page->__call('form', Array)
#15 /home/www/doc/*****/mydomain.de/www/applications/cms/modules/front/pages/page.php(33): IPS\Dispatcher\_Controller->execute()
#16 /home/www/doc/*****/mydomain.de/www/system/Dispatcher/Dispatcher.php(152): IPS\cms\modules\front\pages\_page->execute()
#17 /home/www/doc/*****/mydomain.de/www/index.php(13): IPS\_Dispatcher->run()
#18 {main}


BACKTRACE

#0 /home/www/doc/15***/mydomain.de/www/init.php(995): IPS\_Log::log('INSERT INTO `cm...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

This occurs to all usergroups except the admin account, there it works fine as expected. Note, I haven't chanted anything regarding usergroups or permissions. Thanks for your help.

Posted
17 minutes ago, Marc Stridgen said:

Please disable the captcha you have set there. Unfortuanetly I am unable to get past that custom item

Captcha is disabled now.

Posted

It looks like you took the community offline so I was unable to fully test as an individual outside the administrator group. However, I did notice you are not up to date. Please update to the latest release and disable all third party applications/plugins then try again. 

Posted
21 minutes ago, Ramsesx said:

Thanks but I didn't took my community offline since several months.

Thank you, it looks to have been brought online again but the community has not been updated. Please update to the latest release, we can then investigate this further.

Posted
23 minutes ago, Jim M said:

Please update to the latest release

Ok, since the latest upgrade experiences were not really cool I try to avoid them if not really necessary. But it looks like I have to do that. Thanks.

Posted
12 hours ago, Ramsesx said:

Ok, since the latest upgrade experiences were not really cool I try to avoid them if not really necessary. But it looks like I have to do that. Thanks.

Actually the opposite is true. Generally you will have more issues by not upgrading

Posted

Ok, upgrade went smooth unexpectedly 

Happy Christmas GIF

Only one smaller issue making the upgrade not perfect comfortable, it asked to make a manual query ALTER TABLE `core_log` ADD COLUMN `loaded_hooks` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Any third party hooks loaded';

I did this and pressed the right button but it shows again the mask to alter those tables, did it again and checked my database and the tables and columns were definitely created but it shows again the prompt to alter the tables manually. So I tried to press the left button to let it do automatically and this worked then.

Coming back to the formerly issue. It is still not possible to create a record.

Posted
On 2/23/2022 at 2:29 PM, Ramsesx said:

This occurs to all usergroups except the admin account, there it works fine as expected

Please try with the non admin account *****

PW: *****

You only need to fill out title and editor to reproduce the error

 

 

 

 

Posted
On 2/24/2022 at 4:41 PM, Marc Stridgen said:

I have created a ticket for you on that so we can take a look for you

Well, since there was no more activity from your side I investigated the issue by myself and found out that a custom field was causing this error. In detail, the permissions were set:

1541702043_2022-02-2813_45_489.jpg.5475ee8a6772853712b583ee74e6000b.jpg

First line is permission for administrator and second for the other user groups giving the error I described above. If grant other user groups permission for "Add content to field" it's not throwing out the error. But I don't know why this happend at all because before server changing this setting as you can see in the image was never causing any issue. So I would see this as a bug.

Posted

Standard responses can be up to 72 hours. With advanced escalated items, those can take longer as per message on escalation. I have added the information above to that support request though, so that they can use this during their investigation. Especially if you have never changed that setting.

Posted (edited)
8 hours ago, Marc Stridgen said:

Especially if you have never changed that setting.

Definitely not.

Since it is now possible to post again records and the bug is primarily cosmetic in nature, the fix is no longer urgent.

Edited by Ramsesx
Posted
9 hours ago, Ramsesx said:

Definitely not.

Since it is now possible to post again records and the bug is primarily cosmetic in nature, the fix is no longer urgent.

No problem. The ticket is there in any case so our devs can take a look

  • 3 weeks later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...