Duplicate column name 'pplns_valid'

[vodkadrunkinski]

[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]

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 [email protected] 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.