OpenX Technical Support feed

Delivery Limitations By Ip

Tue, 24 Nov 2009 10:58:26 +0000

I need to deliver ad only to users with IP not in 1.0.0.0/8 range (1.*.*.*)
How I should define delivery limitation?

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.

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

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.

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]

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

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

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!

No Statistics After Fixed Crashed Index File

Fri, 20 Nov 2009 17:57:58 +0000

Hi, all

First, I got an error: [Native message: Can't open file: 'ox_data_summary_ad_hourly.MYI' (errno: 145)]

By suggestions in forums, I fixed crashed tables and that index file.

But a new problem come. I have been waiting for about 5 hours, but today's Statistics is still empty. Can you tell me how to sort out?

I am currently using OpenX v2.6.3 running on Apache 2.0.54, PHP 5.0.4 and MySQL 4.1.13-.

I checked ox_data_raw_ad_impression table. It contains the latest impression data. I found following info in debug.log

Nov 20 17:51:00 +0000 OX [ info] Automatic Maintenance Task not run: could not acquire lock

In maintenance page, I saw:

Scheduled maintenance hasn't run in the past hour. This may mean that you have not set it up correctly.
Automatic maintenance is enabled, but it has not been triggered. Automatic maintenance is triggered only when OpenX delivers banners

Ian

Plugin & Statistic Probleme

Fri, 20 Nov 2009 15:22:49 +0000

Hi everyone !

I recently installed Openx 2.8.2 for my site. Everything works well (invocation etc) but i dont have any stats

I have read all topics about that probleme and tried de different solutions without success.

What should I look, wher can I find a tip to understand where is the probleme from ? What do you need to help me ?

I am quite new to open X and does not manage all functions yet.

Thanks for tips !

Mysql Replication

Fri, 20 Nov 2009 15:04:02 +0000

Hi,

i have a question about clustering with openX.

I read here that it is posible to say a openx installation the it should read from local database and write to a master database.

But i can do what i want, the second openX installation write everything in his own database.

Here the interesting part of the config:

[lb]
enabled=0
hasSuper=
type=mysql
host=192.168.0.1
port=3306
username=my_username
password=my_password
name=openx_db
persistent=
compactStats=1
compactStatsGrace=604800

i tried it with enalbed=0 and enabled=1 - the documentation says enabled have to set to 0, i found that a little bit strange but ok, i tried both.

The mysql replication works without problems, the master send the data to the slave, the only problem i got is the second openx installation.

thank you for your time!
hope somebody can help me.

Erm, Where Are My Stats?

Fri, 20 Nov 2009 14:04:38 +0000

I deleted some campaigns that I no longer needed. However, it seems to have Soviet-style gone back and deleted all stats like the campaign never existed.

Surely this can't be right, without any warning when deleting a campaign?

The campaign isn't needed anymore, but it happened then -- those ads were delivered -- so its stats should still be available surely?

Empty Invocation Code Dropdown

Fri, 20 Nov 2009 12:08:17 +0000

Hi everybody,

the dropdown on invocation code apge is empty.... there is no javascript, php, iframe options... how can i fix this?

Installing Openx 2.8.2 - Failed To Create Temporary Table

Fri, 20 Nov 2009 09:48:11 +0000

Hi,

We've been installing OpenX 2.8.2 and have had the following error at stage 4, the database section:-

Failed to CREATE TEMPORARY TABLE - check your database permissions 
Insufficient database permissions or incorrect database settings to install.

The only way we've been able to proceed past this stage is by setting the database up under root. I'm not sure if this is a good idea? Can anyone advise pls?

The installation wizard suggests that temporary tables only need to be created at the set up stage - so does that mean, once installed we can change db users? And if so, how would we do this and what would the implications of doing this be when its time to upgrade?

Thx

Alick

Community Statistics And Your Statistics Graph Not Showing Up

Fri, 20 Nov 2009 03:54:07 +0000

Hello all,

We upgraded from 2.4 to 2.8 recently. Everything works fine expect that Community Statistics and your statistics
are not showing up. It was working before the upgrade. I went through the forums and came across a thread where it said GD support
should be enabled and memory limit should be 128 M. I have both of them but still the graphs are not showing up.

Can anyone please guide me to solve this issue?

Thanks in advance..

Xampp File Permissions

Fri, 20 Nov 2009 00:37:24 +0000

Hi All,

Just tried to migrate to a local XAMPP server running on Windows XP. I can't get past this error:

--------------
Error: File permission errors have been detected, and must be fixed before you can continue.
For more help, please see the OpenX documentation.

* localhost\openx\www\images NOT writeable
--------------

OpenX even recommends using XAMPP!

Installs of other apps work fine. What am I missing?

Yes, I've looked at several other threads, but didn't find a fix... (example here)

Thanks in advance!

Missing File

Fri, 20 Nov 2009 00:05:36 +0000

Fatal error: require_once() [function.require]: Failed opening required 'DB/DataObject.php' (include_path='/home/a9899063/public_html/ads/lib/pear:/home/a9899063/public_html/ads/lib:.:/usr/lib/php:/usr/local/lib/php') in /home/a9899063/public_html/ads/lib/OA/Dal.php on line 29

I looked for DataObject.php File there is no sduch file in download

Installation: Missing Files In Openx Download

Thu, 19 Nov 2009 17:34:46 +0000

I've downloaded the OPENX files, extracted them and ftp'd them to my server. I've chmod with the permissions s requested. While running the install wizard, the wizard showed that permissions needed to be done to 3 files. I backchecked the files and they do not exist in the OPENX download either on my computer or the files uploaded to the server.

I'm willing to start from scratch, but need to know where I can get a complete download for OPENX.

Failed In Fighting With "file Permission Errors"

Thu, 19 Nov 2009 16:54:34 +0000

Hi all and thank you developers for your great tool!

I've just upgraded from 2.0.11-pr1 version to 2.8.2 (yes I know it's quite late :-). It's all right with the new version besides one annoying problem which is talked a lot about on this forum: I'm getting the "Error: File permission errors have been detected, and must be fixed before you can continue." all the time and it can't be solved by chmod command execution because it comes back after a while.

I've red advices in this topic and have been changed whole OpenX distribution folder's owner to www-data (my Apache process's user) as well as reconfigured maintenance script to be ran under www-data user.

Despite of this I'm getting same error still. As I've been investigated there is new file with incorrect permissions which appears in cache folder anyway:

CODE

-rw------- 1 eduabroad psacln 225 2009-11-19 19:02 deliverycache_da248622e75e6272ba8fc527b994a2a1.php

eduabroad is a name of my domain (eduabroad.ru) and psacln is a group of Plesk panel but I can't figure out when and how it appears. Could anybody suggest me any idea how to find an answer?

How To Delete The History (?)

Thu, 19 Nov 2009 14:34:29 +0000

Hello

Our company currently uses your ad server software. During the use of the system we encountered the following problem - we cannot find anything related to deletion of campaigns's history.
That's why we've got some questions related to this subject:

- How to delete the history of deactivated campaigns (e.g. campaigns inactive for 3 months)?
- How to delete the history of campaigns that don't exist anymore (campaigns that have already been deleted)?
- How to delete the complete history of every campaign while deleting a company (is there any plugin for that operation)?
- How to delete the history of a company's campaign that has already been deleted (is there any plugin for that operation, code sql)?

Regards,

Michał Pośpieszczyk

Is Some Maintenance Done When The Script Times Out/runs Out Of Memory?

Thu, 19 Nov 2009 13:09:58 +0000

I have a 2.6 installation, and haven't been paying much attention to it for a while. It turns out that some tables have had errors for several months and no maintenance has been run. I've repaired the tables, but now I have so much maintenance to do that even by raising the timeout/memory limit it won't complete, (PHP runs out of memory).

Each time I start the maintenance script, and it runs out of memory and fails, does it process *some* of the raw data so that there's a little less to do next time, or does maintenance start again from zero every time?

Thanks,

John