[iDomo]

I can join the server which I have portfowarded temporarily for now, uploaded the DB and connected the MySQL DB to the script. Whenever I log off, the account is not saved in the DB.


I checked my MySQL log and found this:

Код:

[22:20:13] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'banned' doesn't have a default value
[22:22:31] [ERROR] CMySQLQuery::Execute[OnServerSetItem(iii)] - (error #1364) Field 'active' doesn't have a default value
[22:22:33] [ERROR] CMySQLQuery::Execute[OnServerSetItem(iii)] - (error #1364) Field 'active' doesn't have a default value
[22:28:13] [ERROR] CMySQLQuery::Execute[OnServerSetItem(iii)] - (error #1364) Field 'active' doesn't have a default value

I have little experience with MySQL.

[iDomo]

Bump. I really need this fixed. I know I need to set default values to 0 but don't know where to.

[Firewire]

Hello IDomo!

Can you please send a screenshot of your database structure displaying the fields 'banned' and also 'active'.

This happens because the Strict Trans Mode is enabled in your mysql.ini file.

If you look at your table carefully you'll notice that these field names have no default value set, so I suggest editing and setting to 'None'.

Hope all gets resolved,
Firewire.

[iDomo]

Where can I find these databases in PHPMyAdmin?

[Firewire]

When your gamemode first initialises it will use a mysql_connect call to a host defined in your gamemode.

Connect to that using the username and password (do not post them in here).

Thanks,
Firewire.

[iDomo]

I've connected the script to MySQL using PhpMyAdmin. I just don't know where to find these items to set the default value.

[iDomo]

Okay so I've found banned http://prntscr.com/b4qf5a and active http://prntscr.com/b4qfhm

[Firewire]

You say you've found them, have you altered the default values of them too?

- Firewire.

[iKevin]

The last "item" in the line (ex. banned line) is distinct values. Click there and try to make them "None".

[iDomo]

They're already set on none, so I set them "defined as:0".

Apparently the errors are gone but the rest of the structure is giving me errors about values. Do I need to change them all to 0?