Unable to create new fields or change existing fields

[bill09]

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.

[Joe]

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/36549...ysql-query

Cheers,

Joe

[bill09]

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

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/36549...ysql-query

Cheers,

Joe

[Joe]

Hi Bill,

Strange. Try displaying fewer fields on the interface and see if the update message returns.

Cheers,

Joe

[bill09]

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

[Joe]

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