mysql> USE totalwar_vb; No connection. Trying to reconnect... Connection id: 31173 Current database: *** NONE *** Database changed mysql> SELECT * FROM session LIMIT 1; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 31226 Current database: totalwar_vb +----------------------------------+--------+---------------+----------------------------------+--------------+-----------------------------------------------+--------------------------+---------+----------+---------+----------+------------+-------------+--------+------------+---------------+----------+ | sessionhash | userid | host | idhash | lastactivity | location | useragent | styleid | loggedin | inforum | inthread | incalendar | badlocation | bypass | languageid | profileupdate | newposts | +----------------------------------+--------+---------------+----------------------------------+--------------+-----------------------------------------------+--------------------------+---------+----------+---------+----------+------------+-------------+--------+------------+---------------+----------+ | (removed) | 0 | (removed) | (removed) | 1172806656 | /forums/private.php?do=showpm&pmid=322204 | Mediapartners-Google/2.1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | NULL | +----------------------------------+--------+---------------+----------------------------------+--------------+-----------------------------------------------+--------------------------+---------+----------+---------+----------+------------+-------------+--------+------------+---------------+----------+ 1 row in set (0.00 sec) mysql> UPDATE session SET userid=0 WHERE sessionhash='nonexistent'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 31323 Current database: totalwar_vb Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 | username | userid | +----------------+--------+ | Zenith Darksea | 2308 | +----------------+--------+ 1 row in set (0.01 sec) mysql> SELECT * FROM post LIMIT 1; +--------+----------+----------+----------------+--------+-------------------------+------------+----------------------------------------+-------------+---------------+--------------+--------+---------+--------+----------------+--------------+------------+----------------+ | postid | threadid | parentid | username | userid | title | dateline | pagetext | allowsmilie | showsignature | ipaddress | iconid | visible | attach | importthreadid | importpostid | infraction | reportthreadid | +--------+----------+----------+----------------+--------+-------------------------+------------+----------------------------------------+-------------+---------------+--------------+--------+---------+--------+----------------+--------------+------------+----------------+ | 918171 | 49130 | 918158 | Zenith Darksea | 2308 | Re: Happy Greek Easter! | 1145659888 | Yes indeed, Happy Greek Easter to all! | 1 | 1 | (removed) | 0 | 1 | 0 | 0 | 0 | 0 | 0 | +--------+----------+----------+----------------+--------+-------------------------+------------+----------------------------------------+-------------+---------------+--------------+--------+---------+--------+----------------+--------------+------------+----------------+ 1 row in set (0.00 sec) mysql> SELECT userid FROM session LIMIT 1; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 33497 Current database: totalwar_vb +--------+ | userid | +--------+ | 0 | +--------+ 1 row in set (0.00 sec) mysql> SHOW CREATE TABLE session; +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | session | CREATE TABLE `session` ( `sessionhash` char(32) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `host` char(15) NOT NULL default '', `idhash` char(32) NOT NULL default '', `lastactivity` int(10) unsigned NOT NULL default '0', `location` char(255) NOT NULL default '', `useragent` char(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `loggedin` smallint(5) unsigned NOT NULL default '0', `inforum` smallint(5) unsigned NOT NULL default '0', `inthread` int(10) unsigned NOT NULL default '0', `incalendar` smallint(5) unsigned NOT NULL default '0', `badlocation` smallint(5) unsigned NOT NULL default '0', `bypass` tinyint(4) NOT NULL default '0', `languageid` smallint(5) unsigned NOT NULL, `profileupdate` smallint(5) unsigned NOT NULL, `newposts` int(10) unsigned default NULL, PRIMARY KEY (`sessionhash`) ) ENGINE=MEMORY DEFAULT CHARSET=latin1 | +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW TABLES; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 33597 Current database: totalwar_vb +-------------------------+ | Tables_in_totalwar_vb | +-------------------------+ | access | | adminhelp | | administrator | | adminlog | | adminmessage | | adminutil | | adv_modules | | adv_pages | | adv_setting | | adv_settinggroup | | announcement | | announcementread | | attachment | | attachmentpermission | | attachmenttype | | attachmentviews | | avatar | | bbcode | | calendar | | calendarcustomfield | | calendarmoderator | | calendarpermission | | cpsession | | cron | | cronlog | | customavatar | | customprofilepic | | datastore | | deletionlog | | dl_cats | | dl_comments | | dl_downloads | | dl_files | | dl_images | | dl_main | | dl_stats | | dl_votes | | editlog | | event | | externalcache | | faq | | forum | | forumpermission | | forumread | | holiday | | icon | | imagecategory | | imagecategorypermission | | infraction | | infractionban | | infractiongroup | | infractionlevel | | language | | mailqueue | | moderation | | moderator | | moderatorlog | | passwordhistory | | paymentapi | | paymentinfo | | paymenttransaction | | phrase | | phrasetype | | plugin | | pm | | pmreceipt | | pmtext | | podcast | | podcastitem | | poll | | pollvote | | post | | posthash | | postindex | | postindex_temp30064 | | postindex_temp30069 | | postindex_temp30355 | | postindex_temp34371 | | postindex_temp38419 | | postindex_temp38420 | | postindex_temp38812 | | postindex_temp38813 | | postindex_temp38833 | | postindex_temp42094 | | postindex_temp42470 | | postindex_temp43212 | | postindex_temp43213 | | postindex_temp44162 | | postindex_temp44677 | | postindex_temp44883 | | postindex_temp44884 | | postindex_temp46180 | | postindex_temp46181 | | postindex_temp46223 | | postindex_temp47308 | | postparsed | | product | | productcode | | productdependency | | profilefield | | ranks | | regimage | | reminder | | reputation | | reputationlevel | | rssfeed | | rsslog | | search | | session | | setting | | settinggroup | | sigparsed | | sigpic | | smilie | | stats | | strikes | | style | | subscribeevent | | subscribeforum | | subscribethread | | subscription | | subscriptionlog | | subscriptionpermission | | tachyforumpost | | tachythreadpost | | template | | templatehistory | | thread | | threadrate | | threadread | | threadredirect | | threadviews | | upgradelog | | user | | useractivation | | userban | | userfield | | usergroup | | usergroupleader | | usergrouprequest | | usernote | | userpromotion | | usertextfield | | usertitle | | vbfields | | word | | wsnkb_categories | | wsnkb_comments | | wsnkb_email | | wsnkb_links | | wsnkb_markup | | wsnkb_membergroups | | wsnkb_members | | wsnkb_pm | | wsnkb_ratings | | wsnkb_sessions | | wsnkb_settings | | wsnkb_switches | +-------------------------+ 158 rows in set (0.00 sec)