Welcome Guest. Sign in or Signup

3 Answers

Click Totals Not Showing in Admin Control Panel

Asked by: taloncc 724 views Uncategorized


We just upgraded our server to CentOS 5.3 over the weekend. Everything in Advert seems to be working ok except that our admin panel does not show the Clicks or percentage numbers under Today’s Statistics. Our reports also don’t show any click info.

However, if I click a banner and run

SELECT COUNT(*) FROM avp_click_logs WHERE date=NOW();

The count increases with every click.

I hope you can provide some insight on where I should look to fix these report screens. There are no errors in the HTML Error logs. If found no errors in catalina.out or the other Tomcat logs either.

Thank you for your assistance in advance.


3 Answers

  1. renegade_mike on Jul 06, 2009

    AdvertPro Classic is a collection of Perl scripts and runs in Apache.

    It’s only the new AdvertPro, which is a Java web application, that runs in Tomcat so that’s not of interest to you.

    Was MySQL upgraded to version 5.x when you upgraded CentOS? That is probably the issue. AdvertPro Classic is very old. The final version (3.7.16) was released in April, 2002 (over 7 years ago) and only supported MySQL 3.23 and 4.0. It is also compatible with MySQL 4.1, so I would suggest you install a copy of that and run in on a different port unless you can downgrade MySQL for all of your applications.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes

  2. taloncc on Jul 07, 2009

    You are correct we upgraded to MySQL 5.

    Downgrading is really not an option. I can probably install an older version on a different port. However, why not just upgrade to the latest version of advertpro and not classic version? Is there a cost to this upgrade?

    0 Votes Thumb up 0 Votes Thumb down 0 Votes

  3. renegade_mike on Jul 07, 2009

    I’m afraid it’s not possible to do an upgrade. The new AdvertPro is a completely different program that runs on an entirely different platform. The two are not compatible, so it’s a start over from scratch deal.

    For right now I think you’re stuck running a separate MySQL, but your client should look at purchasing the new AdvertPro: http://www.advertpro.com/ We offer 50% off all prices for AdvertPro Classic customers looking to migrate.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes