Jamie_Beatson
-
Posts
13 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by Jamie_Beatson
-
-
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
-
You should have access now!
-
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?
-
Thank you, I'll do that now.
-
Hi there, apologies for the delay in replying, I've updated by access information - you should be able to get in now.
-
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
totrue
. If neither line exists, add the second version to the end of the file and change thefalse
totrue
. Do not change any other aspect, including any comma or semi-colon after thefalse
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.
-
Open the
-
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?
-
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::2184I'm not entirely sure what to do about this - can anyone help?
Thanks
Error during upgrade
in Technical Problems
Posted
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?