problem creating new shops

[destroyer555]

i own a v2 game and i after i added a new city i went to add a new shop but it wouldnt let me it showed this error QUERY ERROR: Column count doesn't match value count at row 1

Query was INSERT INTO shops VALUES('',6,'test','test',0)

please help if you can thanks!

[SaMz]

Re: problem creating new shops

First of all change your name.. Moderators will take that as advertising

[destroyer555]

Re: problem creating new shops

done can someone help now please? :oops:

[Mike09]

Re: problem creating new shops

show the structure for the shops table..

[destroyer555]

Re: problem creating new shops

do u mean this?

Field Type Collation Attributes Null Default Extra Action

shopID int(11) No auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext

shopLOCATION int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext

shopNAME varchar(255) latin1_swedish_ci No Browse distinct values Change Drop Primary Unique Index Fulltext

shopDESCRIPTION text latin1_swedish_ci No Browse distinct values Change Drop Primary Unique Index Fulltext

 

sorry i dont know anything about tables :oops:

[Lithium]

Re: problem creating new shops

at first sight, you have 4 fields on table, and trying to insert 5....

though... your error says exactly that...

"QUERY ERROR: Column count doesn't match value"

[destroyer555]

Re: problem creating new shops

so can you give me the code to put please?

[AbsentCrisis]

Re: problem creating new shops

Check the query in the file it should be an easy fix.

[destroyer555]

Re: problem creating new shops

what? i dont understand anything about query codes :|

[destroyer555]

Re: problem creating new shops

fixed now thanks

[AbsentCrisis]

Re: problem creating new shops

Then you shouldn't be running a game.