Bravo List - Sign in error with xbtitfm 20

Bravo List (http://www.bvlist.com/index.php)

- xBTiT (http://www.bvlist.com/forumdisplay.php?f=30)

- - Sign in error with xbtitfm 20 (http://www.bvlist.com/showthread.php?t=11188)

Sign in error with xbtitfm 20

Hello, i successfully installed xbtitfm 20 on my server, everything seems to be working quite well, but when i try to sign in i always get the following error: Incorrect integer value: '' for column 'userid' at row 1
I also can't sign up...
how can i fix the error?
Thanks in advance for the answers.

tried to google this and it's a common error: https://www.devside.net/wamp-server/...-name-at-row-1

Sign in error with xbtitfm 20

There was a problem with the system, but its solved now. Please try again to sign up.

how to fix ? new installing xbtitfm 2.0 or 2,1 this problem.

Quote:

Originally Posted by soneigr (Post 57221)

how to fix ? new installing xbtitfm 2.0 or 2,1 this problem.

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

Or downgrade php version

Quote:

Originally Posted by mogo (Post 57223)

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

Or downgrade php version

Good evening, where am I going to write this? I changed php from 7.1 to 5.5 and then to 5.6

Quote:

Originally Posted by soneigr (Post 57224)

Good evening, where am I going to write this? I changed php from 7.1 to 5.5 and then to 5.6

If you set globals in MySQL:

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';
This will not set it PERMANENTLY, and it will revert after every restart.

So you should set this in your config file (e.g. /etc/mysql/my.cnf in the [mysqld] section), so that the changes remain in effect after MySQL restart:

Config File: /etc/mysql/my.cnf

[mysqld]
sql_mode = "NO_ENGINE_SUBSTITUTION"

I did it like you told me in this file is it correct?

Code:

[client]

#password    = your_password

port        = 3306

socket        = /tmp/mysql.sock



[mysqld]

port        = 3306

socket        = /tmp/mysql.sock

datadir = /www/server/data

default_storage_engine = InnoDB

skip-external-locking

key_buffer_size = 8M

max_allowed_packet = 100G

table_open_cache = 32

sort_buffer_size = 256K

net_buffer_length = 4K

read_buffer_size = 128K

read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 4M

thread_cache_size = 4

query_cache_size = 4M

tmp_table_size = 8M



#skip-name-resolve

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

[mysqld]

sql_mode = "NO_ENGINE_SUBSTITUTION" 

log-bin=mysql-bin

binlog_format=mixed

server-id = 1

expire_logs_days = 10

slow_query_log=1

slow-query-log-file=/www/server/data/mysql-slow.log

long_query_time=3

#log_queries_not_using_indexes=on





innodb_data_home_dir = /www/server/data

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /www/server/data

innodb_buffer_pool_size = 16M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

innodb_max_dirty_pages_pct = 90

innodb_read_io_threads = 1

innodb_write_io_threads = 1



[mysqldump]

quick

max_allowed_packet = 500M



[mysql]

no-auto-rehash



[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M



[mysqlhotcopy]

interactive-timeout

Quote:

Originally Posted by soneigr (Post 57227)

I did it like you told me in this file is it correct?

Code:

[client]

#password    = your_password

port        = 3306

socket        = /tmp/mysql.sock



[mysqld]

port        = 3306

socket        = /tmp/mysql.sock

datadir = /www/server/data

default_storage_engine = InnoDB

skip-external-locking

key_buffer_size = 8M

max_allowed_packet = 100G

table_open_cache = 32

sort_buffer_size = 256K

net_buffer_length = 4K

read_buffer_size = 128K

read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 4M

thread_cache_size = 4

query_cache_size = 4M

tmp_table_size = 8M



#skip-name-resolve

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

[mysqld]

sql_mode = "NO_ENGINE_SUBSTITUTION" 

log-bin=mysql-bin

binlog_format=mixed

server-id = 1

expire_logs_days = 10

slow_query_log=1

slow-query-log-file=/www/server/data/mysql-slow.log

long_query_time=3

#log_queries_not_using_indexes=on





innodb_data_home_dir = /www/server/data

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /www/server/data

innodb_buffer_pool_size = 16M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

innodb_max_dirty_pages_pct = 90

innodb_read_io_threads = 1

innodb_write_io_threads = 1



[mysqldump]

quick

max_allowed_packet = 500M



[mysql]

no-auto-rehash



[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M



[mysqlhotcopy]

interactive-timeout

Paste it between
[mysqld]
paste here
port = 3306

save and restart mysql

Quote:

Originally Posted by mogo (Post 57228)

Paste it between
[mysqld]
paste here
port = 3306

save and restart mysql

Thanks very much and working now !!!!!!!!!!!!!!!!!!!!