Bug after upgrade to Joomla! 3.2

[luccio]

Hello,

I've updated my site Joomla 3.1.5 to Joomla 3.2
All my extensions work with Joomla 2.0 without problems except the extension PhocaDownload then it worked fine with Joomla 3.1.5

PhocaDownload works great backend and fronted, but there is a bug when you click on download.

Try to download a pdf of her on my site, none works.

http://amisdukmzero.com/index.php?optio ... Itemid=894

I receive the following error message:

Code: Select all

1054 - Unknown column 'c.tokenhits' in 'field list' SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM x65xd_phocadownload AS c, x65xd_phocadownload_categories AS cc WHERE c.id = 2 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2013-11-29 14:50:29' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2013-11-29 14:50:29' ) ORDER BY c.ordering LIMIT 0, 1

Thank you to tell me if you have a solution to this problem.

Luccio.

[luccio]

Hello,

Ok, I found or just the problem, but not the solution.

I remade a new installation from a backup with Akebabacup my site, I applied the update to Joomla 3.2 and all site work even PhocaDownload (version3.0.2)

I then did the update to version 3.0.3 PhocaDownload and error, can not download even locally.

I even tried to change the SEF but without success.

The problem therefore come well Phocadownload version 3.0.3.

Now we need to find the exact error and correct it.

Thank you.

[luccio]

Ok, im solved it

Just add this table via SQL in DB:

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;

I just tested locally, it works great on two sites.

I'll do the update on my 2 websites tomorrow.

More info :

https://www.phoca.cz/documents/16-joomla ... extensions

A very big thank you to Benno for this solution

[nasa]

Hey

Phoca download 3.0.1 was working fine in 3.1 and after 3.2 but when upgrade phoca to 3.0.3 then i'm getting

0 - SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM l8u64_phocadownload AS c, l8u64_phocadownload_categories AS cc WHERE c.id = 16 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,5) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2013-12-11 02:53:09' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2013-12-11 02:53:09' ) ORDER BY c.ordering LIMIT 0, 1

I added it
ALTER TABLE `#__phocadownload` ADD COLUMN `token` char(64) default NULL;
ALTER TABLE `#__phocadownload` ADD COLUMN `tokenhits` int(11) NOT NULL default 0;
but no solution
also before it was working the downloaded file used to be corrupt..

Plz help me
Sharif

[Jan]

Hi, do you get any other error on the page, the SQL query is not error sql query?

Did you add the #__phocadownload with your database prefix, e.g. jos_phocadownload:

https://www.phoca.cz/documents/16-joomla ... extensions

Jan