SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.parent_id' in 'field list'

[cppfuns]

@kesar You can view the information from the URL of this test. http://47.75.202.46:8000/actions?page=1

mysql> SELECT count(a.id) as cant FROM actions a JOIN transactions t ON a.transaction_id = t.id WHERE a.parent_id = 0; ERROR 1054 (42S22): Unknown column 'a.parent_id' in 'where clause'

[cppfuns]

void actions_table::create() { *m_session << "CREATE TABLE actions(" "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY," "account VARCHAR(12)," "transaction_id VARCHAR(64)," "seq SMALLINT," "parent INT DEFAULT NULL," "name VARCHAR(12)," "created_at DATETIME DEFAULT NOW(),"

parent and parent_id do not correspond