close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Loosing images

Thread began 6/06/2013 6:09 am by john70964 | Last modified 6/07/2013 4:40 pm by john70964 | 386 views | 12 replies |

john70964

Loosing images

I doubt this has anything to do with data assist but thought I would ask anyway...

I have a site using mysql.
The site has been running previously via .asp and access.mdb
I now have the site using mysql and php and it is running quite well except it seems to loose NEW image field names from the table.
Imported Image field names from the previous web site are not lost just new entries.

I recently noticed new entry images were missing on the internet and manually replaced these via phpmyadmin.
Two days later they are missing again.
The fields are varchar 100 notnull with a default image name which is then over written with the new imagename.
The actual images are not missing from the folder.

Has anyone any suggestions how this may caused or rectified please?
Thanks for any help.
Regards

John

Sign in to reply to this post

Jason ByrnesWebAssist

I Dont follow, what do you mean by losing images?

please provide more details.

Sign in to reply to this post

john70964

Hello Jason
I am not loosing images. The actual images are in the images folder.

I am loosing the field names that are entered in the table.

eg in a table I may have a field names say image1 image2 image3 etc

The data referring to the image that has been inserted with a new record goes missing, it seem for new records only.

After the field names disappeared from the table I inserted the image field names manually via phpmyadmin Edit Mode and they disappeared again.
Twice I did this.
I did insert a new test record this morning and so far the images appear normally. Be interesting to see if they stick.
Regards
John

Sign in to reply to this post

Jason ByrnesWebAssist

so what you mean to say is that the insert is not inserting the file name?

In the insert record behavior, bind the file name column to the WA Uploaded images (File Field name) -> Server File name binding.

you need to use the Data Assist insert record behavior for this.

Sign in to reply to this post

john70964

No Jason
The images and the image field names are inserted correctly.

After some time, I don't know how long at the moment, the image field name gets deleted (lost) so it becomes an empty field.

Sign in to reply to this post

Jason ByrnesWebAssist

must be a problem when the record is updated.

this can happen if the record gets updated without uploading a new image.

on the update page, you should have a hidden field that is bound to the image column from the recordset.

in the upload behavior, bind the default file setting to the hidden element.

Sign in to reply to this post

john70964

Thanks Jason
Sounds promising.
I have inserted the hidden images and attach a zip of this. I think this is correct but perhaps you would check.
I wondered creating the hidden images would have any effect with the Update Record Server Behavior. I attach an image of that SB

Sign in to reply to this post

Jason ByrnesWebAssist

couple p[robelms:

1) In the update behavior, the image fields are bound to elements that do not exist.

2) There are no image upload fields on the update page.

since there are no image upload fields on the update page, you should not bind the image columns to anything so they will not be updated.

Your not changing anything for the image fields, so don't include them in the update behavior.

Sign in to reply to this post

john70964

Thanks for that advice Jason and in view of that I have also removed the recordID RecNo and the Regdate.
I think that's correct to do.
Can I take it that the hidden image fields are correctly placed?

Sign in to reply to this post

Jason ByrnesWebAssist

since you are not updating the images, the hidden fields aren't needed.

Sign in to reply to this post
loading

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...