Hello! I have a problem when I try to install some modules in xoops. The error is generated because the syntax IF NOT EXISTS is not rightly interpreted. The complete message is the following:

CREATE TABLE xoops_IF NOT EXISTS `oremensili_commesse` ( `ncom` varchar(10) NOT NULL default '0', `descr` varchar(50) default NULL, `cliente` varchar(20) default NULL, `refsd` varchar(15) default NULL, `refcli` varchar(15) default NULL, `note` varchar(255) default NULL, `DTapertura` date NOT NULL default '0000-00-00', `DTchiusura` date NOT NULL default '0000-00-00', PRIMARY KEY (`ncom`), UNIQUE KEY `ncom` (`ncom`) ) TYPE=MyISAM
Error number: 1064
Error message: 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 'NOT EXISTS `oremensili_commesse` ( `ncom` varchar(10) NOT NULL default '0', ' at line 1
( 0.000511)

The prefix xoops_ of the tables is inserted before IF NOT EXISTS, not before the name of the table oremensili_commesse.
The characteristics of the system are the following:

XOOPS Version: 2.2.3.a
Module Name/Version:
PHP Version: 5.1.0
MySQL Version: 5.0.16-nt
Web Server Software (Apache/IIS/Other): Apache
Operating System: MS Windows XP Home Edition
Custom template: (Yes/No) Yes
MySQL characterset (of server, db, client, connection): latin1

Is there anybody who can help me with this topic?
Thanks!
FA

what module your trying to install? i think theres a problem with .sql file in your module