Gallery

Gallery 1.1.2

No permission to download
Overview FAQ Updates (4) Reviews (2) History Discussion
M

Mike2020

Well-known member
Mike2020 submitted a new resource:

Gallery - A image and video gallery system for xenforo

Welcome to a fully featured free gallery addon.
With this gallery you will be able to upload images and videos from your computer and from some of the most used websites like, youtube, dailymotion, vimeo, facebook and metacafe.

Your users will be able to rate, like and watch the media that's uploaded.
They will also be able to watch categories and get alerts by email or the xenforo's alert system.

This add-on uses ffmpeg to convert video's to mp4 format but dont worry if you dont have...
Click to expand...

Read more about this resource...
 
Well, the install and configure thats ok. But when i want view a picture in my gallery appear this server error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

  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 Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
  6. gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
  7. gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
  8. gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
  9. gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /var/www/xxxxxxxx.com.br/onlyfortest/index.php at line 13
 
Ricardo Moura said:
Well, the install and configure thats ok. But when i want view a picture in my gallery appear this server error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

  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 Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
  6. gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
  7. gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
  8. gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
  9. gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /var/www/xxxxxxxx.com.br/onlyfortest/index.php at line 13
Click to expand...
has the title of the image or the category got ' in them
 
Ricardo Moura said:
Well, the install and configure thats ok. But when i want view a picture in my gallery appear this server error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

  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 Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
  6. gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
  7. gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
  8. gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
  9. gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /var/www/xxxxxxxx.com.br/onlyfortest/index.php at line 13
Click to expand...
has this gone away for you now since the update
 
Hi all

Just wanted to update you on whats coming next.
In the next version i will be adding in a friends system where you will be able to add users as friends and only show content to them.

Have already added the add friend to profile over lay
Sorted out add friend
Reject friend and except friend

Just need to work on the limiting media to friends only or public
 
Here are the images of whats to come in next release

Its in testing before its released
 

Attachments

  • addfriend.webp
    addfriend.webp
    13 KB · Views: 17
  • exceptrejectfriend.webp
    exceptrejectfriend.webp
    13.4 KB · Views: 16
  • friendsalerts.webp
    friendsalerts.webp
    13.6 KB · Views: 15
  • friendslist.webp
    friendslist.webp
    24.2 KB · Views: 15
Facing some issues with addon :)

Using php version 5.6.21
Plugin Version : 1.0.5a
XenForo : 1.5.7

Code: 
ErrorException: Undefined index: - library/XenForo/Visitor.php:678
Generated By: admin, 4 minutes ago
Stack Trace
#0 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/Visitor.php(678): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/vhosts...', 678, Array)
#1 /var/www/vhosts/xen-demo/httpdocs/library/gallery/ControllerPublic/index.php(30): XenForo_Visitor->offsetGet(NULL)
#2 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/FrontController.php(351): gallery_ControllerPublic_index->actionIndex()
#3 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /var/www/vhosts/xen-demo/httpdocs/index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
  ["url"] => string(30) "http://xen-demo/gallery/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}


Code: 
Error Info
ErrorException: Undefined index: id - library/gallery/Model/gallery.php:2176
Generated By: admin, 5 minutes ago
Stack Trace
#0 /var/www/vhosts/xxxx/httpdocs/library/gallery/Model/gallery.php(2176): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/vhosts...', 2176, Array)
#1 /var/www/vhosts/xxxxx/httpdocs/library/gallery/ControllerPublic/index.php(276): gallery_Model_gallery->sendNotificationToCategoryWatchUsersOnReply(0, Array, Array)
#2 /var/www/vhosts/xxxxx/httpdocs/library/XenForo/FrontController.php(351): gallery_ControllerPublic_index->actionDouploadfile()
#3 /var/www/vhosts/xxxxx/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /var/www/vhosts/xxxxx/httpdocs/index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
  ["url"] => string(42) "http://xxxxx/gallery/douploadfile"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["_xfToken"] => string(8) "********"
    ["maxuploadsize"] => string(7) "2097152"
    ["phpmaxuploadsize"] => string(2) "2M"
    ["imagetype"] => string(1) "0"
    ["photonameurl"] => string(0) ""
    ["videonameurl"] => string(0) ""
    ["filetitle"] => string(11) "DEmo upload"
    ["description"] => string(41) "Dont know what to say, its just an eye :P"
    ["agerestrict"] => string(1) "0"
  }
}


Also i uploaded the image in a test category and the media is being shown in my media tab but is not available in gallery.

Screenshot
Screenshot_2.webp Screenshot_3.webp
 
JustinHawk said:
Facing some issues with addon :)

Using php version 5.6.21
Plugin Version : 1.0.5a
XenForo : 1.5.7

Code: 
ErrorException: Undefined index: - library/XenForo/Visitor.php:678
Generated By: admin, 4 minutes ago
Stack Trace
#0 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/Visitor.php(678): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/vhosts...', 678, Array)
#1 /var/www/vhosts/xen-demo/httpdocs/library/gallery/ControllerPublic/index.php(30): XenForo_Visitor->offsetGet(NULL)
#2 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/FrontController.php(351): gallery_ControllerPublic_index->actionIndex()
#3 /var/www/vhosts/xen-demo/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /var/www/vhosts/xen-demo/httpdocs/index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
  ["url"] => string(30) "http://xen-demo/gallery/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}


Code: 
Error Info
ErrorException: Undefined index: id - library/gallery/Model/gallery.php:2176
Generated By: admin, 5 minutes ago
Stack Trace
#0 /var/www/vhosts/xxxx/httpdocs/library/gallery/Model/gallery.php(2176): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/vhosts...', 2176, Array)
#1 /var/www/vhosts/xxxxx/httpdocs/library/gallery/ControllerPublic/index.php(276): gallery_Model_gallery->sendNotificationToCategoryWatchUsersOnReply(0, Array, Array)
#2 /var/www/vhosts/xxxxx/httpdocs/library/XenForo/FrontController.php(351): gallery_ControllerPublic_index->actionDouploadfile()
#3 /var/www/vhosts/xxxxx/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#4 /var/www/vhosts/xxxxx/httpdocs/index.php(13): XenForo_FrontController->run()
#5 {main}
Request State
array(3) {
  ["url"] => string(42) "http://xxxxx/gallery/douploadfile"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["_xfToken"] => string(8) "********"
    ["maxuploadsize"] => string(7) "2097152"
    ["phpmaxuploadsize"] => string(2) "2M"
    ["imagetype"] => string(1) "0"
    ["photonameurl"] => string(0) ""
    ["videonameurl"] => string(0) ""
    ["filetitle"] => string(11) "DEmo upload"
    ["description"] => string(41) "Dont know what to say, its just an eye :P"
    ["agerestrict"] => string(1) "0"
  }
}


Also i uploaded the image in a test category and the media is being shown in my media tab but is not available in gallery.

Screenshot
View attachment 134970 View attachment 134971
Click to expand...
check in admin cp if the media is in the un-approved list.

If this is the case you need to change the usergroup options for admins and set this Moderate New Media Added: to no and yes to groups you want to approve media from.
I will look into these errors for you and let you know what i find
 
Mike2020 said:
but change this to Moderate New Media Added: Never as it needs to be set
Click to expand...
it set it to never for admin

also faced this issue viewing media from sidebar :(

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/xen-demo./httpdocs/index.php at line 13
 
JustinHawk said:
it set it to never for admin

also faced this issue viewing media from sidebar :(

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/xen-demo./httpdocs/index.php at line 13
Click to expand...
am looking into this for you
 
JustinHawk said:
it set it to never for admin

also faced this issue viewing media from sidebar :(

Code: 
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE title = ?' at line 6

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in gallery/Model/gallery.php at line 257
gallery_Model_gallery->getSubCategoryByNodeName() in gallery/Model/gallery.php at line 160
gallery_Model_gallery->getCategoryOrError() in gallery/Model/gallery.php at line 149
gallery_Model_gallery->assertCategoryValidAndViewable() in gallery/ControllerPublic/index.php at line 730
gallery_ControllerPublic_index->actionMedia() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/vhosts/xen-demo./httpdocs/index.php at line 13
Click to expand...
what version you using the one here or the one i sent you by email.
 
You must log in or register to reply here.

Similar threads

FoP
  • Solved
XF 2.2 Mirrored media gallery and permissions
Replies
2
Views
31
FoP
FoP
K
Embedded gallery media images do not load lazily
Replies
0
Views
33
Kirby
K
StryGuardian
Media gallery YouTube embeds pull generic info
Replies
0
Views
52
StryGuardian
StryGuardian
O
  • Suggestion Suggestion
Implemented Add tags to media items
Replies
4
Views
55
Old Nick
O
david.steadson
  • Question Question
MG 2.3 How to insert media gallery images in posts?
Replies
1
Views
28
david.steadson
david.steadson
Back
Top Bottom