[OpenSIPS-Users] OpenSIPS Control Panel Installation Confusion

[Bogdan-Andrei Iancu]

Hi Brian,

This resulted from updating the mysql script without updating the docs - 
keep only the bigint cdr_id column.

Regards,
Bogdan

brianpocock wrote:
> Right this is really confusing me, In the installation documentation for the
> opensips control panel says to add a new column to the acc table called
> cdr_id int(11).   I've done this and moved onto the next step, adding a
> stored procedure, when adding this stored procedure I get the error ERROR
> 1060 (42S21) at line 2: Duplicate column name 'cdr_id'
> Looking at line 2 of the stored procedure:
> ALTER TABLE acc ADD COLUMN cdr_id bigint(11) not null default 0 AFTER time; 
> Its doing the same thing that the documentation already told me to do
> earlier but this time with a bigint(11).
>
> Should I just remove this line from the stored procedure?   Will it not work
> without it?   Does it need to be bigint or int?
> Thanks :)
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro