Phoca Forum

Posted: **09 Feb 2015, 11:21**

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

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

Posted: **09 Feb 2015, 11:27**

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

Kind regards,
Benno

Posted: **09 Feb 2015, 13:14**

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.

Posted: **09 Feb 2015, 13:31**

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

Posted: **09 Feb 2015, 22:19**

Ok. solved.

Kind regards,
Benno

Phoca Forum

1054 Unknown column 'access'

1054 Unknown column 'access'

Re: 1054 Unknown column 'access'

Re: 1054 Unknown column 'access'

Re: 1054 Unknown column 'access'

Re: 1054 Unknown column 'access'