Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook 19 hours ago
Jamie_Beatson Posted November 30, 2022 Share Posted November 30, 2022 Hi there. Getting the following error while I attempt to upgrade to the latest version: Specified key was too long; max key length is 1000 bytes/home/weareper/public_html/wapforum/system/Db/Db.php::2184 I'm not entirely sure what to do about this - can anyone help? Thanks Link to comment Share on other sites More sharing options...
Marc Stridgen Posted November 30, 2022 Share Posted November 30, 2022 First of all, revert to your backup, then visit support within the admin CP (top right) In there, address all mysql items that are showing in that area. Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted November 30, 2022 Author Share Posted November 30, 2022 Hi there - I've done that but I'm not seeing any issues in Admin CP/Support. The only thing showing is "Enable utf8mb4" - though the system won't let me convert the database. Is that likely to be the root issue? Link to comment Share on other sites More sharing options...
Randy Calvert Posted November 30, 2022 Share Posted November 30, 2022 Take a look at: 🙂 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 1, 2022 Share Posted December 1, 2022 15 hours ago, Jamie_Beatson said: Hi there - I've done that but I'm not seeing any issues in Admin CP/Support. The only thing showing is "Enable utf8mb4" - though the system won't let me convert the database. Is that likely to be the root issue? It is indeed likely related. Also compact row format if that is showing. You mention you the system wont let you convert it. What is actually happening when you try? Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted December 1, 2022 Author Share Posted December 1, 2022 It's a bit weird - yesterday it simply wouldn't let me convert the database - it just failed. I didn't save a copy of what came up because I ran out of time and was coming back to work on it today. Today I've got further with it - it appears to have gone through the conversion process and I then get to this message: In order to finish the conversion: Open the /home/weareper/public_html/wapforum/conf_global.php on your server. Locate the sql_utf8mb4 declaration, which may look like this: 'sql_utf8mb4' => false, Or like this: $INFO['sql_utf8mb4'] = false; Change the false to true. If neither line exists, add the second version to the end of the file and change the false to true. Do not change any other aspect, including any comma or semi-colon after the false I've gone into the relevant file and the second line already exists in the conf_global.php file. It was already flagged as true. I then click the finish button and it just goes back to the same page - nothing changes and it doesn't appear to complete the process. SeNioR- 1 Link to comment Share on other sites More sharing options...
Miss_B Posted December 1, 2022 Share Posted December 1, 2022 What is the Collation set to at the database? What version are you upgrading from? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 1, 2022 Share Posted December 1, 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...
Jamie_Beatson Posted December 5, 2022 Author Share Posted December 5, 2022 Hi there, apologies for the delay in replying, I've updated by access information - you should be able to get in now. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 5, 2022 Share Posted December 5, 2022 You would need to contact your hosting company on this issue. This is cause by compact row type being used. All tables need to use dynamic row type. Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted December 5, 2022 Author Share Posted December 5, 2022 Thank you, I'll do that now. Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted January 18 Author Share Posted January 18 Hi there- bringing this back up as I'm only now getting time after the holidays to revisit this issue. I've converted my tables to dynamic row format - I've checked the information_schema on my database and they are all showing as dynamic. I've had to alter them all manually as I don't appear to have permissions via my hosting provider to set dynamic as the default row format. I'm now back with the same issue I was having in my December 1 post - I can't complete the Enable utf8mb4 process. I'm still getting the same issue where it goes through the conversion process then asks me to change the variable in conf_global.php to true (it is already set to true) - but when I press "Finish" nothing happens and it just refreshes the same page. Any further suggestions? Link to comment Share on other sites More sharing options...
Jim M Posted January 18 Share Posted January 18 This would likely indicate it is not set appropriately or it isn't able to read the set value. Could you please provide us access so we can review your conf_global.php? Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted January 19 Author Share Posted January 19 You should have access now! Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 19 Share Posted January 19 If you have switched the row format, you first need to upgrade (the row format will have been causing your original error) Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted January 19 Author Share Posted January 19 Ah OK, so I can carry out the upgrade and *then* enable utf8mb4? Apologies - I'll go and try that today and see how it goes! Thanks, Jamie Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 19 Share Posted January 19 Yes, I would do it in that order Link to comment Share on other sites More sharing options...
Jamie_Beatson Posted January 19 Author Share Posted January 19 Running the upgrade again and getting the same error as the first time round: Specified key was too long; max key length is 1000 bytes/home/weareper/public_html/wapforum/system/Db/Db.php::2184 Have confirmed that the row in the table is set to Dynamic and I can't see a reason why I can't go any further. Any ideas? Link to comment Share on other sites More sharing options...
Stuart Silvester Posted January 19 Share Posted January 19 Hi Jamie, We'll take a look at this via a ticket, keep an look out for an email from us. Link to comment Share on other sites More sharing options...
Recommended Posts