search

moopless / stratum-mining-litecoin

This fork is no longer maintained. Please use https://github.com/ahmedbodi/stratum-mining
Other
38 stars 35 forks source link

Duplicate column name 'pplns_valid' #90

Open vodkadrunkinski opened 10 years ago

vodkadrunkinski commented 10 years ago

[root@pool1 sql]# mysql elacoin_mpos < 000_base_structure.sql [root@pool1 sql]# mysql elacoin_mpos < 001_pplns_statistics.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'pplns_valid'

MariaDB [elacoin_mpos]> describe statistics_shares; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | account_id | int(10) unsigned | NO | MUL | NULL | | | block_id | int(10) unsigned | NO | MUL | NULL | | | valid | int(11) | NO | | NULL | | | invalid | int(11) | NO | | 0 | | | pplns_valid | int(11) | NO | | NULL | | | pplns_invalid | int(11) | NO | | 0 | | +---------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.02 sec)

Table looks fine, so just inconsistency in the sql files.

Also...

[root@pool1 sql]# mysql elacoin_mpos < 002_settings_update.sql [root@pool1 sql]# mysql elacoin_mpos < 003_monitoring_update.sql [root@pool1 sql]# mysql elacoin_mpos < 004_blocks_worker.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'worker_name' [root@pool1 sql]# mysql elacoin_mpos < 005_create_templates_table.sql ERROR 1050 (42S01) at line 1: Table 'templates' already exists [root@pool1 sql]# mysql elacoin_mpos < 006_txid_transactions.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'txid' [root@pool1 sql]# mysql elacoin_mpos < 007_accounts_update.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'failed_pins' [root@pool1 sql]# mysql elacoin_mpos < 008_shares_archive_optimization.sql [root@pool1 sql]# mysql elacoin_mpos < 009_tokentype_update.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'expiration'

TheSerapher commented 10 years ago

Don't import the updates. Base file is enough. Not a consistency issue :-) Base file includes all updates once merged.

Cheers, Sebastian

On 03.01.2014, at 14:10, vodkadrunkinski notifications@github.com wrote:

[root@pool1 sql]# mysql elacoin_mpos < 000_base_structure.sql [root@pool1 sql]# mysql elacoin_mpos < 001_pplns_statistics.sql ERROR 1060 (42S21) at line 1: Duplicate column name 'pplns_valid'

MariaDB [elacoin_mpos]> describe statistics_shares; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | account_id | int(10) unsigned | NO | MUL | NULL | | | block_id | int(10) unsigned | NO | MUL | NULL | | | valid | int(11) | NO | | NULL | | | invalid | int(11) | NO | | 0 | | | pplns_valid | int(11) | NO | | NULL | | | pplns_invalid | int(11) | NO | | 0 | | +---------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.02 sec)

Table looks fine, so just inconsistency in the sql files.

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