Error 1054
Posted: 14 Apr 2018, 14:38
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
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