TheFishman wrote:
When I add it to my account into MPA, I get this.
Code: Select all
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 95
STR: '
SQL:
INSERT INTO forum_search_wordlist (word_text, word_id, word_common) VALUES('isn�t', '9976', '0');
SQL query:
INSERT INTO forum_search_wordlist (word_text, word_id, word_common) VALUES('isn�t', '9976', '0');
MySQL said:
#1062 - Duplicate entry 'isn?t' for key 1
This is a common error. It means the source and destination databases are using different character encoding schemes, so some non-ASCII characters are converted to the same symbol, giving that error.
There are two solutions:
Either do a global search and replace in the sql file, and change every instance of
INSERT INTO forum_search_wordlist
to
REPLACE INTO forum_search_wordlist
(you'll need a text editor which can handle very large text files without choking. "LargeEdit" is one, but there are many more.)
or, you can delete all those lines altogether, and run a MOD on the new forum to rebuild the search tables.
Firstly, it is a large database, it says 13.4 meg but when it saves on disk it is 37.8 meg.
That is normal, the data isn't saved as efficiently in the SQL file.
How do I manually delete usernames in Wordpad? As there are over 1000 spam bots and only 250 real users. I just want the posts and users transplanted into the new forum.
Do NOT attempt to do this by editing the data directly. The Admin toolkit can do it on your new forum once installed. Otherwise you will damage the data relationships (many tables refer to each other in the database.)