Hello Ali, I'm inserting priority column values through insert query in my application. But, I'm getting this error. Column counts error resolved but sqlbox halts.
So please resolve this error as soon as possible. Thanks Ammar Ali On Thu, Feb 19, 2015 at 11:30 PM, Ali Kashif <syedalikas...@gmail.com> wrote: > Check your Insert query, > > 2015-02-19 17:14:50 [27305] [2] ERROR: MYSQL: Column count doesn't match > value count at row 1 > 2015-02-19 17:14:50 [27305] [1] ERROR: MYSQL: Column count doesn't match > value count at row 1 > > > > On Thu, Feb 19, 2015 at 2:50 PM, Ammar Ali <ammarali3...@gmail.com> wrote: > >> Hello All, >> >> I'm adding a column "*priority int(3)*" in sqlbox insert and log tables >> (in *sqlbox_mysql.h*) file. >> But, When I'm sending sms through my http application into sqlbox insert >> table "*send_sms*", >> then I'm getting below error in sqlbox terminal window: >> >> 2015-02-19 17:13:52 [27305] [1] DEBUG: Started thread 2 >> (sqlbox.c:bearerbox_to_s >> ql) >> 2015-02-19 17:13:52 [27305] [2] DEBUG: Thread 2 >> (sqlbox.c:bearerbox_to_sql) >> maps >> to pid 27305. >> 2015-02-19 17:14:50 [27305] [2] ERROR: MYSQL: Column count doesn't match >> value count at row 1 >> 2015-02-19 17:14:50 [27305] [1] ERROR: MYSQL: Column count doesn't match >> value count at row 1 >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox() [0x4369fc] >> 2015-02-19 17:14:50 [27305] [2] PANIC: /lib64/libpthread.so.0(+0xf710) >> [0x7fec5c956710] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox() [0x42af42] >> 2015-02-19 17:14:50 [27305] [2] PANIC: >> ./sqlbox(octstr_duplicate_real+0x2e) [0x42e4ee] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox() [0x42ead9] >> 2015-02-19 17:14:50 [27305] [2] PANIC: >> ./sqlbox(octstr_format_valist_real+0x19a) [0x42f1ea] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox(octstr_format+0x8b) >> [0x42f4db] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox(mysql_save_msg+0x401) >> [0x40d151] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox() [0x40b6dc] >> 2015-02-19 17:14:50 [27305] [2] PANIC: ./sqlbox() [0x420899] >> 2015-02-19 17:14:50 [27305] [2] PANIC: /lib64/libpthread.so.0(+0x79d1) >> [0x7fec5c94e9d1] >> 2015-02-19 17:14:50 [27305] [2] PANIC: /lib64/libc.so.6(clone+0x6d) >> [0x7fec5c00b8fd] >> Segmentation fault >> root@ip-192-168-1-101 [sqlbox/gw]# >> >> >> Please resolve this problem as soon as possible. >> >> >> Thanks >> Ammar Ali >> >> >> >> >> >
