| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 7 online users.
» 0 Member(s) | 6 Guest(s)
Facebook
|
|
|
| MyGallery: a responsive image gallery for MyBB |
|
Posted by: Laird - 2022-02-07, 12:47 PM - Forum: MyGallery
- Replies (2)
|
 |
MyGallery is a responsive image gallery plugin for MyBB. I put it together at the request of a paying client. My client has requested that I do not sell it to anybody else, and because I am honouring that request, this page is now only a showcase, and not an offer of sale.
This plugin has been, and continues to be, battle-tested by my client on a high-traffic board with many thousands of gallery images.
Features:- Multi-gallery support.
- Authorised admins can create/edit galleries and their settings in the ACP at Configuration » Gallery Management.
- A unique, customisable codename for each gallery, for user-friendly URLs.
- A (bare-bones) page listing all galleries the member is authorised to view, at galleries.php.
- Galleries are paginated at 12 images per page. Each gallery is visible at gallery.php?codename=[codename] (see, e.g., this board's default gallery at gallery.php?codename=default).
- The special codename "main" shows images from all (authorised/blurred) galleries.
- Responsive design (to best test the responsive design, select the Roundo Light theme bottom-of-page).
- Individual image pages to which comments may be posted by members of authorised usergroups. Support for editing and deleting of comments by both the member who posted them and by admins.
- Optional pop-up of gallery images using the Highslide library on clicking an image, otherwise, clicking an image leads to its comments page (this setting is a per-gallery toggle).
- Three separate per-gallery settings to authorise members of particular usergroups (including Guests) to:
- Post images.
- Post comments.
- View images.
- Images may be deleted by both the member who posted them and by admins.
- A per-gallery setting to either show blurred images to those lacking permission, or simply to display an error message.
- Optional automatic watermarking of uploaded gallery images via your supplied per-gallery watermark image, with support for choice of vertical location of watermark on image upload: top, middle, or bottom.
- Support for a per-gallery set of categories, and for filtering the gallery by categories.
- Support for image titles and optional captions.
- The count of images uploaded by the member is shown on member profiles, with a "Show all" link to show all images posted by that member in all galleries authorised for viewing by the viewing member.
- One or more auto-import forums can be specified per gallery. When a new thread is posted in one of those forums (so long as the forum wasn't also specified in an earlier gallery), all images (enclosed in `img` MyCode tags) in the first post in that thread (if any) are auto-imported into the gallery, unless the posting member unchecks the "Import Image" checkbox (to test this feature on this board for the default gallery, post a new thread in the Sandbox forum).
- When an imported thread contains multiple images, only the first is shown in the gallery view, but with an icon showing the count of images. Clicking on that icon leads to the image (+comments) page which shows the first image full size, with thumbnails for the remaining images - see, e.g., here. Clicking on a thumbnail pops up the full-sized image in the Highslide viewer.
- An admin tool to auto-import all images that haven't yet been imported in the stipulated forum(s).
- Auto-categorisation of auto-imported images: if any words in the title of the thread from which the image is imported match (case-sensitively) a predefined category, then the image is categorised according to that category.
- A domain blacklist to prevent images from matching domains from being auto-imported.
- A per-gallery setting for imported images to show, as gallery image comments, posts from the imported thread, plus a setting in this scenario to hide the first post.
- Support for "liking" images, optionally (per-gallery) integrating with the Thank You/Like System plugin (TYL) for images imported from threads, so that the image uses the TYL likes on the first post of the thread.
- Fully templated plus it comes with its own stylesheet, so its look and feel can be customised via the ACP.
- Support for custom, per-gallery templates.
- A sensibly designed breadcrumb system which shows when filtering by category and/or posting member.
![[Image: mygallery-image-page-with-comments-scree...-02-07.png]](https://creativeandcritical.net/mybb/images/mygallery-image-page-with-comments-screenshot-2022-02-07.png)
Current limitations:- Animation in GIFs is not supported when watermarking and when generating thumbnails: those GIFs become static.
- No listing of categories on each gallery page from which to choose to filter by; can only filter by clicking on the category of an existing image.
- Alerts and email notifications not supported, neither for (1) notification of new images posted to a gallery, nor (2) notification of new comments on a gallery image, nor for any other event.
- Etc.
|
|
|
| An error with Conversations |
|
Posted by: birdfeedr - 2021-10-20, 10:26 AM - Forum: MyConversations
- Replies (12)
|
|
db is MySQLi, maybe other variables apply, but this is my current SQL Mode setting
sql mode ![[Image: dot.gif]](https://cpanel.ho-lee-fooks.com/cpsess2600878778/3rdparty/phpMyAdmin/themes/dot.gif)
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Since I am not a database wizard, I am not sure of the pros/cons of ONLY_FULL_GROUP_BY directive.
I'd appreciate your scrutiny and suggestion for resolution.
Larry
Code: Your copy of MyBB has experienced an error. Details of the error include:
---
Type: 20
File: (Line no. 0)
Message
SQL Error: 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1
Back Trace: #0 errorHandler->email_error(20, SQL Error: 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1, , 0) called at [/home/hlf/public_html/forum/inc/class_error.php:195]
#1 errorHandler->error(20, Array ([error_no] => 1055,[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,[query] =>
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1)) called at [/home/hlf/public_html/forum/inc/db_mysqli.php:597]
#2 DB_MySQLi->error(
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1) called at [/home/hlf/public_html/forum/inc/db_mysqli.php:337]
#3 DB_MySQLi->query(
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1) called at [/home/hlf/public_html/forum/inc/plugins/converse/converse-pm-datahandler-override.php:149]
#4 PMDataHandler->insert_pm() called at [/home/hlf/public_html/forum/inc/functions.php:8816]
#5 send_pm(Array ([subject] => New Reply to 6 years ago,[message] => dingo,
WiMStang has just replied to a thread which you have subscribed to. This thread is titled 6 years ago.
|
|
|
|
| MyConversations: releases and other announcements |
|
Posted by: Laird - 2020-06-06, 09:05 AM - Forum: MyConversations
- Replies (13)
|
|
MyConversations is a conversation plugin for MyBB. Information about this plugin can be read on its current homepage, MyConversations: a conversation plugin for MyBB.
This thread is for release and other announcements regarding MyConversations.
MyConversations is installed on this forum, and you are welcome to create a free account (or two or three) with which to test it. To facilitate testing of conversations with multiple participants, you may use the same registration email address for multiple accounts.
Four test accounts have been set up to be included in any test conversations/groups that you want to start: Willow, Xavier, Yasmine, and Zane. Be aware though that I will be the ultimate recipient of any messages you send those accounts, so don't write anything that you don't want me to see.
Due to the nature of this thread, it is closed to replies from anyone but me. If you wish to ask questions, report bugs, offer suggestions, criticise, or otherwise discuss this plugin, then please create a new thread in this forum for your topic.
|
|
|
|
|
![[Image: mygallery-screenshot-2022-02-07.png]](https://creativeandcritical.net/mybb/images/mygallery-screenshot-2022-02-07.png)