Fatal error on register (MYACC)

[SixNine]

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value in C:\UniServerZ\www\system\libs\pot\OTS_Base_DB.php:101 Stack trace: #0 C:\UniServerZ\www\system\libs\pot\OTS_Base_DB.php(101): PDO->query() #1 C:\UniServerZ\www\system\libs\pot\OTS_Account.php(140): OTS_Base_DB->query() #2 C:\UniServerZ\www\system\pages\createaccount.php(120): OTS_Account->create() #3 C:\UniServerZ\www\index.php(422): require('C:\\UniServerZ\\w...') #4 {main} thrown in C:\UniServerZ\www\system\libs\pot\OTS_Base_DB.php on line 101

Hi so everything was just fine few weeks ago but now since im using new windows i cant really setup files correctly or new problem in code appeared im not sure, whats going on

 

[Yalasari]

Is your "id" field marked as PRIMARY_KEY and does it have AUTO_INCREMENT enabled?
If not, change it and then try to register again.

 

[SixNine]

Is your "id" field marked as PRIMARY_KEY and does it have AUTO_INCREMENT enabled?
If not, change it and then try to register again.

Yea it is as a primary but it doesnt have auto_increment and i cant enable it because i dont really see it

https://i.gyazo.com/2e6c7b1b179b0f922da3e62415501afb.png

 

[Yalasari]

Click "Change" button and then you should be able to find A_I or AUTO_INCREMEMT checkbox

 

[SixNine]

Click "Change" button and then you should be able to find A_I or AUTO_INCREMEMT checkbox

Yea it creates now but it gives this shit
Deprecated: __autoload() is deprecated, use spl_autoload_register() instead in C:\UniServerZ\www\system\libs\phpmailer\PHPMailerAutoload.php on line 45

And in account manager

Notice: Trying to access array offset on value of type bool in C:\UniServerZ\www\system\libs\pot\OTS_Account.php on line 784

 

[Yalasari]

These warnings appear because you are probably using the newest version of PHP which deprecated (they still work although they recommend to not use them) some functions and modified behavior of others. Unless you are experienced enough to fix it by yourself I don't recommend doing this because it isn't necessary. However, if you want to get rid of these warnings you can try downgrading your PHP version.

 

[slaw]

Yea it creates now but it gives this shit
Deprecated: __autoload() is deprecated, use spl_autoload_register() instead in C:\UniServerZ\www\system\libs\phpmailer\PHPMailerAutoload.php on line 45

And in account manager

Notice: Trying to access array offset on value of type bool in C:\UniServerZ\www\system\libs\pot\OTS_Account.php on line 784

You probably using PHP 7.4, which MyAAC hasn't been tested on yet.

The first warning I fixed here: Fix "Deprecated: __autoload() is deprecated" · slawkens/myaac@441bfe7 (https://github.com/slawkens/myaac/commit/441bfe74c1d28accdb407ebc33808be1db9d8114#diff-b8c1289d2fec6548dac037175d0cf028)

The second I will look into it later when I'm back from work.

 

[slaw]

Hello @SixNine,

The second Notice is now fixed too:

Fix some 7.4 notices about OTS_Account bans · slawkens/myaac@259cda1

Example: Notice: Trying to access array offset on value of type bool in C:\UniServerZ\www\system\libs\pot\OTS_Account.php on line 784

github.com