<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to bugs</title><link href="https://sourceforge.net/p/phpadsnew/bugs/" rel="alternate"/><link href="https://sourceforge.net/p/phpadsnew/bugs/feed.atom" rel="self"/><id>https://sourceforge.net/p/phpadsnew/bugs/</id><updated>2012-08-25T13:47:06Z</updated><subtitle>Recent changes to bugs</subtitle><entry><title>Problem in adding banner</title><link href="https://sourceforge.net/p/phpadsnew/bugs/687/" rel="alternate"/><published>2012-08-25T13:47:06Z</published><updated>2012-08-25T13:47:06Z</updated><author><name>Tara</name><uri>https://sourceforge.net/u/tara12/</uri></author><id>https://sourceforge.netaf2ba7a098316fd196bad82f6f88d687baff8021</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have setup the openads on our local server successfully. I have added one advertiser also, but whn i try to add banner under that advertiser i got the following error. The database is also sucessfully created, database connection is also perfect still it is giving this error. Please help me to get out of this error.&lt;/p&gt;
&lt;p&gt;An error occurred while accessing the database&lt;/p&gt;
&lt;p&gt;Due to a problem with the database Openads couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Openads. Please report the following information to the creators of Openads. Also try to describe the actions that led to this error as clearly as possible.&lt;/p&gt;
&lt;p&gt;Version:    Openads 2.0.11-pr1 (200.314)&lt;br /&gt;
PHP 5.2.17 / MySQL&lt;br /&gt;
Page:   /logohomedir/openads/admin/banner-edit.php&lt;br /&gt;
Error:  MySQL server has gone away&lt;br /&gt;
Query:  INSERT INTO phpads_banners (filename, width, height, contenttype, pluginversion, imageurl, htmltemplate, alt, status, bannertext, url, target, storagetype, htmlcache, clientid, bannerid, appendtype, append, transparent, keyword, description, weight, compiledlimitation) VALUES ('network-building-blue-sky.jpg', '2877', '1317', 'jpeg', '0', '{url_prefix}/adimage.php?filename=network-building-blue-sky.jpg&amp;amp;contenttype=jpeg', '[targeturl][/targeturl]\'{alt}\'[targeturl][/targeturl][bannertext]&lt;br /&gt;
[targeturl][/targeturl]{bannertext}[targeturl][/targeturl][/bannertext]', '', '', '', 'http://www.loghomelistings.com', 'blank', 'sql', '\'\'', '2', '', '', '', 'f', '', '', '1', 'true')&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Problem with phpAdsNew Banners</title><link href="https://sourceforge.net/p/phpadsnew/bugs/686/" rel="alternate"/><published>2009-08-04T08:16:49Z</published><updated>2009-08-04T08:16:49Z</updated><author><name>Marc Hill</name><uri>https://sourceforge.net/u/marcinjapan/</uri></author><id>https://sourceforge.netf4706921ae2ea5bc89beb8185eb4aa42f4dfe557</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;&amp;gt; Sir or Ma'am,&lt;br /&gt;
&amp;gt; I can no longer get my banners to display.  I need to resolve this ASAP as&lt;br /&gt;
&amp;gt; they banners are businesses that advertise on my website.&lt;br /&gt;
&amp;gt; This is the message I get:&lt;br /&gt;
&amp;gt; A fatal error occurred&lt;br /&gt;
&amp;gt;&lt;br /&gt;
&amp;gt; phpAdsNew can't connect to the database. Because of this it isn't possible&lt;br /&gt;
&amp;gt; to use the administrator interface. The delivery of banners might also be&lt;br /&gt;
&amp;gt; affected. Possible reasons for the problem are:&lt;br /&gt;
&amp;gt;&lt;br /&gt;
&amp;gt; The database server isn't functioning at the moment&lt;br /&gt;
&amp;gt; The location of the database server has changed&lt;br /&gt;
&amp;gt; The username or password used to contact the database server are not correct&lt;br /&gt;
&amp;gt;&lt;br /&gt;
&amp;gt; NOW, we did change servers recently.  How do I fix this?&lt;br /&gt;
&amp;gt; Marc Hill&lt;br /&gt;
&amp;gt; www.UnitedStangs.com&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>phpAdsNew 2.0.8 with PHP5</title><link href="https://sourceforge.net/p/phpadsnew/bugs/685/" rel="alternate"/><published>2008-07-25T21:22:41Z</published><updated>2008-07-25T21:22:41Z</updated><author><name>don pool</name><uri>https://sourceforge.net/u/donpool/</uri></author><id>https://sourceforge.net9296e81ecff73aac5fb30b2faca2b4c937244fe8</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;phpAdsNew 2.0.8 doesn't work with PHP5, I've changer the register_log_arrays to On, but still not working. Keeps asking me the user/passwd...&lt;/p&gt;
&lt;p&gt;There is something else to do to make it work?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>problem opening stats</title><link href="https://sourceforge.net/p/phpadsnew/bugs/684/" rel="alternate"/><published>2007-12-04T17:21:27Z</published><updated>2007-12-04T17:21:27Z</updated><author><name>TomC449</name><uri>https://sourceforge.net/u/tomc449/</uri></author><id>https://sourceforge.netb172d2a2df48fc421a41ec6c2131fd916a6ab7be</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Error message&lt;br /&gt;
An error occurred while accessing the database&lt;/p&gt;
&lt;p&gt;Due to a problem with the database Openads couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Openads. Please report the following information to the creators of Openads. Also try to describe the actions that led to this error as clearly as possible.&lt;/p&gt;
&lt;p&gt;Version:    Openads 2.0.11-pr1 (200.314) &lt;br /&gt;
PHP 4.3.11 / MySQL 4.1.14 &lt;br /&gt;
Page: /phpAdsNew/admin/stats-global-client.php &lt;br /&gt;
Error: File './phpads/phpads_adviews.MYD' not found (Errcode: 13) &lt;br /&gt;
Query: SELECT bannerid, count(*) as views FROM phpads_adviews GROUP BY bannerid&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;-------------------------&lt;br /&gt;
I am using 2.0 because I have a problem trying to upgrade to 2.4**&lt;/p&gt;
&lt;p&gt;PEAR Error &lt;/p&gt;
&lt;p&gt;MDB2 Error: Array &lt;/p&gt;
&lt;p&gt;_doquery: [Error message: Could not execute statement]&lt;br /&gt;
[Last executed query: SHOW COLUMNS FROM phpads_adclicks]&lt;br /&gt;
[Native code: 1105]&lt;br /&gt;
[Native message: File './phpads/phpads_adclicks.MYD' not found (Errcode: 13)]&lt;/p&gt;
&lt;p&gt;this is at 43% system check&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Banners not Centered</title><link href="https://sourceforge.net/p/phpadsnew/bugs/683/" rel="alternate"/><published>2007-10-09T23:06:39Z</published><updated>2007-10-09T23:06:39Z</updated><author><name>Betsy</name><uri>https://sourceforge.net/u/fwbbetsy/</uri></author><id>https://sourceforge.net6627e87f6e5a6413caedc8d22eefdcb43b65739b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have the phpauctions gpl enhanced v2.51 and when I use the banner feature the banners are not centered ?  How do i get them centered in the page.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>SQL fails in phpAds_logImpression</title><link href="https://sourceforge.net/p/phpadsnew/bugs/682/" rel="alternate"/><published>2007-06-16T22:22:51Z</published><updated>2007-06-16T22:22:51Z</updated><author><name>Bob Dewhirst</name><uri>https://sourceforge.net/u/userid-1819706/</uri></author><id>https://sourceforge.net80456bfd6bbdc0c4d83983d8ae4505a1e13064e8</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi there,&lt;/p&gt;
&lt;p&gt;2.0.11-pr1 running on FreeBSD 6.2, Apache 1.3.37, PHP 5.2.3 and MySQL 5.1.19-beta&lt;/p&gt;
&lt;p&gt;Just tracked down why our system was only registering one ad view per banner/zone per hour.&lt;/p&gt;
&lt;p&gt;In the function phpAds_logImpression:&lt;/p&gt;
&lt;p&gt;$result = phpAds_dbQuery(&lt;br /&gt;
"UPDATE ".(false &amp;amp;&amp;amp; $phpAds_config['insert_delayed'] ? 'LOW_PRIORITY' : '')." ".&lt;br /&gt;
$phpAds_config['tbl_adstats']." SET views = views + 1 WHERE day = NOW() &lt;br /&gt;
AND hour = HOUR(NOW()) AND bannerid = '".$bannerid."' AND zoneid = '".$zoneid."' &lt;br /&gt;
AND source = '".$log_source."' ");&lt;/p&gt;
&lt;p&gt;the update query was failing as no matching rows were found, this is because NOW() returns the full date including hours, seconds etc. where I think you are expecting it to return just the year month date.&lt;/p&gt;
&lt;p&gt;I fixed this by replacing day = NOW() with day = DATE(NOW())&lt;/p&gt;
&lt;p&gt;And all works again.&lt;/p&gt;
&lt;p&gt;Thanks for a great product and I hope this bug report helps it become even better.&lt;/p&gt;
&lt;p&gt;Cheers,&lt;br /&gt;
Bob.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Core dumps</title><link href="https://sourceforge.net/p/phpadsnew/bugs/681/" rel="alternate"/><published>2007-06-15T07:44:05Z</published><updated>2007-06-15T07:44:05Z</updated><author><name>Sportz</name><uri>https://sourceforge.net/u/sportz/</uri></author><id>https://sourceforge.net1786493fb54eba5350b21451e4072023d0cd5076</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi there&lt;/p&gt;
&lt;p&gt;I am running phpAdsNew 2.0.8 running on Apache 1.3.37, PHP 4.4.7 and MySQL 4.1.22-standard.&lt;/p&gt;
&lt;p&gt;A few times a month the application creates huge core dump files which appear in the root folder for phpadsnew.  They are labelled like this core.27425 for example and are around 16mg each.&lt;/p&gt;
&lt;p&gt;Any clues on what these are would be appreciated.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Core dumps</title><link href="https://sourceforge.net/p/phpadsnew/bugs/680/" rel="alternate"/><published>2007-06-12T22:38:32Z</published><updated>2007-06-12T22:38:32Z</updated><author><name>Sportz</name><uri>https://sourceforge.net/u/sportz/</uri></author><id>https://sourceforge.net9dce7cecfaeae48d07fa7b3dd4d4a45ec62509d0</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi there&lt;/p&gt;
&lt;p&gt;I am running phpAdsNew 2.0.8 running on Apache 1.3.37, PHP 4.4.7 and MySQL 4.1.22-standard.&lt;/p&gt;
&lt;p&gt;A few times a month the application creates huge core dump files which appear in the root folder for phpadsnew.  They are labelled like this core.27425 for example and are around 16mg each.&lt;/p&gt;
&lt;p&gt;Any clues on what these are would be appreciated.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>adview.php does not display images stored in database</title><link href="https://sourceforge.net/p/phpadsnew/bugs/679/" rel="alternate"/><published>2007-05-30T13:47:47Z</published><updated>2007-05-30T13:47:47Z</updated><author><name>Michiel van Wessem</name><uri>https://sourceforge.net/u/jmvw/</uri></author><id>https://sourceforge.net24dab9d2805a04e8192be3b573809dc3aa3bd757</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello..&lt;/p&gt;
&lt;p&gt;I'm using Openads for PostgreSQL 2.0.11-pr1&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;The &amp;lt;noscript&amp;gt; section of "Remote Invocation for Javascript" uses a file called adview.php to display images. &lt;/p&gt;
&lt;p&gt;There is a bug in adview.php that prevents delivery of images stored in the database. line 256 in adview.php is:&lt;/p&gt;
&lt;p&gt;echo $image['contents'];&lt;/p&gt;
&lt;p&gt;This should be: &lt;/p&gt;
&lt;p&gt;echo phpPgAds_unescape_bytea($image['contents']);&lt;/p&gt;
&lt;p&gt;because the image data is stored as escaped ASCII. &lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Linked zones not considered when calculating priority</title><link href="https://sourceforge.net/p/phpadsnew/bugs/678/" rel="alternate"/><published>2007-05-25T22:09:14Z</published><updated>2007-05-25T22:09:14Z</updated><author><name>myquealer</name><uri>https://sourceforge.net/u/myquealer/</uri></author><id>https://sourceforge.net446e1d96f4b5ed6b89779576e10693f4924bb1bf</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have been looking through lib-priority.inc.php in an attempt to resolve some long standing priority problems.&lt;/p&gt;
&lt;p&gt;Suppose we have two zones, Z1 and Z2, two high-priority campaigns, H1 and H2, and two low-priority campaigns, L1, and L2.&lt;/p&gt;
&lt;p&gt;H1 and L1 are linked to zone Z1, and H2 and L2 are linked to zone Z2.&lt;/p&gt;
&lt;p&gt;Z1 gets 2000 impressions per day, Z2 gets 100000 impressions per day.&lt;/p&gt;
&lt;p&gt;H1 is configured to deliver 1000 impressions per day. H2 is configured to deliver 50000 impressions per day.&lt;/p&gt;
&lt;p&gt;The weight of L1 and L2 are left at 1.&lt;/p&gt;
&lt;p&gt;It looks to me like the priority of H1 will be set to 1000, the priority of H2 will be set to 50000. Leaving 51000 impressions per day for the low priority campaigns. The priority of L1 will be set to 25500 and the priority of L2 will be set to 25500.&lt;/p&gt;
&lt;p&gt;The result of this is H1 only gets about 40 impressions, instead of the 1000 it should get and H2 gets impressions about about twice as fast as it should in the early part of the day and then few or none in the later part of the day.&lt;/p&gt;
&lt;p&gt;The reason this happens is the sript does not account for which zones an ad is running in when calculating its priority (the word "zone" does not even appear in lib-priority.inc.php). &lt;/p&gt;
&lt;p&gt;I think this could be compensated for manually by adjusting the weights of the low priority campaigns so the weight approximates the daily left over impressions for the zones it is linked to. In this case that would mean setting the weight of L1 to 1 and the weight of L2 to 50. Easy enough in this case, but in our installation we have well over 100 zones and 200 campaigns, most of which are running in a variety of zones.&lt;/p&gt;
&lt;p&gt;Another problem this raises is the weight of low priority campaigns can and do affect the number of impressions served by high priority campaigns.&lt;/p&gt;
&lt;p&gt;Suppose in the above example Z1 had two low priority campaigns linked to it, L1a and L1b, and suppose we wanted L1a to get ten times as many impressions as L1b, so we set the weight of L1a to 10 and leave L1b at 1.&lt;/p&gt;
&lt;p&gt;Now when those 51000 left over impressions are divided up to determine the priorities L1a gets 42500, L1b gets 4250 and L2 gets 4250. So now that simple addition of a low priority campaign to a small zone makes H1 only get about 20 impressions when it should get 1000 and H2 is giving out impressions ten times as fast as it should and runs out of impressions around 3:00 AM.&lt;/p&gt;
&lt;p&gt;We have seen both of thse behaviors in our openAds. We currently have a high-priority campaign which is running out of impressions around 6:00 AM and we have long had high priority campaigns which fail to deliver all their impressions while low priority campaigns in the same zones are getting impressions.&lt;/p&gt;
&lt;p&gt;Am I missing something? Is this an acknowledged issue? Is there a solution in the works?&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>