• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Znote_News (News admin panel)

Saint Spear

Veteran OT User
Joined
Jun 22, 2016
Messages
1,547
Solutions
18
Reaction score
379
znote_news table looks like this.
SQL:
CREATE TABLE IF NOT EXISTS `znote_news` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(30) NOT NULL,
    `text` text NOT NULL,
    `date` int(11) NOT NULL,
    `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

The query selects the database znote_news using n as an alias. So
SQL:
`n`.`pid`
means it tries to do something with the pid column in the znote_news table. (pid is an alias for player id).

Look at your database with etc phpmyadmin, look into the znote_news table. Do you have the pid column? Could be something goes wrong under the installation of the tables.

You could try to drop all znote_ tables and re-add them, although you said you already have tried this?
 
znote_news table looks like this.
SQL:
CREATE TABLE IF NOT EXISTS `znote_news` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(30) NOT NULL,
    `text` text NOT NULL,
    `date` int(11) NOT NULL,
    `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

The query selects the database znote_news using n as an alias. So
SQL:
`n`.`pid`
means it tries to do something with the pid column in the znote_news table. (pid is an alias for player id).

Look at your database with etc phpmyadmin, look into the znote_news table. Do you have the pid column? Could be something goes wrong under the installation of the tables.

You could try to drop all znote_ tables and re-add them, although you said you already have tried this?
Yes i tried to delete and re-install let me try this one..

Still same error..
 
Last edited by a moderator:
Back
Top