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