2
There IS ONE OTHER "BUG" in the Database installation part of XOOPS that I discovered that DEFINITELY prevents the installation and it has NOTHING to do with Permissions - Database or OTHERWISE!
The creators of the SQL scripts add the table type (TYPE=MYISAM) to the end of each table creation line. Some sites (like my home system) are not set up to select a storage type. MY MySQL server, for example is explicitly INNODB. It is the current stable release of MySQL, by the way. Since the servers are mine, I was able to discover the error by locating the script in question, adding a connect line (ie. CONNECT MYDATABASE) at the beginning and executing it from the Unix Shell (BASH in My case) as:
# cd /rootlocation/install/sql
# vi mysql.structure.sql
(insert the correct connect line and save)
mysql -u mjmgr -p <mysql.structure.sql
And you get the error that TYPE=MYISAM is not a valid SQL command for this MySQL installation.
The fix? Re-Edit the file, removing the connect command and go to each table creation line and REMOVE the TYPE=MYISAM option.
(You can use SED or other methods if you are confident enough.)
The installation process then works GREAT - EXCEPT that ANY MODULES you want have the EXACT SAME PROBLEM! Prior to installing or activating the modules, you need to be able to access the command line (Unix) or other editors (Windows) to make the same change!
Xoops creators and developers need to REMOVE the TYPE=MYISAM options and let the database use whatever the default is for that installation!
Xoops would be the BEST SYSTEM I HAVE SEEN and I would USE it if I didn't have to keep correcting this one error for EVERY PART that I wish to utilize!