Hello,
I use version 2.1.1 of Phocadownload on Joomla! 1.7. When I select the list of tags, I get an error with the following message:
Table 'xxx_site_xxx.jos_phocadownload_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocadownload_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Table 'xxx_site_xxx.jos_phocadownload_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocadownload_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Table 'xxx_site_xxx.jos_phocadownload_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocadownload_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Table 'xxx_site_xxx.jos_phocadownload_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocadownload_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc
It seems that the jos_phocadownload_tags table is missing. How do I create this table?
Regards
[Solved] Table jos_phocadownload_tags is missing
-
ergocrate
- Phoca Newbie

- Posts: 4
- Joined: 12 Sep 2011, 15:12
[Solved] Table jos_phocadownload_tags is missing
Last edited by ergocrate on 13 Sep 2011, 21:39, edited 1 time in total.
- Jan
- Phoca Hero

- Posts: 49144
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Table jos_phocadownload_tags is missing
Hi, see the install.sql.bak file in the installation zip and add the sql query manually to your database (e.g. via phpmyadmin, don't forget to change your prefixes)
Jan
Jan
If you find Phoca extensions useful, please support the project
-
ergocrate
- Phoca Newbie

- Posts: 4
- Joined: 12 Sep 2011, 15:12
Re: Table jos_phocadownload_tags is missing
Thanks alot
. It works fine now.
Best regards
Best regards
- Jan
- Phoca Hero

- Posts: 49144
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: [Solved] Table jos_phocadownload_tags is missing
Ok
If you find Phoca extensions useful, please support the project