[ZNOTE] New blank page

Discussion in 'Support' started by lubunttu, May 31, 2016.

  1. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
  2. Znote

    Znote <?php echo $title; ?> Staff Member Global Moderator Premium User

    Joined:
    Feb 14, 2008
    Messages:
    6,364
    Likes Received:
    1,059
    Best Answers:
    149
    Is PHP installed properly?

    Create a file in /var/www/html/info.php

    and add this inside:
    PHP:
    1.  
    2. <?php
    3. ?>
    4.  
    And try to visit that file.

    If that loads correct, then visit /var/log/ (web service) / error.log to see if there are any errors when visiting Znote AAC files.

    if phpinfo does NOT load, then PHP is not installed. Installation differs a bit depending on which web service you use (enginex, lighty, apache).
     
    Omni Cloud and lubunttu like this.
  3. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    Code (Text):
    1.  
    2. 26] PHP Warning:  require_once(engine/init.php): failed to open stream: Permission denied in /var/www/html/znote150/index.php on line 1
    3. [Tue May 31 13:30:27.254461 2016] [:error] [pid 3045] [client 127.0.0.1:44826] PHP Fatal error:  require_once(): Failed opening required 'engine/init.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/html/znote150/index.php on line 1
    4. [Tue May 31 13:30:27.409550 2016] [:error] [pid 3044] [client 127.0.0.1:44828] PHP Warning:  require_once(engine/init.php): failed to open stream: Permission denied in /var/www/html/znote150/index.php on line 1
    5. [Tue May 31 13:30:27.409594 2016] [:error] [pid 3044] [client 127.0.0.1:44828] PHP Fatal error:  require_once(): Failed opening required 'engine/init.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/html/znote150/index.php on line 1
    6.  
     
    cucurbito likes this.
  4. Znote

    Znote <?php echo $title; ?> Staff Member Global Moderator Premium User

    Joined:
    Feb 14, 2008
    Messages:
    6,364
    Likes Received:
    1,059
    Best Answers:
    149
    @lubunttu Permissions are not set, if you are not familiar with it, just do these commands and see if that fixes it:

    cd /var/www/html/znote150/
    chmod -R 777 *
    chown -R www-data:www-data *

    Using lubuntu? Not very familiar with it, it may be the web service uses another user than www-data. Though I have a feeling the permissions are wrong because you created the folder znote150 with another linux user account without granting your web service access to it.
     
  5. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    Code (Text):
    1.  
    2. cd /var/www/html/znote150/
    3. chmod -R 777 *
    4.  
    It's work! Ty...

    After this there is 2 errors

    Do you know?

    Server Information
    Here you will find all basic information about Znote AAC
    Cannot find the file config.lua

    But i putted the right path
    Code (Text):
    1.  
    2. $config['server_path'] = '/home/lubunttu/Documentos/noobwar';
    3.  
    and
    Code (Text):
    1.  
    2. $config['os'] = LINUX;
    3.  
    And i've tried
    Code (Text):
    1.  
    2. cd /home/lubunttu/Documentos/noobwar
    3. chmod -R 777 *
    4.  

    ---

    And what is it?
    php cURL is not enabled. It is required to for paypal and ZEOTSS services.
    1. Find your php.ini file.
    2. Uncomment extension=php_curl
    Restart web server.

    If you don't want this then disable zeotss and paypal in config.php.

    I need turn off paypal mode to can acess my site
    Code (Text):
    1.  
    2.   $config['zeotss'] = array(
    3.      'enabled' => false,
    4.      'visitors' => true,
    5.      'debug' => false,
    6.      'server' => "http://zeotss.znote.eu/"
    7.    );
    8.  
    And where i found all sqls commands need to this new znote? (im using 0.4 on this new... Is good?)
     
    Last edited: Jun 1, 2016
  6. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    Does anyone know the answer one of the questions?
     
  7. LordVissie

    LordVissie ( ͡°( ͡° ͜ʖ( ͡° ͜ʖ ͡°) ͜ʖ ͡°) ͡°)

    Joined:
    Aug 4, 2015
    Messages:
    1,590
    Likes Received:
    599
    Best Answers:
    1
  8. Shyzoul

    Shyzoul Active Member

    Joined:
    Apr 13, 2009
    Messages:
    389
    Likes Received:
    185
    Best Answers:
    8
    @lubunttu i've experienced same issue under ubuntu, probably the file that handles payments (i dont know which is, search by yourself) cannot find php_curl.so lib, under centOS or ArchLinux never experienced same problem just on ubuntu.
     
    lubunttu likes this.
  9. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    Where i can found the news SQL commands to import to my new DB?
     
  10. Shyzoul

    Shyzoul Active Member

    Joined:
    Apr 13, 2009
    Messages:
    389
    Likes Received:
    185
    Best Answers:
    8
    You discover new commands learning SQL programming language, lol.
     
  11. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    I used this sql command i had
    Code (Text):
    1.  
    2. CREATE TABLE IF NOT EXISTS `znote` (
    3.   `id` int(10) NOT NULL AUTO_INCREMENT,
    4.   `version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
    5.   `installed` int(10) NOT NULL,
    6.   `cached` int(11) DEFAULT NULL,
    7.   PRIMARY KEY (`id`)
    8. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
    9.  
    10. INSERT INTO `znote` (`version`, `installed`) VALUES
    11. ('1.5_SVN', '1460678317');
    12.  
    13. CREATE TABLE IF NOT EXISTS `znote_accounts` (
    14.   `id` int(11) NOT NULL AUTO_INCREMENT,
    15.   `account_id` int(11) NOT NULL,
    16.   `ip` int(10) NOT NULL,
    17.   `created` int(10) NOT NULL,
    18.   `points` int(10) DEFAULT 0,
    19.   `cooldown` int(10) DEFAULT 0,
    20.   `active` tinyint(4) NOT NULL DEFAULT '0',
    21.   `activekey` int(11) NOT NULL,
    22.   `flag` varchar(20) NOT NULL,
    23.   PRIMARY KEY (`id`)
    24. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
    25.  
    26. INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
    27. ('1', '0', '1460678317');
    28.  
    29. CREATE TABLE IF NOT EXISTS `znote_news` (
    30.   `id` int(11) NOT NULL AUTO_INCREMENT,
    31.   `title` varchar(30) NOT NULL,
    32.   `text` text NOT NULL,
    33.   `date` int(11) NOT NULL,
    34.   `pid` int(11) NOT NULL,
    35.   PRIMARY KEY (`id`)
    36. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    37.  
    38. CREATE TABLE IF NOT EXISTS `znote_images` (
    39.   `id` int(11) NOT NULL AUTO_INCREMENT,
    40.   `title` varchar(30) NOT NULL,
    41.   `desc` text NOT NULL,
    42.   `date` int(11) NOT NULL,
    43.   `status` int(11) NOT NULL,
    44.   `image` varchar(30) NOT NULL,
    45.   `account_id` int(11) NOT NULL,
    46.   PRIMARY KEY (`id`)
    47. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    48.  
    49. CREATE TABLE IF NOT EXISTS `znote_paypal` (
    50.   `id` int(11) NOT NULL AUTO_INCREMENT,
    51.   `txn_id` varchar(30) NOT NULL,
    52.   `email` varchar(255) NOT NULL,
    53.   `accid` int(11) NOT NULL,
    54.   `price` int(11) NOT NULL,
    55.   `points` int(11) NOT NULL,
    56.   PRIMARY KEY (`id`)
    57. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    58.  
    59. CREATE TABLE IF NOT EXISTS `znote_paygol` (
    60.   `id` int(11) NOT NULL AUTO_INCREMENT,
    61.   `account_id` int(11) NOT NULL,
    62.   `price` int(11) NOT NULL,
    63.   `points` int(11) NOT NULL,
    64.   `message_id` varchar(255) NOT NULL,
    65.   `service_id` varchar(255) NOT NULL,
    66.   `shortcode` varchar(255) NOT NULL,
    67.   `keyword` varchar(255) NOT NULL,
    68.   `message` varchar(255) NOT NULL,
    69.   `sender` varchar(255) NOT NULL,
    70.   `operator` varchar(255) NOT NULL,
    71.   `country` varchar(255) NOT NULL,
    72.   `currency` varchar(255) NOT NULL,
    73.   PRIMARY KEY (`id`)
    74. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    75.  
    76. CREATE TABLE IF NOT EXISTS `znote_players` (
    77.   `id` int(11) NOT NULL AUTO_INCREMENT,
    78.   `player_id` int(11) NOT NULL,
    79.   `created` int(11) NOT NULL,
    80.   `hide_char` tinyint(4) NOT NULL,
    81.   `comment` varchar(255) NOT NULL,
    82.   PRIMARY KEY (`id`)
    83. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    84.  
    85. INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES
    86. ('1', '1460678317', '0', '. . .');
    87.  
    88. CREATE TABLE IF NOT EXISTS `znote_player_reports` (
    89.   `id` int(11) NOT NULL AUTO_INCREMENT,
    90.   `name` varchar(50) NOT NULL,
    91.   `posx` int(6) NOT NULL,
    92.   `posy` int(6) NOT NULL,
    93.   `posz` int(6) NOT NULL,
    94.   `report_description` VARCHAR(255) NOT NULL,
    95.   `date` INT(11) NOT NULL,
    96.   `status` TINYINT(3) NOT NULL DEFAULT '0',
    97.   PRIMARY KEY (`id`)
    98. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    99.  
    100. CREATE TABLE IF NOT EXISTS `znote_changelog` (
    101.   `id` int(11) NOT NULL AUTO_INCREMENT,
    102.   `text` VARCHAR(255) NOT NULL,
    103.   `time` INT(11) NOT NULL,
    104.   `report_id` INT(11) NOT NULL,
    105.   `status` TINYINT(3) NOT NULL DEFAULT '0',
    106.   PRIMARY KEY (`id`)
    107. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    108.  
    109. CREATE TABLE IF NOT EXISTS `znote_shop` (
    110.   `id` int(11) NOT NULL AUTO_INCREMENT,
    111.   `type` int(11) NOT NULL,
    112.   `itemid` int(11) DEFAULT NULL,
    113.   `count` int(11) NOT NULL DEFAULT '1',
    114.   `description` varchar(255) NOT NULL,
    115.   `points` int(11) NOT NULL DEFAULT '10',
    116.   PRIMARY KEY (`id`)
    117. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    118.  
    119. CREATE TABLE IF NOT EXISTS `znote_shop_logs` (
    120.   `id` int(11) NOT NULL AUTO_INCREMENT,
    121.   `account_id` int(11) NOT NULL,
    122.   `player_id` int(11) NOT NULL,
    123.   `type` int(11) NOT NULL,
    124.   `itemid` int(11) NOT NULL,
    125.   `count` int(11) NOT NULL,
    126.   `points` int(11) NOT NULL,
    127.   `time` int(11) NOT NULL,
    128.   PRIMARY KEY (`id`)
    129. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    130.  
    131. CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
    132.   `id` int(11) NOT NULL AUTO_INCREMENT,
    133.   `account_id` int(11) NOT NULL,
    134.   `type` int(11) NOT NULL,
    135.   `itemid` int(11) NOT NULL,
    136.   `count` int(11) NOT NULL,
    137.   `time` int(11) NOT NULL DEFAULT '0',
    138.   PRIMARY KEY (`id`)
    139. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    140.  
    141. CREATE TABLE IF NOT EXISTS `znote_visitors` (
    142.   `id` int(11) NOT NULL AUTO_INCREMENT,
    143.   `ip` int(11) NOT NULL,
    144.   `value` int(11) NOT NULL,
    145.   PRIMARY KEY (`id`)
    146. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    147.  
    148. CREATE TABLE IF NOT EXISTS `znote_visitors_details` (
    149.   `id` int(11) NOT NULL AUTO_INCREMENT,
    150.   `ip` int(11) NOT NULL,
    151.   `time` int(11) NOT NULL,
    152.   `type` tinyint(4) NOT NULL,
    153.   `account_id` int(11) NOT NULL,
    154.   PRIMARY KEY (`id`)
    155. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    156.  
    157. CREATE TABLE IF NOT EXISTS `znote_forum` (
    158.   `id` int(11) NOT NULL AUTO_INCREMENT,
    159.   `name` varchar(50) NOT NULL,
    160.   `access` tinyint(4) NOT NULL,
    161.   `closed` tinyint(4) NOT NULL,
    162.   `hidden` tinyint(4) NOT NULL,
    163.   `guild_id` int(11) NOT NULL,
    164.   PRIMARY KEY (`id`)
    165. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    166.  
    167. INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES
    168. ('Staff Board', '4', '0', '0', '0'),
    169. ('Tutors Board', '2', '0', '0', '0'),
    170. ('Discussion', '1', '0', '0', '0'),
    171. ('Feedback', '1', '0', '1', '0');
    172.  
    173. CREATE TABLE IF NOT EXISTS `znote_forum_threads` (
    174.   `id` int(11) NOT NULL AUTO_INCREMENT,
    175.   `forum_id` int(11) NOT NULL,
    176.   `player_id` int(11) NOT NULL,
    177.   `player_name` varchar(50) NOT NULL,
    178.   `title` varchar(50) NOT NULL,
    179.   `text` text NOT NULL,
    180.   `created` int(11) NOT NULL,
    181.   `updated` int(11) NOT NULL,
    182.   `sticky` tinyint(4) NOT NULL,
    183.   `hidden` tinyint(4) NOT NULL,
    184.   `closed` tinyint(4) NOT NULL,
    185.   PRIMARY KEY (`id`)
    186. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    187.  
    188. CREATE TABLE IF NOT EXISTS `znote_forum_posts` (
    189.   `id` int(11) NOT NULL AUTO_INCREMENT,
    190.   `thread_id` int(11) NOT NULL,
    191.   `player_id` int(11) NOT NULL,
    192.   `player_name` varchar(50) NOT NULL,
    193.   `text` text NOT NULL,
    194.   `created` int(11) NOT NULL,
    195.   `updated` int(11) NOT NULL,
    196.   PRIMARY KEY (`id`)
    197. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    198.  
    199. CREATE TABLE IF NOT EXISTS `znote_deleted_characters` (
    200.   `id` int(11) NOT NULL AUTO_INCREMENT,
    201.   `original_account_id` int(11) NOT NULL,
    202.   `character_name` varchar(255) NOT NULL,
    203.   `time` datetime NOT NULL,
    204.   `done` tinyint(1) NOT NULL,
    205.   PRIMARY KEY (`id`)
    206. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    207.  
    208. CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
    209.   `id` int(11) NOT NULL AUTO_INCREMENT,
    210.   `limit` int(11) NOT NULL DEFAULT '0',
    211.   PRIMARY KEY (`id`),
    212.   FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
    213. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    214.  
    215. CREATE TABLE IF NOT EXISTS `znote_tickets` (
    216.   `id` int(11) NOT NULL AUTO_INCREMENT,
    217.   `owner` int(11) NOT NULL,
    218.   `username` varchar(32) CHARACTER SET latin1 NOT NULL,
    219.   `subject` text CHARACTER SET latin1 NOT NULL,
    220.   `message` text CHARACTER SET latin1 NOT NULL,
    221.   `ip` int(11) NOT NULL,
    222.   `creation` int(11) NOT NULL,
    223.   `status` varchar(20) CHARACTER SET latin1 NOT NULL,
    224.   PRIMARY KEY (`id`)
    225. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    226.  
    227. CREATE TABLE IF NOT EXISTS `znote_tickets_replies` (
    228.   `id` int(11) NOT NULL AUTO_INCREMENT,
    229.   `tid` int(11) NOT NULL,
    230.   `username` varchar(32) CHARACTER SET latin1 NOT NULL,
    231.   `message` text CHARACTER SET latin1 NOT NULL,
    232.   `created` int(11) NOT NULL,
    233.   PRIMARY KEY (`id`)
    234. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    235.  
    236.  
    But some pages dont work like
    ItemMarket (it is a trade offline new?)
    Code (Text):
    1.  
    2. string(216) "SELECT `id`, `itemtype` AS `item_id`, `amount`, `price`, `created`, `anonymous`, (SELECT `name` FROM `players` WHERE `id` = `player_id`) AS `player_name` FROM `market_offers` WHERE `sale` = 1 ORDER BY `created` DESC;"
    3. (query - SQL error)
    4. Type: select_multi (select multiple rows from database)
    5.  
    6. Table 'otserver.market_offers' doesn't exist
    7.  
    Where is the scripts, the sqls commands...
     
  12. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
  13. Shyzoul

    Shyzoul Active Member

    Joined:
    Apr 13, 2009
    Messages:
    389
    Likes Received:
    185
    Best Answers:
    8
    @lubunttu i personally have not much knowledge at sql, but what are you trying to do with those tables?
     
    lubunttu likes this.
  14. Slavi Dodo

    Slavi Dodo #define SLAVI32 _WIN32

    Joined:
    Sep 9, 2015
    Messages:
    598
    Likes Received:
    259
    Best Answers:
    1
    `Table 'otserver.market_offers' doesn't exist`
    This table is in schema.sql of forgottenserver, and it means you didn't properly add the tables of forgottenserver before trying to install znote aac.
     
    lubunttu likes this.
  15. lubunttu

    lubunttu Member

    Joined:
    May 17, 2016
    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
  16. Slavi Dodo

    Slavi Dodo #define SLAVI32 _WIN32

    Joined:
    Sep 9, 2015
    Messages:
    598
    Likes Received:
    259
    Best Answers:
    1
    This is custom content done by the developers of that server, here is a tip, you can just make a table for market items on database to store seller, itemid, count, ...etc. Then load it in php and show it.
    And add the talkacttions to get/remove/add .....
     

Share This Page

Loading...