For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running Apache in,
or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a
database with a standard little PHP script. Then I start working on my
other PHP scripts and testing them out. Of course there are mistakes, like
forgotten semicolons or a left bracket where it should be a right one
(parse errors), and I correct them, untill I get a nice output on my
screen. But suddenly - "Offset 0 is not valid for this result set". This is
a mysql_data_seek() error, but that is probably a coincidence. The point
is: MySQL suddenly thinks that the database is empty, as if it was destroyed.
When I look in my MYSQL directory tree, I find my database in the \data
subdirectory. So it is present (3 files for each table). When I look at the
date stamps for the files, all maintain their creation date/time, although
I did make changes to the tables during testing - except one table, with
just one row in it (my user/password), did change the timestamp, but I did
not access that one (it does not work under Windows)!
It get weirder. I must physically delete the database from the MySQL data
directory, before I can create them anew, with the same little script I
mentioned above. Usually I can access the tabels again then, but quite
often, I don't see the newly created tables, but the changed version from a
previous test - although I deleted those from my hard disk.
So I presume there is a cache somewhere, maintained by Windows, Apache,
MySQL or PHP. Can I flush that cache? How can I stop this weird behaviour?
I hope I am not really damaging my database, because when I will be working
with the real thing later on, I can not afford to have to start from
scratch over and over again. Is there a workaround?
Thanks, Marco (please mail me directly, I am not on the list)
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
| _`\<,_
|__(*)/ (*)________________Ah, op DIE fiets !
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php