There is no shares table, Have you imported the schema?

[sunggeorge]

Maybe a newbie question.

I get captioned message when I run:
twistd -ny launcher.tac

I tried creating the database in config.py first but still get this msg.

I don't know if there should be any thing done to mysql.

Hope someone can help me. Thanks!

[TheSerapher]

If you are using MPOS, import that SQL supplied.

[SpeedMiners]

Hi Serapher - Imported the MPOS SQL and I am getting that error too - Am happy for you to log into my server if you want to check it out, let me know!

[SpeedMiners]

Here is the code that's causing the problem

self.execute(
"""
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.STATISTICS
WHERE table_schema = %(schema)s
AND table_name = 'shares'
""",
{
"schema": getattr(settings, 'DB_MYSQL_DBNAME')
}
)

    data = self.dbc.fetchone()

    if data[0] <= 0:
       raise Exception("There is no shares table. Have you imported the sch

However, I do have the database that it is mentioning I do not..

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mpos |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.01 sec)

Have I installed it incorrectly do you think?

[TheSerapher]

Point Stratum to the right database with proper credentials.

I don't supply customer support. It's an easy thing to setup if you know what to do.

Cheers,
Sebastian

On 15.12.2013, at 04:56, SpeedMiners [email protected] wrote:

Hi Serapher - Imported the MPOS SQL and I am getting that error too - Am happy for you to log into my server if you want to check it out, let me know!

—
Reply to this email directly or view it on GitHub.

[SpeedMiners]

Completely understand - I will dig a little deeper and see what I can find - Thanks for your help, Sebastian :)

I appreciate your work on this project!

[SpeedMiners]

Just to let you guys know I fixed this - My database was empty! Check your database and ensure you've imported all the MPOS tables :)