this occurs after 4000 users succesfully imported then suddenly… its all over. I can coninue… but suspect i am going to be missing a lot of users and posts will not refer to a user.
Was just coming back to say i fixed it, left out the”_” but Stephen has already caught it.
But now? A new problem.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘l” WHERE ID = “96386”‘ at line 1]
UPDATE wp_users SET user_pass = “xxxxxxx”l” WHERE ID = “96386”
Any ideas?
NO matter what i do, the importer cant find my tables
eg
WordPress database error: [Table ‘databasename.GDNUser’ doesn’t exist]
SELECT convert(User.UserID USING “utf8”) AS UserID,convert(User.Password USING “utf8”) AS Password,convert(User.Name USING “utf8”) AS Name,convert(User.Email USING “utf8”) AS Email,convert(User.DateInserted USING “utf8”) AS DateInserted FROM GDNUser AS User LIMIT 0, 100No users to convert
my details are correct, and the tables are there.
not sure what to do now