|
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
tried to google this and it's a common error: https://www.devside.net/wamp-server/...-name-at-row-1
|
#3
|
|||
|
|||
Sign in error with xbtitfm 20
There was a problem with the system, but its solved now. Please try again to sign up.
|
#4
|
|||
|
|||
how to fix ? new installing xbtitfm 2.0 or 2,1 this problem.
|
#5
|
|||
|
|||
SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION'; Or downgrade php version |
#6
|
|||
|
|||
Good evening, where am I going to write this? I changed php from 7.1 to 5.5 and then to 5.6
|
#7
|
|||
|
|||
Quote:
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" |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
Quote:
Paste it between [mysqld] paste here port = 3306 save and restart mysql |
The Following User Says Thank You to mogo For This Useful Post: | ||
soneigr (17th January 2024)
|
#10
|
|||
|
|||
Thanks very much and working now !!!!!!!!!!!!!!!!!!!!
|
Tags |
20 , error , sign , xbtitfm |
|
|