Phoca Forum

Hello,
After updating Joomla from 2.5.5 to 3.3 Phoca Download gives the following message: Table 'XXX.wvas_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM wvas_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

I have read the documentation and forum articles and give it a try to change/repear it. But it did help me out. Lots of red messages in phpadmin and no effect. I'm not a php or database expert so i can fix the problem but i like to use Phoca's web apps and dont want to lose my data.

Is there an other solution to fix it? Help would be very appresiate!

Thx Wim

Hi Wim,

Is there an other solution to fix it? Help would be very appresiate!

Unfortunately there is no other solution. You need to create the missing database table manually.
See: https://www.phoca.cz/news/16-joomla/joom ... ase-column
IMPORTANT:

just run the SQL query which is set in installation file - but be aware, always backup your database before doing some changes there

Kind regards,
Benno

Thx Bonno
the making of the tables succed. I kept the script from the file you give me link to. But i had to make a change in the script because there where 2_ in it instead of 1 and that doesnt work.
CREATE TABLE IF NOT EXISTS `#__phocadownload_styles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) ......................................


But the next fase is that the webside now response with a blanc page only with powered with phoca.... do you have a clou how to fix that?

THX

SOLVED!

i just made a new menu item, after that it worked!

THX anyway

Well done!

Kind regards,
Benno