Phoca Forum

Have had a recent issue where, when clicking on a PDL File Module link, I get:

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 ':statutory-information-files' at line 1 SQL=SELECT cat.description FROM pwijp_categories cat WHERE cat.id=1:statutory-information-files

We run Joomla 3.2.4 on PHP 5.3.3 on MySQL 5.1.69

Use use PDL Component 3.0.5 and PDL File Module 3.0.0

We are unsure if the hosting Co has recently updated MySQL

Any suggestions please?

Chris

Hi,

see:
viewtopic.php?f=1&t=26335&p=98682#p98533

Phoca does not ask standard Joomla! categories table, this error is comming from other extension installed on your site.

Jan

Hi

In fact viewtopic.php?f=31&t=24434 held the answer.

There were two rows missing from the database so I had to perform this action in phpMyAdmin
This has solved the issue but, what I would like to know is, what changed to make this row addition necessary? Particularly as, looking at the DL statistics, its obvious it had been working until recently, when the error (1064 and also 1054) started to happen? Can you explain please Jan?

Thanks

Chris

Hi, this mostly happens when upgrading, there is some problem in Joomla! - I have tested the code with some developers and we didn't found why when upgrading extensions then some upgrade queries are ignored, see:
https://www.phoca.cz/documents/16-joomla ... extensions
Jan

Thanks Jan,

At least I know what to do if it happens again!

C