Database error

Having issues with your Timekoin Server? Someone might be able to answer your questions here.
Post Reply
AoS
Posts: 10
Joined: Tue Apr 08, 2014 3:05 am

Database error

Post by 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
Posts: 404
Joined: Thu Jun 21, 2012 5:18 pm

Re: Database error

Post by warmach »

AoS wrote: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
Posts: 10
Joined: Tue Apr 08, 2014 3:05 am

Re: Database error

Post by 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 :mrgreen:

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
Posts: 404
Joined: Thu Jun 21, 2012 5:18 pm

Re: Database error

Post by warmach »

AoS wrote: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 :mrgreen:

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!
Post Reply