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?
Linking category to an image in an article doesn't work
-
Sniegu
- Phoca Newbie

- Posts: 6
- Joined: 26 Aug 2015, 13:14
-
christine
- Phoca Hero

- Posts: 2938
- Joined: 28 Nov 2010, 17:20
Re: Linking category to an image in an article doesn't work
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:
Kind regards, Christine
EDIT after posting: Hi Benno
Thanks for your 2nd link (I was searching for) - so, we do have now all informations 
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:
of course: it's an example of phocadownload, but belongs also to phocagalleryJust 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}
Kind regards, Christine
EDIT after posting: Hi Benno
- Benno
- 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
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
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
-
Sniegu
- Phoca Newbie

- Posts: 6
- Joined: 26 Aug 2015, 13:14
Re: Linking category to an image in an article doesn't work
Worked, thanks 