Multiple blank images with no data. New post.

[RRoss]

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 Workman]

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

[RRoss]

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.