DMXzone Database Connector PHP Support Product Page
Solved
Error Querying Database
Reported 18 Oct 2014 17:04:11
3
have this problem
18 Oct 2014 17:04:11 Joe Villanova posted:
Can not solve this. I have created other connections to the same server without issue. I can build the connection and it tests properly. I can see and load the table -- but when I test the connection to show the content I get the Error Querying Database. I've tired rebuilding the connection to no avail. Very frustrating. Replies
Replied 20 Oct 2014 08:06:22
20 Oct 2014 08:06:22 Teodor Kuduschiev replied:
Hi Joe,
Is this only happening on the test data source window? What if you add the repeat region with your data on the page? Can you please provide a link to this page?
Is this only happening on the test data source window? What if you add the repeat region with your data on the page? Can you please provide a link to this page?
Replied 20 Oct 2014 14:48:20
20 Oct 2014 14:48:20 Joe Villanova replied:
Replied 20 Oct 2014 15:15:02
20 Oct 2014 15:15:02 Teodor Kuduschiev replied:
There is an "500 Internal Server Error" on your server, when i load the page. Please check your server error logs for detailed error report.
Replied 20 Oct 2014 16:01:47
20 Oct 2014 16:01:47 Joe Villanova replied:
[Mon Oct 20 11:14:06 2014] [error] [client 79.124.72.94] PHP Warning: require_once(/var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php): failed to open stream: No such file or directory in /var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/authorlist.php on line 4, referer: www.hudsonchildrensbookfestival.com/DEV/test.html
[Mon Oct 20 11:14:06 2014] [error] [client 79.124.72.94] PHP Fatal error: require_once(): Failed opening required '/var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php' (include_path='.:') in /var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/authorlist.php on line 4, referer: www.hudsonchildrensbookfestival.com/DEV/test.html
[Mon Oct 20 11:14:06 2014] [error] [client 79.124.72.94] PHP Fatal error: require_once(): Failed opening required '/var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php' (include_path='.:') in /var/www/vhosts/hudsonchildrensbookfestival.com/httpdocs/dmxDatabaseSources/authorlist.php on line 4, referer: www.hudsonchildrensbookfestival.com/DEV/test.html
Replied 20 Oct 2014 16:13:25
20 Oct 2014 16:13:25 Teodor Kuduschiev replied:
Can you please make sure the: /ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php is created and uploaded to your server?
Also what is the remote folder you are uploading your files to? It seems there is some mismatch between the local site/folder structure and the remote one... which may be causing this issue.
Also what is the remote folder you are uploading your files to? It seems there is some mismatch between the local site/folder structure and the remote one... which may be causing this issue.
Replied 20 Oct 2014 18:37:30
20 Oct 2014 18:37:30 Joe Villanova replied:
That fixed it -- and yes, the site structure is a bit of a mess, it's one of the reasons the client is having me redo the site with newer tech and cleanup what is there.
Thanks for the help!
Thanks for the help!
Replied 10 Jan 2017 04:21:59
10 Jan 2017 04:21:59 ELYAS NAIMZADA replied:
i have the same problem i get a blank page and no errors on log file.