Problems importing WP_OPTIONS widget_text in Windows
-
Scenario:
Run backupwordpress on Linux server
Download .sql file to local Windows machine
Import .sql file into local databaseProblem:
Text widgets missing in imported site.Analysis:
backupwordpress doesn’t export strings with escape characters
so some of the serialised strings get corrupted when importing in a Windows environment.The following example produces the correct results
s:18:\"[bw_telephone]\r\n\r\n\";
but you get the incorrect results when the characters are not escaped.Notes: backwpup did not exhibit the same problems.
PS. I noticed another problem
Timestamps would not import. ERROR 1064 (42000)
They were missing single quotes.
The topic ‘Problems importing WP_OPTIONS widget_text in Windows’ is closed to new replies.