DragonflyCMS Projects > Newsletters > [fixed] Gallery images sql error > Community Forums > Phoenix Netology
Forum Index > Community > Newsletters

[fixed] Gallery images sql error Reply to topic


I'm trying to send a Newsletter with images from Photo Gallery, but none show up in the preview.
I get this message at the bottom :
includes/db/mysqli.php
Warning line 103: mysqli_result::close() [mysqli-result.close]: Couldn't fetch mysqli_result

Doesnt matter if I select x last pictures or set a "from-date".
Have also tried changing the settings under Config - Photo Gallery, but no dice....

Whats wrong?

Please enter your server specs in your user profile! 😢


Found the problem - the gallery queries were based on an older version of CPG and were looking for images where the approved field equals YES - should have been approved field equals 1.

Extract the 2 files from the attached zip and upload to your modules/Newsletters/functions/ directory.
Attachment: updates.zip
Description
Filename updates.zip
Filesize 17.57 KiB
Downloaded 2 Time(s)
You are not allowed to view/download this attachment

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


That was better! Thanks! Smile

Please enter your server specs in your user profile! 😢

All times are Australia/Adelaide


Jump to: