znote error create character

[Jpstafe]

Hello, I'm having trouble creating the character on the website, I'm using znote.. When I enter the ACC and the password I get an error. I get an error in :http://127.0.0.1/myaccount.php .. Any solution?

 

[Fjorda]

Refresh the page, and open the PHP error log, post the last few error messages here.

 

[Jpstafe]

Refresh the page, and open the PHP error log, post the last few error messages here.

Where do I look for the PHP Error Logs file?

 

[diegoknight95]

Where do I look for the PHP Error Logs file? i also

 

[Fjorda]

depends on the web server you're using, but I assume you're using xampp. So will most likely be in C:/xampp/ or in program files or wherever you installed it.

xampp/php/logs/php_error_log.txt

 

[Joriku]

If you managed to find the error logs, send them here + the source of the webpage you're using or contact me on discord. Same username <-

 

[Jpstafe]

depends on the web server you're using, but I assume you're using xampp. So will most likely be in C:/xampp/ or in program files or wherever you installed it.

xampp/php/logs/php_error_log.txt

I don't use Xampp I use Znote

 

[Fjorda]

I don't use Xampp I use Znote

I meant the web server you are using.

Xampp is a web server developed by Apache.
Znote is an OT website system.

For example, I've edited many znote systems using xampp as a local webb server

 

[Jpstafe]

I meant the web server you are using.

Xampp is a web server developed by Apache.
Znote is an OT website system.

I'm using Uniform Server

 

[Fjorda]

Should give you the 500 reason there, if not, check under the PHP tab in the menu, and see if there is an option there to see php error log

 

[Jpstafe]

View attachment 80034

Should give you the 500 reason there, if not, check under the PHP tab in the menu, and see if there is an option there to see php error log

[Wed Nov 15 22:44:15.880039 2023] [php:error] [pid 17232:tid 1820] [client ::1:53792] PHP Fatal error:  Uncaught mysqli_sql_exception: No se puede establecer una conexi\xc3\xb3n ya que el equipo de destino deneg\xc3\xb3 expresamente dicha conexi\xc3\xb3n in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:35\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(35): mysqli->__construct()\n#1 C:\\web\\UniServerZ\\www\\engine\\init.php(40): require_once('...')\n#2 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#3 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 35
[Wed Nov 15 22:44:17.927823 2023] [php:error] [pid 17232:tid 1816] [client ::1:53794] PHP Fatal error:  Uncaught mysqli_sql_exception: No se puede establecer una conexi\xc3\xb3n ya que el equipo de destino deneg\xc3\xb3 expresamente dicha conexi\xc3\xb3n in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:35\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(35): mysqli->__construct()\n#1 C:\\web\\UniServerZ\\www\\engine\\init.php(40): require_once('...')\n#2 C:\\web\\UniServerZ\\www\\characterprofile.php(1): require_once('...')\n#3 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 35, referer: http://localhost/us_splash/index.php
[Wed Nov 15 22:44:20.523193 2023] [php:error] [pid 17232:tid 1816] [client 127.0.0.1:53804] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:54\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(54): mysqli_query()\n#1 C:\\web\\UniServerZ\\www\\engine\\function\\users.php(1320): mysql_select_single()\n#2 C:\\web\\UniServerZ\\www\\engine\\init.php(55): user_data()\n#3 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#4 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 54
[Wed Nov 15 22:44:25.053171 2023] [php:error] [pid 17232:tid 1816] [client ::1:53807] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:54\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(54): mysqli_query()\n#1 C:\\web\\UniServerZ\\www\\engine\\function\\users.php(1320): mysql_select_single()\n#2 C:\\web\\UniServerZ\\www\\engine\\init.php(55): user_data()\n#3 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#4 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 54

 

[Joriku]

[Wed Nov 15 22:44:15.880039 2023] [php:error] [pid 17232:tid 1820] [client ::1:53792] PHP Fatal error:  Uncaught mysqli_sql_exception: No se puede establecer una conexi\xc3\xb3n ya que el equipo de destino deneg\xc3\xb3 expresamente dicha conexi\xc3\xb3n in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:35\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(35): mysqli->__construct()\n#1 C:\\web\\UniServerZ\\www\\engine\\init.php(40): require_once('...')\n#2 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#3 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 35
[Wed Nov 15 22:44:17.927823 2023] [php:error] [pid 17232:tid 1816] [client ::1:53794] PHP Fatal error:  Uncaught mysqli_sql_exception: No se puede establecer una conexi\xc3\xb3n ya que el equipo de destino deneg\xc3\xb3 expresamente dicha conexi\xc3\xb3n in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:35\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(35): mysqli->__construct()\n#1 C:\\web\\UniServerZ\\www\\engine\\init.php(40): require_once('...')\n#2 C:\\web\\UniServerZ\\www\\characterprofile.php(1): require_once('...')\n#3 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 35, referer: http://localhost/us_splash/index.php
[Wed Nov 15 22:44:20.523193 2023] [php:error] [pid 17232:tid 1816] [client 127.0.0.1:53804] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:54\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(54): mysqli_query()\n#1 C:\\web\\UniServerZ\\www\\engine\\function\\users.php(1320): mysql_select_single()\n#2 C:\\web\\UniServerZ\\www\\engine\\init.php(55): user_data()\n#3 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#4 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 54
[Wed Nov 15 22:44:25.053171 2023] [php:error] [pid 17232:tid 1816] [client ::1:53807] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php:54\nStack trace:\n#0 C:\\web\\UniServerZ\\www\\engine\\database\\connect.php(54): mysqli_query()\n#1 C:\\web\\UniServerZ\\www\\engine\\function\\users.php(1320): mysql_select_single()\n#2 C:\\web\\UniServerZ\\www\\engine\\init.php(55): user_data()\n#3 C:\\web\\UniServerZ\\www\\index.php(2): require_once('...')\n#4 {main}\n  thrown in C:\\web\\UniServerZ\\www\\engine\\database\\connect.php on line 54

Not sure if I can manually create a column well enough, try this.
Else you can manually add it in though phpmyadmin, which is easier.

ALTER TABLE accounts ADD premium_ends_at INT(15) NOT NULL DEFAULT 0;