Multiple blank images with no data. New post.



  • Re: [Multiple images with no title](no size)

    I,m a noob at mysql so I have a question for the community. We are running Fog 1.2.0 on Ubuntu 14.04 LTS.
    My question is how do i get to the sql interface to run the command " DELETE FROM fog.images WHERE imageName IN (’’,NULL);" ?
    We also had multiple blank images start populating our database, seems to have stopped at 32,205 count. Any help would be appreciated. Thanks!



  • Wayne,

    Thank you so very much that solved our problem!! We are a school district in Texas and this was slowing things down a bit.


  • Moderator

    Open terminal.

    Switch to root properly by typing
    sudo -i

    Then, access mysql by first calling MySQL
    mysql
    If MySQL is password protected, it’d instead be
    mysql -u root -p ,press enter, and then supply the password.

    Then switch to the fog database by typing
    use fog;

    Run your commands:
    DELETE FROM fog.images WHERE imageName IN (’’,NULL);

    To quit MySQL when you are done, type
    quit


Log in to reply
 

399
Online

39.4k
Users

11.1k
Topics

105.5k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.