Database error query in ads...

HI all

   when it have a ads with more than 1 words, we got a database error query...

SELECT * FROM `bx_ads_main_media` WHERE `MediaID` = 

Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Found error in the file '/var/www/vhosts/xxxxxxxx-xxxx.com/httpdocs/v2/modules/boonex/ads/classes/BxAdsDb.php' at line 136.
Called 'getRow' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /var/www/vhosts/xxxxxxxxx.com/httpdocs/v2/inc/classes/BxDolDb.php
            [line] => 236
            [function] => error
            [class] => BxDolDb
            [object] => BxAdsDb Object

in regard

Hello!

Possible something with URI generation. Plz try to create the same ads in our demozzz.com/dolphin7b site.

Regard

 ok, will do, forgot th mention, that was imported ads from the migration scripts

popy

Interesting,

I have several ads, with different text and with images and without.

All they was transfered successfully (and with images and without)

and I don`t see any errors during browsing through ads

Your current log is incomplete,

before

ads/classes/BxAdsDb.php' at line 136.

you should have something about BxAdsModule.php with line number.

If you want - you always can give me your ftp access (PM only)

 ok after looking at the problems, the new ads working fine, it's the imported ads that cause the problems....

popy