This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
November 02, 2010 2:04pm
Subscribe [5]#1 / Nov 02, 2010 2:04pm
I have a site I’ve just upgraded to the 1.7.0 this morning, everything went fine with that.
I was logged in as SuperAdmin and clearing out some spam members with Member utilities when I got logged-out of the CP. I immediately went to log back in but the log-in page now has the theme missing and I get ‘The username you submitted was not found in the database’. I can’t log-in with the editors password either. The actual site is down as well, just a complete white page.
#2 / Nov 03, 2010 5:26am
#3 / Nov 03, 2010 5:54am
Hi John
Turn on some?
Yes, the config file seems OK.
#4 / Nov 03, 2010 6:02am
Tim,
Whoops! sorry Error Reporting is what I meant to link to
#5 / Nov 03, 2010 6:19am
This is what I get
Notice: unserialize() [function.unserialize]: Error at offset 25128 of 65535 bytes in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/skiphys/public_html/my_system_name/core/core.prefs.php on line 129
Warning: Cannot modify header information - headers already sent by (output started at /home/skiphys/public_html/my_system_name/core/core.prefs.php:129) in /home/skiphys/public_html/my_system_name/core/core.functions.php on line 752
Warning: Cannot modify header information - headers already sent by (output started at /home/skiphys/public_html/my_system_name/core/core.prefs.php:129) in /home/skiphys/public_html/my_system_name/core/core.functions.php on line 752
Notice: Undefined index: most_visitors in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 194
Notice: Undefined index: recent_member in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 213
Notice: Undefined index: recent_member_id in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 214
Notice: Undefined index: total_members in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 215
Notice: Undefined index: total_entries in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 216
Notice: Undefined index: total_forum_topics in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 217
Notice: Undefined index: total_forum_posts in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 218
Notice: Undefined index: total_forum_topics in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 218
Notice: Undefined index: total_forum_posts in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 219
Notice: Undefined index: total_comments in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 220
Notice: Undefined index: total_trackbacks in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 221
Notice: Undefined index: last_entry_date in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 223
Notice: Undefined index: last_forum_post_date in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 224
Notice: Undefined index: last_comment_date in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 225
Notice: Undefined index: last_trackback_date in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 226
Notice: Undefined index: last_cache_clear in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 227
Notice: Undefined index: last_visitor_date in /home/skiphys/public_html/my_system_name/modules/stats/mcp.stats.php on line 228
Notice: Undefined index: last_cache_clear in /home/skiphys/public_html/my_system_name/core/core.system.php on line 954#6 / Nov 03, 2010 8:37am
Anyone have any ideas on this?
#7 / Nov 03, 2010 12:48pm
I’m having the same issue with EETemplates.com. Banned some members. Got logged out with no styling on the log in. Config file is intact but does not seem to be recognized as I tried to use overrides to point to the themes folder and it did not work. And to make matters worse it is not allowing any of my users to log in. Says that Admin is not a recognized username. And when I request that it send my password to my email address (which I verified is correct in the DB) it says it Cannot Send Email at This Time. I have no .htaccess in play. I checked the permissions and they are correct. I was using 1.6.9 and figured why not try and update maybe that will jostle something loose. So I updated to 1.7 without a hitch but still cant log in. Nothing in the cache directory. And at this point in time I think all is lost… If anyone has any ideas I would love to hear them too….
#8 / Nov 03, 2010 4:46pm
Howdy folks,
First, I am sorry that you ran into this. Let me give a brief explanation.
The banned IPs are stored in a serialized array in the exp_sites table. That exp_sites table is set to TEXT, meaning it can handle up to about ~64k characters.
What’s happening here is that the the exp_sites table is getting too full, and then it gets truncated. The truncated table is a broken serialized array, which means EE can’t read it.
The way to get up and running right now is to grab the exp_sites table from your backup and restore just that table. That should get you up and running.
Greg Salt, the author of Member Utilities, is also going to pop in here shortly to address that. Essentially, the only reason MU is involved is because it makes such banning so much easier. I believe he has a plan to help overcome this.
#9 / Nov 03, 2010 4:51pm
Beat me to it 😉
Yea what she said.
#10 / Nov 03, 2010 5:05pm
Tim and Marcus,
My apologies for the problems that you’ve suffered with this. I shall be issuing an update to MU that will stop this from occurring again. That update will make an alteration to the exp_sites DB table so that much more data can be stored.
Cheers
Greg
#11 / Nov 03, 2010 5:11pm
Thanks Lisa. I did a db backup before I upgraded yesterday so I’ve rolled back that db now and everything seems fine.
I’ve had a an email from Greg as well letting me know what’s happening.
Edit:
Was posting at the same time. Cheers Greg.
#12 / Nov 03, 2010 5:15pm
So, everybody up and running? Show of hands, please!
#13 / Nov 03, 2010 6:35pm
All good here.
#14 / Nov 03, 2010 6:40pm
I’m good.
#15 / Nov 04, 2010 4:03am
Excellent! Closing this one out. See you around 😊