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
 

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