Jump to content
MakeWebGames

Got any Ideas?


Z?v??

Recommended Posts

I seem to have a problem with creating forces on my game. It worked fine before and now it has just stopped working and is giving this error message:

Column count doesn't match value count at row 1

It lets me choose the name of the force and a description of it but then when I click to create the force, it gives that error message. If anyone has any ideas I would really appreciate them.

Link to comment
Share on other sites

Re: Got any Ideas?

sounds like you may have added a field to 'gangs' , -but never added an 'initial' value to creategang.php for the INSERT statement..

did you try add pictures or something?? export the 'gangs' structure and copy the mysql_query("INSERT INTO gangs VALUES('','$name','$desc',''...........

line from creategang.php and maybe 'we' can be of more help if you don't find it looking for the above mentioned possibility.

Link to comment
Share on other sites

Re: Got any Ideas?

Ya, i've added 3 new fields to my gang table in the database and now the column count doesn't match value count at row 1.

Here's the exact query I have in my creategang.php:

 

mysql_query("INSERT INTO gangs VALUES('','$name','$desc','','',0,0,100,$userid,$userid,5,0,0,'',0,0,0)",$c) or die(mysql_error());

 

That needs something added to it, but I'm not exactly sure where it goes. I might be wrong but I think there needs to be three more 0 fields added in there somewhere??????

Link to comment
Share on other sites

Re: Got any Ideas?

just go export your 'gang' table and print of view the fields, compare them to the INSERT from creategang.

put values or 2 single-quotes for each of the added fields(are all three at the end/bottom of the table???)

you get the drift

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...