For some reason it's skipping tables. Why would it create some tables and not others? I even went in and switched the default to MyISAM just to see if that might be the issue. Below are the tables JR created with a "successful" install - successful meaning that I got to the "success" page - after removing the jrPages and jrBlog modules which would give me an error during the install.
MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5 |
+----------------------------+
| jr_jraction_item |
| jr_jrcore_cache |
| jr_jrcore_count_ip |
| jr_jrcore_form |
| jr_jrcore_form_session |
| jr_jrcore_item |
| jr_jrcore_log |
| jr_jrcore_log_debug |
| jr_jrcore_menu |
| jr_jrcore_modal |
| jr_jrcore_module |
| jr_jrcore_pending |
| jr_jrcore_pending_reason |
| jr_jrcore_performance |
| jr_jrcore_play_key |
| jr_jrcore_queue |
| jr_jrcore_setting |
| jr_jrcore_skin |
| jr_jrcore_temp |
| jr_jrcore_template |
| jr_jrfollower_item |
| jr_jrmailer_throttle |
| jr_jrmarket_channel |
| jr_jrmarket_install |
| jr_jrmarket_system |
| jr_jrprofile_item |
| jr_jrprofile_profile_link |
| jr_jrprofile_quota |
| jr_jrprofile_quota_setting |
| jr_jrprofile_quota_value |
| jr_jrsearch_fulltext |
| jr_jrsearch_item |
| jr_jruser_cookie |
| jr_jruser_device |
| jr_jruser_forgot |
| jr_jruser_item |
| jr_jruser_language |
| jr_jruser_session |
| jr_jruser_url |
+----------------------------+
39 rows in set (0.00 sec)
I appear to have the re-writes working in the vhost conf file. I'm getting a successful routing to the installer, create account, login, create new account, etc. Why it's creating some and not all the tables is beyond me, unless those tables have something special about them which is forcing some kind of skip.
I've also checked the mysqld.log and the site error_log file to see if anything was showing up, nothing out of the ordinary. The error log is showing some broken image files, but that's probably a specific re-write issue I have to handle when and if I get JR working.
I'm not getting any help from the CENTMINMOD developer, he doesn't have time to test out JR (he's never even heard of it). Every other piece of software works fine on CENTMINMOD - IPB, Xenforo, VB, Wordpress, Drupal, etc.
I did my last test with very minor tweaks to CENTMINMOD and the initial install test of JR was done with STOCK Centminmod install. I only did tweaks after I will still getting the errors.
At this point, I'm kinda stuck. I'm really out of energy creating a new database every time the install fails to create the tables I need to have the site working. I really would love to get this working for everyone. Any help with this would be much appreciated.
updated by @jimmy: 12/19/15 10:34:42PM