close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

New pages created with wizard. Insert does not work.

Thread began 4/14/2016 5:50 pm by bjgarner241692 | Last modified 4/15/2016 12:37 pm by Ray Borduin | 128 views | 8 replies |

bjgarner241692

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.

Sign in to reply to this post

bjgarner241692

Link in PM

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

bjgarner241692

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.

Sign in to reply to this post

bjgarner241692

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.

Sign in to reply to this post

bjgarner241692

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.

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

bjgarner241692

Thank you.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...