Phoca Forum

Hello

I have created a new category.
When I try to publish or to unpublish it, I get the following error in the backend:

Table 'mydbname.myprefix_phocadownload_category' doesn't exist SQL=SELECT a.id,a.state AS state, c.published AS cat_state,a.access, c.access AS cat_access FROM myprefix_phocadownload_category AS a LEFT JOIN myprefix_categories AS c ON c.id = a.catid WHERE a.id = 20

When published, I have this error in the frontend:

Warning: Invalid argument supplied for foreach() in /serverpath/components/com_phocadownload/views/categories/tmpl/default.php on line 23

But this error is only shown beside the new category. All categories that existed before, don't show such an error.

Table phocadownload_category really does not exist. But there is a phocadownload_categories table.

I did reinstall Phoca DL 3.0.6. Then I did manually upload all files from the 3.0.6 package. I don't use Overrides. The problem persists.


I use Joomla 3.4.3 and Phoca Download 3.0.6. with the license installed (I did try without it, but same problem).
before I used Joomla 2.5 with an older version of Phoca DL. I did upgrade/migrate as described in the manual on this website, including running the SQL statements.

Any idea why Phoca DL still tries to access table phocadownload_category?


Thank you very much!

Regards
Patrick

Hi, some part of your system calls this SQL query, but not Phoca Download. Try to check all other parts - template (try to switch to another for test), plugins (try to disable them), modules (try to disable them).

Phoca Download does not include any SQL query where it ask _phocadownload_category table

Jan

Hi Jan

Thanks a lot for your help.

If I disable the Phoca Finder Plugin (Categories) (plg_finder_phocadownloadcategory_v3.0.1.zip), then the error message in the Backend disapears. But the error message in the Front end still is there. Even if I disable all 3rd party Plugins and those from core Joomla, that are not needed. Switching to the Protostar-Template does not solve the problem either.

You say, that it does not come from Phoca. But I use the menu Type "Phoca Download > List Categories". So, it believe it must com from Phoca Download, because it does list the Phoca Download Categories(?).

Patrick

Hi Jan

Finally I found the problem:

contacted per PM

Thanks a lot.

Regards
Patrick

For some reason the License Package was an obsolete version.
I installed the latest version of the license and now everything works fine.

Ok