Hello,
We manage a few different Revive AdServer instances (all v3.0.2), but on one of them I have been noticing some pretty frequent errors. NOTE, all were previous OpenX upgrades.
As far as I can tell, everything appears to be working as expected, but our logs are catching MySQL errors from delivery/spc.php
The error is due to invalid SQL syntax, resulting from an empty trafficker_account_id:
$aZoneInfo['trafficker_account_id'] // trafficker_account_id does not exist!
Here is a snippet of the failing SQL:
SELECT
'default_banner_destination_url_trafficker' AS item,
apa.value AS value
FROM
`ox_account_preference_assoc` AS apa
WHERE
apa.account_id =
AND
apa.preference_id = 2
UNION
SELECT
'default_banner_destination_url_manager' AS item,
apa.value AS value
FROM
`ox_account_preference_assoc` AS apa
WHERE
apa.account_id =
AND
apa.preference_id = 2
UNION
SELECT
...
Link to the full script on GitHub: https://github.com/revive-adserver/revive-adserver/blob/master/www/delivery/spc.php#L740
Does anyone have any insight into why this trafficker_account_id would not be populated? I would imagine it's mostly likely an issue with our configuration or banner / zone setup, and not related to the migration to Revive.
Any recommendations on what I could check to help correct these errors would be appreciated.
Regards,
- Mike