The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Error when Creating New Form - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Error when Creating New Form (/showthread.php?tid=267)

Error when Creating New Form - Prig - Aug 26th, 2009

Hey,

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

Quote: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?

RE: Error when Creating New Form - Ben - Aug 26th, 2009

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

RE: Error when Creating New Form - Ben - Aug 26th, 2009

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

RE: Error when Creating New Form - Prig - Aug 27th, 2009

(Aug 26th, 2009, 9:20 PM)Ben Wrote: 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.

RE: Error when Creating New Form - Groll - Aug 23rd, 2010

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?

RE: Error when Creating New Form - Ben - Aug 28th, 2010

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! Smile I'm awfully sorry...

- Ben