XF 2.0 Problem when "About" member

[MoonShadows]

Getting this pop up when I click "About" on any member's profile

XF\Db\Exception: MySQL query error [1021]: Disk full (/tmp/#sql_2f03_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 70
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 69
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1135
XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 278
XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1879
XF\App->run() in src/XF.php at line 328
XF::runApp() in index.php at line 13

 

[RandallC]

looks as your mysql is running out of space.

 

[MoonShadows]

How could that be? The installation is only 3 weeks old. The forum only has 11 members. I have a ticket into the hosting company.

 

[KawaiiHannah]

I also noticed when I click resources it says server error

 

[RandallC]

mysql runs on disk space, your server or vps is hitting its limit before the mysql can finish. I am not an expert but thats what it seems like from reading someone else might chime in with more info.
edit-----------------------------------------------
Depending on what type of web hosting you are on: Shared/Resellers, VPS, Dedicated or cloud. I am assuming your on Shared and it seems the webhost has some tight restrictions on mysql.

 

[MoonShadows]

Thanks for that insight. Yes, I am on shared hosting. I just got a ticket response from my hosting provider that they are looking at the problem now and will update me. I'll post back here with what they say/do.

 

[MoonShadows]

I also noticed when I click resources it says server error

Thanks! I just notified them of that problem, too.

 

[MoonShadows]

"Please allow us some time to further review this and we will update you here as soon as possible.
Thank you for your patience and understanding in the meantime."

Translation...we haven't figured out the problem yet!

 

[RandallC]

You could investigate your self.

create a document called whatever.php

put this in it.

<?php phpinfo(); ?>

open it in your browser

http://yousite.com/whatever.php

that will give you the readout of what your server has and allows via php and mysql

Look for
memory_limit and it might be somewhere around 32mb which in your case may be a problem. It will also list other information

 

[Paul B]

That isn't necessary.

admin.php?tools/phpinfo

 

[RandallC]

That isn't necessary.

admin.php?tools/phpinfo

Awesome Did not know but Im kinda old school as well.

 

[MoonShadows]

They fixed the problem.

Here is what they said: "We have cleared some space from the tmp directory and now the issue is no longer presented."