need help with znote problem! please

[Jake Damico]

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\xampp\htdocs\engine\database\connect.php:54 Stack trace: #0 C:\xampp\htdocs\engine\database\connect.php(54): mysqli_query(Object(mysqli), 'SELECT id, `n...') #1 C:\xampp\htdocs\engine\function\users.php(1320): mysql_select_single('SELECT id, `n...') #2 C:\xampp\htdocs\engine\init.php(55): user_data('0', 'id', 'name', 'password', 'email', 'premium_ends_at') #3 C:\xampp\htdocs\myaccount.php(1): require_once('C:\\xampp\\htdocs...') #4 {main} thrown in C:\xampp\htdocs\engine\database\connect.php on line 54

Post automatically merged: Feb 27, 2023

fixed the above issue now this??

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'active_email' in 'field list' in C:\xampp\htdocs\engine\database\connect.php:90 Stack trace: #0 C:\xampp\htdocs\engine\database\connect.php(90): mysqli_query(Object(mysqli), 'INSERT INTO `zn...') #1 C:\xampp\htdocs\engine\database\connect.php(80): voidQuery('INSERT INTO `zn...') #2 C:\xampp\htdocs\engine\function\users.php(1261): mysql_insert('INSERT INTO `zn...') #3 C:\xampp\htdocs\register.php(148): user_create_account(Array, Array) #4 {main} thrown in C:\xampp\htdocs\engine\database\connect.php on line 90

 

[ForgottenNot]

same problem

 

[Allynn]

Guys, too much for start, headache guaranteed..
Better option, choose and download, engine from here, + ZnoteAcc
Releases · otland/forgottenserver (https://github.com/otland/forgottenserver/releases)

Or, if you messing with custom amazing engine. Look for this:

Solved - How do i add a new column to players in MySQL?

How do i add a new column to players called "points" in MySQL?

otland.net

Search in google, Adding a column, SQL, Insert.
You can also, edit schema.sql in notepad, or notepad ++, and add missing things there.

 

[ForgottenNot]

i solved this i add a new code at engine folder so i can handle premium_ends_at and the other parameter too

 

[Anciaveus]

maybe dont know ?

ALTER TABLE `znote_accounts` ADD `active_email` TINYINT(1) NOT NULL DEFAULT 0;

 

[danielek888]

i solved this i add a new code at engine folder so i can handle premium_ends_at and the other parameter too

can u say how u do this?

 

[omaraboud]

can u say how u do this?

You probably have a mismatch between your database and connect.php Make sure you imported right sql to ur database