1054 Unknown column 'access'

[jakcrabbit]

Hi, I cant regenerate thumbs and any edit items, cause:

Code: Select all

1054 Unknown column 'access' in 'field list' SQL=UPDATE `w21yu_phocagallery` SET `catid`='391',`sid`='0',`title`='01',`alias`='01',`filename`='01.jpg',`format`='0',`date`='2014-05-01 16:23:57',`hits`='0',`latitude`='',`longitude`='',`zoom`='0',`geotitle`='',`userid`='0',`vmproductid`='0',`imgorigsize`='32050',`published`='1',`approved`='1',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='26',`extid`='',`exttype`='0',`extl`='',`extm`='',`exts`='',`exto`='',`extw`='',`exth`='',`language`='*',`access`='1' WHERE `id`='6458'

How to fix it?

Thx, Jan

[Benno]

HI,
see: https://www.phoca.cz/documents/16-joomla ... ase-column

Kind regards,
Benno

[jakcrabbit]

Hi, thx for reply. Problem is, column access isnt in last version in table phocagallery....

I upgraded from joomla 1.5 to 3.3 with upgrading manual.

[jakcrabbit]

Fixed by adding: `access` tinyint(3) unsigned NOT NULL DEFAULT '0', to table phocagallery.... ufff

[Benno]

Ok. solved.

Kind regards,
Benno