Is there an other way?

[wgschol]

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

[Benno]

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

[wgschol]

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

[wgschol]

SOLVED!

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

THX anyway

[Benno]

Well done!

Kind regards,
Benno