1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

$15.00 for quick PHP/mySQL job

Discussion in 'Hire a Freelancer' started by asiriusthoth, Nov 12, 2010.

  1. asiriusthoth

    asiriusthoth Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 4, 2010
    Messages:
    999
    Likes Received:
    761
    Occupation:
    If your on here, might as well friend me. Let's sh
    Location:
    Fort Worth, TX
    I need someone experienced with PHP/mySQL to fix a sql error on a PHP script.

    It's an error with PHPProBid.. if fixed, i'll re-upload a 100% working edition to the 'Download Section'.

    Two errors.. one one the "category" page and the other on the "stores" page.

    categories.php
    --------

    A Mysql error has occurred while running the script:

    The query you are trying to run is invalid
    Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 8
    SQL Query: SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT , 10

    stores.php:

    A Mysql error has occurred while running the script:

    The query you are trying to run is invalid
    Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 20' at line 3
    SQL Query: SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT , 20

    ___________________

    Like I said..i'll re-upload this to the Download Section for anyone to download, once this is fixed. I do not mind paying the $15.00 to get this fixed for everyone else to use.
     
  2. daltarak

    daltarak Newbie

    Joined:
    Oct 4, 2009
    Messages:
    22
    Likes Received:
    3
    The starting number of "LIMIT" isn't there, thats the problem. Try to find the corresponding variable and inspect why the variable isn't set correct or just set the variable to 1.

    If this helps buy yourself some drinks from me :D

    Cheers.
     
  3. BugFixed

    BugFixed Junior Member

    Joined:
    Sep 24, 2010
    Messages:
    130
    Likes Received:
    39
    SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT 1, 10

    or

    SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM probid_auctions a WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.list_in!='store' AND a.creation_in_progress=0 AND -a.closed=0 GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT 1

    //

    SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT 1, 20

    or

    SELECT user_id, shop_name, shop_logo_path, shop_mainpage, username, shop_nb_items FROM probid_users WHERE active=1 AND shop_active=1 ORDER BY shop_nb_items DESC LIMIT 1
     
  4. asiriusthoth

    asiriusthoth Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 4, 2010
    Messages:
    999
    Likes Received:
    761
    Occupation:
    If your on here, might as well friend me. Let's sh
    Location:
    Fort Worth, TX
    Thanks for the info... the problem is I can't find where the code is that is trying to access mySQL... heh
     
  5. Twizzler

    Twizzler Newbie

    Joined:
    Nov 4, 2010
    Messages:
    33
    Likes Received:
    7
    Occupation:
    Typing code.
    Location:
    Lost in cyberspace
    PM sent.
     
  6. Twizzler

    Twizzler Newbie

    Joined:
    Nov 4, 2010
    Messages:
    33
    Likes Received:
    7
    Occupation:
    Typing code.
    Location:
    Lost in cyberspace
    fixed :)
     
  7. Blaze1withMe

    Blaze1withMe Newbie

    Joined:
    Oct 25, 2010
    Messages:
    31
    Likes Received:
    1
    i am having the same issue. please send pm if anyone can help