Database Connection

Well, i can see your query

Here’s the preview/Response

code: 2002 file: "/home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/db/Connection.php" line: 103 message: "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" trace: "#0 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/db/Connection.php(103): PDO->__construct('mysql:host=loca...', 'root', 'root', Array)\n#1 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/db/Connection.php(24): lib\\db\\Connection->__construct(Object(lib\\App), Object(stdClass), 'localhost')\n#2 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/modules/dbconnector.php(26): lib\\db\\Connection::get(Object(lib\\App), 'localhost')\n#3 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/App.php(195): modules\\dbconnector->select(Object(stdClass), 'query', Array)\n#4 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/App.php(127): lib\\App->execSteps(Object(stdClass))\n#5 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/App.php(116): lib\\App->exec(Object(stdClass), false)\n#6 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnectLib/lib/App.php(94): lib\\App->exec(Object(stdClass))\n#7 /home/perf/hp3-ph-1015581/856/3607856/user/htdocs/dmxConnect/api/testimonials.php(8): lib\\App->define(Object(stdClass))\n#8 {main}"

I also see the query results when i load your server action in the browser:

https://www.rtmf.org.uk/dmxConnect/api/testimonials.php

Can you send a link to your live page please?

It’s OK its working Teodor. I just uploaded to the live server and its corrected any issues. I guess there was some changes that hadn’t been uploaded to the remote server.

Thanks for your help. And I apologise for being a royal pain in the arse! :grimacing:

1 Like

Remember: the Development target is local, and the Production target is on the live domain.

Thanks @franse … I’ve just found it a bit confusing at first. I think I get it now.