Square Wheels

Hi,
No, nothing custom.  Yes, you need to manually add the thumbnail.  It looks a lot worse without it.
Here are my settings.

 

@Daniel F solved this.
He determined I needed to turn off STRICT_TRANS_TABLES in MySQL.  Once I did, I was able to create the block.
Thank you

ACP --> Login & Registration --> Registration --> Validation method for new accounts --> Email and administrator validation
The user will be sent an email containing a special link they have to click to validate their account after which an administrator will need to manually approve the account from the Admin Control Panel.

Here are some that I partially wrote and others helped me with.
Two options, first shows all posts, last one removes hidden posts.
Set n (999999) to be one less that the record you are looking for
SELECT
    *
FROM
    forums_posts
ORDER BY
    pid
LIMIT 1 OFFSET 999999;
https://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table/16606
---
Does not show hidden posts.  This is what matches the Forum Statistics block.
SELECT (SELECT COUNT(1) FROM `forums_posts` WHERE `queued` = 0) + (SELECT COUNT(1) FROM    `forums_archive_posts` WHERE archive_queued = 0) AS `PostCount`
---
As long as the archive table is empty, this works.
SELECT
    *
FROM
    forums_posts
WHERE `queued` = 0
ORDER BY
    pid
LIMIT 1 OFFSET 999999;

Thanks @Marc Stridgen.  Since this is intermittent, and only reported from one user, I won't pursue trying to fix this.

From my ACP.
My members see it.

Ad blocker?