"Show Table" error: No primary keys

Hi,

I get the error message "This table has no primary keys and its records can't be viewed!" if I want to show Data of a connected table of a form.

At the overview of the table you can see it has records "Record #1" and if I take a look directly via phpmyadmin I see the table has records. Phpmyadmin also displays cf_id is primary key and auto_increment.

I have an older version of Joomla and Chronoforms also installed. There is no problem to show datas with the same database.

Have I done anything wrong?

Regards Michael

Hi Michael,

Hard to say, I've only seen that error reported when there is no primary key :-(

Can you take a dump of the table in PHPMyAdmin and send it to me along with a form backup?

Bob

Here are the files

Hi Michael,

The form and table work on my test site with no errors. The only think I notice is that the table name has no prefix and so starts with an underscore, which may not be correct

INSERT INTO `_chronoforms_data_Anmeldung`

normally this would be `jos_chronoforms_data_Anmeldung` in older versions of Joomla! or start with a random string in more recent version `abcde_chronoforms_data_Anmeldung`

I suspect that this is the cause of the error that you are seeing.

Bob

Hi Bob

I encounter exactly the same issue.
My table has a prefix.
PhpMyAdmin shows the data correctly.

Listing data records for table gives the following error :
<<<This table has no primary keys and its records can't be viewed!>>>

My table has a PK but impossible to show data in Chronoforms.

Any idea ?

TIA,
Vinamis

--
-- Structure de la table `sl06e_chronoforms_data_mysecondtable20121230`
--

CREATE TABLE IF NOT EXISTS `sl06e_chronoforms_data_mysecondtable20121230` (
`cf_id` int(11) NOT NULL AUTO_INCREMENT,
`cf_uid` varchar(255) NOT NULL,
`cf_created` datetime NOT NULL,
`cf_modified` datetime NOT NULL,
`cf_created_by` int(11) NOT NULL,
`cf_modified_by` int(11) NOT NULL,
`cf_ipaddress` varchar(255) NOT NULL,
`cf_user_id` int(11) NOT NULL,
`input_text_1` varchar(255) NOT NULL,
`input_text_2` varchar(255) NOT NULL,
PRIMARY KEY (`cf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

Hi Amis,

I created a form with the same two inputs, linked a DB Save to your table and it works OK with no error message.

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob

Hi Bob
Happy new year !
Attached is the debug info.
As you can see, the issue is when I use the SHOWDATA button.
TIA for your time,
Vinamis

Hi Amis,

I think I've found the problem here. You are using Joomla! 3.0 and there is a bug in the DB code where the deprecated getTableFields() function needs to be replaced by getTableColumns()

I think that the case that causes this error is around line 54 of administrator\components\com_chronoforms\controller.php but there may be others.

I have sent Max a message about this.

Bob

Thank you for your help and debugging.
Vinamis
Beer or Cidre breton ?

I think I've found the problem here. You are using Joomla! 3.0 and there is a bug in the DB code where the deprecated getTableFields() function needs to be replaced by getTableColumns()

I made these changes and also noticed that the com_chronoforms is owned by apache:apache not my actual admin for Joomla. I replaced all getTableFields() to getTableColums(), used apache:apache and my user:user for all files within the directory and am getting a

SQL=SHOW FULL COLUMNS FROM Array 

When I try to show data.

Any ideas?

-Paul

Hi Paul,

Please download and install the latest version of Chronoforms for J3.0, install it OVER yours, that should update the files and fix this issue.

If not fixed then please contact me through the "Contact us" page.

Regards,
Max