Why am I not able to use the "CREATE TABLE IF NOT EXISTS" in my MySQL file for a module installation?

The module installation stops saying I have: "You have an error in your SQL syntax". This same file is inserted properly using phpMyAdmin.

Another question of mine is why the $modversion['tables'][1] is needed in xoopsversion.php if the module install still installs every table that is within the MySQL install file?

The reason I would like to add a table depending on IF EXIST is that I have two modules that will share tables...but I want to be able to independently install each module without getting an installation errror from Xoops.

Any help would be greatly appreciated!

i think $modversion['tables'][1] is really needed when you uninstall a module. so XOOPS knows which tables to drop..

and your other question. what about using an onInstall function.
https://xoops.org/modules/mediawiki/index.php?title=Dev:database_tables
https://xoops.org/modules/mediawiki/index.php?title=Dev:xoops_install_uninstall

Hey that's perfect!

I have used the onUpdate function before but wasn't aware of the onInstall feature. This will work out great as I have 4 tables that are shared.

Yeah, I just had realized the $modversion['tables'][1] was used for uninstall...

Thanks for the info and the direct links to the XOOPS dev site!