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?
Replied 20 Oct 2014 14:48:20
20 Oct 2014 14:48:20 Joe Villanova replied:
www.hudsonchildrensbookfestival.com/DEV/test.html

I get a blank page when I test live.
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
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.
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!
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.

Reply to this topic