Please help... I am not sure what is wrong. My banners have been up for three months without this problem...All of a sudden I get this error and it keeps crashing my website. When I take delete the banners everything is fine again. Do I need to do something to the database?
Screenprint of myphpadmin and email error: http://gomom.me/error.pdf
Email Error:
Database error in sitename
Query:
SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW() AND `Position` LIKE '%1%' ORDER BY RAND() LIMIT 1
Mysql error: Got error 28 from storage engine
Found error in the file '/home/bizave/public_html/site/inc/banners.inc.php' at line 44.
Called 'db_arr' function with erroneous argument #0.
|
phpmyadmin locate table that says banners show and empty it it might work :)
Clean up your disk:
perror 28
OS error code 28: No space left on device contact your host see what's the limit on the sql server/DB |
Thanks. I deleted the banners. I have 3gig of space and have only used 2mb. What do you mean by clean your disk? Do you mean cache? I clean it daily...
|
Thanks. I deleted the banners. What do you mean by clean your disk? Do you mean cache? I clean it daily...
What I did notice was that there were a ton of shows (over 17,000) and I deleted those from the bx_banners_shows table.
(over 17,000) and I deleted those from the bx_banners_shows table. that will take care of it
you need to check with your host who knows what the MB limit is set for DB you might be running out of space on database
|
Yup, they said that I have 3gig per database and have only used 2mb. Any other suggestions? Thanks so much for taking the time to help me. :) |
Yup, they said that I have 3gig per database and have only used 2mb. Any other suggestions? Thanks so much for taking the time to help me. :)
weird i know that error starts showing up /site crashes when you're close to reaching the limit s about db storage
|
Arvixe is the host. He said unlimited databases with 3gig per database. So, what happens when you reach the db limit? do I just clean it up or start another? |
Arvixe is the host. He said unlimited databases with 3gig per database. So, what happens when you reach the db limit? do I just clean it up or start another?
there's no need to start a new one since d7 can only run of one db so yeah as soon you see something wrong with the site banners show and empty it :) hmm something is not right
|
Arvixe is the host. He said unlimited databases with 3gig per database. So, what happens when you reach the db limit? do I just clean it up or start another?
there's no need to start a new one since d7 can only run of one db so yeah as soon you see something wrs not right
Okay. Well, I put my banners back up. I hope it doesn't happen again. So frustrating.,,
|
i did look at your site and i don't see that much content that would top the 3gb limit hmm something is not right here ammm.... |
i did look at your site and i don't see that much content that would top the 3gb limit hmm something is not right here ammm....
Yes. It is very weird. I have had my banners up for months and only started getting the error Monday morning. I deleted the banner and everything was fine for a day and then crashed again this morning. I know its the banner, just not sure why.
|
Your quota has nothing to do with the database server disk being full.
The error is not saying you have reached your quota limit.
Just about every hosting provider and ISP over sells there resources.
But if this is the case, other users of the database server would be having issues as well.
Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life |
