database error in ads

In all transfered Ads you get a Database Error if you open the Ad (View Page).

SELECT * FROM `bx_ads_main_media` WHERE `MediaID` =

to fix this problem open:

BxAdsDb.php

REPLACE:

function getMediaInfo($iMedId) {
$sMediaSQL = "SELECT * FROM `{$this->_oConfig->sSQLPostsMediaTable}` WHERE `MediaID` = {$iMedId}";
return $this->getRow($sMediaSQL);
}

WITH:

function getMediaInfo($iMedId) {
$sMediaSQL = "SELECT * FROM `{$this->_oConfig->sSQLPostsMediaTable}` WHERE `MediaID` = '{$iMedId}'";
return $this->getRow($sMediaSQL);
}

regard

Quote · 13 Nov 2009

I try this but I don't see no diferents in the code the two codes are the same

Post Reply - if you going to help - No for - bla bla bla bla
Quote · 21 Aug 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.