DMXzone Database Connector PHP Support Product Page

Solved

error querying the database

Reported 24 Dec 2013 21:48:04
1
has this problem
24 Dec 2013 21:48:04 Chris Green posted:
I get the response
Error querying the database
Server response:

when testing producing the contents of a table

It connects to the database OK

Replies

Replied 25 Dec 2013 21:17:42
25 Dec 2013 21:17:42 Chris Green replied:
Test connection source - Once the connection to your database is established, a database source testing window pops up. It lets you test your source and view the results in a browser.

This is where I am in instruction manual
Replied 06 Jan 2014 11:56:00
06 Jan 2014 11:56:00 Teodor Kuduschiev replied:
Hello Chris,
Can you please provide your PHP version and check if you have PDO installed on your server?
Replied 07 Jan 2014 11:10:18
07 Jan 2014 11:10:18 Chris Green replied:
Php version 5.2 and I am told pdo is installed by my engineer. But how would I check myself. If I can snd you a private message ican send ftp access.
Chris
Replied 07 Jan 2014 15:35:21
07 Jan 2014 15:35:21 Teodor Kuduschiev replied:
Please create a php file containing this:
<?php
phpinfo();
?>


Upload it to your server and send the link to it to:
Replied 08 Jan 2014 17:04:25
08 Jan 2014 17:04:25 Chris Green replied:
I have sent the requested email

Chris
Replied 21 Jan 2014 16:06:08
21 Jan 2014 16:06:08 Chris Green replied:
Please can you give me an update. I really cannot start to use all of your products that I have bought until this problem is solved
Kind regards

Chris
Replied 10 Mar 2014 13:24:56
10 Mar 2014 13:24:56 Teodor Kuduschiev replied:
Hello,
Sorry for the late response but we never received this email.
Please be a little more detailed describing what exactly is happening?
Do you see your tables and columns listed in the query builder window? Can you add columns to the columns list ? What is the exact error message that you see? What happens if you do not use the test connection source button, but click ok - does the connection with the selected tables appear in the Data Bindings Panel?
Please answer the questions as detailed as possible so we can help you.
Replied 11 Mar 2014 00:15:35
11 Mar 2014 00:15:35 Chris Green replied:
The php file is at www.foilfencing.com/phpinfo
Select Site, Database query builder
Select connection and database source name and the table appears
Select the field that You wish to query and give it an alias
Click test source
Database source testing comes up and whatever you do with this
A pop up appears headed Dreamweaver, with a content as follows:
Error Querying the database
Server Response:
The above two lines is all there is in the box.

Instead of click test source, click OK
The window disappears

Thank you for your help


Replied 11 Mar 2014 10:06:56
11 Mar 2014 10:06:56 Teodor Kuduschiev replied:
Hello Chris,
Please do the following:
- When you select your database columns and optionally add your aliases click OK
- Then Open HTML5 Data Bindings panel and tell me do you see the database source there? Try adding it from there using the + sign.
Do you even have the latest HTML5 Data Bindings installed?
Replied 11 Mar 2014 13:19:46
11 Mar 2014 13:19:46 Chris Green replied:
Yes I have the latest HTML5 Data Bindings installed. AH! I thought I had. I tried to reinstall it and it said that it could not install it as it required version 12 of dreamweaver and I have version 11.
Replied 11 Mar 2014 13:49:00
11 Mar 2014 13:49:00 Teodor Kuduschiev replied:
Please make sure to donwload and install the MXP version. The ZXP version is for Dreamweaver CC only.
Replied 12 Mar 2014 07:07:33
12 Mar 2014 07:07:33 Chris Green replied:
I have checked and reinstalled Data Bindings and Database connector and still get the same error.
I tried to add the data source via data bindings + but it does not add

I am so sorry to be so needy. I am sure that there is a very simple explanation and that I am just not seeing it. Once i get the idea of how it all works
Replied 12 Mar 2014 09:23:53
12 Mar 2014 09:23:53 Teodor Kuduschiev replied:
Hello,
Please follow the manual. Just skip the step with "Test connection source".
Replied 13 Mar 2014 12:40:06
13 Mar 2014 12:40:06 Chris Green replied:
I have followed the manual as you suggested. I now need to be pointed at an example of code that I must write in my html file that will use the connection to view the results in my browser. (Please)
Replied 13 Mar 2014 12:53:29
13 Mar 2014 12:53:29 Teodor Kuduschiev replied:
Hello,
You should not write any code... The extension paces all of the code on your page. Please follow the manual and video tutorials, it is described step by step how to add content on your page.
Replied 13 Mar 2014 14:42:25
13 Mar 2014 14:42:25 Chris Green replied:
Sorry. But I come to the same point every time. Error querying the database. The results do not appear as in the video, and the data source does not appear in the databindings. At least I now understand what should be happening.

By the way, Thank you for your patience.
Replied 13 Mar 2014 14:50:29
13 Mar 2014 14:50:29 Teodor Kuduschiev replied:
Could you please send me the login details, database login info etc.. and all needed to connect so i can check what is going wrong on your server?
My email is:
Replied 14 Mar 2014 11:01:15
14 Mar 2014 11:01:15 Chris Green replied:
I have sent the email - Please let me know if you ddo not receive it
Replied 14 Mar 2014 11:28:04
14 Mar 2014 11:28:04 Chris Green replied:
I have just sent a second email
Replied 14 Mar 2014 12:29:09
14 Mar 2014 12:29:09 Chris Green replied:
I downloaded your work and added the record mailname to it and it no longer works. Also when I run test on your work I get the same result.
Replied 14 Mar 2014 14:56:47
14 Mar 2014 14:56:47 Teodor Kuduschiev replied:
The issue was fixed in a live chat session.
The problem was caused by the Paths Relative to Site Root setting in Dreameaver. Changing this to Relative to Document fixes the issue. We will improve this in the upcoming update.
Replied 14 Mar 2014 18:36:49
14 Mar 2014 18:36:49 Chris Green replied:
Sorry.

my data source is not adding to bindings like yours did. the js are added to the php file
Replied 16 Mar 2014 21:57:36
16 Mar 2014 21:57:36 Chris Green replied:
Got it!!

When a page is attached to a template I cannot get a data source to attach to the databindings.

Please will you try this and let me know what you think
Try adding a data source to data bindings when the page is attached to a template. For me it does not work.
Then detach that page from the template and try the same process again. For me it does work.

Replied 17 Mar 2014 09:11:05
17 Mar 2014 09:11:05 Teodor Kuduschiev replied:
Hello Chris,
The issue is not caused by the DWT templates, but with your specific page. Your template needs to have an editable region named "head", located before the closing </head> tag, so Dreamweaver will know where to place the code.
Replied 17 Mar 2014 12:36:32
17 Mar 2014 12:36:32 Chris Green replied:
Sorry. I will adapt my template so that it has an editable area in the head region

Reply to this topic