associationamber Posted December 15, 2022 Share Posted December 15, 2022 We can't create new forum after transfer to a new server. It shows error EX1366. Please, help us to solve this. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 15, 2022 Share Posted December 15, 2022 Could you please confirm what version of SQL you are using, and also see if this is using strict mode. Also test this with all 3rd party items disabled (although its likely server settings if it was working beforehand) Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 (edited) mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) | @@GLOBAL.sql_mode | +------------------------------------------------------------------------------- ----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_ DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | Edited December 15, 2022 by associationamber Link to comment Share on other sites More sharing options...
Miss_B Posted December 15, 2022 Share Posted December 15, 2022 Looking at the error message, it looks to me that when a new forum is added, it is trying to save a string/varchar value "" in the column min_posts_post, which is an integer type. Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 49 minutes ago, Marc Stridgen said: Could you please confirm what version of SQL you are using, and also see if this is using strict mode. Also test this with all 3rd party items disabled (although its likely server settings if it was working beforehand) mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) | @@GLOBAL.sql_mode | +------------------------------------------------------------------------------- ----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_ DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | Link to comment Share on other sites More sharing options...
Jim M Posted December 15, 2022 Share Posted December 15, 2022 Could you please go to ACP -> Support. There may be some database schema changes there which may need to be applied. Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 Link to comment Share on other sites More sharing options...
Jim M Posted December 15, 2022 Share Posted December 15, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 6 minutes ago, Jim M said: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Good! I will update the data and inform you. Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 47 minutes ago, associationamber said: Good! I will update the data and inform you. information updated Link to comment Share on other sites More sharing options...
associationamber Posted December 15, 2022 Author Share Posted December 15, 2022 if you need additional rights - please write Link to comment Share on other sites More sharing options...
Jim M Posted December 15, 2022 Share Posted December 15, 2022 Please be advised I have transferred this to a ticket. Please check your email for further correspondence. associationamber and SeNioR- 2 Link to comment Share on other sites More sharing options...
associationamber Posted December 18, 2022 Author Share Posted December 18, 2022 I answered the email. Is everything okay? Link to comment Share on other sites More sharing options...
Solution Jim M Posted December 18, 2022 Solution Share Posted December 18, 2022 Sorry for the delay, however, as it is the weekend, it may take longer for a response. As mentioned in the email we sent: I have escalated your request to that department and they will provide further assistance as quickly as possible. Due to the advanced nature of your request, please note that it may take longer than usual to fully address your concern. Please also note that advanced support is only available Monday through Friday. I apologize in advance for this delay. associationamber 1 Link to comment Share on other sites More sharing options...
associationamber Posted December 18, 2022 Author Share Posted December 18, 2022 Thank you for your answer! Link to comment Share on other sites More sharing options...
associationamber Posted March 1, 2023 Author Share Posted March 1, 2023 Hello! I have a problem again. When I create a new user group, an error is displayed: Link to comment Share on other sites More sharing options...
Jim M Posted March 1, 2023 Share Posted March 1, 2023 19 minutes ago, associationamber said: Hello! I have a problem again. When I create a new user group, an error is displayed: Could you please let me know what you were updating? Unfortunately, I am unable to reproduce this. Link to comment Share on other sites More sharing options...
associationamber Posted March 1, 2023 Author Share Posted March 1, 2023 i create a New Group Link to comment Share on other sites More sharing options...
Jim M Posted March 1, 2023 Share Posted March 1, 2023 1 minute ago, associationamber said: i create a New Group Unfortunately, I cannot reproduce this so would need the fields you're changing. Link to comment Share on other sites More sharing options...
associationamber Posted March 1, 2023 Author Share Posted March 1, 2023 I created a new group again. And the error didn't show up. If it repeats, I will write to you. Link to comment Share on other sites More sharing options...
Jim M Posted March 1, 2023 Share Posted March 1, 2023 No worries, sounds good. associationamber 1 Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts