PDL File Module - Error 1064

[tapiochre]

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

[Jan]

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

[tapiochre]

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

Code: Select all

    ALTER TABLE `#__phocadownload` ADD COLUMN `token` char(64) default NULL;
    ALTER TABLE `#__phocadownload` ADD COLUMN `tokenhits` int(11) NOT NULL default 0;

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

[Jan]

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

[tapiochre]

Thanks Jan,

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

C