I've got a small forum running SMF 2.0.3. I got a system generated space warning email saying I was running out of room on my host. I ran some of the database maintenance tasks in SMF and the database size was greatly reduced. However, it seems to be growing about 10MB a day with ZERO activity going on. I've got new registrations turned off due to too many spammers trying to register. There are no new posts being made at this time, either. Any idea why the MySQL database would be growing?
The error log?
Is it the server hosting you use? Like Arantor said, could you provide the error log?
Do you mean the generic error log from cpanel at my host or a specific MySQL error log?
I was thinking more of the forum error log (Admin > Maintenance > Logs > Error Log)
Is there a way to export the error log that can be attached? This might be the first time I've looked at the log and there are just over 129000 errors!
Well, I wouldn't trawl through 129k errors myself, I'd clear it out and deal with errors as they occur.
OK. I've deleted the logs, which were up to 179000 entries. The most common one I'm seeing this morning are these, though the line number is different each time:
public_html/forum/Themes/dilbermc/MessageIndex.template.php (main sub template - eval?)
Line: 432
public_html/forum/Themes/default/GenericControls.template.php (main sub template - eval?)
Line: 337
The database also grew by 12MB overnight.
Here are a few more that just appeared after I tried to view a post.
2: Invalid argument supplied for foreach()
File: /xxxx/xxxxxxxx/public_html/forum/Themes/default/languages/index.english-utf8.php (main sub template - eval?)
Line: 633
2: Invalid argument supplied for foreach()
File: /xxxx/xxxxxxxx/public_html/forum/Themes/dilbermc/MessageIndex.template.php (main sub template - eval?)
Line: 422
8: Undefined index: max_signatureLength
File: /xxxx/xxxxxxxx/public_html/forum/Themes/default/languages/Profile.english.php (portal_below sub template - eval?)
Line: 43
8: Undefined index: show_sp1_info
File: /xxxx/xxxxxxxx/public_html/forum/Themes/default/languages/Stats.english-utf8.php (main sub template - eval?)
Line: 431
The Dilber MC theme does not work properly on 2.0, which is going to be at least part of the problem.
That "eval" crap may be masking the true errors, too.
Try disabling template evaluation and see what new errors you get.
Admin>Server settings>General.
OK. I've reset the forum theme and all users back to the SMF default and disabled template evaluation. Here's the first error I get.
http://www.musketeerfootball.com/forum/index.php?
8: Undefined index: max_signatureLength
File: /xxxx/xxxxxxxx/public_html/forum/Themes/default/languages/Profile.english-utf8.php
Line: 43
As I don't seem to have that table, on my forum, I guess you have a mod installed, that should create that table.
Which mod could that be?
Can you list all of your mods, please?
It's not a table, it's an entry in $modSettings, presumably the Membergroup Signature Settings mod.
(http://www.katzy.dsl.pipex.com/Smileys/doh.gif)
(http://www.katzy.dsl.pipex.com/Smileys/thankyou.gif)
Looks like getting rid of the Dilbermc theme took care of it. I've had no new errors in the log and the database is much smaller now that I've cleared out the 175000+ errors that were there. I'll watch the next few days, but things are looking good. Thanks for the help.
Quote from: Arantor on January 18, 2013, 01:35:29 PM
I was thinking more of the forum error log (Admin > Maintenance > Logs > Error Log)
Silly me. :P
Quote from: K@ on January 19, 2013, 01:13:44 PM
(http://www.katzy.dsl.pipex.com/Smileys/doh.gif)
(http://www.katzy.dsl.pipex.com/Smileys/thankyou.gif)
That was random... :P
EDIT: Sorry for posting on an already solved topic.