PDA

View Full Version : Send Message To Seller ErroR ?



jbilliau
12-12-2008, 09:55 PM
Possible Bug? version 0.7.0

when clicking on "Send message to seller" from an auction listing....

Error Array ( [0] => SELECT a.user, a.title, u.nick, u.email FROM webid_auctions LEFT JOIN webid_users ON (u.id = a.user) WHERE a.id=4 Unknown table 'a' in field list page:C:\RFCUweb\auction1\send_email.php line:30 )

renlok
13-12-2008, 11:06 AM
on send_email.php
change

$query = "SELECT a.user, a.title, u.nick, u.email FROM ".$DBPrefix."auctions
LEFT JOIN ".$DBPrefix."users ON (u.id = a.user)
WHERE a.id=".intval($auction_id);
to

$query = "SELECT a.user, a.title, u.nick, u.email FROM ".$DBPrefix."auctions a
LEFT JOIN ".$DBPrefix."users u ON (u.id = a.user)
WHERE a.id=".intval($auction_id);