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

FAQ

Moderators

Forum Index > Community > Newsletters

[fixed] Gallery images sql error Reply to topic

atleg

Offline
Joined: Jan 18, 2009
Posts: 2

0 👍 / 0 👎

Sun Feb 14, 2010 4:11 am

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! 😢

Phoenix

Offline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere

0 👍 / 0 👎

Mon Feb 15, 2010 6:29 pm

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):

atleg

Offline
Joined: Jan 18, 2009
Posts: 2

0 👍 / 0 👎

Thu Feb 18, 2010 2:08 pm

That was better! Thanks!

Please enter your server specs in your user profile! 😢

All times are Australia/Adelaide

Post new topic Reply to topic Forum Index > Community > Newsletters
Page 1 of 1