DATABASE SOURCE NOT WORKING

My info:
Mac OSX Mavericks, MAMP server
PHP 5.4.4
MySql
• Server: Localhost via UNIX socket
• Server type: MySQL
• Server version: 5.5.25 - Source distribution
• Protocol version: 10
• User: root@localhost
• Server charset: UTF-8 Unicode (utf8)

Steps:
1) Create db connection OK
2) Create db source. OK to Database Source Testing. Click “Run Test” and this error:
ERROR 1:
Warning: require_once(/Applications/MAMP/htdocs/dmxtest.com/dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php): failed to open stream: No such file or directory in /Applications/MAMP/htdocs/dmxtest.com/dmxDatabaseSources/dsCategories.php on line 4

Fatal error: require_once(): Failed opening required '/Applications/MAMP/htdocs/dmxtest.com/dmxDatabaseSources/../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php' (include_path='.:/Applications/MAMP/htdocs/ZendFramework/library') in /Applications/MAMP/htdocs/dmxtest.com/dmxDatabaseSources/dsCategories.php on line 4

Workaround 1:
require_once($base.'../ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php');
require_once($base.'../ScriptLibrary/dmxDatabaseConnector/adapters/mysql/sqlBuilder.php');
The 2 lines above are in the datasource file. The second path has not been created but wizard keeps trying to update it. I manually copied sqlBuilder.php to the second folder, now I get errors that functions are redeclared.
Workaround 2:
Empty all code from first sqlBuilder.php and upload.

ERROR 2:
Simple datasource created, dsCategories. Should be equivalent to “SELECT * FROM categories”
In dsCategories.php:
$cfg = <<<JSON
{"type": "select", "table": "categories", "columns": [{"table": "categories", "column": "*", "alias": "", "sortable": false}], "wheres": [], "orders": [], "joins": []}
JSON;

In Database Source Testing wizard. Click “Run Test” or “View In Browser” generates the following error code:

{"code":"42000","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"categories\"' at line 1","file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/ScriptLibrary\/dmxDatabaseConnector\/adapters\/mysql\/sqlBuilder.php","line":801,"trace":[{"file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/ScriptLibrary\/dmxDatabaseConnector\/adapters\/mysql\/sqlBuilder.php","line":801,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/ScriptLibrary\/dmxDatabaseConnector\/adapters\/mysql\/sqlBuilder.php","line":772,"function":"executeSelect","class":"SqlConnection","type":"->","args":[{"type":"select","table":"categories","joins":[],"values":[],"wheres":[],"orders":[],"columns":[{"table":"categories","column":"*","alias":"","sortable":false}],"params":[],"sortables":[],"offset":0,"limit":25,"meta":{"allTables":["categories","submissions"],"allViews":[],"tables":{"categories":{"columns":{"catId":{"type":"int","primary":true},"name":{"type":"varchar","size":15,"nullable":true}}}}},"adapter":{"typesMap":null,"LikeFormat":{"starts with":"%s LIKE (%s || '%%') ESCAPE '!'","not starts with":"%s NOT LIKE (%s || '%%') ESCAPE '!'","ends with":"%s LIKE ('%%' || %s) ESCAPE '!'","not ends with":"%s NOT LIKE ('%%' || %s) ESCAPE '!'","contains":"%s LIKE ('%%' || %s || '%%') ESCAPE '!'","not contains":"%s NOT LIKE ('%%' || %s || '%%') ESCAPE '!'"}}}]},{"file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/dmxDatabaseSources\/dsCategories.php","line":12,"function":"execute","class":"SqlConnection","type":"->","args":[{"type":"select","table":"categories","joins":[],"values":[],"wheres":[],"orders":[],"columns":[{"table":"categories","column":"*","alias":"","sortable":false}],"params":[],"sortables":[],"offset":0,"limit":25,"meta":{"allTables":["categories","submissions"],"allViews":[],"tables":{"categories":{"columns":{"catId":{"type":"int","primary":true},"name":{"type":"varchar","size":15,"nullable":true}}}}},"adapter":{"typesMap":null,"LikeFormat":{"starts with":"%s LIKE (%s || '%%') ESCAPE '!'","not starts with":"%s NOT LIKE (%s || '%%') ESCAPE '!'","ends with":"%s LIKE ('%%' || %s) ESCAPE '!'","not ends with":"%s NOT LIKE ('%%' || %s) ESCAPE '!'","contains":"%s LIKE ('%%' || %s || '%%') ESCAPE '!'","not contains":"%s NOT LIKE ('%%' || %s || '%%') ESCAPE '!'"}}},true]}],"warnings":[{"code":2,"message":"Cannot modify header information - headers already sent by (output started at \/Applications\/MAMP\/htdocs\/dmxtest.com\/dmxConnections\/dbConnLocal.php:4)","file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/ScriptLibrary\/dmxDatabaseConnector\/adapters\/mysql\/sqlBuilder.php","line":31,"trace":null},{"code":2,"message":"Cannot modify header information - headers already sent by (output started at \/Applications\/MAMP\/htdocs\/dmxtest.com\/dmxConnections\/dbConnLocal.php:4)","file":"\/Applications\/MAMP\/htdocs\/dmxtest.com\/ScriptLibrary\/dmxDatabaseConnector\/adapters\/mysql\/sqlBuilder.php","line":32,"trace":null}]}

Hello William,
Could you please check how is your site setup in DW - links relative to site root or links relative to document? Also - please send me the following file to : dmxDatabaseSources/dsCategories.php

I found the workaround. Dreamweaver CC 2014, Mac OSX Mavericks

Folder #1 /ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php
Folder #2 /ScriptLibrary/dmxDatabaseConnector/adapters/mysql/sqlBuilder.php

Apparently sqlBuilder.php in folder #1 and #2 are different. I manually created folder #2 and copied the folder#1 file to folder #2 thinking they were the same. This did not work because they are different.

Workaround:
First, manually create folder #2
Then run the dmx wizard.

Your problem is that your wizard creates folder & file #1 and does not create folder #2, hence the folder#2 file is not created.

This was also a problem with the animation plug-in. I first had to manually create the folder for it's files.

Hi William,
You cannot copy and paste files into different folders as they are not the same. If Dreamweaver is not creating those folders for you there is either some create/write permissions issue on your machine, or your Dreamweaver configuration is corrupted.

Just as a note, I had the same problem when trying to use the mssql adapter (no problem using mysql). I had to manually create the /adapters/mssql folder before the dmx script was able to write the second sqlBuilder.php. I verified file permissions in windows before doing so, just to see if it was a permissions issue. Permissions were the same below as above.

Could be Dreamweaver config corrupted. I've had to wipe it a few times in the past to fix issues.

Anyway, thanks for posting your solution Bill.