3.5.0 broke my database connections

Wappler General Bugs
#1

Wappler Version : 3.5.0
Operating System : windows 10

Database connections not working after upate

How to reproduce

https://testing.hitekfab.com/testingTestPage5.asp

Here is a simple test page that should run a simple DB query

Wappler 3.5.4 Released
#2

Baub, please remove the dummy bug report template text when posting a new topic. It’s just for your info.

@patrick will check this

#3
#4

Please try following update, unzip file in dmxConnectLib/lib.

app.zip (1.5 KB)

#5

Nope still error

#6

Can you post the exact error you see?

#7 
{"type":"Error","fileName":"lib/app.asp","lineNumber":115,"message":"Required module \"C:/webroot/testing.hitekfab/dmxConnect/modules/file:///C:/webgraphics/TestingHitekFab/dmxConnect/modules/Connections/HitekFab\" does not exist","stack":[{"fileName":"lib/app.asp","lineNumber":115,"method":"_exec","args":["file:///C:/webgraphics/TestingHitekFab/dmxConnect/modules/Connections/HitekFab"]},{"fileName":"lib/app.asp","lineNumber":115,"method":"_exec","args":[["file:///C:/webgraphics/TestingHitekFab/dmxConnect/modules/Connections/HitekFab",{"name":"query1","module":"dbconnector","action":"select","options":{"connection":"HitekFab","sql":{"type":"SELECT","columns":[{"table":"WebsiteEmails","column":"*"}],"table":{"name":"WebsiteEmails"},"joins":[],"query":"SELECT *\nFROM WebsiteEmails","params":[]}},"output":true,"meta":[{"name":"emailID","type":"number"},{"name":"name","type":"text"},{"name":"companyname","type":"text"},{"name":"email","type":"text"},{"name":"phone","type":"text"},{"name":"moreinfo","type":"text"},{"name":"comment","type":"text"},{"name":"frompage","type":"text"},{"name":"emailDate","type":"time"},{"name":"replied","type":"text"},{"name":"repliedDate","type":"time"}],"outputType":"array"}]]},{"fileName":"lib/app.asp","lineNumber":85,"method":"exec","args":[{"steps":["file:///C:/webgraphics/TestingHitekFab/dmxConnect/modules/Connections/HitekFab",{"name":"query1","module":"dbconnector","action":"select","options":{"connection":"HitekFab","sql":{"type":"SELECT","columns":[{"table":"WebsiteEmails","column":"*"}],"table":{"name":"WebsiteEmails"},"joins":[],"query":"SELECT *\nFROM WebsiteEmails","params":[]}},"output":true,"meta":[{"name":"emailID","type":"number"},{"name":"name","type":"text"},{"name":"companyname","type":"text"},{"name":"email","type":"text"},{"name":"phone","type":"text"},{"name":"moreinfo","type":"text"},{"name":"comment","type":"text"},{"name":"frompage","type":"text"},{"name":"emailDate","type":"time"},{"name":"replied","type":"text"},{"name":"repliedDate","type":"time"}],"outputType":"array"}]}]},{"fileName":"lib/app.asp","lineNumber":57,"method":"define","args":[{"meta":{"$_GET":[{"type":"text","name":"sort"},{"type":"text","name":"dir"}]},"exec":{"steps":["file:///C:/webgraphics/TestingHitekFab/dmxConnect/modules/Connections/HitekFab",{"name":"query1","module":"dbconnector","action":"select","options":{"connection":"HitekFab","sql":{"type":"SELECT","columns":[{"table":"WebsiteEmails","column":"*"}],"table":{"name":"WebsiteEmails"},"joins":[],"query":"SELECT *\nFROM WebsiteEmails","params":[]}},"output":true,"meta":[{"name":"emailID","type":"number"},{"name":"name","type":"text"},{"name":"companyname","type":"text"},{"name":"email","type":"text"},{"name":"phone","type":"text"},{"name":"moreinfo","type":"text"},{"name":"comment","type":"text"},{"name":"frompage","type":"text"},{"name":"emailDate","type":"time"},{"name":"replied","type":"text"},{"name":"repliedDate","type":"time"}],"outputType":"array"}]}}]}],"scope":{"$_ERROR":null,"$_SERVER":{"ALL_HTTP":"HTTP_CONNECTION:close\nHTTP_ACCEPT:application/json\nHTTP_ACCEPT_ENCODING:gzip, deflate, br\nHTTP_ACCEPT_LANGUAGE:en-US,en;q=0.9\nHTTP_COOKIE:_ga=GA1.2.1000385299.1604678250; _gid=GA1.2.1290667019.1604678250; ASPSESSIONIDCCUDTBCD=IGONKPJCODAFEALKMIKMGLKC\nHTTP_HOST:testing.hitekfab.com\nHTTP_REFERER:https://testing.hitekfab.com/testingTestPage5.asp\nHTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36\nHTTP_SEC_FETCH_SITE:same-origin\nHTTP_SEC_FETCH_MODE:cors\nHTTP_SEC_FETCH_DEST:empty","ALL_RAW":"Connection: close\r\nAccept: application/json\r\nAccept-Encoding: gzip, deflate, br\r\nAccept-Language: en-US,en;q=0.9\r\nCookie: _ga=GA1.2.1000385299.1604678250; _gid=GA1.2.1290667019.1604678250; ASPSESSIONIDCCUDTBCD=IGONKPJCODAFEALKMIKMGLKC\r\nHost: testing.hitekfab.com\r\nReferer: https://testing.hitekfab.com/testingTestPage5.asp\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36\r\nsec-fetch-site: same-origin\r\nsec-fetch-mode: cors\r\nsec-fetch-dest: empty","APPL_MD_PATH":"/LM/W3SVC/5/ROOT","APPL_PHYSICAL_PATH":"C:\\webroot\\testing.hitekfab\\","AUTH_PASSWORD":"","AUTH_TYPE":"","AUTH_USER":"","CERT_COOKIE":"","CERT_FLAGS":"","CERT_ISSUER":"","CERT_KEYSIZE":"256","CERT_SECRETKEYSIZE":"2048","CERT_SERIALNUMBER":"","CERT_SERVER_ISSUER":"C=US, S=Arizona, L=Scottsdale, O=\"GoDaddy.com, Inc.\", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2","CERT_SERVER_SUBJECT":"OU=Domain Control Validated, CN=hitekfab.com","CERT_SUBJECT":"","CONTENT_LENGTH":"0","CONTENT_TYPE":"","GATEWAY_INTERFACE":"CGI/1.1","HTTPS":"on","HTTPS_KEYSIZE":"256","HTTPS_SECRETKEYSIZE":"2048","HTTPS_SERVER_ISSUER":"C=US, S=Arizona, L=Scottsdale, O=\"GoDaddy.com, Inc.\", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2","HTTPS_SERVER_SUBJECT":"OU=Domain Control Validated, CN=hitekfab.com","INSTANCE_ID":"5","INSTANCE_META_PATH":"/LM/W3SVC/5","LOCAL_ADDR":"192.168.2.12","LOGON_USER":"","PATH_INFO":"/dmxConnect/api/Tests/newBaubTest.asp","PATH_TRANSLATED":"C:\\webroot\\testing.hitekfab\\dmxConnect\\api\\Tests\\newBaubTest.asp","QUERY_STRING":"","REMOTE_ADDR":"97.86.27.155","REMOTE_HOST":"97.86.27.155","REMOTE_USER":"","REQUEST_METHOD":"GET","SCRIPT_NAME":"/dmxConnect/api/Tests/newBaubTest.asp","SERVER_NAME":"testing.hitekfab.com","SERVER_PORT":"443","SERVER_PORT_SECURE":"1","SERVER_PROTOCOL":"HTTP/1.1","SERVER_SOFTWARE":"Microsoft-IIS/10.0","URL":"/dmxConnect/api/Tests/newBaubTest.asp","HTTP_CONNECTION":"close","HTTP_ACCEPT":"application/json","HTTP_ACCEPT_ENCODING":"gzip, deflate, br","HTTP_ACCEPT_LANGUAGE":"en-US,en;q=0.9","HTTP_COOKIE":"_ga=GA1.2.1000385299.1604678250; _gid=GA1.2.1290667019.1604678250; ASPSESSIONIDCCUDTBCD=IGONKPJCODAFEALKMIKMGLKC","HTTP_HOST":"testing.hitekfab.com","HTTP_REFERER":"https://testing.hitekfab.com/testingTestPage5.asp","HTTP_USER_AGENT":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36","HTTP_SEC_FETCH_SITE":"same-origin","HTTP_SEC_FETCH_MODE":"cors","HTTP_SEC_FETCH_DEST":"empty"},"$_GET":{},"$_POST":{},"$_HEADER":{"connection":"close","accept":"application/json","accept-encoding":"gzip, deflate, br","accept-language":"en-US,en;q=0.9","cookie":"_ga=GA1.2.1000385299.1604678250; _gid=GA1.2.1290667019.1604678250; ASPSESSIONIDCCUDTBCD=IGONKPJCODAFEALKMIKMGLKC","host":"testing.hitekfab.com","referer":"https://testing.hitekfab.com/testingTestPage5.asp","user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36","sec-fetch-site":"same-origin","sec-fetch-mode":"cors","sec-fetch-dest":"empty"},"$_COOKIE":{"_ga":"GA1.2.1000385299.1604678250","_gid":"GA1.2.1290667019.1604678250","ASPSESSIONIDCCUDTBCD":"IGONKPJCODAFEALKMIKMGLKC"},"$_SESSION":{}},"appData":{}}
#8

maybe there is an error on the page for some reason.

The rest of the site seems to be working correclty now with the new app.asp

#9

The error comes from /dmxConnect/api/Tests/newBaubTest.asp

#10

Thanks @patrick and @teodor for the quick replies today!

:beers:

#11

Have seen this a few times before. While saving a server action or database connection, sometimes randomly the “Database Connection” step’s value references the complete file system path instead of something like “Connections/HitekFab”.
Have seen this in both ASP.NET & PHP.

What I do is check other working server action for the correct value… usually its Connections/HitekFab… and replace the same in the server action json with the issue.

1 Like
#12
#13

Fixed in Wappler 3.5.2

#14
#15

This topic was automatically closed after 2 days. New replies are no longer allowed.