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:
|
18751
|
Posts:
|
18401
|
Latest User:
|
Volodimiirpi
|
|
|
|
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
|
|