|
About
|
|
|
Author: FR
|
|
|
Credits:
|
|
|
|
Brookfresh, Brad Lawryk, Crogon, DaMysterious, EklipzeDesigns, ML, musashi, phpBB Group, phpBB-Auction-Team, php-styles, sanman, Tel, Vampy, wGEric
|
|
|
Supported Sites
|
|
|
Statistics
|
|
User:
|
17825
|
|
Posts:
|
18401
|
|
Latest User:
|
Jessieelamp
|
|
|
|
| View previous topic :: View next topic |
| Author |
Message |
Lcars85296
Small-Cap Auctioneer
Joined: 17 Mar 2005
Posts: 17
Location: Arizona
|
 Posted: Wed May 04, 2005 8:26 am Post subject: B1.3m-3a --Ratings sql error |
 |
|
After a sale when you try to post a rating I am getting:
Couldnt insert rating
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ' 3, ' at line 9
INSERT INTO phpbb_auction_user_rating (FK_auction_offer_id, FK_auction_offer_seller_id, FK_auction_offer_buyer_id, auction_offer_seller_rating_text, FK_auction_offer_seller_rating_id, auction_user_seller_rating_time) VALUES(73, , 3, 'duper', '1', 1115193570)
Line : 177
File : auction_rating.php
It is not adding the value " . $seller_id . ",
I have checked the code for the sql to retreive to $seller_id and it looks good to me. I have run out of ideas why the $seller_id is not set. The $buyer_id is called from the same sql and seems to be fine. Any ideas?
_________________
"A witty saying proves nothing."
- Voltaire (1694-1778) |
|
| Back to top |
|
 |
FR
Site Admin
Joined: 26 Jan 2004
Posts: 1764
Location: root directory
|
| Posted: Wed May 04, 2005 7:03 pm Post subject: |
|
|
OPEN auction_rating.php
FIND
| Code: | if( isset($HTTP_GET_VARS[POST_AUCTION_OFFER_URL]))
{
$auction_offer_url = ( isset($HTTP_GET_VARS[POST_AUCTION_OFFER_URL]) );
$auction_offer_url = htmlspecialchars($auction_offer_url);
}
|
REPLACE WITH
| Code: | if( isset($HTTP_GET_VARS[POST_AUCTION_OFFER_URL]))
{
$auction_offer_url = $HTTP_GET_VARS[POST_AUCTION_OFFER_URL];
$auction_offer_url = htmlspecialchars($auction_offer_url);
}
|
FIND
| Code: | $user_id = ( isset($HTTP_GET_VARS[POST_USERS_URL]) );
$user_id = htmlspecialchars($user_id);
|
REPLACE WITH
| Code: | $user_id = $HTTP_GET_VARS[POST_USERS_URL];
$user_id = htmlspecialchars($user_id);
|
_________________
Want to say thank you. Use my Amazon Wishlist
Meet the world on movie-on.com |
|
| Back to top |
|
|
Lcars85296
Small-Cap Auctioneer
Joined: 17 Mar 2005
Posts: 17
Location: Arizona
|
| Posted: Thu May 05, 2005 6:25 am Post subject: |
|
|
That worked great.
Thanks
_________________
"A witty saying proves nothing."
- Voltaire (1694-1778) |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Usergroups
Register
Profile
Log in to check your private messages
Log in
