Error 1054

[David789]

Hi
I admit I am not a webmaster wizard. However I have had Phoca Gallery working in the past although not exactly as I would have liked.
I am looking at having several parent categories (years for instance) and the sub categories underthose (dates). so on the first page of images I wanted to display the years with a photo from that year. click on that photo and it take you to all the subcategories for that year. Then I would also like to be able to download the full resolution image that has been uploaded as well as the thumbnails on the page and a medium size for slide show.
I had this working at one stage when I only had the one parent category However I was never able to download the full image size only the medium version of it.
Anyway I tried to add another year parent category with the folder 2018 with the one photo in that folder to display for the category and I could not get it to save the category it kept coming up with the error 1054 Unknown column 'pcproductid' in 'field list'
I have now deleted all the images and categories and trying to start from scratch of course the full size images are still in the folder images/phocagallery/2017 ect

Could I please have some guidance on how to set Phoco Gallery to work without this error and to achieve my objectives. Thank you very much for your help best regards David

I am running the latest version of Phoca gallery 4.3.10
PHP Built On Linux cp442.ezyreg.com 2.6.32-673.8.1.lve1.4.3.1.el6.x86_64 #1 SMP Thu May 5 16:06:47 EDT 2016 x86_64
Database Type mysql
Database Version 5.6.38
Database Collation latin1_swedish_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.33
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.8.6 Stable [ Amani ] 13-March-2018 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:59.0) Gecko/20100101 Firefox/59.0

[Benno]

Hi,
Backup your database first and then this query should be run in your database (e.g. per phpMyAdmin, #__ should be changed to your database prefix):

Code: Select all

ALTER TABLE `#__phocagallery` ADD COLUMN `pcproductid` int(11) NOT NULL DEFAULT '0';

See: viewtopic.php?t=58551

Kind regards,
Benno

[David789]

Thanks I was "just" able to manage that change with some doubt as to what I was doing. I read the other topic although I put the new column at the end as that was easier for me to work out as there was an add button. Setting the INT to 11 was not to hard to intuitively work out but the Not None Default was a real guess as my PHPADMIN may have looked different to others in the end I set this to none and it worked.
Now on to trying to get some of the other options setup as I would like them.
The downloading the full size image what has to be set to get that working?

[Benno]

You're welcome!

Kind regards,
Benno