• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Database problem

Scheduled Pinned Locked Moved
FOG Problems
1
3
318
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    Matthieu Jacquart
    last edited by Jun 30, 2022, 3:56 PM

    Hi,

    I try to clean fog database because I had strange behavior today when I deployed some computers : snapin in pending task didn’t match to the right computer. And indeed there were a lot of snapin task and snapin job in database, thaht didn’t appear un web UI.
    So i clean some database (and forgot to made a backup before, of course…) but now I have this message when I click on “tasks” database

    Notice in ./libraries/classes/Display/Results.php#4442
    Trying to access array offset on value of type null
    
    Backtrace
    
    ./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
    ,
    string '`taskCreateTime`',
    )
    ./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
    ,
    array,
    array,
    boolean true,
    )
    ./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
    ,
    string './themes/pmahomme/img/',
    NULL,
    array,
    boolean false,
    integer 0,
    integer 0,
    boolean true,
    ,
    array,
    boolean true,
    )
    ./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
    array,
    string 'fog',
    string 'tasks',
    NULL,
    integer 0,
    ,
    NULL,
    string './themes/pmahomme/img/',
    NULL,
    ,
    string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
    NULL,
    )
    ./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
    array,
    boolean true,
    string 'fog',
    string 'tasks',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
    NULL,
    NULL,
    )
    ./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
    array,
    boolean true,
    string 'fog',
    string 'tasks',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `tasks`',
    NULL,
    NULL,
    )
    Notice in ./libraries/classes/Display/Results.php#4468
    Trying to access array offset on value of type null
    
    Backtrace
    
    ./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
    ,
    string '`taskCreateTime`',
    )
    ./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
    ,
    array,
    array,
    boolean true,
    )
    ./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
    ,
    string './themes/pmahomme/img/',
    NULL,
    array,
    boolean false,
    integer 0,
    integer 0,
    boolean true,
    ,
    array,
    boolean true,
    )
    ./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
    array,
    string 'fog',
    string 'tasks',
    NULL,
    integer 0,
    ,
    NULL,
    string './themes/pmahomme/img/',
    NULL,
    ,
    string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
    NULL,
    )
    ./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
    array,
    boolean true,
    string 'fog',
    string 'tasks',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
    NULL,
    NULL,
    )
    ./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
    array,
    boolean true,
    string 'fog',
    string 'tasks',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `tasks`',
    NULL,
    NULL,
    )
    
    I don't now if it's a problem but if you have some advces...
    Thanks !
    Matthieu
    

    Fog 1.5.9.138
    Debian 11
    Vmware ESXi

    1 Reply Last reply Reply Quote 0
    • M
      Matthieu Jacquart
      last edited by Matthieu Jacquart Jun 30, 2022, 11:33 AM Jun 30, 2022, 5:31 PM

      Finally I restore my VM to previous snapshot and follow this procedure to clean database : https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL
      But when I check into phpmyadmin, I see there are lots of records in these db whereas web ui is empty for any deployment task or snapin task :

      • snapins jobs
      • snapins tasks
      • tasks

      Can I clean manually these tables ?

      Thanks,
      MAtthieu

      Fog 1.5.9.138
      Debian 11
      Vmware ESXi

      1 Reply Last reply Reply Quote 0
      • M
        Matthieu Jacquart
        last edited by Jul 3, 2022, 6:04 AM

        Hi,

        Any ideas ?
        I saw in DB that even if task manager is empty in web UI, the 2 tabels “tasks” and “snapins tasks” are still containing data…
        And if I launch several deployment tasks with the associated snapins, either the snapins do not appear at all (empty web ui), or they are offset (see picture)
        snapin.jpg

        If my database is broken, is it possible to recreate a new empty one and import some important tables ?

        Thans,
        Matthieu

        Fog 1.5.9.138
        Debian 11
        Vmware ESXi

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        1 / 1
        • First post
          2/3
          Last post

        136

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project