Jump to content
MakeWebGames

[mccode v2] Simple Job Specials


Richard

Recommended Posts

  • 2 weeks later...
  • Replies 63
  • Created
  • Last Reply

Top Posters In This Topic

problem

Hi I added your mod but when i go to create a new job i get this error

QUERY ERROR: Column count doesn't match value count at row 1

Query was INSERT INTO jobranks VALUES('', 'test', 15, 1, 1, 1, 1, 1, 1, 1)

and when i go to the interview for the new job i get this error

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=2' at line 1

Query was UPDATE users SET job=15,jobrank= WHERE userid=2;

Can someone please help?

Link to comment
Share on other sites

  • 1 month later...
QUERY ERROR: Column count doesn't match value count at row 1

Query was INSERT INTO jobranks VALUES('', 'test', 15, 1, 1, 1, 1, 1, 1, 1)

This is a simple error with a simple solution...

its telling you that the amount of values you are inserting does not match up with the amount of fields in the jobranks table..

the insert is showing 10 fields in the jobranks table in your database, verifiy if this is correct :)

hope that helps cheers

Link to comment
Share on other sites

  • 7 months later...

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...