gulley Posted December 9, 2008 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
AlabamaHit Posted December 9, 2008 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
gulley Posted December 12, 2008 Author 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
Savager Posted December 12, 2008 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
AlabamaHit Posted December 17, 2008 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
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.