AAC Failed To Create Account [GesiorAAC]

[Extrodus]

Error:

SQLSTATE:	HY000
Driver code:	1366
Error message:	Incorrect integer value: '' for column 'vip_time' at row 1

Failed to create account.


Trying to create an account and getting this error, anyone have any ideas?

 

[Gesior.pl]

Edit mysql config (Ubuntu with mariadb: /etc/mysql/mariadb.conf.d/50-server.conf). Add there:

sql_mode=''

Temporary solution: Execute in mysql (phpmyadmin etc.) SET GLOBAL sql_mode='';. It will fix problem until next mysql restart.

 

[Extrodus]

@Gesior.pl - Thank you so much for the response, unfortunately these are the files I have in /etc/mysql/. Should I just modify mysql.cnf? Currently using Apache2 if that helps.

And this was the line used to install mysql:
sudo apt-get install mysql-server mysql-client

 

[Gesior.pl]

It should be added in my.cnf or mysql.cnf.

 

[Extrodus]

It should be added in my.cnf or mysql.cnf.

Modified mysql.cnf to look like this

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
sql_mode=''

And now the website returns:

Error occured![/HEADING][/HEADING][/HEADING]
[HEADING=2][HEADING=2]Error ID:[/HEADING][/HEADING]
[HEADING=2][HEADING=2]More info: CANNOT CONNECT TO DATABASE: SQLSTATE[HY000] [2002] No such file or directory[/HEADING][/HEADING]
[HEADING=2][HEADING=2][/HEADING][/HEADING]
[HEADING=2][HEADING=2]File: /var/www/html/classes/database_mysql.php   Line: 22[/HEADING][/HEADING]
[HEADING=2][HEADING=2]File: /var/www/html/classes/database.php   Line: 199[/HEADING][/HEADING]
[HEADING=2][HEADING=2]File: /var/www/html/pages/latestnews.php   Line: 22[/HEADING][/HEADING]
[HEADING=2][HEADING=2]File: /var/www/html/system/load.page.php   Line: 7[/HEADING][/HEADING]
[HEADING=2][HEADING=2]File: /var/www/html/index.php   Line: 37

Also tried editing /conf.d/mysql.cnf and it didnt work
Tested the "Temporary" solution, that did work for now.

 

[Roddet]

Search for [mysqld] on files that Gesior said or any other file and paste there

 

[Extrodus]

Search for [mysqld] on files that Gesior said or any other file and paste there

Found /etc/mysql/mysql.conf.d/mysqld.cnf and added sql_mode='' to the bottom of it, rebooted the PC and it still works!
Thanks for the help guys <3

 

[diegoknight95]

help i have the same error on phpmyadmin 7.2 ubuntu 18.04