[OpenSIPS-Devel] OpenSIPS 1.11.2 and aliases table

[Steve Ames]

I vaguely recall this happening in 1.8.2 also but...

Completely fresh 1.11.2 install. Getting the following error:

Sep 17 17:05:48 [6151] ERROR:core:db_check_table_version: invalid version 1007 for table aliases found, expected 1009
Sep 17 17:05:48 [6151] ERROR:usrloc:register_udomain: error during table version check.

Versions table does show 1007.

Registrar-create.sql shows the following:

INSERT INTO version (table_name, table_version) values ('aliases','1007');
CREATE TABLE aliases (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    username CHAR(64) DEFAULT '' NOT NULL,
    domain CHAR(64) DEFAULT NULL,
    contact CHAR(255) DEFAULT '' NOT NULL,
    received CHAR(128) DEFAULT NULL,
    path CHAR(128) DEFAULT NULL,
    expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL,
    q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
    callid CHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
    cseq INT(11) DEFAULT 13 NOT NULL,
    last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
    flags INT(11) DEFAULT 0 NOT NULL,
    cflags INT(11) DEFAULT 0 NOT NULL,
    user_agent CHAR(255) DEFAULT '' NOT NULL,
    socket CHAR(64) DEFAULT NULL,
    methods INT(11) DEFAULT NULL,
    sip_instance CHAR(255) DEFAULT NULL,
    CONSTRAINT alias_idx UNIQUE (username, domain, contact, callid)
) ENGINE=MyISAM;

It seems to be missing the 'attr' column that 1009 requires.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20140917/2714c791/attachment.htm>