dugdesigns
Forum Replies Created
-
Hey Cory,
Thanks, I did see that and found another post from someone who was having the same issue. When I initially tried that it didn’t work. I did finally get it to work with the manual install, the process wasn’t too simple, but you even state that in the plugin description, “it’s not for a novice”. I did finally get everything up and running though!
Here’s the steps it took to get it to work (well the ones I remember) maybe this will help someone else.
Moving from a localhost (MAC) to online server (in this case, Godaddy). Note Godaddy has old version of MYSQL, so a couple steps below (2 and 5) deal with that.
1.) Ran duplicator locally, saved files.
2.) Unzipped archive file. Opened database.sql with text editor. Ran search for utf8mb4 replaced with utf8. Rezipped archive. (removes errors on install)
3.) FTP’d files (archive and installer) to root directory on server (directory MUST be empty, no copies of wordpress)
4.) Ran installer which Unzipped file but left files in unzipped folder.
5.) Dragged files out into main root folder.
6.) Re-ran installer selecting Manual Install. Ran fine but ran into some errors with formatting of pages. (weird question mark character in content)
7.) Localhost myPHPadmin, exported database – selecting Database Compatibility Mode MySQL40 and checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
8.) Imported database on web server
9.) Exported pages (WP localhost). Imported pages (WP web server)
10.) Uploaded theme (webserver)
11.) Exported theme settings (WP localhost). Imported settings (WP web server)There were a lot of steps troubleshooting issues and cleaning things up, but this is the process I can remember finally getting everything to look exactly the way I had it on my local machine.
NDA01, I had that same issue with the question marks.
I believe it had something to do with the import of the database and the UTF8 code. Keep in mind I’ve tried so many things it’s hard to keep track, but I finally have a complete duplicate of my website up and running.
For my issue, I believe this fixed it, I exported the database again (working local) and selected MYSQL40 in the Database Compatibility Mode and checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT.
I then imported it (on web server) and all the question marks and content was fixed.
If you try this, be sure to export your current database as a backup so should something go wrong you can just revert back to that.
Hope that helps.
I had this same issue.
6000 or so errors of this:
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_ci” – [sql=
CREATE TABLE wp_commentmetaalex.mqt post was what worked for me. Thanks for posting Alex!
To elaborate. I unzipped the zipped file that Duplicator creates. Found database.sql, opened with a text editor, did a find and replace.
Find: utf8mb4 replace with: utf8
Saved file and rezipped. Deleted all files on server, re-uploaded and ran install again. That produced no errors on install.
Please note though, I still haven’t successful made this work. Just started another discussion about the file unzipping, but not pulling the files out of the unzipped file. Thread link below.
(https://wordpress.org/support/topic/unzips-but-stays-in-unzipped-folder)