Error...Table Doesn't Exist

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

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

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

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

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/