Ramsesx Posted February 23, 2022 Posted February 23, 2022 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.
Marc Posted February 23, 2022 Posted February 23, 2022 Please could you let me know where you are posting a new record? I can then take a look and see whats happening for you Ramsesx 1
Marc Posted February 23, 2022 Posted February 23, 2022 Please disable the captcha you have set there. Unfortuanetly I am unable to get past that custom item
Ramsesx Posted February 23, 2022 Author Posted February 23, 2022 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.
Jim M Posted February 23, 2022 Posted February 23, 2022 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.
Ramsesx Posted February 23, 2022 Author Posted February 23, 2022 51 minutes ago, Jim M said: It looks like you took the community offline Thanks but I didn't took my community offline since several months.
Jim M Posted February 23, 2022 Posted February 23, 2022 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.
Ramsesx Posted February 23, 2022 Author Posted February 23, 2022 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.
Marc Posted February 24, 2022 Posted February 24, 2022 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
Ramsesx Posted February 24, 2022 Author Posted February 24, 2022 2 hours ago, Marc Stridgen said: Generally you will have more issues by not upgrading Yes, I just meant the upgrading process itself, will try to upgrade now.
Ramsesx Posted February 24, 2022 Author Posted February 24, 2022 Ok, upgrade went smooth unexpectedly 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.
Marc Posted February 24, 2022 Posted February 24, 2022 I would need to know all the values being entered. As you will be able to see by the last entry named "test" I was able to add an entry
Ramsesx Posted February 24, 2022 Author Posted February 24, 2022 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
Solution Marc Posted February 24, 2022 Solution Posted February 24, 2022 I have created a ticket for you on that so we can take a look for you
Ramsesx Posted February 28, 2022 Author Posted February 28, 2022 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: 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.
Marc Posted February 28, 2022 Posted February 28, 2022 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. Ramsesx 1
Ramsesx Posted February 28, 2022 Author Posted February 28, 2022 (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 February 28, 2022 by Ramsesx
Marc Posted March 1, 2022 Posted March 1, 2022 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
Marc Posted March 17, 2022 Posted March 17, 2022 I see my colleague has posted a suggestion you can use to fix the issue on your ticket there. Is this now resolved for you?
Recommended Posts