remove mysql prefix or use cmsb without mysql prefix

Hi Karls,

We haven't tested that but if you're comfortable modifying the code you could try disabling the error checking in /lib/admin_functions.php in the installIfNeeded() function

    //if     (!$_REQUEST['mysqlTablePrefix'])                          { alert("Please enter your 'MySQL Table Prefix'<br>\n"); }
    //elseif (preg_match("/[A-Z]/", $_REQUEST['mysqlTablePrefix']))    { alert("Value for 'MySQL Table Prefix' must be lowercase.<br>\n"); }
    //elseif (!preg_match("/^[a-z]/i", $_REQUEST['mysqlTablePrefix'])) { alert("Value for 'MySQL Table Prefix' must start with a letter.<br>\n"); }
    //elseif (!preg_match("/_$/", $_REQUEST['mysqlTablePrefix']))      { alert("Value for 'MySQL Table Prefix' must end in underscore.<br>\n"); }
    //elseif (preg_match("/[^a-z0-9\_\-\.]/i", $_REQUEST['mysqlTablePrefix'])) { alert("Please enter a valid 'MySQL Table Prefix' (Example: cms_)<br>\n"); }

And then deleting/renaming /data/isInstalled.php to get back to the install screen.

Maybe do a full backup first and then try to restore.

Hope that helps!

One more question:
Can I rename the Record number field from "num" to "id" with my custom tables? (probably not, that is default cmsb auto-increment...)

Hi Karls, 

No, everything is hardcoded to work with 'num' as the unique identifier.  Depending on your use case you might be able to add an id field and keep them updated or in sync.  It would take some experimenting though.