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

DW CC 2019 "Not Responding" any more when opening a file, installed DW CC 2020, installed WA extensions, it too is now "Not Responding"

Thread began 9/16/2020 2:07 am by Nathon Jones Web Design | Last modified 9/17/2020 6:51 am by Ray Borduin | 27 views | 5 replies |

Nathon Jones Web Design

DW CC 2019 "Not Responding" any more when opening a file, installed DW CC 2020, installed WA extensions, it too is now "Not Responding"

Eventually, DW CC 2020 responds with...."a script in the file UNKNOWN is taking a long time to load" and the option to continue or not.
Opening the file in notepad I commented out the following block of code...

<?php
if (isset($_POST["addvenueBTN"]) || isset($_POST["addvenueBTN_x"])) {
$InsertQuery = new WA_MySQLi_Query($csdbmysqli);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "TradVenue";
$InsertQuery->bindColumn("NJdomainID", "i", "$domainID", "WA_DEFAULT");
$InsertQuery->bindColumn("NJuserID", "i", "".((isset($_POST["VENUEuID"]))?$_POST["VENUEuID"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueNAME", "s", "".((isset($_POST["venueNAME"]))?$_POST["venueNAME"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueCONTACT", "s", "".((isset($_POST["venueCONTACT"]))?$_POST["venueCONTACT"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueADD1", "s", "".((isset($_POST["venueADD1"]))?$_POST["venueADD1"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueADD2", "s", "".((isset($_POST["venueADD2"]))?$_POST["venueADD2"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueADD3", "s", "".((isset($_POST["venueADD3"]))?$_POST["venueADD3"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueADD4", "s", "".((isset($_POST["venueADD4"]))?$_POST["venueADD4"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueCITY", "s", "".((isset($_POST["venueCITY"]))?$_POST["venueCITY"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueREGION", "s", "".((isset($_POST["venueREGION"]))?$_POST["venueREGION"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueCOUNTRY", "i", "".((isset($_POST["venueCOUNTRY"]))?$_POST["venueCOUNTRY"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venuePOSTCODE", "s", "".((isset($_POST["venuePOSTCODE"]))?$_POST["venuePOSTCODE"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueLAT", "s", "".((isset($_POST["venueLAT"]))?$_POST["venueLAT"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueLONG", "s", "".((isset($_POST["venueLONG"]))?$_POST["venueLONG"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venuePHONE", "s", "".((isset($_POST["venuePHONE"]))?$_POST["venuePHONE"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueMOBILE", "s", "".((isset($_POST["venueMOBILE"]))?$_POST["venueMOBILE"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueEMAIL", "s", "".((isset($_POST["venueEMAIL"]))?$_POST["venueEMAIL"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueURL", "s", "".((isset($_POST["venueURL"]))?$_POST["venueURL"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueFACEBOOK", "s", "".((isset($_POST["venueFACEBOOK"]))?$_POST["venueFACEBOOK"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueTWITTER", "s", "".((isset($_POST["venueTWITTER"]))?$_POST["venueTWITTER"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueSUMMARY", "s", "".((isset($_POST["venueSUMMARY"]))?$_POST["venueSUMMARY"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueDESC", "s", "".((isset($_POST["venueDESC"]))?$_POST["venueDESC"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueOPENTIMES", "s", "".((isset($_POST["venueOPENTIMES"]))?$_POST["venueOPENTIMES"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueCAPACITY", "s", "".((isset($_POST["venueCAPACITY"]))?$_POST["venueCAPACITY"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueBOOKINGS", "s", "".((isset($_POST["venueBOOKINGS"]))?$_POST["venueBOOKINGS"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueDIRECTIONS", "s", "".((isset($_POST["venueDIRECTIONS"]))?$_POST["venueDIRECTIONS"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venuePARKING", "s", "".((isset($_POST["venuePARKING"]))?$_POST["venuePARKING"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueDISABLED", "s", "".((isset($_POST["venueDISABLED"]))?$_POST["venueDISABLED"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueTOILETS", "s", "".((isset($_POST["venueTOILETS"]))?$_POST["venueTOILETS"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueIMG", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."", "WA_DEFAULT");
$InsertQuery->bindColumn("venueIMGCAP", "s", "".((isset($_POST["venueIMGCAP"]))?$_POST["venueIMGCAP"]:"") ."", "WA_DEFAULT");
if($_SESSION['NJinUSERID'] !== 1 || $_SESSION['NJinUSERID'] !== 100 || $_SESSION['NJinUSERID'] !== 117) {
$InsertQuery->bindColumn("venueAPPROVED", "i", "2", "WA_DEFAULT");
}
$InsertQuery->saveInSession("NEWvenueID");
$InsertQuery->execute();
$InsertGoTo = "add_event.php?av=1";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>


...and when I open DW CC 2020 and open this file, it loads without crashing DW.

Why is this INSERT behaviour crashing DW CC, and how do I fix it?
Thank you.
NJ

Sign in to reply to this post

Ray BorduinWebAssist

It has something to do with the Dreamweaver regular expression engine.

When something comes close to matching, but then runs into issues, it causes a crash.

In this case it is the hand coding you did:

php:
if($_SESSION['NJinUSERID'] !== 1 || $_SESSION['NJinUSERID'] !== 100 || $_SESSION['NJinUSERID'] !== 117) {

  $InsertQuery->bindColumn("venueAPPROVED", "i", "2", "WA_DEFAULT");
        }



One solution to the problem is to make sure it breaks the match earlier... by adding a comment like:

php:
if (isset($_POST["addvenueBTN"]) || isset($_POST["addvenueBTN_x"])) {  // hand coded



By adding the comment in the first line, it prevents dreamweaver from trying to match the rest where the crash occurs.

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathon Jones Web Design

Ray, the crash is happening with and without the hand coding on this behaviour. I should have made that clear, sorry.

NJ

Sign in to reply to this post

Ray BorduinWebAssist

If you attach the file then I could take a look. My guess is that there is other hand coding... does the solution I gave fix it?

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathon Jones Web Design

The solution you have given has resolved it, thank you Ray.

Has something changed in DW though? I have been using CC 2019 absolutely solidly for the past 12 months and have hand coded sections in the WA recordsets and behavious in a lot of projects, and have never had this problem.

Much appreciated.
NJ

Sign in to reply to this post

Ray BorduinWebAssist

I've known about this issue for 20 years... It isn't anything that has changed. It only happens for some server behaviors and it depends on where the hand coding appears.

Sign in to reply to this post
Did this help? Tips are appreciated...

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