OpenX 2.3 Forum RSS

External Javascript Banners And Click Counter Problem

Tue, 24 Nov 2009 08:44:09 +0000

Hi all,

for first sorry for my english.

I'm trying to add an external javascript banner but when I check the statistics the click counter doesn't work.

I can see the views but not the clicks (always 0).

I've added this banner as HTML banner and I've checked "Alter HTML to enable tracking of Clicks" but still doesn't work.

Any suggestions?

Tnx in advance.

Impressions And Conversions Are Not Getting Recorded

Tue, 24 Nov 2009 07:27:13 +0000

I just found out that our local Ad server stopped recording impressions for last couple of weeks. Further investigated I found out that its not recording conversions either. I tried to run maintainance script and it gave following error:

_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE MDB2_STATEMENT_mysql_d5e880e2cf799a08f2dba8ca535aff27 FROM '\n INSERT INTO\n `tmp_ad_required_impression`\n (\n ad_id,\n required_impressions\n )\n VALUES\n (?, ?)']
[Native code: 1146]
[Native message: Table 'tkadvert.tmp_ad_required_impression' doesn't exist]

I am using mysql and the dbuser has CREATE,UPDATE iNSERT AND DELETE rights.

pls help

Update: One thing I would like to mention that table ox_data_intermediate_ad is just recording clicks and value is 0 for impressions column.

Zone Chaining And Tracking

Tue, 24 Nov 2009 01:00:14 +0000

I have zone chaining working as follows:

Banners are linked to zone 1
Zone 2 has no banners linked to it
Zone 2 is chained to zone 1

When zone 2 is invoked using its invocation tags, banners from zone 1 are shown correctly. However, the impressions and clicks are tracked for zone 1 (where the banner is linked) instead of zone 2 (the zone called by the invocation tags).

What's the easiest/cleanest way to get the impressions and clicks tracked for the zone whose invocation tag is shown instead of the zone to which the banner is actually linked?

Thanks,

Alex

ETA: I'm using OpenX 2.8.2, the latest version.

Advertiser Video Report And Website Video Report Fail

Tue, 24 Nov 2009 00:36:59 +0000

Has anyone encountered problems in running the Advertiser Video and the Website Video Reports?

Both the Advertiser Video Report and the Website Video Report fail to either bring back results, or to raise an on-screen error. In each case, a blank page is returned.

The problem has been observed on both an in-house testing environment and a similarly configured remotely hosted production environment.

We are running OpenX 2.8.2 with the openXVideoAds1.1 plugin.

Open X is hosted under CentOS release 5.4 (Final), with the latest patches applied. We are running Apache 2.2.3 and PHP 5.1.6 with eAccelerator v0.9.5.3. The database is MySQL (Client API version: 5.0.77).

Please Note: Relevant configuration files and a more detailed description of the problem have been uploaded to the bug report section of this forum.

Any assistance is resolving this issue is most deeply appreciated.

Advertiser Video Report And Website Video Report Fail

Tue, 24 Nov 2009 00:23:58 +0000

We are running OpenX 2.8.2 with the openXVideoAds1.1 plugin.

Open X is hosted under CentOS release 5.4 (Final), with the latest patches applied. We are running Apache 2.2.3 and PHP 5.1.6 with eAccelerator v0.9.5.3. The database is MySQL (Client API version: 5.0.77).

With the exception of the Advertiser Video Report and the Website Video Report, the application is functioning normally.

Both the Advertiser Video Report and the Website Video Report fail to either bring back results, or to raise an on-screen error. In each case, a blank page is returned.

The problem has been observed on both an in-house testing environment and a similarly configured remotely hosted production environment.

To assist in determining the cause of the problem, we have attached the OpenX configuration file as well as .pdf files representing the content of the Apache2 (httpd.conf) file and PHP (php.ini) configuration files.

At the moment, the following database tables are empty (0 records):

ox_account_user_permission_assoc
ox_acls
ox_acls_channel
ox_ad_category_assoc
ox_affiliates_extra
ox_campaigns_trackers
ox_category
ox_channel
ox_data_bkt_a
ox_data_bkt_a_var
ox_data_intermediate_ad_connection
ox_data_intermediate_ad_variable_value
ox_data_raw_ad_click
ox_data_raw_ad_impression
ox_data_raw_ad_request
ox_data_raw_tracker_impression
ox_data_raw_tracker_variable_value
ox_data_summary_ad_zone_assoc
ox_data_summary_channel_daily
ox_data_summary_zone_impression_history
ox_log_maintenance_forecasting
ox_password_recovery
ox_targetstats
ox_trackers
ox_tracker_append
ox_variables
ox_variable_publisher

Your assistance is resolving this issue is deeply appreciated.

Zone Not Clicking Thru

Mon, 23 Nov 2009 23:05:31 +0000

Hello,

I setup a zone on Thursday of last week and it was clicking through. Now it seems the ad does not click though and I've created a new zone to see if maybe it was that one zone that is messed up but it doesn't seem to matter what new zone i create. The ads will not click through for any zones that I create moving forward. Also now and then i seem to get these errors :

Fatal error: Call to a member function getOffset() on a non-object in /var/www/html/openx-2.8.2-rc25/lib/pear/Date.php on line 531

Please HELP!

PS: the zone in question is : 88861

Advertiser Budget Instead Of Campaign

Mon, 23 Nov 2009 21:29:25 +0000

Our current structure model does not allow for Campaigns to be each of our Paid advertisers. The reporting structure behind it would make our life hell.

So is there a way to put a monthly budget for each advertiser?

Thanks
Richard

Is Anyone From Openx Out There?

Mon, 23 Nov 2009 18:17:28 +0000

I've been trying to get in touch with someone at OpenX via the professional services inquiry for a week now. We need some assistance with an urgent issue on our side, but no one seems to respond.

If someone from the OpenX team is reading this, how do we get a response from, or help from, your professional services group? We are willing to pay, but no one seems to want to get back to us.

Missing Css On Iss

Mon, 23 Nov 2009 15:09:50 +0000

Hi everybody,

i'm istalling openx into IIS + PHP, but since the load of the first page /openx/www/admin/install.php, all the css is missing...
Checking with Firebug, i see that css are totally missing (the css tab is totally blank)

What can i do?

Statistics Disappear As Of Thursday

Mon, 23 Nov 2009 14:32:37 +0000

On Thursday morning at 4:05 am, I got the following error...

ERROR: Could not migrate aggregate bucket data from the 'ox_data_bkt_c', 'ox_data_bkt_m', 'ox_data_bkt_r' bucket table(s)

... and I have gotten it every hour since.

I am working through the forum, but my PHP and MySQL Kung FU is not strong at all. Can anyone help me restart stat tracking and hopefully recover non-migrated statistics?

Steve

Serving Multiple Banners In One Zone

Mon, 23 Nov 2009 12:47:43 +0000

Hi,

Is there a way to serve multiple banners in one particular zone so that the banner changes on every refresh? (just like Google ads).

I use Open X 2.6 presently. Please let me know.

Thanks All

Problem After Upgrade

Mon, 23 Nov 2009 12:00:47 +0000

Hi guys,
i had upgraded my openx installation and now he won't to log statistics.
the log says:
PHP Fatal error: Call to undefined function parseIniFile() in /var/www/openx/lib/OA/Admin/Settings.php on line 341, referer: ++website++

thanks in advance.

Spreadsheet For Inventory Management

Mon, 23 Nov 2009 11:23:42 +0000

I want a spreadsheet that will help us match up our bookings with the inventory that we manually forecast to be available.

Perhaps a traditional inventory management system for a hotel etc may be adaptable: zones are like the products, traffic is similar to quantity available.

Ad bookings could then be entered, each one subtracting the appropriate amount of traffic off the applicable zone for the period of the booking.

Perhaps a chart could illustrate which zones had availablity over the coming month etc.

Has anyone got such a system running?

Similar questions have been asked before and I can't believe no one has the answer:

http://forum.openx.org/index.php?showtopic...art=#entry87788

http://forum.openx.org/index.php?showtopic...mp;#entry114831

Openx And Campsite

Mon, 23 Nov 2009 09:07:58 +0000

Hi guys,

i've found that if i build and installation of campsite on root folder, and openx in a subfolder, OpenX starts to work in a weird way, with missing graphic, javascripts not working etc...

After some research i've found that is the campsite .htaccess to create troubles. If i take out that code, openx start to work well again. How can i fix this to make them worki together? This is it's content:

# There might be no access to apache config, set options here
DirectoryIndex index.php index.html
Options -Indexes FollowSymLinks -MultiViews

# Options might not aloowed here, use Rewrite rules instead

RewriteEngine On

RewriteCond %{REQUEST_URI} ^/+get_img$
RewriteRule . /get_img.php [L]

RewriteCond %{REQUEST_URI} ^/+attachment/+
RewriteRule . /attachment.php [L]

RewriteCond %{REQUEST_URI} !\.php$
RewriteCond %{REQUEST_URI} !\.html$
RewriteCond %{REQUEST_URI} !\.css$
RewriteCond %{REQUEST_URI} !\.js$
RewriteCond %{REQUEST_URI} !^/+admin
RewriteCond %{REQUEST_URI} !^/+install
RewriteCond %{REQUEST_URI} !^(/+plugins/[^/]*)?/+javascript
RewriteCond %{REQUEST_URI} !^/sys-templates
RewriteCond %{REQUEST_URI} !^(/+plugins/[^/]*)?/+css
RewriteCond %{REQUEST_URI} !^(/+plugins/[^/]*)?/+images
RewriteCond %{REQUEST_URI} !^/+templates/+
RewriteRule . /index.php [L]

RewriteCond %{REQUEST_URI} .tpl$
RewriteRule . /index.php [L]

RewriteCond %{REQUEST_URI} ^/+admin$|^/+admin/+.*|^/+admin-files
RewriteRule . /admin.php [L]

Statistics Cant Show After Migrate To New Server

Mon, 23 Nov 2009 07:05:03 +0000

Hi,

I am using OpenX 2.6.4 which installed in my own server, last week I had move to a new server. No statistics record show in admin UI start from that day. The statistics data which is 1 week before, still can show in admin UI.

I had check mysql, table 'ox_data_raw_ad_impression' is ok, then I check the date-time field of last record, it show that data still collected in mysql but just can't show. So can I solve this problem?

Thanks

Info:
Apache 2.2.3
PHP 5.1.6
MySQL 5.0.77 (my mysql user don't have create table access right)
OpenX 2.6.4

tail maintenance.log

QUOTE

Nov 23 06:28:10 +0000 OX [ error] PEAR :: MDB2 Error: no such table : _doQuery: [Error message: Could not execute statement]
[Last executed query: TRUNCATE TABLE `tmp_ad_zone_impression`]
[Native code: 1146]
[Native message: Table 'openx.tmp_ad_zone_impression' doesn't exist]

Nov 23 06:28:10 +0000 OX [ error] PEAR :: MDB2 Error: no such table : _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE MDB2_STATEMENT_mysql_2455bf591d227dd7075295c26afb0e67 FROM '\n INSERT INTO\n `tmp_ad_zone_impression`\n (\n ad_id,\n zone_id,\n required_impressions,\n requested_impressions,\n to_be_delivered\n )\n VALUES\n (?, ?, ?, ?, ?)']
[Native code: 1146]
[Native message: Table 'openx.tmp_ad_zone_impression' doesn't exist]

Invocation Code Tab Not Giving Options

Mon, 23 Nov 2009 04:54:32 +0000

I have established zones, banners,advertisers,campaigns and websites within OPENX Ads Server however when I go to invocation code on a zone the drop down box is empty. I have been through the forum and tried many things but I have had no luck in getting this to work.

does anyone out there have any ideas?

Error: Permission Denied For ... To Get Property Window.document

Sun, 22 Nov 2009 22:39:33 +0000

Hi,
I upgraded to 2.8.2

Find this error for every ad in the Firefox Error Console

QUOTE

Error: Permission denied for to get property Window.document from .
Source File: http://ads.myopenxserver.com/www/delivery/...amp;cb=10090820
Line: 12

(the url with a blank after // to display full)
Source File: http:// ads.myopenxserver.com/www/delivery/afr.php?resize=1&n=a44b6c37&zoneid=25&target=_blank&cb=10090820

Any hint/ideas ... highly appreciated
sloft

Error Upgrade 2.6.2 To 2.8.2

Sun, 22 Nov 2009 20:23:12 +0000

Currently I have OpenX located on an Apache 2.6.2 on Windows in a location eg .. \ Apache \ htdocs \ OX
I want to upgrade to version 2.8.2 and change location and put it in .. \ Apache \ htdocs \ AD but having operational until you perform the 2.6.2 migration properly.

For this I created the folder .. \ Apache \ htdocs \ AD and in the folder. \ Var rollover data 2.6.2 and reconfifuro config.php file to point to the correct location.
I create a DB in MySQL called AD and restored the backup 2.6.2
Run the Winzer:
1 .- OpenX 2.6.2 detected. this version can be upgraded.
2 .- User / password -> OK
3 .- Database: DB detects the new server correctly

Now come the errors:

* _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO ox_application_variable (name, value) VALUES ( 'mse_process_raw', '1 ')] [Native code: 1062] [Native message: Duplicate entry' mse_process_raw 'for key 1]
* Script returned false OA_UpgradePostscript_2_7_12_dev
* Failure in upgrade postscript postscript_openads_upgrade_2.7.12.phpThere was an error while processing your previous upgrade and OpenX must attempt to recover the upgrade process. Please click the Recover button below.

I asked RECOVER:

Preparing to rollback package openads_upgrade_2.7.12.xml
Starting to rollback package openads_upgrade_2.7.12.xml
Finished rolling back package openads_upgrade_2.7.12.xml
Information regarding the problems encountered during the upgrade can be found in
openads_upgrade_2.7.12_2009_11_22_09_10_00.log
Information regarding steps taken during rollback can be found in
D: \ Apache \ htdocs \ AD/var/openads_upgrade_2.7.12_2009_11_22_09_10_00.log.rollback
Database and configuration files have been rolled back to version 2.7.11-dev
Preparing to rollback package openads_upgrade_2.7.11-dev.xml
Starting to rollback package openads_upgrade_2.7.11-dev.xml
Finished rolling back package openads_upgrade_2.7.11-dev.xml
Information regarding the problems encountered during the upgrade can be found in
openads_upgrade_2.7.11-dev_2009_11_22_09_10_00.log
Information regarding steps taken during rollback can be found in
D: \ Apache \ htdocs \ AD/var/openads_upgrade_2.7.11-dev_2009_11_22_09_10_00.log.rollback
Database and configuration files have been rolled back to version 2.7.8-dev
Preparing to rollback package openads_upgrade_2.7.8-dev.xml
Starting to rollback package openads_upgrade_2.7.8-dev.xml
Finished rolling back package openads_upgrade_2.7.8-dev.xml
Information regarding the problems encountered during the upgrade can be found in
openads_upgrade_2.7.8-dev_2009_11_22_09_09_59.log
Information regarding steps taken during rollback can be found in
D: \ Apache \ AD/var/openads_upgrade_2.7.8-dev_2009_11_22_09_09_59.log.rollback
Database and configuration files have been rolled back to version 2.7.6
Preparing to rollback package openads_upgrade_2.7.6.xml
Starting to rollback package openads_upgrade_2.7.6.xml
Finished rolling back package openads_upgrade_2.7.6.xml
Information regarding the problems encountered during the upgrade can be found in
openads_upgrade_2.7.6_2009_11_22_09_09_59.log
Information regarding steps taken during rollback can be found in
D: \ Apache \ htdocs \ AD/var/openads_upgrade_2.7.6_2009_11_22_09_09_59.log.rollback
Database and configuration files have been rolled back to version 2.6.2
Recovery complete

I optimized the tables in MySQL, I checked in case they were wrong .. etc. ..

What can I do?. Thank you.

Upgrade From Openads 2.0.11-pr1 To Openx 2.8.2 Fails

Sat, 21 Nov 2009 15:10:30 +0000

Attempting to upgrade version Openads 2.0.11 to latest OpenX 2.8.2 fails at the same spot for me every time.

When I check for a log file in the /var directory, there's a file named: openads_upgrade_2.0.11_to_2.3.32_beta_2009_11_21_06_56_22.log

At the bottom of that file is the following:

CODE

UPGRADE SUCCEEDED
to version: 515
timing: destructive
target database: mallus_openx
table prefix: phpads_
successfully initialised DB Upgrade
verifying destructive changes
verifying/creating destructive tasklist
executing destructive tasks
UPGRADE SUCCEEDED
loading script postscript_openads_upgrade_2.0.11_to_2.3.32_beta.php
instantiating class OA_UpgradePostscript_2_0_11
method is callable execute
Removed old application version
#! failed to instantiate MDB2_Schema unable to find package 'MDB2_Driver_' file 'MDB2/Driver/.php'

I have followed the upgrade instruction exactly (including increasing the memory limit and timeout), and was able to successfully upgrade this same installation (a copy of the same database) on my laptop's development environment. My dev environment is Mac/MySQL 5/PHP 5.3, and the production environment is Linux/PHP 5.2.9/MySQL 4.1.

At this point, I'm stuck. Thankfully I'm testing with a copy of the database on a different vhost.

Any ideas? I can provide more detailed logs if needed.

-dave

Email Alerts For System Issues (e.g. Maint. Failing)

Sat, 21 Nov 2009 13:11:09 +0000

Would be nice if the admin was sent an email when the maint. script failed.... This would help the admins catch issues as they are starting to occur.

I really like the alerts to the sales people when their campaigns are about to expire/have expired.

Thanks,

Eric

Openx Marketing Error 500

Sat, 21 Nov 2009 07:54:34 +0000

Hello,

I just installed openx and I saw a link to activate openx market. However, when I click on the (http://www.taminwebhost.com/openx/www/admin/plugins/oxMarket/market-index.php) I get a 500 error page. How can I fix that?

Thanks,

Mathew
http://www.Taminwebhost.com

Xml Feed Integration

Sat, 21 Nov 2009 07:17:47 +0000

I am looking for someone to install an XML feed into my openx adserver. It is a PPC sponsored search feed.

Please PM or email if you can do it, along with you price.

Thanks

A

Admin Area Working Slow In 2.8.2

Fri, 20 Nov 2009 21:12:11 +0000

Good day!

I'm running the latest version of OpenX 2.8.2 on fairly good VDS (750Mhz CPU, 1Gb RAM). The serving ads speed is enough for me (I do not
have a lot of traffic yet), but admin area is extremely slow despite the fact that load average is not higher 0,30...

Not only dashboard but any other admin area page takes 3-4 seconds to generate. I have Eaccellerator installed. The strange thing that
on this machine my other sites run good, the old Openads 2.0.11 worked on this server at the speed of light.

Thanks in advance for any tips\ideas!

Iframes And Forms?

Fri, 20 Nov 2009 19:20:00 +0000

I've got a backfill campaign i want to run that's not a clickable < a href > ad, it's an actual form.

I've set it up as an iframe. The iframe draws in the form html. the end result is that the ad block should display a nice fillable form.

But when I set this up as a banner, it wants a destination url.for the ad (which is handled by the form submit button, I don't want it clickable).
Any way to set this up?

Two Backfill Campaigns

Fri, 20 Nov 2009 18:47:58 +0000

I have a variety of sites pulling ads from our openx install and am trying to set up two backfill campaigns. One is geotargetted by country, the next is 'for everyone else'. My question is how do I set this up?

Banner A: low priority, no conditoins
Banner B: low priority, geotargetted to one country only.

If I do it that way, can I be assured that for visitors in the geotargetted country, that they'll always see Banner B? i.e. will openx know to serve Banner B over Banner A to that country?