weird problem?

bofla

Hi guys,
I have a strange ultra weird problem here🙂
I have a signup script that I made and worked fine untill I moved it to other server. The problem is that mysql database that needs to be updated, doesnt get updated:p
I have 3 steps, data is saved in hidden values of html, and in the end it posts to update.php witch gets all the data with $_POST[field], and then tries to update the DB. Weirdest thing is that it sucessfully goes to the last page, not reporting me any kind of errors. I've setuped E_ALL but still, doesnt show any error, it behaves that everything is OK. The MySQL connection is ok, it selects the DB, but doesnt update it. I use:
$sql = "insert into user values('','$first','$last','$address'...etc then
mysql_query($sql);
@mysql_close($this->frist);
and headers are updated with "finish" page. I use Php 4.2.2 and MySQL 3.23.58 on RH 9(1.7GHz, 512mb ram, 80gb hdd). I tried to find solution on this forum, and I have found this link:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10272830
but that is not my error because the connection is OK. This is all I could find regarding this issue. I hope someone will help🙂

Btw, forgot to say, that this all worked like a charm untill I have moved it to the other server.

Regards,
Robert

mtimdog

Is the mysql database local? If it is, did you move the mysql data between the servers?

bofla

Yes, MySQL database is local and I have moved it to the new server.

mtimdog

If you echo out mysql_error after the query, what does it say?

bofla

It doesn't shows anything, just blank, nothing in stdout. Maybe I missused it ?
mysql_query($sql);
mysql_error();
@mysql_close($this->frist);

mtimdog

echo mysql_error();

bofla

Ok, now I get the error:
Column count doesn't match value count at row 1

and on row 1 I have an auto_increment value:

CREATE TABLE user (
id int(11) NOT NULL auto_increment,

what shall I do?

mtimdog

Row 1 is replying to your query. If you're not going to explicitly list the names of the fields you're inserting, then you need to insert the exact number of fields in your table (in your query).

bofla

Thanks, I have just looking at row 1 for error, didn't checked the other fields thought it was ok. One field was missing. Thanks for pointing that out.