[Rehan]

So, I was right about that the database structure and default data is not being installed properly during the SMF setup.

Which MySQL server version are you running? Perhaps SMF doesn't support the MySQL version you are running (too old or too new maybe).

You can use the command below to get the version information or use a tool like phpMyAdmin / Adminer:

Code: (Select All)

mysql --version

Example output:

Code: (Select All)

mysql  Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.28

Perhaps also the database engine is not supported.

---

Look what I found: https://www.simplemachines.org/community...c=560047.0 and https://www.simplemachines.org/community...c=555076.0

You said you were using Debian with quite recent software (kinda). That could mean that your MySQL server is most likely MariaDB instead of the Oracle MySQL server.

Seems like SMF isn't compatible to MariaDB MySQL or your configuration causes some issues. The second topic hints that you might have to change the default MySQL database engine.

Can you post your my.cnf file?

I got the output same as you used as example. and i searched for my.cnf and found 3 files.I know we need only mysql cnf files btw i have posted all of those

Here are these 

/etc/mysql//my.cnf

Code: (Select All)

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# 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.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

/etc/alternatives/my.cnf

Code: (Select All)

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# 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.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]



And the third one lists them. btw here is the code

Code: (Select All)

auto
/etc/mysql/my.cnf

/etc/mysql/mariadb.cnf
200
/etc/mysql/my.cnf.fallback
100