DMXzone Database Connector PHP Support Product Page

Solved

Migrating a site from MySQL to PostgreSQL.

Reported 27 Nov 2017 22:16:53
2
have this problem
27 Nov 2017 22:16:53 David Cox posted:
I am migrating a site from MySQL to PostgreSQL. I have changed my connection files, and the connection to PG is working. When I try to run a query, it appears that the SQL statement is still escaping the column and table names with backticks (as with MySQL). Is there something I missed? Where can I look to figure out why this is happening?

After enabling debugging, I get the following:
Syntax error: 7 ERROR: syntax error at or near "`"
LINE 1: ...t`, `username`, `password`, `title`, `email` FROM `userwex...

Replies

Replied 28 Nov 2017 08:04:26
28 Nov 2017 08:04:26 Teodor Kuduschiev replied:
Hello David,
Did you re-create the query or used the one, created with the mysql connection?
Replied 30 Nov 2017 16:24:44
30 Nov 2017 16:24:44 David Cox replied:
Teodor
I was able to fix the issue with a previous solution you suggested by altering the code in postgres.php.
thank you
Dave
This reply was removed on 3/14/2018 7:06:15 PM.
See the changelog

Reply to this topic