sonnb - XenGallery (XenForo Gallery) [Deleted]

Got this error , any thoughts?
An exception occurred: Mysqli prepare error: Unknown column 'album.cover_content_id' in 'where clause' in /var/www/vhosts/ionian-island.co.uk/httpdocs/forums/library/Zend/Db/Statement/Mysqli.php on line 77

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
  5. XenForo_Model->fetchAllKeyed() in sonnb/XenGallery/Model/Album.php at line 168
  6. sonnb_XenGallery_Model_Album->getAlbums() in sonnb/XenGallery/WidgetRenderer/Album.php at line 244
  7. sonnb_XenGallery_WidgetRenderer_Album->_render() in WidgetFramework/WidgetRenderer.php at line 637
  8. WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 338
  9. WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 293
  10. WidgetFramework_Core->renderWidgetsForHook() in WidgetFramework/Listener.php at line 77
  11. WidgetFramework_Listener::template_hook()
  12. call_user_func_array() in XenForo/CodeEvent.php at line 58
  13. XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 285
  14. XenForo_Template_Abstract->callTemplateHook() in XenForo/Template/Abstract.php(265) : eval()'d code at line 131
  15. eval() in XenForo/Template/Abstract.php at line 265
  16. XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
  17. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
  18. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
  19. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 604
  20. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  21. XenForo_FrontController->run() in /var/www/vhosts/ionian-island.co.uk/httpdocs/forums/index.php at line 13
 
Got this error , any thoughts?
An exception occurred: Mysqli prepare error: Unknown column 'album.cover_content_id' in 'where clause' in /var/www/vhosts/ionian-island.co.uk/httpdocs/forums/library/Zend/Db/Statement/Mysqli.php on line 77

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
  5. XenForo_Model->fetchAllKeyed() in sonnb/XenGallery/Model/Album.php at line 168
  6. sonnb_XenGallery_Model_Album->getAlbums() in sonnb/XenGallery/WidgetRenderer/Album.php at line 244
  7. sonnb_XenGallery_WidgetRenderer_Album->_render() in WidgetFramework/WidgetRenderer.php at line 637
  8. WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 338
  9. WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 293
  10. WidgetFramework_Core->renderWidgetsForHook() in WidgetFramework/Listener.php at line 77
  11. WidgetFramework_Listener::template_hook()
  12. call_user_func_array() in XenForo/CodeEvent.php at line 58
  13. XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 285
  14. XenForo_Template_Abstract->callTemplateHook() in XenForo/Template/Abstract.php(265) : eval()'d code at line 131
  15. eval() in XenForo/Template/Abstract.php at line 265
  16. XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
  17. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
  18. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
  19. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 604
  20. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
  21. XenForo_FrontController->run() in /var/www/vhosts/ionian-island.co.uk/httpdocs/forums/index.php at line 13
You upgraded from an older version? Did you get errors while upgrading? It indicates that cover_content_id was failed to be added to album table.
 
Yes older version not syre which one, any easy way i can fix it without rollibg back to yesterdays back up?
No erros whilst uploading file
 
Yes older version not syre which one, any easy way i can fix it without rollibg back to yesterdays back up?
Please start a conversation with me and send me your current XenGallery's tables structure. I need to know current structure before give your exactly answer.
 
Why are the video thumbnails that were imported from XenMedio so small compared to videos added directly to XenGallery?

Can we resize them so that they are the default size?
 
  • Like
Reactions: rdn
Why are the video thumbnails that were imported from XenMedio so small compared to videos added directly to XenGallery?

Can we resize them so that they are the default size?
Because that is how thumbnails were generated in XenMedio, we cannot just enlarge them.
 
sonnb updated sonnb - XenGallery (XenForo Gallery) with a new update entry:

Added sort in album view, privacy setting on uploading, new option for widget, bug fixing.

- Added a new option "Hide Author Information" for album/content/photo/video widget. This will hide author and counter information, only title is visible.
- Added privacy settings for new photos/videos in album's edit page, add photos page and add videos pages. This will help users to bulk set privacy for newly added photos.
- Added content sort to album view. Sorting is now being saved to cookie, this helps users to use the gallery as the way they sort it.
- Minor changes and bug fixes.

Read the rest of this update entry...
 
Thanks for fixing the title bug and heavily requested individual photo and video privacy during album creation.
 
Hi @sonnb
Not sure why but when when i embed YouTube videos now, its not pulling the thumb image at all.

Screen Shot 2014-01-13 at 23.54.52.webp

In the past it used to work fine, I'm not sure at what update this broke at as i have not added any videos for a bit before today.

Screen Shot 2014-01-13 at 23.55.37.webp
 
Back
Top Bottom