Search the forum...
Type to search...
Other Articles Anywhere questions
Luiz Felipe Tavares
Luiz Felipe Tavares
Hello, I am trying to setup Joomla with PostgreSQL as my database. However I cannot get Articles Anywhere to work, I get an error message saying SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "LIKE" LINE 1: SHOW TABLES LIKE 'sq5et_fields' ^
Do you provide support for PostgreSQL databases ?
Thank you,
Best regards
Peter van Westen
ADMIN
Peter van Westen
ADMIN
My extensions are only tested on MySQL (and MariaDB). I offer no specific support for PostgreSQL.
That being said, I have no code in Articles Anywhere that would do a SHOW TABLES on the fields table.
So this could be down to an other plugin/code being triggered by outputting specific fields.
Switch on Error Reporting in your Joomla configuration to see the full error trace (to see what is actually triggering that error).
Luiz Felipe Tavares
Luiz Felipe Tavares
In order to avoid the interference of other plugins/extensions I am testing this in a clean joomla install, and I only installed articles anywhere in it.
I turned on the error trace, and it seems to be related to Articles Anywhere calls.
You can find the error trace in this link:
dev2.intratec.us/
I would appreciate your assistance
Peter van Westen
ADMIN
Peter van Westen
ADMIN
Ah, Joomla 3 version.... ok.
Please try the latest development version from:
regularlabs.com/development-releases
Luiz Felipe Tavares
Luiz Felipe Tavares
Thank you for your great and timely assistance.
Just updated the extension, the previous error is gone, but now there is a new error message:
ERROR: syntax error at or near "'query_comment'" LINE 1: ....CustomFields.getAvailableFieldsFromDB : 63 ]' as 'query_com... ^
/var/www/vhosts/dev.intratec.us/dev2.intratec.us/libraries/joomla/database/driver/postgresql.php:1557
The new trace is available at: dev2.intratec.us/
Do you think that there is something that I could do to prevent this compatibility issues globally ? Besides using MySQL or MariaDB.
Once again, thank you very much for your great support.
Peter van Westen
ADMIN
Peter van Westen
ADMIN
The query_comment is added when in debug mode or when the "Use Query Comments" option in the Articles Anywhere system plugin settings is enabled.
A lot of extensions will rely on MySQL and have custom queries that will break on PostgreSQL.
So I expect you to run into more things.
Forum
Support for PostgreSQL - Articles Anywhere
Luiz Felipe Tavares
Luiz Felipe Tavares
Do you provide support for PostgreSQL databases ?
Thank you,
Best regards
Peter van Westen
ADMIN
Peter van Westen
ADMIN
That being said, I have no code in Articles Anywhere that would do a SHOW TABLES on the fields table.
So this could be down to an other plugin/code being triggered by outputting specific fields.
Switch on Error Reporting in your Joomla configuration to see the full error trace (to see what is actually triggering that error).
Please post a rating at the
Joomla! Extensions Directory
Luiz Felipe Tavares
Luiz Felipe Tavares
I turned on the error trace, and it seems to be related to Articles Anywhere calls.
You can find the error trace in this link:
dev2.intratec.us/
I would appreciate your assistance
Peter van Westen
ADMIN
Peter van Westen
ADMIN
Please try the latest development version from:
regularlabs.com/development-releases
Please post a rating at the
Joomla! Extensions Directory
Luiz Felipe Tavares
Luiz Felipe Tavares
Just updated the extension, the previous error is gone, but now there is a new error message:
ERROR: syntax error at or near "'query_comment'" LINE 1: ....CustomFields.getAvailableFieldsFromDB : 63 ]' as 'query_com... ^
/var/www/vhosts/dev.intratec.us/dev2.intratec.us/libraries/joomla/database/driver/postgresql.php:1557
The new trace is available at: dev2.intratec.us/
Do you think that there is something that I could do to prevent this compatibility issues globally ? Besides using MySQL or MariaDB.
Once again, thank you very much for your great support.
Peter van Westen
ADMIN
Peter van Westen
ADMIN
Do you think that there is something that I could do to prevent this compatibility issues globally ? Besides using MySQL or MariaDB.
No, don't think so.A lot of extensions will rely on MySQL and have custom queries that will break on PostgreSQL.
So I expect you to run into more things.
Please post a rating at the
Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you
log in
Buy a Pro subscription
Buy a Pro subscription