Sites not showing since last saturday/sunday..?

[ceewee]

Can anyone see from the status.php s what's wrong with these sites?

http://www.hetforumvannederland.nl/status.php
http://www.unitedworldforum.net/status.php



My other 13 sites with my provider (Servage) run fine, among them another SMF 114, which has considerable traffic) Above sites not...

Also, is there a error.log in readable form which is in smf directory?

THX

[ThorstenE]

Code Select Expand

r . '/Sources')) $sourcedir = $boarddir . '/Sources'; ?> is shown at above the status.php.. looks like your Settings.php is destroyed or empty?

[ceewee]

Code Select Expand

r . '/Sources')) $sourcedir = $boarddir . '/Sources'; ?> is shown at above the status.php.. looks like your Settings.php is destroyed or empty?

Corrected that, but sites still doens't show..

[ThorstenE]

have you access to the webservers error_log? apache's error_log is very helpful, some hosts put them in the users homedirectory..
i would try repair_settings.php, first, maybe it helps..
if not it's possible a problem with the webserver, have you any seo-modifications installed or a .htaccess in the forum's directory?

[ceewee]

have you access to the webservers error_log? apache's error_log is very helpful, some hosts put them in the users homedirectory..
i would try repair_settings.php, first, maybe it helps..
if not it's possible a problem with the webserver, have you any seo-modifications installed or a .htaccess in the forum's directory?

Servage has no logs available for users.
Have .htaccess in these 2, works fine on third site.
<Files .htaccess>
Order allow,deny
Deny from all
</Files>
Options +FollowSymLinks
RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_USER_AGENT} ^BlackWidow [OR]
RewriteCond %{HTTP_USER_AGENT} ^Bot\ mailto:[email protected] [OR]
RewriteCond %{HTTP_USER_AGENT} ^ChinaClaw [OR]
RewriteCond %{HTTP_USER_AGENT} ^Custo [OR]
RewriteCond %{HTTP_USER_AGENT} ^DISCo [OR]
RewriteCond %{HTTP_USER_AGENT} ^Download\ Demon [OR]
RewriteCond %{HTTP_USER_AGENT} ^eCatch [OR]
RewriteCond %{HTTP_USER_AGENT} ^EirGrabber [OR]
RewriteCond %{HTTP_USER_AGENT} ^EmailSiphon [OR]
RewriteCond %{HTTP_USER_AGENT} ^EmailWolf [OR]
RewriteCond %{HTTP_USER_AGENT} ^Express\ WebPictures [OR]
RewriteCond %{HTTP_USER_AGENT} ^ExtractorPro [OR]
RewriteCond %{HTTP_USER_AGENT} ^EyeNetIE [OR]
RewriteCond %{HTTP_USER_AGENT} ^FlashGet [OR]
RewriteCond %{HTTP_USER_AGENT} ^GetRight [OR]
RewriteCond %{HTTP_USER_AGENT} ^GetWeb! [OR]
RewriteCond %{HTTP_USER_AGENT} ^Go!Zilla [OR]
RewriteCond %{HTTP_USER_AGENT} ^Go-Ahead-Got-It [OR]
RewriteCond %{HTTP_USER_AGENT} ^GrabNet [OR]
RewriteCond %{HTTP_USER_AGENT} ^Grafula [OR]
RewriteCond %{HTTP_USER_AGENT} ^HMView [OR]
RewriteCond %{HTTP_USER_AGENT} HTTrack [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^Image\ Stripper [OR]
RewriteCond %{HTTP_USER_AGENT} ^Image\ Sucker [OR]
RewriteCond %{HTTP_USER_AGENT} Indy\ Library [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^InterGET [OR]
RewriteCond %{HTTP_USER_AGENT} ^Internet\ Ninja [OR]
RewriteCond %{HTTP_USER_AGENT} ^JetCar [OR]
RewriteCond %{HTTP_USER_AGENT} ^JOC\ Web\ Spider [OR]
RewriteCond %{HTTP_USER_AGENT} ^larbin [OR]
RewriteCond %{HTTP_USER_AGENT} ^LeechFTP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Mass\ Downloader [OR]
RewriteCond %{HTTP_USER_AGENT} ^MIDown\ tool [OR]
RewriteCond %{HTTP_USER_AGENT} ^Mister\ PiX [OR]
RewriteCond %{HTTP_USER_AGENT} ^Navroad [OR]
RewriteCond %{HTTP_USER_AGENT} ^NearSite [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetAnts [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetSpider [OR]
RewriteCond %{HTTP_USER_AGENT} ^Net\ Vampire [OR]
RewriteCond %{HTTP_USER_AGENT} ^NetZIP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Octopus [OR]
RewriteCond %{HTTP_USER_AGENT} ^Offline\ Explorer [OR]
RewriteCond %{HTTP_USER_AGENT} ^Offline\ Navigator [OR]
RewriteCond %{HTTP_USER_AGENT} ^PageGrabber [OR]
RewriteCond %{HTTP_USER_AGENT} ^Papa\ Foto [OR]
RewriteCond %{HTTP_USER_AGENT} ^pavuk [OR]
RewriteCond %{HTTP_USER_AGENT} ^pcBrowser [OR]
RewriteCond %{HTTP_USER_AGENT} ^RealDownload [OR]
RewriteCond %{HTTP_USER_AGENT} ^ReGet [OR]
RewriteCond %{HTTP_USER_AGENT} ^SiteSnagger [OR]
RewriteCond %{HTTP_USER_AGENT} ^SmartDownload [OR]
RewriteCond %{HTTP_USER_AGENT} ^SuperBot [OR]
RewriteCond %{HTTP_USER_AGENT} ^SuperHTTP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Surfbot [OR]
RewriteCond %{HTTP_USER_AGENT} ^tAkeOut [OR]
RewriteCond %{HTTP_USER_AGENT} ^Teleport\ Pro [OR]
RewriteCond %{HTTP_USER_AGENT} ^VoidEYE [OR]
RewriteCond %{HTTP_USER_AGENT} ^Web\ Image\ Collector [OR]
RewriteCond %{HTTP_USER_AGENT} ^Web\ Sucker [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebAuto [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebCopier [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebFetch [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebGo\ IS [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebLeacher [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebReaper [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebSauger [OR]
RewriteCond %{HTTP_USER_AGENT} ^Website\ eXtractor [OR]
RewriteCond %{HTTP_USER_AGENT} ^Website\ Quester [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebStripper [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebWhacker [OR]
RewriteCond %{HTTP_USER_AGENT} ^WebZIP [OR]
RewriteCond %{HTTP_USER_AGENT} ^Wget [OR]
RewriteCond %{HTTP_USER_AGENT} ^Widow [OR]
RewriteCond %{HTTP_USER_AGENT} ^WWWOFFLE [OR]
RewriteCond %{HTTP_USER_AGENT} ^Xaldon\ WebSpider [OR]
RewriteCond %{HTTP_USER_AGENT} ^Zeus  [OR]
RewriteCond %{HTTP:Range} .+ [OR]
RewriteCond %{QUERY_STRING} quickmod [NC]
RewriteRule ^.* - [F,L]

[ceewee]

have for both sites now old backups (January 30-08) running (later ones up till 04-07 didn't work either) but at the top I see

r . '/Sources')) $sourcedir = $boarddir . '/Sources'; ?>

will try repair settings but appears again and again while path seems to be ok.

Servage says it has nothing to do with their database servers (when 2 sites went offline, they had some servers going down), mysql-db are ok optimized, repaired.

They blame it on index.php, but that hasn't changed (put relevant backup from hd/dvd on server)

When going in admin-mode I get more then just above line:(only in http://www.hetforumvannederland.nl however..


r . '/Sources')) $sourcedir = $boarddir . '/Sources'; ?>s) . " LIKE '%&#%') LIMIT 500", __FILE__, __LINE__); while ($row = mysql_fetch_assoc($request)) { $changes = array(); foreach ($row as $column_name => $column_value) if ($column_name !== $primary_key && strpos($column_value, '&#') !== false) $changes[] = "$column_name = '" . addslashes(preg_replace('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6})~e', '$entity_replace(\'\\2\')', $column_value)) . "'"; // Update the row. if (!empty($changes)) db_query(" UPDATE {$db_prefix}$cur_table SET " . implode(", ", $changes) . " WHERE $primary_key = " . $row[$primary_key] . " LIMIT 1", __FILE__, __LINE__); } mysql_free_result($request); $context['start'] += 500; // After ten seconds interrupt. if (time() - $context['start_time'] > 10) { // Calculate an approximation of the percentage done. $context['percent_done'] = round(100 * ($context['table'] + ($context['start'] / $max_value)) / $context['num_tables'], 1); $context['continue_get_data'] = '?action=convertentities;table=' . $context['table'] . ';start=' . $context['start'] . ';sesc=' . $context['session_id']; return; } } $context['start'] = 0; } // Make sure all serialized strings are all right. require_once($sourcedir . '/Subs-Charset.php'); fix_serialized_columns(); // If we're here, we must be done. $context['percent_done'] = 100; $context['continue_get_data'] = '?action=maintain'; $context['last_step'] = true; } ?>n'; $context['last_step'] = true; } ?> ?>'filename'].' '.$txt['langCompare_MissingCopyTo'].' '.$item['renamed'].'  '; $a = !$a; } echo ' '.$txt['langCompare_MissingCopyInfo'].' '; } //Show the Missing Strings echo ' '.$txt['langCompare_missingStrings'].' '; if(empty($context['missing_strings'])) echo ' '.$txt['langCompare_noMissingStrings'].' '; else { $a = true; foreach($context['missing_strings'] as $name => $value) { echo ' '.$txt['langCompare_MissingCopyDir'].' '.$item['current_dir'].'
'.$txt['langCompare_inTheFile'].' '.$context['language_files']['english'][$name]['filename'].' '.$txt['langCompare_appearFollowString'].' '.$context['language_files'][$context['compared_language']][$name]['filename'].' '.$txt['langCompare_Variable'].'  '.$txt['langCompare_TextString'].' '; $a = !$a; foreach($value as $string) { echo ' $'.$string['type'].'[\''.$string['name'].'\']  '.$string['string'].' '; $a = !$a; } echo ' '; } echo ' '.$txt['langCompare_MissingStringInfo'].' '; } echo ' '; } ?>

I'm puzzled...

[ceewee]

I've put clean 1.1.4 index. php (indexstan.php) besides present index.php, and it shows the same mistakes.

(fatal error on bottom on both sites in indexstan.php is for call from unique vistors mod which can not find required code offcourse)

index(stan)php from 1.1.4. zip has date 29 Juli 2007 on my hd.
Servage doesn't see my point, up till June 30, 2008 my board with latest mysql db worked fine...now I have a backup working from half year ago, from the begin of both boards.

[ceewee]

It took me some time...
r . '/Sources')) $sourcedir = $boarddir . '/Sources'; ?>

that error was not in orginal zip-file settings.php but somehow, it kept appearing when i used reoair_settings.php..several times..unstable mysql serverenvironement ?

Been working to get things working, only found some jibberish in http://www.hetforumvannederland.nl admin section which doens't appear in http://www.unitedworldforum.net, which is strange, because it's the exact software(config).

Have for both sites now settings.php with 2 databaseinfo's so I can switch easaly between oldest backups and newest..

The newest ones 040708 which wouldn't load since 300608 I have manualy deleted in phpmyadmin all entries which are not relevant (enough), and got size reduced heavyly..and then it worked.
Databases were both corrupted however, had to use repair/optimize a lot..

So I have my newest backups working again :-) besides that jibebrisch in forumvannederland.nl:

s) . " LIKE '%&#%') LIMIT 500", __FILE__, __LINE__); while ($row = mysql_fetch_assoc($request)) { $changes = array(); foreach ($row as $column_name => $column_value) if ($column_name !== $primary_key && strpos($column_value, '&#') !== false) $changes[] = "$column_name = '" . addslashes(preg_replace('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6})~e', '$entity_replace(\'\\2\')', $column_value)) . "'"; // Update the row. if (!empty($changes)) db_query(" UPDATE {$db_prefix}$cur_table SET " . implode(", ", $changes) . " WHERE $primary_key = " . $row[$primary_key] . " LIMIT 1", __FILE__, __LINE__); } mysql_free_result($request); $context['start'] += 500; // After ten seconds interrupt. if (time() - $context['start_time'] > 10) { // Calculate an approximation of the percentage done. $context['percent_done'] = round(100 * ($context['table'] + ($context['start'] / $max_value)) / $context['num_tables'], 1); $context['continue_get_data'] = '?action=convertentities;table=' . $context['table'] . ';start=' . $context['start'] . ';sesc=' . $context['session_id']; return; } } $context['start'] = 0; } // Make sure all serialized strings are all right. require_once($sourcedir . '/Subs-Charset.php'); fix_serialized_columns(); // If we're here, we must be done. $context['percent_done'] = 100; $context['continue_get_data'] = '?action=maintain'; $context['last_step'] = true; } ?>n'; $context['last_step'] = true; } ?> ?>>'filename'].' '.$txt['langCompare_MissingCopyTo'].' '.$item['renamed'].'  '; $a = !$a; } echo ' '.$txt['langCompare_MissingCopyInfo'].' '; } //Show the Missing Strings echo ' '.$txt['langCompare_missingStrings'].' '; if(empty($context['missing_strings'])) echo ' '.$txt['langCompare_noMissingStrings'].' '; else { $a = true; foreach($context['missing_strings'] as $name => $value) { echo ' '.$txt['langCompare_MissingCopyDir'].' '.$item['current_dir'].'
'.$txt['langCompare_inTheFile'].' '.$context['language_files']['english'][$name]['filename'].' '.$txt['langCompare_appearFollowString'].' '.$context['language_files'][$context['compared_language']][$name]['filename'].' '.$txt['langCompare_Variable'].'  '.$txt['langCompare_TextString'].' '; $a = !$a; foreach($value as $string) { echo ' $'.$string['type'].'[\''.$string['name'].'\']  '.$string['string'].' '; $a = !$a; } echo ' '; } echo ' '.$txt['langCompare_MissingStringInfo'].' '; } echo ' '; } ?>

Don't know what it is or where it comes from..
and is only in http://www.hetforumvannederland.nl and not in
http://www.unitedworldforum.net

[ceewee]

The above jibberisch is not always the same: On some pages it is this:

'filename'].' '.$txt['langCompare_MissingCopyTo'].' '.$item['renamed'].'  '; $a = !$a; } echo ' '.$txt['langCompare_MissingCopyInfo'].' '; } //Show the Missing Strings echo ' '.$txt['langCompare_missingStrings'].' '; if(empty($context['missing_strings'])) echo ' '.$txt['langCompare_noMissingStrings'].' '; else { $a = true; foreach($context['missing_strings'] as $name => $value) { echo ' '.$txt['langCompare_MissingCopyDir'].' '.$item['current_dir'].'
'.$txt['langCompare_inTheFile'].' '.$context['language_files']['english'][$name]['filename'].' '.$txt['langCompare_appearFollowString'].' '.$context['language_files'][$context['compared_language']][$name]['filename'].' '.$txt['langCompare_Variable'].'  '.$txt['langCompare_TextString'].' '; $a = !$a; foreach($value as $string) { echo ' $'.$string['type'].'[\''.$string['name'].'\']  '.$string['string'].' '; $a = !$a; } echo ' '; } echo ' '.$txt['langCompare_MissingStringInfo'].' '; } echo ' '; } ?>

Checked if somehow these are injected in *.php but nope....

[青山 素子]

That looks like some of the files are corrupted. You might have to upload clean copies of everything and install your mods on those copies.

[ceewee]

That looks like some of the files are corrupted. You might have to upload clean copies of everything and install your mods on those copies.

I've "text"searched the (backup)files and files I've downloaded from site for those "jibberisch", and it came up empty!?
Stranger, both sites have the same files/mods and only hetforumvannederland.nl has it, in start admin the most, the other adminpages the smaller ones. Luckily in the forum itself there's no jibberisch.

Will download and check the files again, my first idea was also some files are corrupted..but then it has to show in some files..

[ceewee]

That looks like some of the files are corrupted. You might have to upload clean copies of everything and install your mods on those copies.

Clean copies of everything and new install mods?  :-(  I have 96 mods installed !

And up till 300608 both smfs/domains worked fine, since 040708 they are running again, but only 1 without any jibberisch..so rather search that jibberisch...

[青山 素子]

Clean copies of everything and new install mods?  :-(  I have 96 mods installed !

And you wonder why you are having issues?

And up till 300608 both smfs/domains worked fine, since 040708 they are running again, but only 1 without any jibberisch..so rather search that jibberisch...

Good luck. It looks like you have some corruption in a few files, probably some single quotes and semi-colons in the wrong place. You might also be missing the starting PHP indicator ("<?php") in a few.

The latest snippet you posted points to a problem by the "langCompare" mod.

[ceewee]

Clean copies of everything and new install mods?  :-(  I have 96 mods installed !

And you wonder why you are having issues?

Had no issues from 300108 till 300608, so smf with 96 mods worked fine (as expected ;-) )
Still blame provider-mysql trouble in that last weekend for trouble/corruption. Will check that language-compare.mod

THX

I still have files/mysql backup with just ;-) 83 mods installed and try that on other domain/map
or place copy 100%okboard and rework that to boards/msgs board with jibberisch..
Instead of starting all over again, 115 update will be done manuel also for same reason.

[ceewee]

Solved the jibberisch in http://www.hetforumvannederland.nl

Viewed page-source and textsearched with ultraedit, that pointed to files and linenumbers..

first

s) . " LIKE '%&#%') LIMIT 500", __FILE__, __LINE__); while ($row = mysql_fetch_assoc($request)) { $changes = array(); foreach ($row as $column_name => $column_value) if ($column_name !== $primary_key && strpos($column_value, '&#') !== false) $changes[] = "$column_name = '" . addslashes(preg_replace('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6})~e', '$entity_replace(\'\\2\')', $column_value)) . "'"; // Update the row. if (!empty($changes)) db_query(" UPDATE {$db_prefix}$cur_table SET " . implode(", ", $changes) . " WHERE $primary_key = " . $row[$primary_key] . " LIMIT 1", __FILE__, __LINE__); } mysql_free_result($request); $context['start'] += 500; // After ten seconds interrupt. if (time() - $context['start_time'] > 10) { // Calculate an approximation of the percentage done. $context['percent_done'] = round(100 * ($context['table'] + ($context['start'] / $max_value)) / $context['num_tables'], 1); $context['continue_get_data'] = '?action=convertentities;table=' . $context['table'] . ';start=' . $context['start'] . ';sesc=' . $context['session_id']; return; } } $context['start'] = 0; } // Make sure all serialized strings are all right. require_once($sourcedir . '/Subs-Charset.php'); fix_serialized_columns(); // If we're here, we must be done. $context['percent_done'] = 100; $context['continue_get_data'] = '?action=maintain'; $context['last_step'] = true; } ?>n'; $context['last_step'] = true; } ?> ?>>'filename'].' '.$txt['langCompare_MissingCopyTo'].' '.$item['renamed'].'  '; $a = !$a; } echo ' '.$txt['langCompare_MissingCopyInfo'].' '; } //Show the Missing Strings echo ' '.$txt['langCompare_missingStrings'].' '; if(empty($context['missing_strings'])) echo ' '.$txt['langCompare_noMissingStrings'].' '; else { $a = true; foreach($context['missing_strings'] as $name => $value) { echo ' '.$txt['langCompare_MissingCopyDir'].' '.$item['current_dir'].'
'.$txt['langCompare_inTheFile'].' '.$context['language_files']['english'][$name]['filename'].' '.$txt['langCompare_appearFollowString'].' '.$context['language_files'][$context['compared_language']][$name]['filename'].' '.$txt['langCompare_Variable'].'  '.$txt['langCompare_TextString'].' '; $a = !$a; foreach($value as $string) { echo ' $'.$string['type'].'[\''.$string['name'].'\']  '.$string['string'].' '; $a = !$a; } echo ' '; } echo ' '.$txt['langCompare_MissingStringInfo'].' '; } echo ' '; } ?>


----------------------------------------
Find 's) . " LIKE '%&#%')' in '
HETFORUMVANNEDERLAND.NL\Sources\Admin.php' :
HETFORUMVANNEDERLAND.NL\Sources\Admin.php(1507):                AND (" . implode(" LIKE '%&#%' OR ", $columns) . " LIKE '%&#%')
Found 's) . " LIKE '%&#%')' 1 time(s).
----------------------------------------
Find 's) . " LIKE '%&#%')' in '
HETFORUMVANNEDERLAND.NL\Sources\Admin.php~' :
HETFORUMVANNEDERLAND.NL\Sources\Admin.php~(1484):                AND (" . implode(" LIKE '%&#%' OR ", $columns) . " LIKE '%&#%')
Found 's) . " LIKE '%&#%')' 1 time(s).
Search complete, found 's) . " LIKE '%&#%')' 2 time(s).

============================
second


'filename'].' '.$txt['langCompare_MissingCopyTo'].' '.$item['renamed'].'  '; $a = !$a; } echo ' '.$txt['langCompare_MissingCopyInfo'].' '; } //Show the Missing Strings echo ' '.$txt['langCompare_missingStrings'].' '; if(empty($context['missing_strings'])) echo ' '.$txt['langCompare_noMissingStrings'].' '; else { $a = true; foreach($context['missing_strings'] as $name => $value) { echo ' '.$txt['langCompare_MissingCopyDir'].' '.$item['current_dir'].'
'.$txt['langCompare_inTheFile'].' '.$context['language_files']['english'][$name]['filename'].' '.$txt['langCompare_appearFollowString'].' '.$context['language_files'][$context['compared_language']][$name]['filename'].' '.$txt['langCompare_Variable'].'  '.$txt['langCompare_TextString'].' '; $a = !$a; foreach($value as $string) { echo ' $'.$string['type'].'[\''.$string['name'].'\']  '.$string['string'].' '; $a = !$a; } echo ' '; } echo ' '.$txt['langCompare_MissingStringInfo'].' '; } echo ' '; } ?>

----------------------------------------
Find ''.$txt['langCompare_MissingCopyTo'].' <b>'.$item['renamed'].'</b>' in HETFORUMVANNEDERLAND.NL\Themes\default\Admin.template.php' :
HETFORUMVANNEDERLAND.NL\Themes\default\Admin.template.php(1838):                '.$txt['langCompare_MissingCopyTo'].' <b>'.$item['renamed'].'</b>
Found ''.$txt['langCompare_MissingCopyTo'].' <b>'.$item['renamed'].'</b>' 1 time(s).
Search complete, found ''.$txt['langCompare_MissingCopyTo'].' <b>'.$item['renamed'].'</b>' 1 time(s).


replaced these files with copies of the 100%ok site/domain http://www.unitedworldforum.net
et voila like the french say...SOLVED

What caused this is another matter...
unstable mysql envir or something else...but glad it does work now flawless (untill the next error offcourse)


THX all..!! :-)

[Rumbaar]

Glad you got it worked out.  File shouldn't become corrupted like that with an change or issue.  Now I can't see an issue with mySQL being a cause or being able to affect your actual file contents like that.

Did you change anything during that period, did your host have any disk failures or other issues server side?

[ceewee]

Glad you got it worked out.  File shouldn't become corrupted like that with an change or issue.  Now I can't see an issue with mySQL being a cause or being able to affect your actual file contents like that.

Did you change anything during that period, did your host have any disk failures or other issues server side?

What's the cause of it?
Host had Mysql issue that I know for sure.
Luckily I'm a backup-junkie (I have still all my emails from all the accounts I have and had since 1996 for example) so I had  numerous file and db backups , but what could wreck just those 2 admin files, i'm in the blue, black or red...
Not knowing that cause is against my principles, host not having any logs is not helping either.
Having 2 smf forums running flawless for half a year with 96 mods(more will be added ;-) ) made me happy sofar..but will be more carefull then I even was before..

[青山 素子]

What's the cause of it?
Host had Mysql issue that I know for sure.
Luckily I'm a backup-junkie (I have still all my emails from all the accounts I have and had since 1996 for example) so I had  numerous file and db backups , but what could wreck just those 2 admin files, i'm in the blue, black or red...
Not knowing that cause is against my principles, host not having any logs is not helping either.
Having 2 smf forums running flawless for half a year with 96 mods(more will be added ;-) ) made me happy sofar..but will be more carefull then I even was before..

A lot of things could cause random table corruption. I personally had some problems with version 5.0 below 5.0.24. Also, failing disks, a corrupted filesystem, bad memory, or even just a bad driver for the disk adapter could all cause issues. If the server is heavily overloaded, there is also the potential for problems when writing to the tables. In addition, a crash on MySQL or even the whole server can cause corruption.

[Rumbaar]

What were the two files that were affected, I couldn't really tell from the code you posted.   It was files right, not actual mySQL tables?

[ceewee]

What were the two files that were affected, I couldn't really tell from the code you posted.   It was files right, not actual mySQL tables?

Admin.php on 2 places, and admin.template.php on 1 place, no tables were affected.

[Rumbaar]

So had you installed any mods recently?  Or modified/accessed those files recently?

[ceewee]

So had you installed any mods recently?  Or modified/accessed those files recently?

No, last mods were from January, and didn't modified those files, from January up till end  June everything worked fine, in 2 smf's (same mods, 96 of them ;-) ) unitedworldforum.net and hetforumvannederland.nl.
But then I've noticed my Mysql backups I've ordered thru control panel didn't show up for days, and then both sites went into oblivion.. asked helpedesk , they simply renamed index.php to index1.php and said see your site shows up...I just saw a directorylisting, not my idea of a running site...
I did 2 things then: tried to connect older Mysqlbackups to site, as backupjunkie I had numerous and  tried to see thru phpmyadmin in most recent db what's wrong.
Older backups wouldn't connect despite they had been running ok when I backupd them, just the first from January did. (would loose half years work then)
Checking most recent db made me realize that db size was quite large, these 2 forums had many visits from spiders and people as guest but just a very few real users, at the time I was only one posting.
Have another smf with 1500 users, 50 posting with 1,5 Gb attachments that size was just 3 Mb, while these 2 were above 10 Mb and growing each day.
Thru phpmyadmin I saw half of size was due to error messages, so emptied that, repaired and optimized  eh volia like the french said, sites were back online but with errors and that jibberisch in hetforumvannederland.nl. unitedworldforum.net worked flawless again without that jibberisch.
That's what made me search with ultra edit and find those admin.php and admin.template.php and
fixed it with copy from other smf.

But stiil, what caused this !?  Those mysql glitches at provider ?

[Rumbaar]

I wont profess to be an authority in mySQL and servers, but I can't see how a mySQL corruption of any kind can alter code or affect code of a static .php file like you had.  So I can't think of a link between the two or how it is even possible.

[青山 素子]

After that description, it almost sounds like some general server issues, especially with things not showing up in your server's control panel. However, only your host really knows what happened - all everybody else can offer is speculation.

[ceewee]

As long as sites are running (again), I stay (happy) in doubt. :-)  THX