Database error

[AoS]

my TK-server has a database error due to hardware malfunction (which is fixed now) and is at Transaction History: 0.00%

Is there is simple way to purge the database and to start fresh?

[warmach]

my TK-server has a database error due to hardware malfunction (which is fixed now) and is at Transaction History: 0.00%

Is there is simple way to purge the database and to start fresh?

My guess is your transaction history table got corrupted.

If you know SQL, then log into server and delete the table and recreate from the SQL file included in server download.

If not, you could try the Check DB and Repair DB buttons in Tools. To be honest though, this will take a REALLY long time and may make the machine unresponsive.

Do you have phpMyAdmin installed?

[AoS]

Thank you for your help!

I don't know SQL, but I think the problem is fixed.

This is what I did, it is a part from your excellent installation-manual I've used to install the server

Code: Select all

mysql -u root -p
DROP DATABASE timekoin;
CREATE DATABASE timekoin;
GRANT ALL PRIVILEGES ON  timekoin.* TO 'tkuser'@'localhost';
FLUSH PRIVILEGES;
USE timekoin;
source ~/timekoinserver_v3.61/new_install_sql/timekoin.sql
exit

After starting apache, don't forget to change the default userid/passwd, as this is reset to default.

Timekoin is rebuilding now.

[warmach]

Thank you for your help!

I don't know SQL, but I think the problem is fixed.

This is what I did, it is a part from your excellent installation-manual I've used to install the server

Code: Select all

mysql -u root -p
DROP DATABASE timekoin;
CREATE DATABASE timekoin;
GRANT ALL PRIVILEGES ON  timekoin.* TO 'tkuser'@'localhost';
FLUSH PRIVILEGES;
USE timekoin;
source ~/timekoinserver_v3.61/new_install_sql/timekoin.sql
exit

After starting apache, don't forget to change the default userid/passwd, as this is reset to default.

Timekoin is rebuilding now.

Way to go!