Data disappears

[BigBob]

I'm currently having problems with a gaming ladder script and specifically the register/validate part.

A player will register and will have to validate via a code sent in e-mail. The username etc. are stored in the table 'validate'. Once validated the username etc. should be transferred to the 'users' table but this doesn't happen.

The data is deleted from the 'validate' table but doesn't appear in 'users'

The code can be seen at:

http://pastebin.com/936959

Any ideas?

[Daemonspyre]

Before Fumigator has the opportunity (), why are you not validating your query with die(mysql_error())?

It may show you why you are not inserting data (and hence, its disappearance) the way you are expecting.

[BigBob]

Added that in and it says:

Error: Column count doesn't match value count at row 1

[Daemonspyre]

That's why you are "losing" data. There is a missing (or extra) column in one of your SQL statements, causing the statement to fail.

Look over your SQL and make sure that you have the right number of columns in your INSERT.

FOR EXAMPLE:

If mytable has 13 columns, INSERT INTO myTable VALUES () needs to have 13 values in it, while INSERT INTO myTable (col1,col2,col3) VALUES () only needs to have 3 values in it.

[Fumigator]

Before Fumigator has the opportunity ( ), why are you not validating your query with die(mysql_error())?

Oh man that made me laugh. You caught on to my mantra

[Daemonspyre]

Figured you needed a good chuckle.

[BigBob]

Originally Posted by Daemonspyre

That's why you are "losing" data. There is a missing (or extra) column in one of your SQL statements, causing the statement to fail.

Look over your SQL and make sure that you have the right number of columns in your INSERT.

FOR EXAMPLE:

If mytable has 13 columns, INSERT INTO myTable VALUES () needs to have 13 values in it, while INSERT INTO myTable (col1,col2,col3) VALUES () only needs to have 3 values in it.

Cheers. I didn't code the script myself.

I added extra ones in make them equal but still get the same error.

1. I'm guessing the coder put NULL in first as that would be the 'ID' column and is auto_increment. Would I be right?

2. The last two fields are showing the attributes 'UNSIGNED'. Would this make a difference at all?

I recently integrated the ladder with a forum so this is where the extra fields came from.


EDIT: Okie. Not having a good day. I was saving the file but then uploading the original one again. Did it 4 times before I reliased. It's now working. Thanks for the help! Rep given.

[Daemonspyre]

1. You would be correct

2. UNSIGNED means that the column will only accept numbers and will not accept negative numbers. Default for these is usually NULL or 0.

Before you go adding columns to your scripts/tables, why not change your INSERT statements to include the field names?

[BigBob]

Originally Posted by Daemonspyre

1. You would be correct

2. UNSIGNED means that the column will only accept numbers and will not accept negative numbers. Default for these is usually NULL or 0.

Before you go adding columns to your scripts/tables, why not change your INSERT statements to include the field names?

Check my edit to last post ;-)

[Daemonspyre]

Sorry! Didn't see the EDIT till after.

Thanks for the REP!