I'm working on a module and have for some reason my .sql file is not creating the db tables when I install the module. I don't however get any error messages.

Here is what is reported when installing the module



When I check the database, no tables have actually been created. I have tried creating the SQL file with phpmyadmin 2.5.5 and 2.2.7 both with the same results.

I am able to run the sql file using both MySQL shell and phpmyadmin and all tables are created as intended. So I know the file at least works.

Does anyone know why XOOPS would report that the tables have been created when they are not?

Dumb question, but do you have an xoops_ table prefix?

Could you post an extract of the .sql file?

hey, turns out the problem was with my MySQL server. I reinstalled MySQL and everything worked like a charm.

thank you for responding.