I
I
ITLabLTD2018-08-31 13:44:53
mobile connection
ITLabLTD, 2018-08-31 13:44:53

Why can't I add groups, gateways, SIM-banks in the sim-server?

Hello everybody!
There is a problem with setting up a sim server for the GOIP gateway, the installation goes well, the web interface is available, but when you try to add a group, sim bank or gateway, a mysql error occurs.
When adding a group, the message "query: Field 'scheduler_id' doesn't have a default value" appears.
When adding a SIM bank: "query: Incorrect integer value: '' for column 'short_time' at row 1
" : "query: Field 'line_status' doesn't have a default value"
I dug into the sources, it turns out that in mysql tables there are not null fields without a default value, and when adding a record to the tables, the PHP script does not fill in these fields, hence the error, but I did not find on the Internet that someone faced similar problems . Can someone explain what I'm doing wrong?
I downloaded the sim server from here: en.dbltek.com/Software-Download.html
tried almost all versions I could find, from 1.2 to the latest 1.9.1, the same errors everywhere
Tried different OS ubuntu 16.04 and centos7, different versions of php and muscle, always the same problem.
OS: ubuntu 16.04 and centos7
Mysql: 5.5, 5.7
PHP: 5.5, 5.6
I was already going to rewrite PHP scripts, but I don’t really want to, considering that I will have to write partially in the blind, because I don’t know which fields in the database are used for what.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
solalex, 2018-08-31
@ITLabLTD

Disable mysql mode: "Strict Mode"

SET @@GLOBAL.sql_mode= ''
SET @@SESSION.sql_mode= ''

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question