Buy Now
Sign in

Error...Table Doesn't Exist

malloy0 , October 15 2007, 05:44
M
malloy0 15
October 15 2007, 05:44 #2795
Hi,

Trying to display ALL of the records I have in my form. From the backend I have the Joomla default set to display 50 records / lines per page and have 80 records / lines in total. Thus to display all 80 requires me to click on the NEXT, or PAGE 2 at the bottom of the Chronoform Joomla page, but when I do I get this error...

"Table Doesn't Exist for this form, Please create a table first to store your form data"

I click on the Create a Table in the upper left menu and it get the error the table is already created.

Help?

Also, using v2.3.2 9/16/07

Thanks!

Mike
Attachments
Contact.cfbak.zip
(1.5 KiB)
52 Downloads/Views
GreyHead 64
October 15 2007, 19:05 #2803
Hi Mike,

Max has posted in another thread that he thinks the upgrade to the later version of ChronoForms will fix this.

If not please post the link URL attached to NEXT and I can go dig in the code.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
GreyHead 64
October 18 2007, 14:33 #2907
Hi Mike,

It really needs Max to work on this but I think I have a fix for you to try.

Look in admin.chronocontact.php for function showdataChronoContact() around line 291. A few lines below you'll find this code
if($id == 0) {
$id = $_POST['formid'];
}
amend this to add [0] in the second line so it reads:
if($id == 0) {
$id = $_POST['formid'][0];
}


Bob

Max: The problem seems to be that $_POST['formid'] returns an array and this code gives $id the value 'Array'. I'm not sure if it will always return an array so there may need to be an extra test in there.

Edited to correct file name (see later posts). Sorry!<br><br>Post edited by: GreyHead, at: 2007/10/18 16:08
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
admin 28
October 18 2007, 19:18 #2911
Hi Mike, Bob,

Yes, this is a bug and Bob's fix did it, Mike just one thing, the file name is admin.chronocontact.php, please follow everything at Bob's solution and it will be fixed.

Cheers

Max
Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
malloy0 15
October 18 2007, 19:32 #2912
Thanks Bob/Max,

Bob's fix did work. Max I knew that Bob typed the wrong filename, I was able to figure whic file by doing a search fo rthe string on line 291. Anyway all is well.

This work great...and am certain you've heard this before, but it would be nice to filter records, be able to edit records, sorts records all in the database. Now this can be done by saving to excel, but it would be nice to do this in the database table.

Thanks so much.

Mike

P.S. If you wish to see how we are using this go to
<!-- w --><a class="postlink" href="http://www.myccv.com">www.myccv.com</a><!-- w --> go to QUICK LINKS / Tryout Registration OR http://www.myccvc.com/content/view/74/139/
Attachments
indexp.txt
(2.9 KiB)
62 Downloads/Views