We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: Ukrtelecom (ukrtelecom)
WORK - insert into stat_wtmp (bill_serv_id, login, domain_name, calling_station_id, called_station_id, nas_ip_address, framed_ip_address, nas_port_id, session_id, connect_info, time_begin, session_active, cur_input_octets, cur_output_octets, /* connect_info,*/ time_end ) values(:CUR_BILL_SERVICE_ID, :login, :domain_name, :caller_id, :called_id, :nas_ip_addr, :user_ip_addr, :nas_port_id, :session_id, :connect_info, :packet_timestamp, :cur_session_active, :input_octets, :output_octets, /* :connect_info,*/ :packet_timestamp);
NOT WORK - insert into stat_wtmp (bill_serv_id, login, domain_name, calling_station_id, called_station_id, nas_ip_address, framed_ip_address, nas_port_id, session_id, connect_info, time_begin, session_active, cur_input_octets, cur_output_octets, connect_info, time_end ) values(:CUR_BILL_SERVICE_ID, :login, :domain_name, :caller_id, :called_id, :nas_ip_addr, :user_ip_addr, :nas_port_id, :session_id, :connect_info, :packet_timestamp, :cur_session_active, :input_octets, :output_octets, :connect_info, :packet_timestamp);
Dynamic SQL Error. SQL error code = -206. unknown ISC error 336397210. unknown ISC error 336397208. FIELD - connect_info; TABLE STAT_WTMP:
CREATE TABLE STAT_WTMP ( ID_WTMP_ITEM ID /* ID = INTEGER DEFAULT 0 */, BILL_SERV_ID ID /* ID = INTEGER DEFAULT 0 */, NAS_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */, NAS_PORT_ID BIGINTEGER /* BIGINTEGER = BIGINT */, TIME_BEGIN ACCOUNT /* ACCOUNT = INTEGER */, TIME_END ACCOUNT /* ACCOUNT = INTEGER */, SESSION_TIME COUNTER /* COUNTER = INTEGER */, CALLING_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */, CALLED_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */, FRAMED_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */, SESSION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */, INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */, CUR_INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */, OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */, CUR_OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */, CONNECT_INFO VARCHAR64 /* VARCHAR64 = VARCHAR(64) */, LOGIN VARCHAR32 /* VARCHAR32 = VARCHAR(32) */, DOMAIN_NAME VARCHAR64 /* VARCHAR64 = VARCHAR(64) */, SESSION_ACTIVE TRUEFALSE DEFAULT 1 /* TRUEFALSE = INTEGER */, DATE_WR DATETIME DEFAULT 'now' /* DATETIME = TIMESTAMP */, SPEED_UP VARCHAR16 /* VARCHAR16 = VARCHAR(16) */, SPEED_DOWN VARCHAR16 /* VARCHAR16 = VARCHAR(16) */ );
The text was updated successfully, but these errors were encountered:
Commented by: @dyemanov
Not a bug. You cannot insert twice into the same column.
Sorry, something went wrong.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Won't Fix [ 2 ]
Commented by: Ukrtelecom (ukrtelecom)
Yeh, thanks very much! )))))) In Firebird 1.5.4 it's is normal for interpretator!
Upgrade fbclient and firebird.msg on your client machine and you'll see a human readable error message that clearly explains the issue.
I use IBExpert! When i upgrade my fbclient and firebird.msg on my client machine?
Workflow: jira [ 13872 ] => Firebird [ 14135 ]
security: Managers [ 10013 ] =>
status: Resolved [ 5 ] => Closed [ 6 ]
No branches or pull requests
Submitted by: Ukrtelecom (ukrtelecom)
WORK -
insert into stat_wtmp (bill_serv_id,
login,
domain_name,
calling_station_id,
called_station_id,
nas_ip_address,
framed_ip_address,
nas_port_id,
session_id,
connect_info,
time_begin,
session_active,
cur_input_octets,
cur_output_octets,
/* connect_info,*/
time_end
)
values(:CUR_BILL_SERVICE_ID,
:login,
:domain_name,
:caller_id,
:called_id,
:nas_ip_addr,
:user_ip_addr,
:nas_port_id,
:session_id,
:connect_info,
:packet_timestamp,
:cur_session_active,
:input_octets,
:output_octets,
/* :connect_info,*/
:packet_timestamp);
NOT WORK -
insert into stat_wtmp (bill_serv_id,
login,
domain_name,
calling_station_id,
called_station_id,
nas_ip_address,
framed_ip_address,
nas_port_id,
session_id,
connect_info,
time_begin,
session_active,
cur_input_octets,
cur_output_octets,
connect_info,
time_end
)
values(:CUR_BILL_SERVICE_ID,
:login,
:domain_name,
:caller_id,
:called_id,
:nas_ip_addr,
:user_ip_addr,
:nas_port_id,
:session_id,
:connect_info,
:packet_timestamp,
:cur_session_active,
:input_octets,
:output_octets,
:connect_info,
:packet_timestamp);
Dynamic SQL Error.
SQL error code = -206.
unknown ISC error 336397210.
unknown ISC error 336397208.
FIELD - connect_info;
TABLE STAT_WTMP:
CREATE TABLE STAT_WTMP (
ID_WTMP_ITEM ID /* ID = INTEGER DEFAULT 0 */,
BILL_SERV_ID ID /* ID = INTEGER DEFAULT 0 */,
NAS_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */,
NAS_PORT_ID BIGINTEGER /* BIGINTEGER = BIGINT */,
TIME_BEGIN ACCOUNT /* ACCOUNT = INTEGER */,
TIME_END ACCOUNT /* ACCOUNT = INTEGER */,
SESSION_TIME COUNTER /* COUNTER = INTEGER */,
CALLING_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
CALLED_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
FRAMED_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */,
SESSION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CUR_INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CUR_OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CONNECT_INFO VARCHAR64 /* VARCHAR64 = VARCHAR(64) */,
LOGIN VARCHAR32 /* VARCHAR32 = VARCHAR(32) */,
DOMAIN_NAME VARCHAR64 /* VARCHAR64 = VARCHAR(64) */,
SESSION_ACTIVE TRUEFALSE DEFAULT 1 /* TRUEFALSE = INTEGER */,
DATE_WR DATETIME DEFAULT 'now' /* DATETIME = TIMESTAMP */,
SPEED_UP VARCHAR16 /* VARCHAR16 = VARCHAR(16) */,
SPEED_DOWN VARCHAR16 /* VARCHAR16 = VARCHAR(16) */
);
The text was updated successfully, but these errors were encountered: