I am running Windows XP PHP PHP Version 5.1.2, MySQL 5.0.20, Apache/2.2.0 , all configured properly.

Installation is all green until time to create the tables in the database...

Database mysql
Database Hostname localhost
Database Username xoopsuser
Database Password xoopsmatrexweather
Database Name xoops
Table Prefix xoops
Use persistent connection? No
XOOPS Physical Path C:/Program Files/xampp/htdocs
XOOPS Virtual Path (URL) http://localhost

---------------------------------------------------
Saving configuration data..
File ../mainfile.php overwritten by ../mainfile.dist.php.
Constant XOOPS_ROOT_PATH written to C:/Program Files/xampp/htdocs.
Constant XOOPS_URL written to http://localhost.
Constant XOOPS_DB_TYPE written to mysql.
Constant XOOPS_DB_PREFIX written to xoops.
Constant XOOPS_DB_HOST written to localhost.
Constant XOOPS_DB_USER written to xoopsuser.
Constant XOOPS_DB_PASS written to xoopsmatrexweather.
Constant XOOPS_DB_NAME written to xoops.
Constant XOOPS_DB_PCONNECT written to 0.
Constant XOOPS_GROUP_ADMIN written to 1.
Constant XOOPS_GROUP_USERS written to 2.
Constant XOOPS_GROUP_ANONYMOUS written to 3.
Constant XOOPS_CHECK_PATH written to 1.

Configuration data has been saved successfully to mainfile.php.
-----------------------------------------------------

check path & URL
Physical path is correct.
Virtual path is a valid URL.

The server path to your XOOPS root directory: C:/Program Files/xampp/htdocs
URL to your XOOPS root directory: http://localhost

If the above setting is correct, press the button below to continue.
-----------------------------------------------------
confirm database settings
Database Hostname localhost
Database Username xoopsuser
Database Name xoops
Table Prefix xoops

If the above setting is correct, press the button below to continue.
-----------------------------------------------------
check database
Connection to database server is OK.
Database XOOPS exists and connectable.

Database connection is OK.
Press the button below to create database tables.
-----------------------------------------------------
Failed creating table xoops_avatar.
Failed creating table xoops_avatar_user_link.
Failed creating table xoops_banner.
Failed creating table xoops_bannerclient.
Failed creating table xoops_bannerfinish.
Failed creating table xoops_block_module_link.
Failed creating table xoops_xoopscomments.
Failed creating table xoops_xoopsnotifications.
Failed creating table xoops_config.
Failed creating table xoops_configcategory.
Failed creating table xoops_configoption.
Failed creating table xoops_groups.
Failed creating table xoops_group_permission.
Failed creating table xoops_groups_users_link.
Failed creating table xoops_image.
Failed creating table xoops_imagebody.
Failed creating table xoops_imagecategory.
Failed creating table xoops_imgset.
Failed creating table xoops_imgset_tplset_link.
Failed creating table xoops_imgsetimg.
Failed creating table xoops_modules.
Failed creating table xoops_newblocks.
Failed creating table xoops_online.
Failed creating table xoops_priv_msgs.
Failed creating table xoops_ranks.
Failed creating table xoops_session.
Failed creating table xoops_smiles.
Failed creating table xoops_tplset.
Failed creating table xoops_tplfile.
Failed creating table xoops_tplsource.
Failed creating table xoops_users.

Database tables created.


Any clues what could be causing this?

Thanks in advance.

PROBLEM FIXED.

The issue was that my xoopsuser did not have the proper permissions. Typically a system usually just needs select, insert, update, delete, but for the installation you also need to have create and drop.

Hope this helps someone.

I had the same problem. By using your guide, it is solved. Thank you

Cheers,
ahYeop

Quote:

i have a similar problem. most of the tables quoted above are created with no problem but failed on these 4:

Failed creating table xoops_xoopscomments.
Failed creating table xoops_group_permission.
Failed creating table xoops_tplset.
Failed creating table xoops_tplfile.

xoops 2.0.16, on a freebsd 6.0 box, MySQL 5.0,
php 5.5.

any idea?