-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
@Jim M But when I switch to 8.2 then run it, I get a 500 error.
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
@Marc @Jim M Now I'm getting a message saying I should upgrade from PHP 8.1 on my server to 8.2, but when I go into my GoDaddy hosting account and change it to 8.2, my website gives a 500 error. When I switch back to 8.1, it's back up again. What's the most likely cause of this and how can I fix it so I can move to 8.2?
-
Jim M reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Marc reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Yeah, for some reason the "reactions" folder wasn't in uploads. Works now. Thanks!
-
mr_hopp reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Okay, that resolved just fine and the forums look to be back up! Thanks so much for all your help!
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Thanks for setting my mind at ease, @Marc! By the way, this normal behavior? And is it okay that when I get that 502 error every now and again that it continues from there? (It's currently at &mr=250 so I don't know how long this is supposed to take — I guess each one of these is a table it's upgrading in the database?)
-
mr_hopp reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
@Marc Does my list above look right? I’m just a bit paranoid after the first upgrade not working, so want to be as sure as I can I have everything covered before diving back in. 😅 Thank you!
-
mr_hopp reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
mr_hopp reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
mr_hopp reacted to a post in a topic: Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Thanks for all your help! I just updated the patch so running the latest version — 4.7.20 — and it looks like everything else is good to go. See the screenshot at bottom. Only recommendations are 1) Status updates have been removed in v5 and 2) Open tagging has been replaced with a new system in v5 (neither of which I need). So now the next step to upgrade to v5 would be the following, right? (Forgive me, I'm not a database guy and not technically savvy in this arena, so just trying to scrape by here — thanks to your help!) Here's my list I'll follow: Backup Everything: I will make sure that both my website files and database are fully backed up beforehand. Delete Old Files: I will delete all existing files from the root of my Invision Forums folder so there are no conflicts with the new v5 files. Upload v5 Files: After deleting the old files, I will upload and expand the new Invision Community v5 zip file into the root of my Invision Forums folder. Update conf_global.php: I'll update the conf_global.php file with my database details and add the following two lines to enable UTF-8 conversion (thanks @teraßyte!): 'sql_charset' => 'utf8mb4', 'sql_utf8mb4' => true, Visit the /admin/upgrade Page: Once the files and configuration are updated, I will visit the /admin/upgrade page in my forum and hopefully there will be no issues like last time! Upload New v5 Theme: After the upgrade process completes, I will upload the new theme file created by my developer specifically for v5. If any UTF-8 conversion issues are still there after the upgrade, I can run the CLI script at "/admin/convertutf8" (to force the re-conversion). After this is settled, I'll delete the "constants.php" file in the UTF8Converter folder. Permissions Check: After upgrade is complete, I will make sure the permissions for files and folders are set correctly (e.g., 755 for folders, 644 for files) to avoid potential access issues. Am I missing anything or do I have anything wrong?
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Okay thanks @Marc! I restored from backup and went into the support area of the admin CP, but it says there are no issues identified with the database? Thanks for the heads up @teraßyte , I'll check it out!
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
You can delete this topic. I've given up. For now.
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Actually, every time I go to try the upgrade procedure again, it seems to delete the table, then it gives me the error again: Table 'invisionNEWigoxXyA6BLXXX.core_social_promote' doesn't exist So I keep creating the core_social_promote table manually as suggested. So I feel like a dog chasing his own tail over here; I’m unable to proceed with the upgrade. Totally stuck! How can I fix this? For what it's worth, I don't even need the social promote functionality on my forums anyway.
-
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Okay, I finally got that one to work, but now I'm running into an issue with a table error: Table 'invisionNEWigoxXyA6BLXXX.core_social_promote' doesn't exist But I created the core_social_promote table manually as suggested. Here’s the structure I used: CREATE TABLE core_social_promote ( promote_id INT(11) NOT NULL AUTO_INCREMENT, member_id INT(11) NOT NULL, promote_date DATETIME NOT NULL, promote_data TEXT NOT NULL, PRIMARY KEY (promote_id) ); However, the issue still persists, and I’m unable to proceed with the upgrade. It seems that the upgrade script is still unable to recognize the existence of the table. Could you kindly provide further guidance on how to resolve this issue? I’m unsure why the system isn’t recognizing the table even after I’ve manually created it.
-
mr_hopp started following Stuck on v5 upgrade
-
Stuck on v5 upgrade
Just in case this thread gets checked more often ... Don't know if this is a bug or not, but I'll drop it right here. :)
-
Stuck on v5 Upgrade – “Your database character set is not using a 4-Byte UTF-8” Error
Anyone? I've felt like I've tried everything and still getting that same error message ...
mr_hopp
Clients
-
Joined
-
Last visited