[Discuss] SMF Gallery Block for SMF2

[vbgamer45]

hello,
does anybody support this mod now?

it was working until I updated SMF (from 2.0.13 to 2.0.14),
after that I've got error message instead of picture:
MySQL error:Access denied for user ''@'localhost' (using password: NO)

I`m using SMF Gallery Random Picture-ver.1.7.1 and SMF Gallery LITE 6.0

If you are using this block code use the updated on for SMF 2.0 at
https://www.tinyportal.net/index.php?topic=32358.msg278635#msg278635

[VladTepes]

hello,
does anybody support this mod now?

it was working until I updated SMF (from 2.0.13 to 2.0.14),
after that I've got error message instead of picture:
MySQL error:Access denied for user ''@'localhost' (using password: NO)

I`m using SMF Gallery Random Picture-ver.1.7.1 and SMF Gallery LITE 6.0

While it's unlikely to be this, if the rest of your forum is working - make sure that your server is using the appropriate version of PHP - for SMF 2.0.14 it needs to be 5.4 or higher.

[Ramzesito]

If you are using this block code use the updated on for SMF 2.0 at
https://www.tinyportal.net/index.php?topic=32358.msg278635#msg278635

thank you, this update is working!)

[Oldiesmann]

Is there an updated version of this? I tried it in SMF 2.1 and it didn't work because tp_query() wasn't defined. However, it also includes several calls to mysql_ functions which won't work anymore either.

[lurkalot]

Is there an updated version of this? I tried it in SMF 2.1 and it didn't work because tp_query() wasn't defined. However, it also includes several calls to mysql_ functions which won't work anymore either.

Think the latest modified one is here, uses $smcFunc;

https://www.tinyportal.net/index.php?topic=32358.msg277437#msg277437

[Oldiesmann]

Is there an updated version of this? I tried it in SMF 2.1 and it didn't work because tp_query() wasn't defined. However, it also includes several calls to mysql_ functions which won't work anymore either.

Think the latest modified one is here, uses $smcFunc;

https://www.tinyportal.net/index.php?topic=32358.msg277437#msg277437

That one worked, but I had to edit Subs-Db-Mysql.php to remove "ONLY_FULL_GROUP_BY" from the SQL modes list (otherwise it was throwing an error about id_picture not being in the GROUP BY clause - easier to just leave the query as is instead of adding each column it complains about or figure out how to rewrite the query...)

[lurkalot]

Is there an updated version of this? I tried it in SMF 2.1 and it didn't work because tp_query() wasn't defined. However, it also includes several calls to mysql_ functions which won't work anymore either.

Think the latest modified one is here, uses $smcFunc;

https://www.tinyportal.net/index.php?topic=32358.msg277437#msg277437

That one worked, but I had to edit Subs-Db-Mysql.php to remove "ONLY_FULL_GROUP_BY" from the SQL modes list (otherwise it was throwing an error about id_picture not being in the GROUP BY clause - easier to just leave the query as is instead of adding each column it complains about or figure out how to rewrite the query...)

Glad you got something out of it at least.   

Unfortunately quite a few of the block codes need updating as they are very old. we don't have anyone working on these atm.