Phoca Forum

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?

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 Thanks for your 2nd link (I was searching for) - so, we do have now all informations

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

Worked, thanks