phpbb-auction.com Forum Index phpbb-auction.com
Download, Support, Documentation
 
Donate to phpbb-auction.com to support the project


phpbb-Auction
  Home
   - News
   - Bug report/Patches
   - Future Features
  Demo
  Downloads
   - Version 1.3m  (Core /Lang /Mods)
   - Version 1.2m  (Core /Lang /Mods)
   - Version 1.0m  (Core /Lang /Mods)
   - All
  Services
  Documentation
   - Features
   - Documents
   - How-Tos
   - About
  Support
   - English
   - German
  Development
   - Changlog
   - Requests
   - Team
   - CVS
  Community
   - Website of the Month
   - Websites
   - Community Forum
   - Member

Navigation
FAQFAQ
SearchSearch
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesLog in to check your private messages
Log inLog in

Forum
Changing start time auctions
Sun Feb 07, 2010 4:33 am FR
Easy: what code to use to update sql table?
Fri Oct 16, 2009 8:39 am guyb
Unlimited products(downloads)
Wed Oct 14, 2009 7:09 pm hoimyr
Seller chooses currency
Sun Oct 11, 2009 8:00 pm hoimyr
Cant select end date without getting error
Sun Oct 11, 2009 6:43 pm hoimyr

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: 17470
Posts: 18401
Latest User: margaretlc2

B1.3m-3a --Ratings sql error

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    phpbb-auction.com Forum Index -> Bug report-Patches Version 1.3m
View previous topic :: View next topic  
Author Message
Lcars85296
Small-Cap Auctioneer
Small-Cap Auctioneer


Joined: 17 Mar 2005
Posts: 17
Location: Arizona

PostPosted: Wed May 04, 2005 8:26 am    Post subject: B1.3m-3a --Ratings sql error Reply with quote

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
View user's profile Send private message Visit poster's website
FR
Site Admin
Site Admin


Joined: 26 Jan 2004
Posts: 1764
Location: root directory

PostPosted: Wed May 04, 2005 7:03 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Lcars85296
Small-Cap Auctioneer
Small-Cap Auctioneer


Joined: 17 Mar 2005
Posts: 17
Location: Arizona

PostPosted: Thu May 05, 2005 6:25 am    Post subject: Reply with quote

That worked great.

Thanks
_________________
"A witty saying proves nothing."
- Voltaire (1694-1778)
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    phpbb-auction.com Forum Index -> Bug report-Patches Version 1.3m All times are GMT
Page 1 of 1

 
Jump to:  
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


phpbb-auction.com - Developed by www.digital-media-lab.com
Sponsored by: www.globibo.com - www.learn2go.de - www.talentone.org - www.language-school.in - www.ping-ke.cn