Page 1 of 3 123 LastLast
Results 1 to 10 of 27
  1. #1

    itemmarket.php error

    i get this error when you go to the item market

    QUERY ERROR: Unknown column 'imQTY' in 'field list'
    Query was SELECT im.`imPRICE`,`imQTY`,`imCURRENCY`,`imADDER`,`imID` , i.`itmid`,`itmname`, u.`userid`,`username`, it.`itmtypename` FROM `itemmarket` im LEFT JOIN `items` i ON im.`imITEM` = i.`itmid` LEFT JOIN `users` u ON u.`userid` = im.`imADDER` LEFT JOIN `itemtypes` it ON i.`itmtype` = it.`itmtypeid` ORDER BY i.`itmtype`, i.`itmname`, u.`username` ASC

  2. #2
    Banned
    Join Date
    Aug 2011
    Location
    Calumet City, IL
    Posts
    268
    O.o go to the database table itemmarket and add in imQTY(int 11)

  3. #3
    The ` imQTY` field is missing in this case
    add this sql in database
    [PHP]ALTER TABLE `itemmarket` ADD `imQTY` INT(11) NOT NULL default '0';[PHP]
    You are Either one from these
    1)Have enough money , Knows enough Programming , But Too Lazy
    2)Have enough money , Always Online , But Dont know any thing about programming
    3)Knows alot of programming , Always online but No money

    All programmers are playwrights and all computers are lousy actors

  4. #4
    No dont do that why would you use int(11)???

    Are you really EVER going to have that many? Should a player have that many??

    mediumint would suffice
    Ruler of Zu

    FIA ISP FTW!

    MWG a discussion forum. If you do not like replies then perhaps dont start a topic.

    I no longer support Mccodes bugs, errors or security flaws either on the forum or by private message due to the lack of support by the mccodes staff for their own engine.

    If your looking for an engine get one thats supported by its staff. EzRPG and EzRPG Rework & NWE are my recommendations.

  5. #5

  6. #6
    Banned
    Join Date
    Aug 2011
    Location
    Calumet City, IL
    Posts
    268
    Quote Originally Posted by rulerofzu View Post
    No dont do that why would you use int(11)???

    Are you really EVER going to have that many? Should a player have that many??

    mediumint would suffice
    games differ, Ive seen games that have well over billions in qty which is stupid but people do it. default is fine just in case, there is no huge scary risk at using int (11) its just not what you would do which is fine but we gave him the standard fix for his problem.

  7. #7
    No huge scary risk well apart from if your game is successful then the difference is quite large.

    Standard fix? how so since when was int(11) the default standard?
    Ruler of Zu

    FIA ISP FTW!

    MWG a discussion forum. If you do not like replies then perhaps dont start a topic.

    I no longer support Mccodes bugs, errors or security flaws either on the forum or by private message due to the lack of support by the mccodes staff for their own engine.

    If your looking for an engine get one thats supported by its staff. EzRPG and EzRPG Rework & NWE are my recommendations.

  8. #8
    Well thanks SRB didnt know the default was 10 I just use whats appropriate!
    Ruler of Zu

    FIA ISP FTW!

    MWG a discussion forum. If you do not like replies then perhaps dont start a topic.

    I no longer support Mccodes bugs, errors or security flaws either on the forum or by private message due to the lack of support by the mccodes staff for their own engine.

    If your looking for an engine get one thats supported by its staff. EzRPG and EzRPG Rework & NWE are my recommendations.

  9. #9
    Banned
    Join Date
    Aug 2011
    Location
    Calumet City, IL
    Posts
    268
    Ah yea meant 10 lol I knew it was one of them 10 or 11, but yea doesnt really matter if you can secure you code theres no problems either way. Being accurate does leave less room for error and bugs but being smart about the script can be just as good but either way he has multiple answers to try so he should be ok.

  10. #10
    Hmm interesting, I have always used int (11) just cause thats how everything else is unless I just need something with a small reall small value so I just use like tinyint (1) does that work is there something better

Page 1 of 3 123 LastLast

Similar Threads

  1. [ V2 ] Can't solve Parse error: syntax error, unexpected T_VARIABLE error??
    By jjnicholascolwill in forum Modification Support
    Replies: 4
    Last Post: 08-31-2011, 06:59 AM
  2. Itemmarket V2 Problem.
    By PowlFruit in forum Engine Support
    Replies: 13
    Last Post: 06-25-2011, 02:58 PM
  3. [Help] itemmarket (v2)
    By bocco in forum General Discussion
    Replies: 7
    Last Post: 03-24-2009, 10:00 PM
  4. itemmarket.php help
    By tittlemouse in forum Other Programming
    Replies: 12
    Last Post: 03-11-2008, 10:37 PM
  5. Coding Error (itemmarket.php) - Please help!!!
    By Jamie Taylor - Director of Operations in forum General Discussion
    Replies: 4
    Last Post: 06-16-2007, 06:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •