We use cookies to help make our site work properly and to analyze how our site is used. Some are optional, but none contain your personal information, and we don't use any for ads. You can view our cookies policy, manage your cookie preferences, or consent and dismiss this banner by clicking agree:

Agree
ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Blank index file, can't log in.

July 29, 2010 4:50pm

Subscribe [3]

  • #1 / Jul 29, 2010 4:50pm

    Ray Brown

    33 posts

    Hello all.

    I’ve got a site that was functioning correctly for a few weeks, but it just went down and now my site is borked.  I suspect that this has something to do with it being on a Windows server, which I’ve never installed EE on until now.

    My client was editing the site url in the admin section of the CP (he merely wanted to add ‘www.’ to the domain name), and the site broke after he tried to save the new settings.  Usually, this would throw a PHP error, as I keep my config.php file loaded with custom settings and I have the file set to 644 so that it can’t be overwritten by the server.  However, the file was overwritten anyway (I guess Windows servers ignore file permissions?) and now the system is broken.

    Reimporting my custom config.php settings does nothing.  Going to the CP login screen (http://site.com/system/index.php) loads an unstyled version of the login screen, but won’t let me log in and gives me the error “The username you submitted was not found in the database.”  A quick jaunt into PHPMyAdmin shows me that the username is indeed in the database, and everything in the DB appears to be just fine.

    I’m using EE 1.6.9 build 20100415 on a Windows server running PHP 5.2.6 and MySQL 5.0.51b.  Any help would be greatly appreciated!

  • #2 / Jul 29, 2010 5:02pm

    Ray Brown

    33 posts

    Update:

    When I switch the debug setting to “2”, I get lots of fun error messages.  Here they are

    Notice: unserialize() [function.unserialize]: Error at offset 150 of 3539 bytes in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php:129) in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.functions.php on line 742

Warning: Cannot modify header information - headers already sent by (output started at [SITE_PATH]\[SYSTEM_FOLDER]\core\core.prefs.php:129) in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.functions.php on line 742

Notice: Undefined index: most_visitors in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 194

Notice: Undefined index: recent_member in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 213

Notice: Undefined index: recent_member_id in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 214

Notice: Undefined index: total_members in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 215

Notice: Undefined index: total_entries in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 216

Notice: Undefined index: total_forum_topics in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 217

Notice: Undefined index: total_forum_posts in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 218

Notice: Undefined index: total_forum_topics in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 218

Notice: Undefined index: total_forum_posts in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 219

Notice: Undefined index: total_comments in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 220

Notice: Undefined index: total_trackbacks in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 221

Notice: Undefined index: last_entry_date in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 223

Notice: Undefined index: last_forum_post_date in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 224

Notice: Undefined index: last_comment_date in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 225

Notice: Undefined index: last_trackback_date in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 226

Notice: Undefined index: last_cache_clear in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 227

Notice: Undefined index: last_visitor_date in [SITE_PATH]\[SYSTEM_FOLDER]\modules\stats\mcp.stats.php on line 228

Notice: Undefined offset: 0 in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.system.php on line 688

Notice: Undefined index: last_cache_clear in [SITE_PATH]\[SYSTEM_FOLDER]\core\core.system.php on line 954

  • #3 / Jul 29, 2010 5:19pm

    MediaGirl Inc.

    186 posts

    It’s a problem with the exp_sites table.

    Call me and I can help… 505-205-1597.

    Anna

  • #4 / Jul 29, 2010 5:20pm

    MediaGirl Inc.

    186 posts

    Call because it’s easier to explain the fix. If it does the trick for you, you can post it back here.

  • #5 / Jul 29, 2010 5:46pm

    Ray Brown

    33 posts

    After speaking with the amazing MediaGirl, A quick (but careful!) edit of the serialized data in the exp_sites table fixed everything.  The data string was expecting the site_url value to be N characters long, but the actual value was N-4 characters long (because the CP tried to save the value with “www.” in the mix, but it couldn’t.

    Literally changing one character in the numerical count for that value brought the system back to life, so big thanks to you, Anna!

    This issue is resolved.

  • #6 / Jul 29, 2010 5:47pm

    MediaGirl Inc.

    186 posts

    Happy to have helped!

    If you are seeing this error with a valid username (The username you submitted was not found in the database.) and see white screens on all pages, you know it’s an issue with the count for the site_url value in the exp_sites table.

    Anna

  • #7 / Jul 29, 2010 5:51pm

    Ingmar

    29245 posts

    Glad to see you’re all set 😊 Post again as needed, please.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases

© Packet Tide, All Rights Reserved. Legal Notices

Username

Password

Forgot password?
or Register