Invocation code not showing / Error 500

[King of Ads]

Hi guys,

I'm new to revive-adserver, but I'm excited about it, I did a successful installation on my local machine,  v4.1.3, tested with multi sites at localhost, everything working fine, i like it a lot!

Then when I went to upload on the live server, (it runs php 5.6, and I'm using HTTPS), installation in a subfolder was ok (https://mydomain.com/reviveadserver/), plugins were installed and enable. I can create advertisers, campaigns, websites and banners ... but I am not able to have the "invocation code" display: when I click the "invocation code" tab, it shows a blank tab, and the browser reports a 500 error (500 Internal Server Error). There is nothing on the logs and my host support says that it's nothing on their side. Pop-ups are allowed on my browser, and I can see the banner preview ok when editing the banner.

I did a google search, read various topics on this forum but after a entire day I'm exhausted. Does anyone had a similar issue in recent times?

Any comment will be very welcome guys, thank you a lot!

[andrewatfornax]

Alas, a 500 internal server error means exactly that - something went wrong internally with the server.

That could be a web server problem, or it could be that there was a fatal PHP error. Either way, the logs on the server (both webserver and PHP logs) are where you need to look. If there's nothing there, you may need to increase the logging level.

https://documentation.revive-adserver.com/display/DOCS/Revive+Adserver+Broken#ReviveAdserverBroken-HTTP500ErrorCode

[King of Ads]

Hi @andrewatfornax ,

When you said "increase logging level" something "clicked" to me: after reading this I found an option on the "php.ini" at server setup, where I can enable debug to front-end. I did it and in fact it gave me a message (user/domain edited by me):

 Fatal error: Call to a member function getZoneForInvocationForm() on boolean in /home/USERNAME/DOMAIN.COM/adserver/www/admin/zone-invocation.php on line 58

Line 58 I put here below with underline. Is "$zoneid" being a boolean for some reason? What could be causing that? Unfortunately I don't see where to go from here.

/*-------------------------------------------------------*/
/* Main code                                             */
/*-------------------------------------------------------*/

$dalZones = OA_Dal::factoryDAL('zones');
if ($zone = $dalZones->getZoneForInvocationForm($zoneid)) {
    $extra = array('affiliateid' => $affiliateid,
                   'zoneid' => $zoneid,
                   'width' => $zone['width'],
                   'height' => $zone['height'],
                   'delivery' => $zone['delivery'],
                   'website' => $zone['website']
    );
    // Ensure 3rd Party Click Tracking defaults to the preference for this agency
    if (!isset($thirdpartytrack)) {
        $thirdpartytrack = $GLOBALS['_MAX']['CONF']['delivery']['clicktracking'];
    }
    $maxInvocation = new MAX_Admin_Invocation();
    echo $maxInvocation->placeInvocationForm($extra, true);
}

 

[andrewatfornax]

I'd maybe double check all the plugins really are installed and enabled?

[King of Ads]

Yes the plugin part seems ok. But I did the double check just to make sure (uninstall/reinstall all / enable), no changes, same behavior.

Another symptom I can see is that when I click the left menu "campaigns" it shows a blank tab with just the title "Campaigns of..." . The php error in this case is the message:

Fatal error: Call to a member function getClientCampaigns() on boolean in /home/user/mydomain/adserver/www/admin/advertiser-campaigns.php on line 116

 

Edited May 4, 2018 by King of Ads

[King of Ads]

More information, after re-reading this topic now:

 

I face a similar issue, see below my pc localhost installation (working fine) vs the webhost server installation (error). "Banners.php", "Campaigns.php", "Zones.php" are not present on the web server installation. (at folder  /lib/max/dal/admin/).

Also it's like they are not allowed on the server, any folder where I try to upload them, they are gone in seconds.

 

 

Edited May 4, 2018 by King of Ads

[King of Ads]

Hi guys,

Good news, I believe I was able to overcome this issue. First let's say my host company didn't help at all, unfortunately I'm alone on this.

The problem: we will look at 3 files that when put on the server are being rejected (deleted in a matter of seconds or latter):

• yourdomain.com\adserver\lib\max\Dal\Admin\Campaigns.php
• yourdomain.com\adserver\lib\max\Dal\Admin\Banners.php
• yourdomain.com\adserver\lib\max\Dal\Admin\Zones.php

The solution: I removed the following lines of those files:

----------------------------------------------------------------------------------------------------------

CAMPAIGNS.PHP - remove it to enable campaign tab display

LINES 617/618

        $rsCampaigns = DBC::NewRecordSet($query);

        $aCampaigns = $rsCampaigns->getAll(array('campaignid', 'clientid', 'campaignname', 'status', 'priority', 'revenue'));

LINES 655/656

        $rsCampaigns = DBC::NewRecordSet($query);
        $aCampaigns = $rsCampaigns->getAll(array('campaignid', 'clientid', 'campaignname', 'status', 'priority', 'revenue'));

----------------------------------------------------------------------------------------------------------

BANNERS.PHP

I removed the entire function starting at line 301:

function getBannersCampaignsClients($filterMarketBanners = true)
    {
        $prefix = $this->getTablePrefix();
        $oDbh = OA_DB::singleton();
        $tableB  = $oDbh->quoteIdentifier($prefix.'banners',true);
        $tableC  = $oDbh->quoteIdentifier($prefix.'campaigns',true);
        $tableCl = $oDbh->quoteIdentifier($prefix.'clients',true);

        $query = "
            SELECT
                b.bannerid,
                b.campaignid,
                b.description,
                c.clientid,
                c.campaignname,
                cl.clientname
            FROM
                {$tableB} AS b,
                {$tableC} AS c,
                {$tableCl} AS cl
            WHERE
                c.campaignid=b.campaignid
                AND cl.clientid=c.clientid
        ";
        if ($filterMarketBanners) {
            $query .= " AND (b.ext_bannertype <> ". DBC::makeLiteral(DataObjects_Banners::BANNER_TYPE_MARKET) . " OR b.ext_bannertype IS NULL)";
        }
        
        return DBC::NewRecordSet($query);
    }

----------------------------------------------------------------------------------------------------------

ZONES.PHP

function _linkZonesToCampaign at LINE 449, remove this part:

           $rsCampZones = DBC::NewRecordSet($query);
            if (PEAR::isError($rsCampZones)) {
                return $rsCampZones;
            }
            $aCampZones = $rsCampZones->getAll();

 

----------------------------------------------------------------------------------------------------------

Everything seems to be working fine until now, I tested with an external call to banner and it shows ok. I'll post any updates here.

Thank God I make it work, I was almost giving up for a plan B. But now my question, are those lines/functions essential for the software? Do I have to keep something in mind because of doing that?

Thanks you guys for this very helpful forum here.

 

Edited May 5, 2018 by King of Ads

[andrewatfornax]

Hi @King of Ads,

As a general rule, I would say yes, most of the code is required. If you go changing things, then who know what will work or won't work.

I hate giving this advice, because it always seems a little lame and unhelpful, but honestly, if your hosting provider cannot give you a host where you can upload files and they files you put in place actually stay there, then you're wasting your money. There are plenty of other hosting companies out there who actually deliver the service that you pay for.

[King of Ads]

Hi Andrew,

You are totally right, I'll keep this in mind for the future. Here the answer I received from the hosting provider:

"This would appear to be an issue with the content you are adding. If the content is corrupt, it could be rejected by the server however, we do not have way to provide guidance on whether code or function is not able to be uploaded. You would want to consult a web developer for further assistance with getting your site code to function on our hosting server."

Well, luckily the adserver is delivering ok, geotargeting ok. I'll probably try to dig deeper into this issue as soon as I have more time, but for now I'll leave as it is. My demands are small scale so I'm not risking too much trouble for now.

The Revive is great, I'm enjoying working with it, it's simple and direct, very intuitive. Hopefully as I grow into this world of digital advertisement (I'm new to advertisement in general) I'll come back here to learn and share more with the community.

Thank you for taking time to follow the topics,

[King of Ads]

Hi guys,

Some updates to share here. As a final solution, now I have all the installation files working on the server. The issue seems to be the hosting provider blocking the words BannerCampaigns/rsCamp or something like that.

In summary, the solution for me was to rename some script terms as follows:

-----------------------------------------------------------

EDIT THIS FILES:
adserver/lib/max/Dal/Admin/Banners.php
adserver/www/admin/maintenance-acl-check.php

REPLACE "getBannersCampaignsClients"
WITH    "getBannersXampaignsClients"

-----------------------------------------------------------

EDIT THIS FILES:
adserver/etc/changes/StatMigration.php
adserver/lib/max/Dal/Admin/Campaigns.php
adserver/lib/max/Dal/Admin/Zones.php
adserver/www/admin/admin-search.php

REPLACE "$rsCamp"
WITH    "$rsXamp"

-----------------------------------------------------------

[nothan]

Thanks mate. you saved my day

[King of Ads]

How funny is it that after so much time I needed to start another fresh install (not update/upgrade), using the current 5.0.5 and come into the same issue. What a shame to lose 1 hour just to find my own answer! =D

At least it still works thank God!

Edited August 11, 2020 by King of Ads