Product Importer Doesn't Create DB Tables

[tnguy3n]

I wrote a product XML file to insert database tables, data, phrases, and templates for my script/add-on. Phrases and templates are to be inserted properly; however, database tables are not created nor the data.

Can anyone please take a look and tell me what I did wrong?

Below is part of codes in my product xml file:

removed

Thanks in advanced!

tnguy3n

[Paul M]

What version number does the product itself have ?

[Marco van Herwaarden]

Did you manually write the XML-file?
Are you doing a clean install or an overwrite?
You might want to enable error reporting for testing first.

[tnguy3n]

What version number does the product itself have ?

@ Paul M: the product version is 1.0

@ Marco:
Yup, I wrote that product xml file, for clean installation. And thank for the tip. the error report pointed me to where to the bug.
For some reasons, MySQL doesn't like the DEFAULT syntax as in ENGINE=MyISAM DEFAULT AUTO_INCREMENT=2 , so I changed it to
ENGINE=MyISAM AUTO_INCREMENT=2

and it worked!

many thanks.