Linking category to an image in an article doesn't work

Phoca Gallery - image gallery extension
Sniegu
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 26 Aug 2015, 13:14

Linking category to an image in an article doesn't work

Post by Sniegu »

Hi guys,

So, here's the thing. I updated a site from J!2.5 to J!3.4 and updated Phoca by installing the latest package. All seemed fine, so I started restructurizing my gallery. Here's what I've done:

1. Created a menu (just a menu, no module)
2. Created a List of Images (Category View) menu item for each category I have
3. Created an article and pasted an image in it
4. Test-copied the link from the menu item to link the image to this category

And I received this error:
1146
Table 'sabatont.eua_phocagallery_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM eua_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
The page you requested cannot be found.

I checked and, well, yeah - the table doesn't exist. How do I go around this? What does this table do? How can I create it?
christine
Phoca Hero
Phoca Hero
Posts: 2938
Joined: 28 Nov 2010, 17:20

Re: Linking category to an image in an article doesn't work

Post by christine »

Hi,

have a look please to: https://www.phoca.cz/documents/16-joomla/834 ... ase-column and here:
https://www.phoca.cz/documents/17-phoca- ... em-solving > be aware of:
Just copy the SQL queries of new tables and run them in e.g. phpMyAdmin. But be aware, because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you must rename them, e.g.:

#__phocadownload to TablePrefix_phocadownload

TablePrefix is the prefix you selected while installing Joomla! (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore}
of course: it's an example of phocadownload, but belongs also to phocagallery

Kind regards, Christine

EDIT after posting: Hi Benno :wink: Thanks for your 2nd link (I was searching for) - so, we do have now all informations :wink:
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9965
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Linking category to an image in an article doesn't work

Post by Benno »

Hi,
see: https://www.phoca.cz/documents/16-joomla ... ase-column
&
viewtopic.php?f=1&t=33788

Kind regards,
Benno

Edit: Hi Christine, Du warst deutlich schneller :wink:
Sniegu
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 26 Aug 2015, 13:14

Re: Linking category to an image in an article doesn't work

Post by Sniegu »

Worked, thanks :D
Post Reply