PHPauction. Auction closed!

I have installed php auctions 2.1 but there seems to be some sort of date problem.
When an item is added for sale and submitted, the auction is already closed (finished).
Upon checking the auction in the admin cp. the date is not showing correctly, I.E 3-/-2/2006.
The actual date should be 03/12/2006.
This is a free instalation via cpanel from my provider.

I have looked at 'date.inc.php' but all looks ok in there.

Anyone come across this before?

same problem as me mate.... did you find a solution?

I got the same problem and searched the net for hours without any help and success..
Could anyone please mail me the sollution to this problem to groothuijsen@gmail.com ???

Kind regards.

Paul

I would give up on this one. If you *really* need it go to the PHPAuction official site (which is no longer free... boo!) and they have a link to a cruddy hosting provider that has it.

PHP Auction 2.1 simply doesn't work with recent versions of SQL. I've tried on 2 hosting providers with Fantastico.

You *could* fix it yourself...

read the last message on the following thread:

http://auctioncode.com/viewtopic.php?t=964

and you'll see why the date thing is doing what it is doing.

I just spent, errrmm, 3 or 4 hours going through the code and updating the substring values. And it worked! And then 20 other errors popped up when you tried to make a bid.

Waste. Of. Time. I wish Fantastico / Hosting providers would friggen' address this - either by putting up something that works or by removing it (as it's a time-sink to try and get to work).

an conversion of the databases to sql 4.0 couldn't help this?

because i dont know what is going wrong in the sql. is the database sql file in version 4.0 and so uploaded in the wrong format?

you know what's the frustrating thing?
I had it working about one year ago and just wanted to update .. grrrrrr

Fix the timestamp before it's used:

$year = substr($t,0,4); // the variable you need to work on is $t - then just before put:

$date = ereg_replace("/|-|:| |.|,","",$t);
// leave the rest as it is.
$year = substr($t,0,4);
$month = substr($t,4,2);

in onother page you will find this value is taken from $date, then

$date = ereg_replace("/|-|:| |.|,","",$date);
// leave the rest as it is.
$year = substr($date,0,4);
$month = substr($date,4,2);

etc

GattoTigre

Typo! mistake in the first example.

GattoTigre

in fact, is has only to do with the interpretation of the date.
e.g. today is 17.12.2006 3:36 am 23 sec.
--> that would be 20061217033623

$year = substr($t,0,4); -> means: starting at position 0 taking 4 numbers (2006)

$month = substr($t,5,2); -> means: starting at position 5 taking 2 numbers (12)

etc.

The tricky thing is, that the timestamp on your server might use a different format, e.g
2006-12-17-03-36-23

as a consequence:

$year = substr($t,0,4); -> means: starting at position 0 taking 4 numbers (2006)

$month = substr($t,6,2); -> means: starting at position 5 taking 2 numbers (12)

it could also be:
200612-17-03-36-23
have a try, it worked well for me.

i have the same problem with the date-format

has anybody a fixed file to download or to mail? or which files have to be edited?

i have v2.1 from phpauction

my email: mailaddie@web.de

thank you!

Using GattoTigre's approach i have solved this and generated a zip with all the needed files. You can find it here:
sv-consult . dk + /sharing/phpauction.html
(you don't need to register, don't worry)

If you are not interested in that, you should at least be aware that Gattotigres regular expression is wrong. it should be:


the error is NOT escaping . like \.


feel free to email me if you can not access my site. the rules doesn't allow me to make it a real url


svconsult