#26 LATER: upgrade halts because of dup. key violation

[Dan Langille]

I just got this:

Due to a problem with the database phpPgAds couldn't
retrieve or store data. If this problem is reproducable it
might be caused by a bug in phpPgAds. Please report
the following information to the creators of phpPgAds.
Also try to describe the actions that led to this error as
clearly as possible.

Version: phpPgAds 2.0.6 (200.26)
PHP 4.3.10 / PostgreSQL
Page: /phpPgAds/admin/upgrade.php
Error: ERROR: duplicate key violates unique constraint
"phpads_adstats_pkey"
Query: INSERT INTO phpads_adstats (views,
clicks, day, hour, bannerid, zoneid, source) SELECT
views::int4, clicks::int4, day::date, hour::int4, bannerid::
int4, zoneid::int4, source::varchar FROM
tmp_phpads_adstats

[Dan Langille]

Logged In: YES
user_id=27858

I was upgrading from Version 2 RC 4.1

[Dan Langille]

Logged In: YES
user_id=27858

I looked for the code that does the above insert. I could not
find it.

Where is it? If I can find it, I'll fix it and submit a patch.

Until then, I'm stuck. Thanks.

[Dan Langille]

Logged In: YES
user_id=27858

See also: http://forum.phpadsnew.com/index.php?
showtopic=9430

[Dan Langille]

Logged In: YES
user_id=27858

See also: http://forum.phpadsnew.com/index.php?
showtopic=9430

[Matteo Beccati]

Logged In: YES
user_id=214792

I've seen your explaination on the forum and will check it
as soon as possible.

[Matteo Beccati]

Logged In: YES
user_id=214792

Since phpPgAds 2.0 RC 4.1 is rather old, I won't fix it just
before a new release. I will do it later, as soon as possible.