Web Auction installed on Windows

A place to discuss and receive support for the Web Auction application.

Web Auction installed on Windows

Postby dragon71 » Wed Mar 09, 2011 5:53 pm

Just did a new install on a Windows server, maybe this will help somebody. If Steve or any of you Web Auction pros disagree with anything in this post, please weigh in, these are just the steps I used to get it going.

- Used the following software on 1 server:
Microsoft Windows Server 2003 R2 Standard Edition Service Pack 2
Apache 2.2.17 w/SSL for Windows
PHP 5.2.17 VC6 Thread Safe (PHP 5.3.5 VC6 Thread Safe did not work for this application)
MySQL 5.5.9 Community Version on port 3306
Web Auction 0.3.5

- Followed the instructions in install.php

- Changed the following line in \dataface\actions\register.php:
From: registration_date timestamp(11) not null,
To: registration_date timestamp not null,

- Changed the SQL statement in \actions\reports.php:
From: $sql = "select p.product_id,p.product_name,w.winner,w.bid_amount,
if(w.email_sent,'Yes','No') as email_sent,
if(w.admin_email_sent,'Yes','No') as admin_email_sent,
convert_tz(w.close_date,'SYSTEM','".df_utc_offset()."') as close_date
from products p left join closed w on p.product_id=w.product_id";
To: $sql = "select p.product_id,p.product_name,w.winner,w.bid_amount,
if(w.email_sent,'Yes','No') as email_sent,
if(w.admin_email_sent,'Yes','No') as admin_email_sent,
convert_tz(w.close_date,'SYSTEM','".df_utc_offset()."') as close_date,
concat(x.firstname, ' ' , x.lastname) as full_name, x.email as email
from products p left join closed w on p.product_id=w.product_id left join users x
on w.winner = x.username";

-Comment out the following lines in \actions\reports.php:
//$row['email'] = $user->val('email');
//$row['full name'] = $user->val('fullname');

We ran our first real auction today. It ran for 4 hours, no errors, no problems.

Thanks, Bill
dragon71
 
Posts: 1
Joined: Wed Mar 09, 2011 4:25 pm

Re: Web Auction installed on Windows

Postby shannah » Thu Mar 10, 2011 3:01 pm

Thanks for posting this, Bill. Were these changes necessary to get it running on your system, or were they just "improvements"?

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Web Auction Discussion

Who is online

Users browsing this forum: No registered users and 15 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved