Localhost to Live Server

To be more specific (in this new post seeing as i cant edit my previous one!!) in the installer log txt the error that shows up is **ERROR** database error write ‘Table ‘house2_db.wp_housejosephoptions’ doesn’t exist’ – [sql=INSERT INTO wp_housejosephoptions

I dont understand why this is doesnt exist as i created a new database????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

Hey the_new_intern,

Sorry your running into issues. It looks like the CREATE table statements may have not been executed properly as well. Did you happen to see CREATE table errors by chance in the log? You may also have to check in phpmyadmin and see if the tables to the db exist…

WordPress did a change in 4.2 that tried to update the colloation type on your database. This could be the issue on your setup as well. There is a full thread hear about the issue, that may help.

It does seem to be a colloation issue(whatever that means) heres a sample from the log after i tried it again
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_ci” – [sql=
CREATE TABLE wp_housejosephcommentmeta (
meta_id bigint(20) unsigned…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_ci” – [sql=
CREATE TABLE wp_housejosephcomments (
comment_ID bigint(20) unsigned…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_ci” – [sql=
CREATE TABLE wp_housejosephlinks (
link_id bigint(20) unsigned NOT N…]

Still dont know how to fix it though???

I would recommend using the recommendation from @alex.mqt which he states:

So the solution was to edit the SQL (found in the archive) by replacing every utf8mb4 character set with utf8.

The SQL file he is referring to is called database.sql which is inside the archive file. So you will need to manually extract it and manually update the sql file, then you can rezip up the archive and try and run it again. Its a bit involved but that is currently the easiest fix, the other option requires running some PHP code if your familiar with how to do that…

Now im getting this problem after step 2
Fatal error: Call to undefined function wp() in /home/josmar330/houseofjosephphotography.com/wp-blog-header.php on line 14

Actually scrap that last post for now. I think i know whats going on now. In the wp snapshots folders there was multiple backups of the site created by another plugin and i difnt realize the files where still there, so when i uploaded the archive these files were unzipped all over the place and i couldnt understand at first why there was multiple copies of the site all over the ftp server, because each time i ran the duplicator it kept creating theses copies as well and it has taken hours and hours and hours to delete them, so what ive done now is created afresh local install with perfect files and folders and im deleting all the old stuff off the ftp server. BTW in relation about the ut8mb4 char i as talking with Dreamhost support and they said their servers were not at that level yet so thats why i was getting the errors. The saga continues…..