MySQL INSERT returns "Unable to save result .

[Anon]

Hello all,

when I'm doing an insert (using mysql database) it throws me the message:
Warning: MySQL: Unable to save result set in [file].

It stores the data, but then I cannot do an mysql_insert_id(); -> allways return 0

any suggestions?

thanks alot for your attention

[Anon]

mysql_insert-id() ONLY stores the 'auto_increment' value that was increased by last performed INSERT function.

so if you dont have any auto_increment type in your table which was updated, then it work work.

[Anon]

Yes, it is ok...

id int(11) DEFAULT '0' NOT NULL auto_increment

but it seems that mysql_query functions returns false, instead of storing data into database.

thanks again

[Anon]

make sure you are doing mysql_insert_id() BEFORE you close the link to mySQL i.e. the mysql_close().

if you do mysql_insert_id() after closing the link, then it will not be able to get the auto_incremented value.

or, may be if you can show a bit of the code which is doing this, then i guess we can help bit more.

regards,
Daarius...

[Anon]

Dear Daarius,
here is my code.
mysql_query("INSERT INTO newaltesweb (id,ts,idnivelpnl,fechaalta,nombre,apellidos,domicilio,codpos,poblacion,provincia,pais,email,telefono,fax,profesion,sexo,fechanacimiento,estudios,conocimientospnl,idioma) VALUES(0,NOW(),'$conocimientospnl',NOW(),'$nombre','$apellidos','$domicilio','$codpos','$poblacion','$provincia','$pais','$email','$telefono','$fax','$profesion','$sexo','$frm_date_bir','$estudios','$conocimientospnl',1)",$sql_connection);

$referencia=mysql_insert_id();

As you can see I don't close the link so... it is so extrange. If it is helpful to you, I'm working with de PHP4.

If I comment the mysql_insert_id() it returns me the warning too.
I've tried to use the query, for debbuging, and put the query into db, and MySQL, doesn't return me any warning (on console mode).

Thanks again

[Anon]

well, the code looks ok to me. i cant see anything wrong with above bit.

but the warnings normally come for the SQL query (if your SQL is corerct) for database connection. if its not connecting to the db, it might give you warning too, and the message is not a clear one saying cant connect to db, BUT infact says that:

1. is not a valid MySQL link() etc...

anyway, sorry i cant see anything wrong above.

[Anon]

Thanks for your patience...

I've solved doing the following:

$olderr=error_reporting(0);
$query="INSERT INTO newaltesweb (id,ts,idnivelpnl...
mysql_query($query);
$res=mysql_query("SELECT last_insert_id()");
$referencia=mysql_result($res,0,'last_insert_id()');
error_reporting($olderr);
mysql_free_result($res);

and it works!!

thanks alot for your time

[Anon]

Marc

Most likely what has happened is, PHP4 was compiled with the '--with-mysql'
option, without specifying the path to mysql. This means PHP is using its
built-in mysql client library. If your system is running applications, such as
php3 as a concurrent Apache module, or auth-mysql, that use other versions of
mysql clients, then there is a conflict between the two differing versions of
those clients.

Recompiling php4, and adding the path to mysql to the flag,
'--with-mysql=/your/path/to/mysql' usually solves the problem.