1

I've been using PDO plugin for wordpress and SQLite database. It does not work as expected so I want to use MySQL database, but without PDO for Wordpress since I cannot trust that plugin anymore, It has not been updated for more than 2 years.

So, this is what i did:

  1. Exported SQLite database to sql file
  2. Made necessary changes in syntax http://www.maxkpage.com/blog/free-sqlite-to-mysql-converter-super-easy/
  3. Installed new Wordpress with new MySQL database
  4. Copied old Wp-content folder and replaced the new one
  5. Imported old data by copying all "INSERT INTO ...." form old into new tables, which I emptied first

Now, here comes the problem. Everything works fine, I can see the posts on website, but when I populate wp_users or wp_usermeta or wp_options with old data I get "You don't have sufficient permissions" message when I log into dashboard. Not wrong username or password, but when I log in I just see that message and the website becomes white blank.

Where is the problem and how can I fixed it?

0

I found out what is wrong. The tutorial says to remove all double quotes " and replace them with spaces or backticks `, but some values in the mentioned tables have double quotes around them. This one for example:

INSERT INTO "wp_usermeta" VALUES(14,1,'wp_capabilities','a:1:{s:13:"administrator";s:1:"1";}');

So replacing that with backticks causes malfunction.

Replace only double quotes around table names "wp_usermeta" -> wp_usermeta

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.