Weird problem...

jstrybis

Hi,

This is a very weird problem that, as far as i know, started happening today and was not happening before.

I have a database of users where I track the registration date and their last visit time via a timestamp field. Up until now, the registration column has stayed static while the last visit column has updated appropriately.

I believe that today, for some reason, both fields were updating when I CLEARLY only had an sql statement that told mysql to update the lastvisit column.

This is distressing as I have no idea why it would do such a thing. I've now lost a great deal of registration date information because it was being updated when the user logged in. (I did a search of all my source and only found reference to the regdate column once, which is the join insert...)

Is this a known problem or something? Can there only be one column in a table that is of the timestamp format?

That's what it would seem since I ended up trying a lot of things then finally changing the regdate column to datetime instead of timestamp... it now does not update with the lastvisit field.

Any information on this would be greatly appreciated.

On a side note: is there a reason why this site's pages do not execute properly? Half the time I see the page's source intead of the page.

Thanks,
Jay

tsinka

Hi,

the standard behaviour of MySQL is to update the first timestamp field in a table to the current date automatically on each update. I don't know why it didn't that in your case in the past. In order to make sure that that field doesn't change you can change your UPDATE queries to something like e.g.

UPDATE atable SET firstts=firstts,secondts='20040922091001',... WHERE ...

Thomas

P.S.: I don't have any problems with the pages displayed on PHPBuilder ... do you see the PHP source ?

jstrybis

Ah, I figured as much.

Thanks for the info.

No, I just see the HTML source... something wrong with the headers or something.

tsinka

You're right,

something might be wrong with the web servers.

I also had that "HTML Source" problem on PHPBuilder two or three times within the last two hour. Two times I only got the head of the page (logo, ads ...) but no content.

Thomas