I have been developing a module with Drupal 7.17 through 7.19 on a Windows XAMPP installation. And have done many module installs and uninstall while updating and adding tables the module uses, all with no problems.
Today, I added my module's directory to the sites/all/modules and check the module in Modules and saved the configuration. I got the system error message PDOException: SQLSTATE[42000: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds .... . Both databases are the same version of MySQL, and I am the only Drupal Administrator.
One of the my module's tables was added to multisite database and all the module's files and menus were added to system table(s). Unchecking the module and saving the configuration in the Modules, removed the check from the Module's List but did not add my module to the Uninstall tab.
I had to have the drupal database to get to before my module's install.
I have no clue what to look for or what's wrong in my module's .info, .module or etc. What went wrong???
I compared the file ftp'd to my site's server and my localhost files and they are the same.
Thanks in advance for any help or feedback,
Roy