Error after upgrade to new version

Discussion in 'Installation/Configuration' started by czdavid, Oct 11, 2013.

  1. czdavid

    czdavid Member

    Hello,

    I got this error to my mailbox few days after ips config 3 upgrade.
    I know, that it isnt nothing critical.

    What I can do to fix it?

    Thank you.


    Code:
    11.10.2013-16:45 - WARNING - DB::query(REPLACE INTO monitor_data (server_id, type, created, data, state) VALUES (1, 'disk_usage', UNIX_TIMESTAMP(), 'a:3:i:1;a:7:s:2:\"fs\";s:10:\"/dev/simfs\";s:4:\"type\";s:5:\"simfs\";s:4:\"size\";s:4:\"300G\";s:4:\"used\";s:4:\"115G\";s:9:\"available\";s:4:\"186G\";s:7:\"percent\";s:3:\"39%\";s:7:\"mounted\";s:1:\"/\";}i:2;a:7:{s:2:\"fs\";s:5:\"tmpfs\";s:4:\"type\";s:5:\"tmpfs\";s:4:\"size\";s:4:\"6.5G\";s:4:\"used\";s:1:\"0\";s:9:\"available\";s:4:\"6.5G\";s:7:\"percent\";s:2:\"0%\";s:7:\"mounted\";s:12:\"/lib/init/rw\";}i:3;a:7:{s:2:\"fs\";s:5:\"tmpfs\";s:4:\"type\";s:5:\"tmpfs\";s:4:\"size\";s:4:\"6.5G\";s:4:\"used\";s:1:\"0\";s:9:\"available\";s:4:\"6.5G\";s:7:\"percent\";s:2:\"0%\";s:7:\"mounted\";s:8:\"/dev/shm\";}}', 'ok')) -> mysqli_query Can't open file: './dbispconfig/monitor_data.frm' (errno: 24)
     
    Last edited: Oct 12, 2013
  2. Quaxth

    Quaxth New Member

    Error messages, commands and other system infos are best placed in Code tags for to be displayed correctly which isn't done and displayed correctly by copy and paste them into the post directly.

    The BBCode is exactly for such postings. BBCode is enabled on this forum and if you didn't know them, take a look at the lower left corner of the page in the Posting Rules windows, click on BB code link to get all avilable.

    Thanks.
     
  3. galius

    galius New Member

    I have the same problem!

    After upgrade of my "Debian GNU/Linux 7" 4 days before, no I have this message in my Ispconfig3 Panel:

    Code:
    #0 db->query(SELECT data from monitor_data WHERE type = 'harddisk_quota' ORDER BY created DESC) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT data from monitor_data WHERE type = 'harddisk_quota' ORDER BY created DESC) called at [/usr/local/ispconfig/interface/web/dashboard/dashlets/quota.php:19] #2 dashlet_quota->show() called at [/usr/local/ispconfig/interface/web/dashboard/dashboard.php:169] #0 db->query(SELECT data from monitor_data WHERE type = 'email_quota' ORDER BY created DESC) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT data from monitor_data WHERE type = 'email_quota' ORDER BY created DESC) called at [/usr/local/ispconfig/interface/web/dashboard/dashlets/mailquota.php:19] #2 dashlet_mailquota->show() called at [/usr/local/ispconfig/interface/web/dashboard/dashboard.php:169] 
    If I clic in "Monitor", I see this:
    Code:
    #0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:192] #2 _getServerState(1, neo.alosys.fr, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:113] #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63] 
    If I clic in "Server State", I see this:
    Code:
    #0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:192] #2 _getServerState(1, neo.alosys.fr, 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:57] 
    If I clic in "Show Overview", I see this:
    Code:
    #0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:192] #2 _getServerState(1, neo.alosys.fr, 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:57] 
    And for each menu, I have the same kind of information.

    Could anyone help me find a solution?

    Thanks
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    You might want to try if the ispconfig updater can fix the missing or broken tables: download the ispconfig tar.gz again, unpack it and run the update.php script in the install folder.
     
  5. galius

    galius New Member

    When I run the command in ~/ispconfig3_install/install# ./update.php

    I have this:

    [email protected]:~/ispconfig3_install/install# ./update.php
    bash: ./update.php: Permission non accordée

    if I give the necessary permissions, I have that:

    ./update.php: ligne1: ?php: Aucun fichier ou dossier de ce type
    ./update.php: ligne3: /bin: est un dossier
    ./update.php: ligne4: Erreur de syntaxe près du symbole inattendu « c »
    ./update.php: ligne4: `Copyright (c) 2007-2010, Till Brehm, projektfarm Gmbh'
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    A php script is executed like this:

    php update.php
     
  7. galius

    galius New Member

    This solution solved my problem ... ;-) Thank you very much for your support :D
     

Share This Page