• 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!

Znote problem 'schema.znote_news'

xlucha

New Member
Joined
Nov 4, 2012
Messages
44
Reaction score
3
Hi guys

I need some advice how to fix this problem.

Table 'schema.znote_news' doesn't exist


I use this tutorial
https://otland.net/threads/video-tu...eaac-on-ubuntu-16-04-lts-linux-server.243186/

and i have problem with Znote, look at this screens

p.s.
i check my mysql database and from Znote i have only 2 positions . znote and znote accounts,
i dont have 'schema.znote_news', znote_images paypal and and .....

i check sql code and looks like
CREATE TABLE IF NOT EXISTS `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
`cooldown` int(10) DEFAULT 0,
`active` tinyint(4) NOT NULL DEFAULT '0',
`activekey` int(11) NOT NULL DEFAULT '0',
`flag` varchar(20) NOT NULL, <--- here i try to add DEFAULT '0' but did't work
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;



image ru
 
Last edited:
Back
Top