Can't create a new table

tfk 03 Mar, 2012
I previously created a table for a form. However, today when I select a form and click Create Table, the form for defining a table opens as normal. When I click save, the page closes and the success confirmation message is displayed.

However, the table does not show in the Forms manager. I tried this on a form with an existing table, and it was not added to the drop-down list. When I tried it on another form without an existing table, the drop-down list was not displayed that form.

Edit: I'm using v4 on Joomla 2.5

Thanks
GreyHead 04 Mar, 2012
Hi tfk,

Please use PHPMyAdmin to check if the table has actually been created. If not you may need to set Site Debug on temporarily so see what the actual MySQL query is and if there are any error messages from it.

Bob
tfk 04 Mar, 2012
Thanks for the reply.

SORRY--I hadn't changed the table in the dbsave action😶 Thanks, however, for the tip about the phpMyAdmin.
GreyHead 05 Mar, 2012
Hi tfk,

Ah, I misunderstood. The drop-down in the Forms Manager only shows the tables that are connected to the form using one of the DB actions; if you select the table in a DB Save action then it will appear in the list.

Bob
This topic is locked and no more replies can be posted.