Phoca Forum

1055: Unknown column 'cc.c.title' in 'order clause'

Could you tell me what to do.

Best regards

Hi,

maybe some tables are missing resp. not upgraded. See here please: https://www.phoca.cz/documents/16-jooml ... extensions

BTW: Which PHP version are you using?

Kind regards, Christine

Thank you for your quick reply. I read your suggestion:
ALTER TABLE `#__phocadownload` ADD COLUMN `token` char(64) default NULL;
ALTER TABLE `#__phocadownload` ADD COLUMN `tokenhits` int(11) NOT NULL default 0;

But once in PhpMyAdmin I am not sure how to proceed. Can you guide me. Tell me if I am right or correct me and complete please the next steps:
1. Clic onto #_phocadownload
2. Clic onto SQL, I see than SELECT * FROM `#_phocadownload` WHERE 1 in a frame
3. Shall I had the two line alter table in that frame and clic onto insert? or onto update?

As you see I am not familiar with Php My Admin and I thank you for your help.

PS. I am using php 7

Best regards

Jean Claude

Hi Jean Claude,

I'm not sure, if I can explain correctly ... in principle, before starting amendments etc. make backup from your database

1) You must "clear" the field (in PHPMyAdmin).
2) Then insert your Codes with your prefix.
3) Klick: OK

I hope, it works

Kind regards, Christine

When I do the SQL request according to your explaination. I get following message

#1146 - Table 'celias4601_site01.celias46__phocadownload' doesn't exist

May be should I do it at level of #_Phocadownload?

This being said, I checked that token and tokenhits columns already exist within #_phocalownload.

I have on my computer an old version of Phocadownload (dated Oct 2015) which I could transfert the "com_Phocadownload" files by FTP, deleting before on the serveur the actual ones. May be this would solve my pb. Any suggestion of somthing not to do?

Hi, usually when upgrading extension, the database structure will be updated - depends on Joomla! extension manager.

But this means: Table 'celias4601_site01.celias46__phocadownload' doesn't exist - not even the basic table is included in your database for Phoca Download

Jan

Hi, The problem has been finally solved by reloading Phoca 3.1.2. and upgrading to last Joomla 3.8. Apparently one Phocadownload file had been initially uncorrectly transferred. I should have thought of doing it before

Thank you Jan and Christine for your patience. Your are doing a great job.

Hi JCPO,

thank you for your information!

Kind regards from the team:
Jan, Benno & Christine