It doesn't appear to be the same error that others are experiencing re: charsets...this is what the error message is...
1064 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 'SELECT media_id FROM media_manager)' at line 1
in:
[DELETE FROM media_to_products where media_id not in ( SELECT media_id FROM media_manager);]
I did a test store with the same data, same files etc, the only difference was that the version of mySQL was newer. Is that what's causing the issue? If so are there any work arounds beyond creating a new database, backing up the old data into it and changing the config file info?
Bookmarks