[fixed] Gallery images sql error

atleg · New Poster Offline Joined: Jan 18, 2009 Posts: 2

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?

Phoenix · Posted: Mon Feb 15, 2010 6:59 pm Post subject: Re: Gallery images sql error

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.

atleg · New Poster Offline Joined: Jan 18, 2009 Posts: 2

That was better! Thanks!