The following warnings occurred: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
|
Unable to create new fields or change existing fields - 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: Unable to create new fields or change existing fields (/showthread.php?tid=3019) |
Unable to create new fields or change existing fields - bill09 - Apr 30th, 2014 Hi, I have a table with 114 fields in it. I am unable to add any new fields or make any changes to existing fields. The screen refreshes, but I do not receive the typical 'The changes to your field(s) have been saved.' message after I click Update, nor do I receive any error messages. All other tables allow changes. I am using version 2.2.5. Any suggestions would be appreciated. RE: Unable to create new fields or change existing fields - Joe - Apr 30th, 2014 I think your script might be timing out. This sometimes occurs on some servers when the PHP ini file is set to a low max execution time. Here are more details on resolving this issue: http://stackoverflow.com/questions/365496/how-to-keep-a-php-script-from-timing-out-because-of-a-long-mysql-query Cheers, Joe RE: Unable to create new fields or change existing fields - bill09 - May 1st, 2014 Thanks Joe, It's currently set to 30 seconds (max allowed on our hosting account). I timed how long it takes from when I click the Update button until the screen refreshes and it is only 5 seconds. Would there be any restrictions on the database/table type? (MyISAM) Bill (Apr 30th, 2014, 6:50 PM)Joe Wrote: I think your script might be timing out. This sometimes occurs on some servers when the PHP ini file is set to a low max execution time. Here are more details on resolving this issue: http://stackoverflow.com/questions/365496/how-to-keep-a-php-script-from-timing-out-because-of-a-long-mysql-query RE: Unable to create new fields or change existing fields - Joe - May 1st, 2014 Hi Bill, Strange. Try displaying fewer fields on the interface and see if the update message returns. Cheers, Joe [SOLVED] RE: Unable to create new fields or change existing fields - bill09 - May 2nd, 2014 Hi Joe, I set it to show only 10 fields then I was able to add a new field. Strange, but it worked. Thanks for the tip! Bill RE: Unable to create new fields or change existing fields - Joe - May 8th, 2014 Hi Bill, No problem. Thanks for reporting back. I think the script was timing out. With lot of fields it takes the script much longer to update. Cheers, Joe |