Error when Creating New Form

[Prig]

Hey,

I was trying to create a new form today and received the following error...

Error:
Failed query in ft_setup_form, line 707:
INSERT INTO ft_forms (access_type, date_created, is_active, is_complete,
form_name, form_url, redirect_url, edit_submission_page_label)
VALUES ('admin', '2009-08-26 15:35:23', 'no', 'no', 'Test', 'http://www.urltoform.com', 'http://www.urltoform.com',
'Edit Submission')
Debug:

Unknown column 'edit_submission_page_label' in 'field list'

Any thoughts on how to resolve this issue?

[Ben]

Eesh.... that's a serious one. Thanks for posting this.

I did some looking around and found that there was a syntax error with an earlier version of the upgrade script which would have prevented the field from being created. The field was a recent addition.

In the next build I'll include some code to ensure that that field is created. But in the meantime, you might just want to add the field manually.

Are you familiar / comfortable with phpMyAdmin? If so, run this query on your forms table (changing the ft_ table prefix to whatever you have.

Code:

ALTER TABLE ft_forms ADD edit_submission_page_label TEXT NULL

That should fix 'er up!

Sorry about that, Prig.

- Ben

[Ben]

Hey Prig -

Nevermind, just upgrade to the latest version. I just released a fix that should solve your problem.

Let me know if it doesn't fix it!

- Ben

[Prig]

Hey Prig -

Nevermind, just upgrade to the latest version. I just released a fix that should solve your problem.

Let me know if it doesn't fix it!

- Ben

Hey Ben,

Thanks for the quick response. I was able to get past step 1, but waiting to hear back from a client about various options. But everything seems to be working so far.

Once again, thanks for looking into this for me.

[Groll]

I'm having the exact same problem. I am using v 1.5.1 (I know, I know...but this works great for me, and I don't want to upgrade, as I have so much in these forms that I don't want to screw anything up.

I ran the SQL query, and got this result:[/align]

Your SQL query has been executed successfully (Query took 0.2611 sec)

But I still get the message when I set up a new form. The forms that are in there work perfectly, but I can't seem to set up a new form.

The only 'thing' that I did recently was move the form tools and database to a new server, but I haven't set up a 'new' form until right now.

How can I fix this? I really don't want to upgrade at this time...is 1.5.1 still supported...at least for this fix?

[Ben]

Hi Groll,

I totally understand why you don't want to upgrade - 1.5.1 is a perfectly decent script, and upgrading is always a pain.

But the error described above is very much a 2.x problem. I don't support 1.5 any more because I find it hard keeping up with 2.x support! I'm awfully sorry...

- Ben