<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>remove mysql prefix or use cmsb without mysql prefix</title>
        <link>https://interactivetools.com/forum/forum-posts.php?remove-mysql-prefix-or-use-cmsb-without-mysql-prefix-82691</link>
        <description></description>
        <pubDate>Tue, 11 Aug 2026 14:09:59 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;remove-mysql-prefix-or-use-cmsb-without-mysql-prefix-82691" rel="self" type="application/rss+xml" />

                <item>
          <title>remove mysql prefix or use cmsb without mysql prefix</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2246623#post2246623</link>
          <description><![CDATA[<p>Hi Karls, </p>
<p>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.</p>]]></description>
          <pubDate>Tue, 11 Jul 2023 16:07:13 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2246623#post2246623</guid>
        </item>
                <item>
          <title>remove mysql prefix or use cmsb without mysql prefix</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2246621#post2246621</link>
          <description><![CDATA[<p>One more question:<br />Can I rename the Record number field from "num" to "id" with my custom tables? (probably not, that is default cmsb auto-increment...)</p>]]></description>
          <pubDate>Tue, 11 Jul 2023 01:44:53 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2246621#post2246621</guid>
        </item>
                <item>
          <title>remove mysql prefix or use cmsb without mysql prefix</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2246620#post2246620</link>
          <description><![CDATA[<p>Thank you Dave for your quick reply!</p>
<p>I'll give it a try.</p>]]></description>
          <pubDate>Mon, 10 Jul 2023 12:28:14 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2246620#post2246620</guid>
        </item>
                <item>
          <title>remove mysql prefix or use cmsb without mysql prefix</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2246617#post2246617</link>
          <description><![CDATA[<p>Hi Karls,</p>
<p>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</p>
<pre class="language-php"><code>    //if     (!$_REQUEST['mysqlTablePrefix'])                          { alert("Please enter your 'MySQL Table Prefix'&lt;br&gt;\n"); }
    //elseif (preg_match("/[A-Z]/", $_REQUEST['mysqlTablePrefix']))    { alert("Value for 'MySQL Table Prefix' must be lowercase.&lt;br&gt;\n"); }
    //elseif (!preg_match("/^[a-z]/i", $_REQUEST['mysqlTablePrefix'])) { alert("Value for 'MySQL Table Prefix' must start with a letter.&lt;br&gt;\n"); }
    //elseif (!preg_match("/_$/", $_REQUEST['mysqlTablePrefix']))      { alert("Value for 'MySQL Table Prefix' must end in underscore.&lt;br&gt;\n"); }
    //elseif (preg_match("/[^a-z0-9\_\-\.]/i", $_REQUEST['mysqlTablePrefix'])) { alert("Please enter a valid 'MySQL Table Prefix' (Example: cms_)&lt;br&gt;\n"); }</code></pre>
<p>And then deleting/renaming /data/isInstalled.php to get back to the install screen.</p>
<p>Maybe do a full backup first and then try to restore.</p>
<p>Hope that helps!</p>]]></description>
          <pubDate>Mon, 10 Jul 2023 12:09:00 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2246617#post2246617</guid>
        </item>
                <item>
          <title>remove mysql prefix or use cmsb without mysql prefix</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2246616#post2246616</link>
          <description><![CDATA[<p>Hi,</p>
<p>Can I install or remove the MySQL prefix of the cmsBuilder (so I can merge later with another project).</p>
<p>regards,<br />Karls</p>]]></description>
          <pubDate>Mon, 10 Jul 2023 11:39:30 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2246616#post2246616</guid>
        </item>
              </channel>
    </rss>
  