https://www.machform.com/forums/ MachForm Community Forums Topic: Change prefix tables en Sun, 03 May 2026 23:30:48 +0000 https://www.machform.com/forums/topic/change-prefix-tables#post-11458 Tue, 22 Feb 2011 22:19:10 +0000 petebocken 11458@https://www.machform.com/forums/ <p>So I did another search/replace on all files for the following: ap_form_{$form_id} =&gt; ap_test_form_{$form_id}</p> <p>Now when I create a new form the database table prefix is correct. So I guess it will work to just do a search/replace on all files every time I want to install a new instance of Machform. </p> https://www.machform.com/forums/topic/change-prefix-tables#post-11456 Tue, 22 Feb 2011 22:05:41 +0000 petebocken 11456@https://www.machform.com/forums/ <p>@Sean - I followed your instructions and I think I'm confused on the last part about "Afterwards, replace function $ap =&gt; function ap_"</p> <p>Are you doing another search/replace across all files after installation? If you replace $ap with ap_ then you actually will end up with two underscores, so that can't be right.</p> <p>Also, isn't the whole idea to be able to install multiple machform installations in one database? So wouldn't you want to customize the 4 lines to say something like "ap_test_forms", etc?</p> <p>I tried this. Installation went fine and the tables were created in the database with my custom name but when you go to log in the webpage is white and nothing comes up. Maybe that is because I am missing the last step.</p> <p>I tried search/replace across all files and replace $ap with ap_test and then everything works fine, except when you create a new form an ap_form_1 table is added to the database. So isn't the whole point to be able to have a base installation directory that you can just change the config file to a unique database prefix and not have to touch the files since it's automatically looking up the correct prefix in the config file? If that's how it's suppose to work, apparently it's not or I'm doing something wrong. </p> https://www.machform.com/forums/topic/change-prefix-tables#post-8256 Sat, 02 Jan 2010 05:02:44 +0000 sphelan 8256@https://www.machform.com/forums/ <p>Yuniar,</p> <p>Table prefixes are an important feature, and is not be a hard change to implement ... I just did this locally in 33 minutes.</p> <p>Put these 4 lines at the end of config.php:<br /> $ap_forms = 'ap_forms';<br /> $ap_form_elements = 'ap_form_elements';<br /> $ap_element_options = 'ap_element_options';<br /> $ap_column_preferences = 'ap_column_preferences';</p> <p>Then search/replace across all files, replacing:<br /> ap_forms =&gt; $ap_forms<br /> ap_form_elements =&gt; $ap_form_elements<br /> ap_element_options =&gt; $ap_element_options<br /> ap_column_preferences =&gt; $ap_column_preferences</p> <p>Even if you do this globally, it almost works as is . Afterwards, replace:</p> <p>function $ap =&gt; function ap_</p> <p>And you're done.</p> <p>Can we get this into the main code base? I'd hate to lose my upgrade path for this one feature.</p> <p>Sean Phelan<br /> <a href="http://www.VIRTUssist.com">http://www.VIRTUssist.com</a> - Secretarial And Virtual Assistant Services </p> https://www.machform.com/forums/topic/change-prefix-tables#post-6966 Tue, 18 Aug 2009 20:53:26 +0000 redityo 6966@https://www.machform.com/forums/ <p>Sorry, I'm afraid it's not possible to change the prefix. All tables are already having ap_xxxx prefix. </p> https://www.machform.com/forums/topic/change-prefix-tables#post-6955 Tue, 18 Aug 2009 02:05:38 +0000 Ajaxriver 6955@https://www.machform.com/forums/ <p>Is it possible to change the default prefix ap_ of tables to another prefix like jos_?</p> <p>I need this because joomla.</p> <p>Thanks<br /> JMorais </p>