Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > xBTiT
Reply
  #1  
Old 30th July 2017, 09:50
bluking96's Avatar
bluking96 bluking96 is offline
Member
 
Join Date: Jul 2017
Posts: 2
Default 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.
Reply With Quote
  #2  
Old 30th July 2017, 10:40
Johnny Utah's Avatar
Johnny Utah Johnny Utah is offline
Senior Member
 
Join Date: Feb 2009
P2P
Posts: 129
Default
tried to google this and it's a common error: https://www.devside.net/wamp-server/...-name-at-row-1
Reply With Quote
  #3  
Old 17th March 2019, 11:13
Henrysix's Avatar
Henrysix Henrysix is offline
Member
 
Join Date: Feb 2019
Sri Lanka
Posts: 11
Default Sign in error with xbtitfm 20
There was a problem with the system, but its solved now. Please try again to sign up.
Reply With Quote
  #4  
Old 17th January 2024, 10:13
soneigr's Avatar
soneigr soneigr is offline
Senior Member
 
Join Date: Dec 2023
Greece
Posts: 55
Default
how to fix ? new installing xbtitfm 2.0 or 2,1 this problem.
Reply With Quote
  #5  
Old 17th January 2024, 11:07
mogo's Avatar
mogo mogo is offline
Senior Member
 
Join Date: Jun 2020
P2P
Posts: 92
Default
Quote:
Originally Posted by soneigr View Post
how to fix ? new installing xbtitfm 2.0 or 2,1 this problem.

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

Or downgrade php version
Reply With Quote
  #6  
Old 17th January 2024, 11:36
soneigr's Avatar
soneigr soneigr is offline
Senior Member
 
Join Date: Dec 2023
Greece
Posts: 55
Default
Quote:
Originally Posted by mogo View Post
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
Reply With Quote
  #7  
Old 17th January 2024, 12:42
mogo's Avatar
mogo mogo is offline
Senior Member
 
Join Date: Jun 2020
P2P
Posts: 92
Default
Quote:
Originally Posted by soneigr View Post
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"
Reply With Quote
  #8  
Old 17th January 2024, 13:06
soneigr's Avatar
soneigr soneigr is offline
Senior Member
 
Join Date: Dec 2023
Greece
Posts: 55
Default
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
Reply With Quote
  #9  
Old 17th January 2024, 13:29
mogo's Avatar
mogo mogo is offline
Senior Member
 
Join Date: Jun 2020
P2P
Posts: 92
Default
Quote:
Originally Posted by soneigr View Post
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
Reply With Quote
The Following User Says Thank You to mogo For This Useful Post:
soneigr (17th January 2024)
  #10  
Old 17th January 2024, 13:42
soneigr's Avatar
soneigr soneigr is offline
Senior Member
 
Join Date: Dec 2023
Greece
Posts: 55
Default
Quote:
Originally Posted by mogo View Post
Paste it between
[mysqld]
paste here
port = 3306

save and restart mysql
Thanks very much and working now !!!!!!!!!!!!!!!!!!!!
Reply With Quote
Reply

Tags
20 , error , sign , xbtitfm

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 11:06. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.