New pages created with wizard. Insert does not work.

Attached files are exactly what was created by your wizard. The insert page does not work at all. On submit, it greys out for the file upload then refreshes with blank fields. The record is not created, the files are not uploaded.

Link in PM

I see you have a column named "status", but status is a reserved word in mysql. Try updating that column name or removing it from your insert.

If that isn't the issue I'd need to debug on the live site to figure it out. If you give me FTP access I can do that.

See a full list of reserved words here:https://dev.mysql.com/doc/refman/5.5/en/keywords.html

That seems to have been the problem. Thank you for the prompt answer.

A few things I would like to mention.

When I select Menu as the field type, it would be nice if your code inserted the database value as the "Selected" value in that field on the Update page. I understand I would have to insert any other options.

The cell widths used in the Basic design are very narrow. Easy enough to change but it would be nice if they were created at twice the width that they are presently.

On the Update page, it would be nice to see the present value of File fields, maybe just in text beside the field.

Actually, that was not the problem. I neglected to Save the field name change on my DB Server so when I re-ran the wizard to recreate the pages it still used the word Status for the field name and yet it worked fine.

No idea why it failed but it is working now.

So the problem appears to have been a simple timeout. If I try to upload 4 images at once, it fails. If I do one or two at a time, it is fine. Also, if I start with small images it is fine.

This exposed another issue. While I have set the option to shrink the images they are not being shrunk at all. FTP info in PM.

In addition, the way your Update pages are created, there is no option to delete an image. I can only update an image or leave it as is. That is not my primary issue as I can create a page to do just that but it should not be necessary. Deleting an attribute of a record is a legitimate part of updating.

Try updating your php.ini file like:

upload_max_filesize = 10M
post_max_size = 10M
max_execution_time = 240;

That should allow you to upload more files at once.

I tried your form and it resized my image properly... Perhaps it didn't resize when the upload failed?

I tested again and realized all but the first upload is set to "no resize"... I've gone ahead and updated the server behaviors so they should update.

Thank you.