close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Getting 'This record has been removed' on Detail page

Thread began 5/11/2017 1:58 pm by DeanCollins | Last modified 4/16/2019 12:20 am by Ray Borduin | 316 views | 7 replies |

DeanCollins

Getting 'This record has been removed' on Detail page

Hi! When I go from a results page to the details page, I'm getting a "This record has been removed" message instead of the record details. (Also, the record HASN'T been removed, which confounds me more.)

I've got details pages galore elsewhere so this is for some reason a one-off thing.

I've attached the results and details pages in question.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like some of your code on the details page got placed in the wrong spot.

Move lines 75-153 to the top of the page and that should fix the problem.

Sign in to reply to this post

DeanCollins

Ah! Thanks! That did it.

Sign in to reply to this post

Jonas

I also have this problem on one page (and I recognize the same problem from previous pages I created using DA). Can you please specify in more detail which lines of code to move and where.

The strange thing is that it works on some pages but not on others.

Sign in to reply to this post

Ray BorduinWebAssist

I'd have to look at the page. Try changing WebAssist->Preferences and choose "Wizard Settings" and increase the delay. Sometimes when the wizard runs too fast Dreamweaver can start behaving inconsistently.

Sign in to reply to this post

Jonas

Can u take a look at this page (attached)?
I receive the same error message on this insert page when I register a new record. But the problem is probably bigger than that, I suspect. Because it writes nothing to the database. I have tried to do the same page several times with the help of DA. But it will be the same.
Thanks in advance!

Supplement: However, it saves the selected image, so "upload files" work.

I can't understand what the problem is. Now I have created this page ten times the least, and get the same error. I have compared to other insert files that I created with DA and that work - but find nothing strange. Can there be anything in my database? I attach a screenshot to this as well.

And the update page writes without a problem.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you have:

$InsertQuery->bindColumn("genomsnittsbetyg", "s", "", "WA_SKIP");

Which will cause it to not enter a value for that column, however that column doesn't have a default specified and doesn't allow null. You can't skip a column that doesn't have a default value and doesn't allow null during an insert.

Sign in to reply to this post

Jonas

I didn't see that! I am very grateful.

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