gulley Posted December 9, 2008 Share Posted December 9, 2008 :-( I Keep Getting Them To Errors And No Will Help Me Fix Them :( Will you help Me Fix Them Error One Is In Items When I Try To Use Med Refils Or E Refills Or Packs I Get QUERY ERROR: You have an error in your SQL syntax; c heck the manual that corresponds to your MySQL server version for the right syntax to use near '= '0' WHERE userid=1' at line 1 Query was UPDATE `users` SET = '0' WHERE userid=1 Error two Is when i try to create a new user (e.g) Bot QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO users (username, login_name, userpass, level, money, shells, crystals, turns, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney) VALUES( 'Bot ', 'Bot ', md5('Bot') , 100, 100, 0, 0, 0, 210, 210, 100, 100, 203, 203, 5050, 5050, 1, 'Male', unix_timestamp(), 'Bot', -1) If There Is Anyone Out There Is Willing to Help ME :-D My Email Is [email protected] Owner Of www.pimpbattles.com Thanks Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted December 9, 2008 Share Posted December 9, 2008 Re: Need Help With Items And Create Or Error :-( redo your query......your not giving values to everyting....thats very easy to see man...... Quote Link to comment Share on other sites More sharing options...
gulley Posted December 12, 2008 Author Share Posted December 12, 2008 Re: Need Help With Items And Create Or Error :-( What do you mean Edit things in PHP-Admin? Or Game Staff Panel? Quote Link to comment Share on other sites More sharing options...
Savager Posted December 12, 2008 Share Posted December 12, 2008 Re: Need Help With Items And Create Or Error :-( QUERY ERROR: You have an error in your SQL syntax; c heck the manual that corresponds to your MySQL server version for the right syntax to use near '= '0' WHERE userid=1' at line 1 Query was UPDATE `users` SET ?????????= '0' WHERE userid=1 what are you setting to 0 lol Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted December 17, 2008 Share Posted December 17, 2008 Re: Need Help With Items And Create Or Error :-( you have like 25 things listed and only 21 values for them. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.