CODEWITHSUNDEEP
phpmysqldatabasewordpress
James
James

Reputation: 193

Wordpress sIte doesn't work after transfer from local server (database issue?)

I have developed a custom WordPress theme with custom woocommerce shop locally with MAMP. It works great.

I have uploaded all the files to the server, revised the config file for new database. Created the database, exported it from my local with in the phpMyadmin and imported it to the online server database. The database was 16MB so it didn't import well as one file or as separate tables so I used bigdump to import it. and it looked like it worked.

after that I changed the URLs to the new ones from in wp_options table in phpMyadmin of the new db.

However the site now displays error lines and the WordPress Admin Bar is missing from the top. In addition to that the Products tab of woocommerce is missing and the plugin admin area is empty. I also cannot install plugins. etc' It all doesn't function well.

I'm guessing this is a bad transfer of the database but I have no clue.

This is the website

Error lines examples:
Warning: array_merge(): Argument #2 is not an array in /usr/local/pem/vhosts/254369/webspace/httpsdocs/wp-content/plugins/wp-pagenavi/scb/Options.php on line 46

Also...

Warning: call_user_func_array(): First argument is expected to be a valid callback,

'woocommerce_demo_store' was given in /usr/local/pem/vhosts/254369/webspace/httpsdocs/wp-includes/plugin.php on line 405

Any advise on figuring out what the problem is?

Upvotes: 1

Views: 3290

Answers (2)

anuragbh
anuragbh

Reputation: 593

James - regarding the import error, this is because the server you are trying to import the file on has a limit on the size of files it can import.

Go into the root folder of your server (the one in which wp-content, wp-includes etc folders are in), and either edit the php.ini file currently there, or upload a new one. You can download this sample file: http://www.reallylinux.com/docs/php.ini and upload it. Edit the post_max_size and upload_max_filesize value to 50MB or something: post_max_size = 50M

This will fix the import problem.

For the plugin error, copy the plugin files from wp-content from your dev server and import them into the live server, it should work.

Upvotes: 0

anuragbh
anuragbh

Reputation: 593

You shouldn't import the data by exporting all tables through phpMyAdmin. In the process you will overwrite the tables that were created for the new wordpress installation, with its own values for options such as siteurl, bloginfo etc.

So re-install Wordpress on the new server, to start again clean. Don't overwrite the tables it auto-generates.

Login to your development wordpress dashboard, go to Tools > Export and select all content, including all linked files. Go to new Wordpress, go to tools > Import, select Wordpress, install the plugin, choose the file you exported and you should be all set.

You will need to update some URL's that might not get updated within your posts/pages. You might also need to update catid's in your code, as the imported categories will get assigned new values.

Upvotes: 1

Related Questions