Recent Topics

1 Apr 16, 2007 22:52    

Currently I am experiencing very many problems w/b2evolution 1.9.x
that is crippling my site. I started getting many SQL error 127's in
various evo_stats tables, and following people's advice checked and
repaired the affected tables when a problem occurred. Only thing was
this kept happening every couple of days. So, when another evo_stats
MYSQL error page popped up, I'd check, repair then EMPTY the affected
table. Sometimes I'd get a different SQL error code too.

Still every few days, the errors would return. It appears to me that
b2evolution may have a problem with writing erroneous data to the
affected tables that cause the problem. I'm not the coder or a php/b2
wizard so I am dumping some of the error pages in this post to see if
anyone can come up with a solution. Here goes - please help:

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Error establishing a database connection!

(Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (11))

1. Are you sure you have typed the correct user/password?
2. Are you sure that you have typed the correct hostname?
3. Are you sure that the database server is running?

After my site was back up every once in a while I would get various
MYSQL error 127 in a certain series of tables (evo_stats). When
checking in the b2 forums they advised me to check and repair the
table through phpmyadmin, which I did. Which cleared up the problem.
However, every few days the MYSQL 127 error would appear under
various different tables in evo_stats. So again I checked, repaired
and the problem went away. For a few days. And now the above message
is displayed on my site and in cpanel trying to get to my MySQL
databases, the page won't load no matter what I do so I do a thing. I
will list below any saved MYSQL error pages in case for some reason
this makes sense to what is going on:

I can't see if this is a b2 issue or a MYSQL thing. -Vincent

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Got error 127 from storage engine(Errno=1030)

Your query: Session::dbsave()

UPDATE evo_sessions SET
sess_data =
'a:2:{s:20:\"core.preview_Comment\";a:2:{i:0;N;i:1;O:7:\"Comment\":27:
{s:4:\"Item\";O:4:\"Item\":46:{s:12:\"creator_User\";N;s:6:\"Author\";
N;s:15:\"creator_user_ID\";s:1:\"4\";s:13:\"assigned_User\";N;s:16:\"a
ssigned_user_ID\";N;s:10:\"issue_date\";s:19:\"2007-04-14
19:32:45\";s:8:\"mod_date\";s:19:\"2007-04-14
19:32:45\";s:6:\"status\";s:9:\"published\";s:6:\"locale\";s:5:\"en-
US\";s:5:\"title\";s:28:\"Into the Blogosphere: Day
14\";s:8:\"urltitle\";s:27:\"into_the_blogosphere_day_14\";s:7:\"conte
nt\";s:1909:\"One of the most superfluous and infernal posting
techniques employed by the accursedly lame blogospherians (aka daily
bloggers) to bloat their pathetic sites with new content is the
useless and used-too-often <strong>Regurgitated News Post</strong>.
Like Emperor Penguins that blow partially digested fish chunks into
their hungry chick\'s mouth to feed it\'s rabid appetite, so does the
daily blogger spew partially read/heard news articl

es from television, the web or newspapers to feed their blog\'s
appetite for daily content with the mistaken impression that their
readers care, or that they have readers at all.\r\n\r\nReaders who
apparently are so <strong><em>*poke* *poke*</em></strong> \"special\"
as to not be able to get news from tv, radio or the paper themselves
but rely on the daily blogger to keep them informed of the important
things like the weather, what\'s that great yellow scary ball of
fiery death up in the sky or who\'s the father of X Y or Z
celebrity\'s baby.\r\n\r\nThe Regurgitated News post is one of the
most useless weapons in the daily blogger\'s Keep Those Articles
a\'Coming arsenal since the posts are only \"important\" (ha!) for a
very short time. After that, they\'re even more of a waste of space
on the internet as usual. \r\n\r\nMultiply this tragedy by the number
of blogospherians out there that do this and you quickly see why the
web is drowning under their

plastic six-pack rings of posting death...\r\n\r\nAnd with that
said, I\'d like to discuss w/you all the <a
href=\"http://abcnews.go.com/US/wireStory?id=3042115\"
target=\"_blank\">recent accident</a> that injured New Jersey
Governor, Jon S. Corzine this Thursday. <a
href=\"http://abcnews.go.com/US/wireStory?id=3042115\"
target=\"_blank\">(click link)</a>.\r\n\r\nWear your seatbelt
kids.\r\n\r\nWe\'re glad to hear that despite his injuries NJ Gov.
Corzine is expected to make a full recovery.\r\n\r\nSeriously kids,
wear your $%#@!ing seat belts...
Sad\";s:13:\"content_pages\";N;s:9:\"wordcount\";s:3:\"289\";s:9:\"ren
derers\";s:17:\"b2WPAutP.b2evSmil\";s:14:\"comment_status\";s:4:\"open
\";s:3:\"url\";s:0:\"\";s:6:\"typ_ID\";s:1:\"1\";s:5:\"st_ID\";N;s:8:\
"deadline\";N;s:8:\"pr
iority\";s:1:\"3\";s:20:\"notifications_status\";s:8:\"finished\";s:2
1:\"notifications_ctsk_ID\";N;s:11:\"main_cat_ID\";s:2:\"14\";s:7:\"bl
og_ID\";s:1:\"5\";s:4:\"Blog\";O:4:\"Blog\":39:{s:9:\"shortname\";s:8:
\"Unincorp\";s:4:\"name\";s:23:\"Navarino
Unincorporated\";s:7:\"tagline\";s:0:\"\";s:9:\"shortdesc\";s:0:\"\";s
:8:\"longdesc\";s:0:\"\";s:6:\"locale\";s:5:\"en-
US\";s:11:\"access_type\";s:7:\"default\";s:7:\"siteurl\";s:0:\"\";s:1
4:\"staticfilename\";s:19:\"unincorporated.html\";s:4:\"stub\";s:18:\"
unincorporated.php\";s:7:\"urlname\";s:18:\"unincorporated.php\";s:13:
\"links_blog_ID\";N;s:5:\"notes\";s:0:\"\";s:8:\"keywords\";s:179:\"na
varino, humor, computers, quard, ferratio, fun, zany, comedian,
comedy, zdtv, techtv, vincent, unincorporated, vinny, angry
computerist, mitnick, labmistress, cornucopia of
evil\";s:13:\"allowcomments\";s:12:\"post_by_post\";s:15:\"allowtrackb
acks\";s:1:\"0\";s:12:\"allowblogcss\";s:1:\"1\";s:12:\"allowusercss\"
;s:1:\"1\";s:12:\"default_
s
kin\";s:14:\"unincorporated\";s:10:\"force_skin\";s:1:\"1\";s:13:\"di
sp_bloglist\";s:1:\"0\";s:11:\"in_bloglist\";s:1:\"1\";s:3:\"UID\";N;s
:14:\"media_location\";s:6:\"custom\";s:12:\"media_subdir\";s:0:\"\";s
:14:\"media_fullpath\";s:38:\"/home/vincent/public_html/rants/media/\"
;s:9:\"media_url\";s:50:\"http://www.navarinounincorporated.com/rants/
media/\";s:18:\"CollectionSettings\";O:18:\"CollectionSettings\":8:{s:
9:\"_defaults\";a:2:{s:19:\"new_feedback_status\";s:5:\"draft\";s:12:\
"ping_plugins\";s:29:\"ping_pingomatic,ping_b2evonet\";}s:13:\"db_tabl
e_name\";s:15:\"T_coll_settings\";s:13:\"col_key_names\";a:2:{i:0;s:12
:\"cset_coll_ID\";i:1;s:9:\"cset_name\";}s:14:\"col_value_name\";s:10:
\"cset_value\";s:17:\"cache_by_col_keys\";i:1;s:5:\"cache\";a:1:{i:5;a
:2:{s:19:\"new_feedback_status\";O:8:\"stdClass\":4:{s:5:\"value\";s:9
:\"published\";s:10:\"dbUptodate\";b:1;s:8:\"dbRemove\"
;b:0;s:12:\"unserialized\";b:1;}s:12:\"ping_plugins\";O:8:\"stdClass\
":3:{s:5:\"value\";s:29:\"ping_b2evonet,ping_pingomatic\";s:10:\"dbUpt
odate\";b:1;s:8:\"dbRemove\";b:0;}}}s:10:\"all_loaded\";b:0;s:19:\"cou
nt_col_key_names\";i:2;}s:2:\"ID\";s:1:\"5\";s:11:\"dbtablename\";s:7:
\"T_blogs\";s:8:\"dbprefix\";s:5:\"blog_\";s:8:\"dbIDname\";s:7:\"blog
_ID\";s:17:\"datecreated_field\";s:0:\"\";s:18:\"datemodified_field\";
s:0:\"\";s:13:\"creator_field\";s:0:\"\";s:16:\"lasteditor_field\";s:0
:\"\";s:9:\"dbchanges\";a:0:{}s:19:\"delete_restrictions\";a:1:{i:0;a:
3:{s:5:\"table\";s:12:\"T_categories\";s:2:\"fk\";s:11:\"cat_blog_ID\"
;s:3:\"msg\";s:21:\"%d related
categories\";}}s:15:\"delete_cascades\";a:2:{i:0;a:3:{s:5:\"table\";s:
17:\"T_coll_user_perms\";s:2:\"fk\";s:16:\"bloguser_blog_ID\";s:3:\"ms
g\";s:25:\"%d user rights
defintions\";}i:1;a:3:{s:5:\"table\";s:15:\"T_subscriptions\";s:2:\"fk
\";s:11:\"sub_coll_ID\";s:3:\"msg\";s:16:\"%d
subscriptions\";}}}s:13:\"extra_cat_IDs\";N;s:5
:
\"Links\";N;s:10:\"priorities\";a:5:{i:1;s:11:\"1 -
Highest\";i:2;s:8:\"2 - High\";i:3;s:10:\"3 - Medium\";i:4;s:7:\"4 -
Low\";i:5;s:10:\"5 -
Lowest\";}s:19:\"content_prerendered\";N;s:2:\"ID\";s:3:\"309\";s:11:\
"dbtablename\";s:7:\"T_posts\";s:8:\"dbprefix\";s:5:\"post_\";s:8:\"db
IDname\";s:7:\"post_ID\";s:17:\"datecreated_field\";s:11:\"datecreated
\";s:18:\"datemodified_field\";s:12:\"datemodified\";s:13:\"creator_fi
eld\";s:15:\"creator_user_ID\";s:16:\"lasteditor_field\";s:16:\"lasted
it_user_ID\";s:9:\"dbchanges\";a:0:{}s:19:\"delete_restrictions\";a:2:
{i:0;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:16:\"link_dest_it
m_ID\";s:3:\"msg\";s:24:\"%d links to source
items\";}i:1;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:14:\"post
_parent_ID\";s:3:\"msg\";s:23:\"%d links to child
items\";}}s:15:\"delete_cascades\";a:3:{i:0;a:3:{s:5:\"table\";s:7:\"T
_links\";s:2:\"fk\";s:11:\"link_itm_ID\";s:3:\"msg\";s:29:\"%d links
to destination items\";}i:1;a:3:{s:5:\"table\";s:10:\
"
T_postcats\";s:2:\"fk\";s:15:\"postcat_post_ID\";s:3:\"msg\";s:28:\"%
d links to extra
categories\";}i:2;a:3:{s:5:\"table\";s:10:\"T_comments\";s:2:\"fk\";s:
15:\"comment_post_ID\";s:3:\"msg\";s:11:\"%d
comments\";}}s:7:\"objtype\";s:4:\"Item\";s:11:\"datecreated\";s:19:\"
2007-04-14 19:32:45\";s:12:\"datemodified\";s:19:\"2007-04-14
19:32:45\";s:16:\"lastedit_user_ID\";s:1:\"4\";s:5:\"views\";s:1:\"9\"
;}s:7:\"item_ID\";s:3:\"309\";s:11:\"author_User\";O:4:\"User\":38:{s:
5:\"login\";s:16:\"vincent
navarino\";s:4:\"pass\";s:32:\"67fea38e62c5f1a6d8ee725b8e147a09\";s:9:
\"firstname\";s:7:\"Vincent\";s:8:\"lastname\";s:8:\"Navarino\";s:8:\"
nickname\";s:5:\"Vinny\";s:6:\"idmode\";s:6:\"namefl\";s:6:\"locale\";
s:5:\"en-
US\";s:5:\"email\";s:12:\"vnav@cox.net\";s:3:\"url\";s:37:\"http://www
.navarinounincorporated.com\";s:3:\"icq\";s:1:\"0\";s
:3:\"aim\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:3:\"yim\";s:0:\"\";s:2:\"i
p\";s:0:\"\";s:6:\"domain\";s:0:\"\";s:7:\"browser\";s:0:\"\";s:11:\"d
atecreated\";s:19:\"2004-08-08
13:02:26\";s:5:\"level\";s:2:\"10\";s:6:\"notify\";s:1:\"1\";s:10:\"sh
owonline\";s:1:\"1\";s:13:\"allow_msgform\";s:1:\"1\";s:9:\"validated\
";s:1:\"1\";s:10:\"_num_posts\";N;s:8:\"group_ID\";s:1:\"1\";s:5:\"Gro
up\";N;s:18:\"blog_post_statuses\";a:0:{}s:11:\"cache_perms\";a:0:{}s:
2:\"ID\";s:1:\"4\";s:11:\"dbtablename\";s:7:\"T_users\";s:8:\"dbprefix
\";s:5:\"user_\";s:8:\"dbIDname\";s:7:\"user_ID\";s:17:\"datecreated_f
ield\";s:0:\"\";s:18:\"datemodified_field\";s:0:\"\";s:13:\"creator_fi
eld\";s:0:\"\";s:16:\"lasteditor_field\";s:0:\"\";s:9:\"dbchanges\";a:
0:{}s:19:\"delete_restrictions\";a:4:{i:0;a:3:{s:5:\"table\";s:7:\"T_p
osts\";s:2:\"fk\";s:21:\"post_lastedit_user_ID\";s:3:\"msg\";s:33:\"%d
posts last edited by this
user\";}i:1;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:21:\"post_
assigned_user_ID\";s:3
:
\"msg\";s:30:\"%d posts assigned to this
user\";}i:2;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:20:\"link_
creator_user_ID\";s:3:\"msg\";s:29:\"%d links created by this
user\";}i:3;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:21:\"link_
lastedit_user_ID\";s:3:\"msg\";s:33:\"%d links last edited by this
user\";}}s:15:\"delete_cascades\";a:5:{i:0;a:3:{s:5:\"table\";s:14:\"T
_usersettings\";s:2:\"fk\";s:12:\"uset_user_ID\";s:3:\"msg\";s:31:\"%d
user settings on
collections\";}i:1;a:3:{s:5:\"table\";s:10:\"T_sessions\";s:2:\"fk\";s
:12:\"sess_user_ID\";s:3:\"msg\";s:31:\"%d sessions opened by this
user\";}i:2;a:3:{s:5:\"table\";s:17:\"T_coll_user_perms\";s:2:\"fk\";s
:16:\"bloguser_user_ID\";s:3:\"msg\";s:28:\"%d user permissions on
blogs\";}i:3;a:3:{s:5:\"table\";s:15:\"T_subscriptions\";s:2:\"fk\";s:
11:\"sub_user_ID\";s:3:\"msg\";s:16:\"%d
subscriptions\";}i:4;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:2
0:\"post_creator_user_ID\";s:3:\"msg\";s:29:\"%d posts created by
t
his
user\";}}}s:9:\"author_ID\";s:1:\"4\";s:4:\"type\";s:7:\"comment\";s:6
:\"status\";s:9:\"published\";s:6:\"author\";N;s:12:\"author_email\";N
;s:10:\"author_url\";N;s:9:\"author_IP\";s:13:\"68.96.187.213\";s:4:\"
date\";s:19:\"2007-04-15 11:30:47\";s:7:\"content\";s:51:\"blue: 1
gweep: 0<br />\n<br
/>\n<em>buuuurrrnnn!</em>\";s:10:\"spam_karma\";N;s:13:\"allow_msgform
\";N;s:2:\"ID\";i:0;s:11:\"dbtablename\";s:10:\"T_comments\";s:8:\"dbp
refix\";s:8:\"comment_\";s:8:\"dbIDname\";s:10:\"comment_ID\";s:17:\"d
atecreated_field\";s:0:\"\";s:18:\"datemodified_field\";s:0:\"\";s:13:
\"creator_field\";s:0:\"\";s:16:\"lasteditor_field\";s:0:\"\";s:9:\"db
changes\";a:8:{s:12:\"comment_type\";a:2:{s:4:\"type\";s:6:\"string\";
s:5:\"value\";s:4:\"type\";}s:15:\"comment_post_ID\";a:2:{s:4:\"type\"
;s:6:\"number\";s:5:\"value\";s:7:\"post_ID\";}s:17:\"comment_author_I
D\";a:2:{s:4:\"type\";s:6:\"number\";s:5:\"value\";s:9:\"author_ID\";}
s:17:\"comment_author_IP\";a:2:{s:
4
:\"type\";s:6:\"string\";s:5:\"value\";s:9:\"author_IP\";}s:12:\"comm
ent_date\";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"value\";s:4:\"date\"
;}s:15:\"comment_content\";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"valu
e\";s:7:\"content\";}s:14:\"comment_status\";a:2:{s:4:\"type\";s:6:\"s
tring\";s:5:\"value\";s:6:\"status\";}s:24:\"comment_original_content\
";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"value\";s:16:\"original_conte
nt\";}}s:19:\"delete_restrictions\";a:0:{}s:15:\"delete_cascades\";a:0
:{}s:7:\"post_ID\";s:3:\"309\";s:16:\"original_content\";s:41:\"blue:
1 gweep:
0\r\n\r\n<em>buuuurrrnnn!</em>\";}}s:24:\"core.no_CachePageContent\";a
:2:{i:0;N;i:1;i:1;}}',
sess_ipaddress = "68.96.187.213",
sess_key = 'EV4iYxTBjcdjFzodyZQh5PrplLKNIpS5',
sess_lastseen = "2007-04-15 11:30:47",
sess_user_ID = 4

WHERE sess_ID = 424

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Got error 127 from storage engine(Errno=1030)

Your query: Session::dbsave()

UPDATE evo_sessions SET
sess_data =
'a:2:{s:20:\"core.preview_Comment\";a:2:{i:0;N;i:1;O:7:\"Comment\":27:
{s:4:\"Item\";O:4:\"Item\":46:{s:12:\"creator_User\";N;s:6:\"Author\";
N;s:15:\"creator_user_ID\";s:1:\"4\";s:13:\"assigned_User\";N;s:16:\"a
ssigned_user_ID\";N;s:10:\"issue_date\";s:19:\"2007-04-14
19:32:45\";s:8:\"mod_date\";s:19:\"2007-04-14
19:32:45\";s:6:\"status\";s:9:\"published\";s:6:\"locale\";s:5:\"en-
US\";s:5:\"title\";s:28:\"Into the Blogosphere: Day
14\";s:8:\"urltitle\";s:27:\"into_the_blogosphere_day_14\";s:7:\"conte
nt\";s:1909:\"One of the most superfluous and infernal posting
techniques employed by the accursedly lame blogospherians (aka daily
bloggers) to bloat their pathetic sites with new content is the
useless and used-too-often <strong>Regurgitated News Post</strong>.
Like Emperor Penguins that blow partially digested fish chunks into
their hungry chick\'s mouth to feed it\'s rabid appetite, so does the
daily blogger spew partially read/heard news articl
es from television, the web or newspapers to feed their blog\'s
appetite for daily content with the mistaken impression that their
readers care, or that they have readers at all.\r\n\r\nReaders who
apparently are so <strong><em>*poke* *poke*</em></strong> \"special\"
as to not be able to get news from tv, radio or the paper themselves
but rely on the daily blogger to keep them informed of the important
things like the weather, what\'s that great yellow scary ball of
fiery death up in the sky or who\'s the father of X Y or Z
celebrity\'s baby.\r\n\r\nThe Regurgitated News post is one of the
most useless weapons in the daily blogger\'s Keep Those Articles
a\'Coming arsenal since the posts are only \"important\" (ha!) for a
very short time. After that, they\'re even more of a waste of space
on the internet as usual. \r\n\r\nMultiply this tragedy by the number
of blogospherians out there that do this and you quickly see why the
web is drowning under their
plastic six-pack rings of posting death...\r\n\r\nAnd with that
said, I\'d like to discuss w/you all the <a
href=\"http://abcnews.go.com/US/wireStory?id=3042115\"
target=\"_blank\">recent accident</a> that injured New Jersey
Governor, Jon S. Corzine this Thursday. <a
href=\"http://abcnews.go.com/US/wireStory?id=3042115\"
target=\"_blank\">(click link)</a>.\r\n\r\nWear your seatbelt
kids.\r\n\r\nWe\'re glad to hear that despite his injuries NJ Gov.
Corzine is expected to make a full recovery.\r\n\r\nSeriously kids,
wear your $%#@!ing seat belts...
Sad\";s:13:\"content_pages\";N;s:9:\"wordcount\";s:3:\"289\";s:9:\"ren
derers\";s:17:\"b2WPAutP.b2evSmil\";s:14:\"comment_status\";s:4:\"open
\";s:3:\"url\";s:0:\"\";s:6:\"typ_ID\";s:1:\"1\";s:5:\"st_ID\";N;s:8:\
"deadline\";N;s:8:\"pr
iority\";s:1:\"3\";s:20:\"notifications_status\";s:8:\"finished\";s:2
1:\"notifications_ctsk_ID\";N;s:11:\"main_cat_ID\";s:2:\"14\";s:7:\"bl
og_ID\";s:1:\"5\";s:4:\"Blog\";O:4:\"Blog\":39:{s:9:\"shortname\";s:8:
\"Unincorp\";s:4:\"name\";s:23:\"Navarino
Unincorporated\";s:7:\"tagline\";s:0:\"\";s:9:\"shortdesc\";s:0:\"\";s
:8:\"longdesc\";s:0:\"\";s:6:\"locale\";s:5:\"en-
US\";s:11:\"access_type\";s:7:\"default\";s:7:\"siteurl\";s:0:\"\";s:1
4:\"staticfilename\";s:19:\"unincorporated.html\";s:4:\"stub\";s:18:\"
unincorporated.php\";s:7:\"urlname\";s:18:\"unincorporated.php\";s:13:
\"links_blog_ID\";N;s:5:\"notes\";s:0:\"\";s:8:\"keywords\";s:179:\"na
varino, humor, computers, quard, ferratio, fun, zany, comedian,
comedy, zdtv, techtv, vincent, unincorporated, vinny, angry
computerist, mitnick, labmistress, cornucopia of
evil\";s:13:\"allowcomments\";s:12:\"post_by_post\";s:15:\"allowtrackb
acks\";s:1:\"0\";s:12:\"allowblogcss\";s:1:\"1\";s:12:\"allowusercss\"
;s:1:\"1\";s:12:\"default_s
kin\";s:14:\"unincorporated\";s:10:\"force_skin\";s:1:\"1\";s:13:\"di
sp_bloglist\";s:1:\"0\";s:11:\"in_bloglist\";s:1:\"1\";s:3:\"UID\";N;s
:14:\"media_location\";s:6:\"custom\";s:12:\"media_subdir\";s:0:\"\";s
:14:\"media_fullpath\";s:38:\"/home/vincent/public_html/rants/media/\"
;s:9:\"media_url\";s:50:\"http://www.navarinounincorporated.com/rants/
media/\";s:18:\"CollectionSettings\";O:18:\"CollectionSettings\":8:{s:
9:\"_defaults\";a:2:{s:19:\"new_feedback_status\";s:5:\"draft\";s:12:\
"ping_plugins\";s:29:\"ping_pingomatic,ping_b2evonet\";}s:13:\"db_tabl
e_name\";s:15:\"T_coll_settings\";s:13:\"col_key_names\";a:2:{i:0;s:12
:\"cset_coll_ID\";i:1;s:9:\"cset_name\";}s:14:\"col_value_name\";s:10:
\"cset_value\";s:17:\"cache_by_col_keys\";i:1;s:5:\"cache\";a:1:{i:5;a
:2:{s:19:\"new_feedback_status\";O:8:\"stdClass\":4:{s:5:\"value\";s:9
:\"published\";s:10:\"dbUptodate\";b:1;s:8:\"dbRemove\"
;b:0;s:12:\"unserialized\";b:1;}s:12:\"ping_plugins\";O:8:\"stdClass\
":3:{s:5:\"value\";s:29:\"ping_b2evonet,ping_pingomatic\";s:10:\"dbUpt
odate\";b:1;s:8:\"dbRemove\";b:0;}}}s:10:\"all_loaded\";b:0;s:19:\"cou
nt_col_key_names\";i:2;}s:2:\"ID\";s:1:\"5\";s:11:\"dbtablename\";s:7:
\"T_blogs\";s:8:\"dbprefix\";s:5:\"blog_\";s:8:\"dbIDname\";s:7:\"blog
_ID\";s:17:\"datecreated_field\";s:0:\"\";s:18:\"datemodified_field\";
s:0:\"\";s:13:\"creator_field\";s:0:\"\";s:16:\"lasteditor_field\";s:0
:\"\";s:9:\"dbchanges\";a:0:{}s:19:\"delete_restrictions\";a:1:{i:0;a:
3:{s:5:\"table\";s:12:\"T_categories\";s:2:\"fk\";s:11:\"cat_blog_ID\"
;s:3:\"msg\";s:21:\"%d related
categories\";}}s:15:\"delete_cascades\";a:2:{i:0;a:3:{s:5:\"table\";s:
17:\"T_coll_user_perms\";s:2:\"fk\";s:16:\"bloguser_blog_ID\";s:3:\"ms
g\";s:25:\"%d user rights
defintions\";}i:1;a:3:{s:5:\"table\";s:15:\"T_subscriptions\";s:2:\"fk
\";s:11:\"sub_coll_ID\";s:3:\"msg\";s:16:\"%d
subscriptions\";}}}s:13:\"extra_cat_IDs\";N;s:5:
\"Links\";N;s:10:\"priorities\";a:5:{i:1;s:11:\"1 -
Highest\";i:2;s:8:\"2 - High\";i:3;s:10:\"3 - Medium\";i:4;s:7:\"4 -
Low\";i:5;s:10:\"5 -
Lowest\";}s:19:\"content_prerendered\";N;s:2:\"ID\";s:3:\"309\";s:11:\
"dbtablename\";s:7:\"T_posts\";s:8:\"dbprefix\";s:5:\"post_\";s:8:\"db
IDname\";s:7:\"post_ID\";s:17:\"datecreated_field\";s:11:\"datecreated
\";s:18:\"datemodified_field\";s:12:\"datemodified\";s:13:\"creator_fi
eld\";s:15:\"creator_user_ID\";s:16:\"lasteditor_field\";s:16:\"lasted
it_user_ID\";s:9:\"dbchanges\";a:0:{}s:19:\"delete_restrictions\";a:2:
{i:0;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:16:\"link_dest_it
m_ID\";s:3:\"msg\";s:24:\"%d links to source
items\";}i:1;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:14:\"post
_parent_ID\";s:3:\"msg\";s:23:\"%d links to child
items\";}}s:15:\"delete_cascades\";a:3:{i:0;a:3:{s:5:\"table\";s:7:\"T
_links\";s:2:\"fk\";s:11:\"link_itm_ID\";s:3:\"msg\";s:29:\"%d links
to destination items\";}i:1;a:3:{s:5:\"table\";s:10:\"
T_postcats\";s:2:\"fk\";s:15:\"postcat_post_ID\";s:3:\"msg\";s:28:\"%
d links to extra
categories\";}i:2;a:3:{s:5:\"table\";s:10:\"T_comments\";s:2:\"fk\";s:
15:\"comment_post_ID\";s:3:\"msg\";s:11:\"%d
comments\";}}s:7:\"objtype\";s:4:\"Item\";s:11:\"datecreated\";s:19:\"
2007-04-14 19:32:45\";s:12:\"datemodified\";s:19:\"2007-04-14
19:32:45\";s:16:\"lastedit_user_ID\";s:1:\"4\";s:5:\"views\";s:1:\"9\"
;}s:7:\"item_ID\";s:3:\"309\";s:11:\"author_User\";O:4:\"User\":38:{s:
5:\"login\";s:16:\"vincent
navarino\";s:4:\"pass\";s:32:\"67fea38e62c5f1a6d8ee725b8e147a09\";s:9:
\"firstname\";s:7:\"Vincent\";s:8:\"lastname\";s:8:\"Navarino\";s:8:\"
nickname\";s:5:\"Vinny\";s:6:\"idmode\";s:6:\"namefl\";s:6:\"locale\";
s:5:\"en-
US\";s:5:\"email\";s:12:\"vnav@cox.net\";s:3:\"url\";s:37:\"http://www
.navarinounincorporated.com\";s:3:\"icq\";s:1:\"0\";s
:3:\"aim\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:3:\"yim\";s:0:\"\";s:2:\"i
p\";s:0:\"\";s:6:\"domain\";s:0:\"\";s:7:\"browser\";s:0:\"\";s:11:\"d
atecreated\";s:19:\"2004-08-08
13:02:26\";s:5:\"level\";s:2:\"10\";s:6:\"notify\";s:1:\"1\";s:10:\"sh
owonline\";s:1:\"1\";s:13:\"allow_msgform\";s:1:\"1\";s:9:\"validated\
";s:1:\"1\";s:10:\"_num_posts\";N;s:8:\"group_ID\";s:1:\"1\";s:5:\"Gro
up\";N;s:18:\"blog_post_statuses\";a:0:{}s:11:\"cache_perms\";a:0:{}s:
2:\"ID\";s:1:\"4\";s:11:\"dbtablename\";s:7:\"T_users\";s:8:\"dbprefix
\";s:5:\"user_\";s:8:\"dbIDname\";s:7:\"user_ID\";s:17:\"datecreated_f
ield\";s:0:\"\";s:18:\"datemodified_field\";s:0:\"\";s:13:\"creator_fi
eld\";s:0:\"\";s:16:\"lasteditor_field\";s:0:\"\";s:9:\"dbchanges\";a:
0:{}s:19:\"delete_restrictions\";a:4:{i:0;a:3:{s:5:\"table\";s:7:\"T_p
osts\";s:2:\"fk\";s:21:\"post_lastedit_user_ID\";s:3:\"msg\";s:33:\"%d
posts last edited by this
user\";}i:1;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:21:\"post_
assigned_user_ID\";s:3:
\"msg\";s:30:\"%d posts assigned to this
user\";}i:2;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:20:\"link_
creator_user_ID\";s:3:\"msg\";s:29:\"%d links created by this
user\";}i:3;a:3:{s:5:\"table\";s:7:\"T_links\";s:2:\"fk\";s:21:\"link_
lastedit_user_ID\";s:3:\"msg\";s:33:\"%d links last edited by this
user\";}}s:15:\"delete_cascades\";a:5:{i:0;a:3:{s:5:\"table\";s:14:\"T
_usersettings\";s:2:\"fk\";s:12:\"uset_user_ID\";s:3:\"msg\";s:31:\"%d
user settings on
collections\";}i:1;a:3:{s:5:\"table\";s:10:\"T_sessions\";s:2:\"fk\";s
:12:\"sess_user_ID\";s:3:\"msg\";s:31:\"%d sessions opened by this
user\";}i:2;a:3:{s:5:\"table\";s:17:\"T_coll_user_perms\";s:2:\"fk\";s
:16:\"bloguser_user_ID\";s:3:\"msg\";s:28:\"%d user permissions on
blogs\";}i:3;a:3:{s:5:\"table\";s:15:\"T_subscriptions\";s:2:\"fk\";s:
11:\"sub_user_ID\";s:3:\"msg\";s:16:\"%d
subscriptions\";}i:4;a:3:{s:5:\"table\";s:7:\"T_posts\";s:2:\"fk\";s:2
0:\"post_creator_user_ID\";s:3:\"msg\";s:29:\"%d posts created by t
his
user\";}}}s:9:\"author_ID\";s:1:\"4\";s:4:\"type\";s:7:\"comment\";s:6
:\"status\";s:9:\"published\";s:6:\"author\";N;s:12:\"author_email\";N
;s:10:\"author_url\";N;s:9:\"author_IP\";s:13:\"68.96.187.213\";s:4:\"
date\";s:19:\"2007-04-15 11:30:47\";s:7:\"content\";s:51:\"blue: 1
gweep: 0<br />\n<br
/>\n<em>buuuurrrnnn!</em>\";s:10:\"spam_karma\";N;s:13:\"allow_msgform
\";N;s:2:\"ID\";i:0;s:11:\"dbtablename\";s:10:\"T_comments\";s:8:\"dbp
refix\";s:8:\"comment_\";s:8:\"dbIDname\";s:10:\"comment_ID\";s:17:\"d
atecreated_field\";s:0:\"\";s:18:\"datemodified_field\";s:0:\"\";s:13:
\"creator_field\";s:0:\"\";s:16:\"lasteditor_field\";s:0:\"\";s:9:\"db
changes\";a:8:{s:12:\"comment_type\";a:2:{s:4:\"type\";s:6:\"string\";
s:5:\"value\";s:4:\"type\";}s:15:\"comment_post_ID\";a:2:{s:4:\"type\"
;s:6:\"number\";s:5:\"value\";s:7:\"post_ID\";}s:17:\"comment_author_I
D\";a:2:{s:4:\"type\";s:6:\"number\";s:5:\"value\";s:9:\"author_ID\";}
s:17:\"comment_author_IP\";a:2:{s:4
:\"type\";s:6:\"string\";s:5:\"value\";s:9:\"author_IP\";}s:12:\"comm
ent_date\";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"value\";s:4:\"date\"
;}s:15:\"comment_content\";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"valu
e\";s:7:\"content\";}s:14:\"comment_status\";a:2:{s:4:\"type\";s:6:\"s
tring\";s:5:\"value\";s:6:\"status\";}s:24:\"comment_original_content\
";a:2:{s:4:\"type\";s:6:\"string\";s:5:\"value\";s:16:\"original_conte
nt\";}}s:19:\"delete_restrictions\";a:0:{}s:15:\"delete_cascades\";a:0
:{}s:7:\"post_ID\";s:3:\"309\";s:16:\"original_content\";s:41:\"blue:
1 gweep:
0\r\n\r\n<em>buuuurrrnnn!</em>\";}}s:24:\"core.no_CachePageContent\";a
:2:{i:0;N;i:1;i:1;}}',
sess_ipaddress = "68.96.187.213",
sess_key = 'EV4iYxTBjcdjFzodyZQh5PrplLKNIpS5',
sess_lastseen = "2007-04-15 11:30:47",
sess_user_ID = 4

WHERE sess_ID = 424

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Got error 127 from storage engine(Errno=1030)

Your query:

SELECT COUNT(*) AS totalHits, hit_referer, dom_name

FROM evo_hitlog
INNER JOIN evo_useragents ON hit_agnt_ID = agnt_ID
LEFT JOIN evo_basedomains ON dom_ID = hit_referer_dom_ID

WHERE hit_referer_type IN ('referer')

Additional information about this error:

MySQL error!

Got error 134 from storage engine(Errno=1030)

Your query:

SELECT sess_ID, sess_key, sess_data, sess_user_ID

FROM evo_sessions

WHERE sess_ID = '424'

AND sess_key = 'EV4iYxTBjcdjFzodyZQh5PrplLKNIpS5'

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Got error 134 from storage engine(Errno=1030)

Your query:

SELECT sess_ID, sess_key, sess_data, sess_user_ID

FROM evo_sessions

WHERE sess_ID = '424'

AND sess_key = 'EV4iYxTBjcdjFzodyZQh5PrplLKNIpS5'

AND UNIX_TIMESTAMP(sess_lastseen) > 1176057056

AND UNIX_TIMESTAMP(sess_lastseen) > 1176057056

AND agnt_type = "browser"
AND hit_blog_ID = '5'
GROUP BY dom_name
ORDER BY totalHits DESC

2 Apr 17, 2007 22:13

This is a horrible post! It makes the page a million pixels wide. Blech!!! Anyway google "mysql error 127" and it looks like it might be a mysql bug. I can't figure out who's saying what when I follow what google shows me though.

3 Apr 18, 2007 01:09

Sorry about that Ed; somewhere in my wp and the forum editor the formatting got stripped; I've redone it. I would have noticed and redone the mangled mess sooner but my power supply decided to sizzle like bacon.

4 Apr 18, 2007 04:52

Cool. Have you found any resolution on your issue? Trying to follow what I found from google seemed to imply that it's an intermittent problem that may or may not be associated with the version of mysql on your server. Also I think some people said that had to analyze & repair the questionable table many times. Seems a common situation is tables with large numbers of entries, if that helps any.

5 Apr 18, 2007 09:38

Thanks Ed, so far no joy on a resolution. It's only been a full day since the last error. I will try next time it occurs to analyze and repair more than a few times through phpmyadmin and see what goes on from there. will write back if problem seems to go away or a cause is known.


Form is loading...