I can't shake this error when attempting to use the Database Source Query Builder.

I used DMX Zone Database Connector to create the database connection using the same credentials as Dreamweavers standard database panel.

I get the same result from DW CS5 and CC using different databases.

Any ideas?

Hello Chris,

Please provide your server type and database you are using. Please also describe when exactly does this error appear?

Hi Teodor,

It's a Linux/Apache server running php 5.3 and Mysql 5.1. PDO enabled.

The error occurs thus:

Site > DMXzone Database Connector > Manage Data Sources (to open Database Source Query Builder panel (DSQB).

As soon as I select my recently added database from the "Connections" drop down menu in the DSQB the warning message appears.

As mentioned, standard Dreamweaver database connection methods work fine, but I'm really looking forward to using the query builder.

Thanks
Chris

Can you please tell me what is the exact error message?

Yes, its: "error loading database structure"

Hi Chris,

There were no error during the creation of the Database connection? The test of it went all fine?

Greetings,
George

Hi George,

That's the funny thing, the Test Connection button and and the Apply button of the Database Connection panel both return the "Database Connection OK" message - even if I put in the incorrect details (which I did for experimentation).

Cheers
Chris

Hi Chris,

This is weird, probably that is the reason for the error.
Your PHP server is accepting somehow all kinds of MySQL connections ...

What part of the fields you are entering wrong on purpose?

Try the make good connection with the right credentials. Then on the Query Builder dialog, make sure you refresh the schema first by pressing the refresh Icon under the tables drop down.

If the connection is right you should see the table names from the database in the table drop down.

Greetings,
George

Regards the incorrect details I just played with the mysql properties (database name, password).

I'm afraid, having restored the correct credentials, the 'refresh' button returns exactly the same error when I click it - 'error loading database structure!'.

Such a shame this, the query builder looks incredible, but I'm having no luck at all.

Hi Chris,

Seems you have to delete the cache of the Database Connector manually.

You can locate it at
:
Windows:
C:\Users\username\AppData\Roaming\Adobe\Dreamweaver CC\en_US\Configuration\Temp\dmxDatabaseConnector\Cache

Mac:
MacHD \ Users \ <username> \ Library \ Application Support \ Adobe \ Dreamweaver CC \ <language> \ Configuration \ Temp \ dmxDatabaseConnector \ Cache

just empty the folder and then restart the Query builder.

Greetings,
George

Hi George,

Thank you and I so wish that had worked but I'm afraid I got the same result.

On returning to the folder created in the cache I did grab the following code from the text file (if it helps):

<br />
<b>Parse error</b>: parse error, unexpected '{' in <b>/home/6/9/b/3554/3554/public_html/dmxConnections/dmxDatabase.php</b> on line <b>32</b><br />

Cheers
Chris

Hi Chris,

Yes this is really helpful!

Seems indeed a weird php error pops up.
Are you sure you have PHP 5.3 running? Do you have phpinfo somewhere?

try running this file directly:
dmxConnections/dmxDatabase.php

Should go without any parse errors...

-George

SUCCESS!

OK, firstly, the cache clearing advice may well have worked, but for the fact the example I was trying DID NOT have php 5 (still 4). On trying the same advice with a server known to be running php 5.3 - what do you know? Works a treat.

Thank You!!

Good to hear it is all solved our! Yes you do need PHP 5.2+ to have the Database Connector running.

Greetings,
George