Table doesn't exist even in ChronoForms_V3.1_RC5.5, HELP!

skyshing 03 Sep, 2009
I want to create a menu from 'Menu Creator'. I have created a table already and in the 'DB Connection' Tab, I have selected the table name I want to connect to. I also enabled 'Enable Data storage' to YES.
Ok all done here, now when I click on 'Menu Creator', I can see a simnple form, I entered all the required fields there (Form, Parent, Link Text, Order and Icon) and click 'Create' and refresh my browser. Yes I can see new menu link is being created and when I click on the link, it says 'Table doesn't exist'.

I tried it few times and I have even deleted the table from phpmyadmin end to start from new and everytime I created a new menu link, it is the same - 'Table doesn't exist'. I also load the demo form and create the menu link there and see if the menu link work, but it is the same as it says 'Table doesn't exist'.

I have seen several post similar to this one, but not resolve yet. I am using the latest version ChronoForms_V3.1_RC5.5 here and I would have thought this issue would have been solved by now in the latest version or is it something I did not do right, please advise me.

Also the icon that I selected for the menu link does not show up at all.
GreyHead 05 Sep, 2009
Hi skyshing,

This does seem to be a bug in ChronoForms. Here's a fix.

Open administrator/components/com_chronocontact/admin.chronocontact.php and go to line 894 or thereabouts (in the current release). Look for the first and last lines from teh snippet below and add the three new lines as show:
	$table = JRequest::getVar('table', '');
//add the next three lines
	if ( $id && !$table ) {
	    $table = $formtables[0];
	}

	$result = $database->getTableList();

Bob
jrthor2 04 Feb, 2010
I have version 3.2 RC 5.5, but I don't have the directory administrator/components/com_chronocontact/admin/, so I can't edit the file you mention??

I found it. The file to edit is:
administrator/components/com_chronocontact/admin.chronocontact.php
GreyHead 04 Feb, 2010
Hi jrthor2,

Yes that's it - typo on my part. I corrected my original post.

Bob
msharab 09 Mar, 2010
Hi I Create a menu Item Successfully

But when i enter this item i got a grid contains the following

-----------------------------
Record 1
Record 2
Record 3
Record 4
Record 5
.
.
.
-----------------------------


I need to show Each Column in table directly in this Grid

Please How to Solve this problem???
GreyHead 09 Mar, 2010
Hi msharab,

ChronoForms only has this simple data viewer.

You can build a custom viewer with ChronoConnectivity (it will display in the front-end). Or you can use PHPMyAdmin or EasySQL or some other tool to get a custom Database view.

Bob
msharab 10 Mar, 2010
Thanks GreyHead,

I need Some Documentation for chrono Connectivity

How to Use it???
GreyHead 10 Mar, 2010
Hi msharab,

There's a thread in the ChronoConnectivity form here that explains how to use it.

You can also add a list of column names in the "Extra dataview columns fields names" on thev DB Connection tab to have them included in the data viewer grid display.

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

VPS & Email Hosting 20% discount
hostinger