Cannot Create Campaigns

The error is your OpenX server (not the openx_manager module) complaining that no advertiser object exists for the campaign you want to create.

Try checking whether the uid of the drupal account you used in attempting to create the campaign exists in the duid column of the openx_manager_advertiser table (and likewise for tables openx_manager_manager and openx_manager_publisher). If the uid doesn't exist, create another admin user and try with that account.

These tables are meant to bind your drupal uid to corresponding objects (advertiser, manager, publisher) on the OpenX server.

The openx_manager module adds entries to these 3 tables upon new user creation when you have user integration turned on in admin/settings/openx-manager/settings. However, it does not populate these tables for user accounts that existed before installing the module, in particular for uid=1.

openx_manager is trying to insert invalid records into the table openx_manager_campaign, i.e. where ocid=0;

How are you creating campaigns? Are you trying to do it via /node/add/campaign? Please note that doesn't work in the current version of openx_manager module, since it doesn't know the appropriate advertiser nid for the current user when you try to use the generic node add form.

When I create a campaign, I have to log in as a user with appropriate openx nodes advertiser, manager, and publisher associated. Then I browse to /user, click on the "Advertiser" tab, and then on the "Create a New Campaign" link.

There is a similar requirement for adding banners, i.e. trying to submit via /node/add/banner will fail. Rather you must browse to the campaign node, and click on the "Create a New Banner" link at the bottom of the page.

Likewise for creating Zones, you must click on the Publisher tab of your user account page and then on "Create a New Zone."

A feature request would be to add relevant drop-down boxes (or some other appropriate form element) to the node creation forms for campaigns, banners, and zones to make this process a bit less unwieldy.

From what I understand of openx_manager module (I'm not its developer), the errors you are seeing are being issued from the OpenX server itself, and openx_manager is just repeating them.

Has your module been to able to create *any* object on the Openx server itself, i.e. advertiser, publisher, manager, and not just in the bridge tables maintained by open_manager? Besides username/password issues for connecting to your OpenX server, I see this module has outstanding issues with its implementation of the OpenX api, e.g. http://drupal.org/node/662326

I've been using openx_manager successfully with my own instance of the OpenX Ad Server, v. 2.8.1.

Also, have you tried the reverse path, i.e. create objects first in the OpenX server and then do /admin/settings/openx-manager/import?

I'm sorry to read this is still not working for you. Short of simply trying with a completely fresh Drupal install and performing an import, I'm out of suggestions. My only guess is that something is irrecoverably out of sync between openx_manager's tables under Drupal and the OpenX server itself, in particular with user sync.

I am including all the (anonymized) values from my variable table relevant to my openx_manager v6.x-1.02 module, in case that illuminates any problems.

REPLACE `variable` (`name`, `value`) VALUES
('openx_manager_server', 's:23:"http://blahblahblah.com";'),
('openx_manager_username', 's:8:"blahblah";'),
('openx_manager_password', 's:8:"blahblah";'),
('openx_manager_user_integration', 'i:1;'),
('openx_manager_campaign_inventory', 'a:3:{s:11:"impressions";s:11:"impressions";s:6:"clicks";s:6:"clicks";s:11:"conversions";s:11:"conversions";}'),
('openx_manager_banner_types', 'a:6:{s:3:"sql";s:3:"sql";s:3:"web";s:3:"web";s:4:"url2";s:4:"url2";s:3:"url";s:3:"url";s:4:"html";s:4:"html";s:3:"txt";s:3:"txt";}'),
('openx_manager_banner_target', 's:0:"";'),
('content_extra_weights_openx_banner', 'a:2:{s:5:"title";s:2:"-5";s:4:"menu";s:2:"-2";}'),
('node_options_openx_banner', 'a:2:{i:0;s:6:"status";i:1;s:7:"promote";}'),
('upload_openx_banner', 's:1:"0";'),
('form_build_id_openx_banner', 's:37:"form-27de033e7271cc7a8a2a9d4538a43587";'),
('node_options_openx_campaign', 'a:2:{i:0;s:6:"status";i:1;s:7:"promote";}'),
('upload_openx_campaign', 's:1:"1";'),
('form_build_id_openx_campaign', 's:37:"form-9279184d03f2370c8a89fa0eb70f2f7b";'),
('teaser_include_openx_banner', 'b:1;');

Besides that, have you verified that the Openx server itself is working properly, delivering banner ads to the appropriate zones? For example, it requires a cronjob to run maintenance.php hourly, which was buried a bit in the docs.

http://www.openx.org/en/docs/2.8/adminguide/Running+maintenance