MyAAC v0.7.12

[slaw]

[Thu May 04 10:42:14.222260 2017] [:error] [pid 1844:tid 2020] [client ::1:60293] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' in C:\\UniServerZ\\www\\system\\libs\\pot\\OTS_Base_DB.php:100\nStack trace:\n#0 C:\\UniServerZ\\www\\system\\libs\\pot\\OTS_Base_DB.php(100): PDO->query('INSERT INTO `my...')\n#1 C:\\UniServerZ\\www\\system\\libs\\pot\\OTS_Account.php(896): OTS_Base_DB->query('INSERT INTO `my...')\n#2 C:\\UniServerZ\\www\\install\\steps\\finish.php(99): OTS_Account->logAction('Account created...')\n#3 C:\\UniServerZ\\www\\install\\index.php(40): require('C:\\\\UniServerZ\\\\w...')\n#4 {main}\n  thrown in C:\\UniServerZ\\www\\system\\libs\\pot\\OTS_Base_DB.php on line 100, referer: http://localhost/install/

Go to your phpmyadmin, select your database and execute this:

ALTER TABLE `myaac_account_actions` MODIFY `ip` INT(11) NOT NULL DEFAULT 0;

Anyway, this is strange. I don't understand why its returning NULL

 

[slaw]

Warning: DOMDocument::loadXML(): Input is not proper UTF-8, indicate encoding ! Bytes: 0xEA 0x20 0x70 0x6F in Entity, line: 1 in C:\xampp\htdocs\new\system\libs\pot\OTS_ServerInfo.php on line 124

Fatal error: Call to a member function getElementsByTagName() on null in C:\xampp\htdocs\new\system\libs\pot\OTS_InfoRespond.php on line 191

Try editing system\libs\pot\OTS_ServerInfo.php
Change:

if(!$info->loadXML( $status->getBuffer()))

to:

if(!$info->loadXML( utf8_encode($status->getBuffer())))

And tell me if it helped.

 

[Dreww]

Go to your phpmyadmin, select your database and execute this:

ALTER TABLE `myaac_account_actions` MODIFY `ip` INT(11) NOT NULL DEFAULT 0;

Anyway, this is strange. I don't understand why its returning NULL

Now is working! Thanks a lot

 

[Ancienciq]

Check this screenshot!

i have this error when creating new character how to fix it?

 

[slaw]

Check this screenshot!

i have this error when creating new character how to fix it?

You trying to submit empty formular or not filled all fields?

Anyway, this has been fixed.

Download latest version here: Releases · slawkens/myaac · GitHub

 

[_M4G0_]

Try editing system\libs\pot\OTS_ServerInfo.php
Change:

if(!$info->loadXML( $status->getBuffer()))

to:

if(!$info->loadXML( utf8_encode($status->getBuffer())))

And tell me if it helped.

Solved
Server Online » Players Online: 0 / 0 » Monsters: 58535 » Uptime: 0h 0m

 

[_M4G0_]

Create Character


After Submit


MyAAC latest version is 0.0.5. You're using the latest version.

 

[tommy91]

Yeeah, um, i am getting this!
And i am on the latest.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' in E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('INSERT INTO `my...') #1 E:\xampp\htdocs\system\libs\pot\OTS_Account.php(896): OTS_Base_DB->query('INSERT INTO `my...') #2 E:\xampp\htdocs\system\pages\accountmanagement.php(932): OTS_Account->logAction('Created charact...') #3 E:\xampp\htdocs\index.php(188): require('E:\\xampp\\htdocs...') #4 {main} thrown in E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

 

[slaw]

Create Character
View attachment 29814

After Submit
View attachment 29815

MyAAC latest version is 0.0.5. You're using the latest version.

You can't be using the latest version. Cause it has been fixed. I tried the same on my AAC and its working. It shows error, cause you can't create name with 'GM'.

Yeeah, um, i am getting this!
And i am on the latest.

But you have probably installed
Go to your phpmyadmin, select your database and execute this:

ALTER TABLE `myaac_account_actions` MODIFY `ip` INT(11) NOT NULL DEFAULT 0;

 

[_M4G0_]

You can't be using the latest version. Cause it has been fixed. I tried the same on my AAC and its working. It shows error, cause you can't create name with 'GM'.
[/code]

 

[_M4G0_]

Cant Create but dont show any error

 

[tommy91]

You can't be using the latest version. Cause it has been fixed. I tried the same on my AAC and its working. It shows error, cause you can't create name with 'GM'.


But you have probably installed
Go to your phpmyadmin, select your database and execute this:

ALTER TABLE `myaac_account_actions` MODIFY `ip` INT(11) NOT NULL DEFAULT 0;

Ive reinstalled using that 0.0.5 and it still does that

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' in E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('INSERT INTO `my...') #1 E:\xampp\htdocs\system\libs\pot\OTS_Account.php(896): OTS_Base_DB->query('INSERT INTO `my...') #2 E:\xampp\htdocs\system\pages\accountmanagement.php(932): OTS_Account->logAction('Created charact...') #3 E:\xampp\htdocs\index.php(188): require('E:\\xampp\\htdocs...') #4 {main} thrown in E:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

 

[Ancienciq]

You trying to submit empty formular or not filled all fields?

Anyway, this has been fixed.

Download latest version here: Releases · slawkens/myaac · GitHub

no i was filling it correctly, i have downloaded latest version and this still happens

 

[slaw]

Ive reinstalled using that 0.0.5 and it still does that

As I said, you need to execute that query in database.

Check this screenshot!

i have this error when creating new character how to fix it?

Create Character
View attachment 29814

After Submit
View attachment 29815

MyAAC latest version is 0.0.5. You're using the latest version.

Ok now fixed, seems i didn't upload it correctly last time.

Download latest version here: https://github.com/slawkens/myaac/archive/master.zip

 

[Ancienciq]

Thanks!

 

[_M4G0_]

As I said, you need to execute that query in database.





Ok now fixed, seems i didn't upload it correctly last time.

Download latest version here: https://github.com/slawkens/myaac/archive/master.zip

Ok
i have removed from characters.php this line

if($ban['type'] != 2 and $ban['type'] != 4)

for solve this error
Notice: Undefined index: type in C:\xampp\htdocs\new\system\pages\characters.php on line 622
Notice: Undefined index: type in C:\xampp\htdocs\new\system\pages\characters.php on line 622
Account Information
Created: 1 January 1970, 1:00 am [Banished until 05 May 2017, 06:50]

 

[slaw]

Ok
i have removed from characters.php this line

if($ban['type'] != 2 and $ban['type'] != 4)

for solve this error
Notice: Undefined index: type in C:\xampp\htdocs\new\system\pages\characters.php on line 622
Notice: Undefined index: type in C:\xampp\htdocs\new\system\pages\characters.php on line 622
Account Information
Created: 1 January 1970, 1:00 am [Banished until 05 May 2017, 06:50]

Good job. I removed it too. It wasn't needed.

 

[tommy91]

This is what i get now, after testing with Uniserv.

 

[slaw]

This is what i get now, after testing with Uniserv.

Use this version: https://github.com/slawkens/myaac/archive/master.zip

 

[slaw]

I have launched a demo site, where you can also preview some awful templates!

Link: Latest News - Forgotten