Re: [phpOpenTracker-general] session_register() & Incorrect key file for table: 'pot_visitors' problem

Andreas Israel <[email protected]> Sat, 16 Jul 2005 13:17:47 +0200
Newsgroups gmane.comp.web.phpopentracker.general
Message-ID <[email protected]>
Hello Jeroen,

its me again.

I searched a little around and found that "your error" seems to be a bug 
in mysql. The guys at mysql recommend to update the software.

And there is a sql statement called "REPAIR" which should fix the 
problem. temporarily. To update seems to be better.

The links for your own reading fun:

<http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html>* 
http://forums.mysql.com/read.php?21,18281,18281
* http://www.forbiddenweb.org/viewtopic.php?id=37951
* http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html

Sorry for the misinformation.

Andreas


[email protected] schrieb:

>Hello Andreas,
>
>Thanks for your response. It is clear to me. Although I am not quite sure
>how to build a new blank table. What I want to do it to build a completly
>new database.
>This is how I build the current one. Can you confirm that it
>is the right way?
>
>: mysqladmin -h localhost -u root -p create phpopentracker
>: mysql phpopentracker <
>phpOpenTracker-1.5.1/phpOpenTracker/docs/sql/mysql/myisam.sql
>
>
>mysql> INSERT INTO user (Host, User, Password, Select_priv) VALUES
>('localhost', 'phptracker', password('mypassword'), 'Y');
>mysql> GRANT ALL ON phpopentracker.* TO phptracker;
>mysql> FLUSH PRIVILEGES
>
>thank a lot again!
>
>_______________________________________________
>phpOpenTracker-General mailing list
>[email protected]
>http://lists.berlios.de/mailman/listinfo/phpopentracker-general
>
>  
>