Genius admin droped Table nuke_bbsessions

AwwYouDead · Hangin' Around Joined: Apr 02, 2006 Posts: 38

My genius admin tried to fix a session error while I was away. Instead of waiting for me he assumed "DROP" ment "empty"
... Anyhow I have browsed around a bit trying to find the info i need to create a new nuke_bbsessions Table. version is .23

Gremmie · Posted: Sat Aug 09, 2008 6:53 pm

You can download phpBB or bb2nuke again and look at the install script.

But I have it right here:

Code:

CREATE TABLE `nuke_bbsessions` (
`session_id` char(32) character set latin1 NOT NULL default '',
`session_user_id` mediumint(8) NOT NULL default '0',
`session_start` int(11) NOT NULL default '0',
`session_time` int(11) NOT NULL default '0',
`session_ip` char(8) character set latin1 NOT NULL default '0',
`session_page` int(11) NOT NULL default '0',
`session_logged_in` tinyint(1) NOT NULL default '0',
`session_admin` tinyint(2) NOT NULL default '0',
KEY `session_user_id` (`session_user_id`),
KEY `session_ip` (`session_ip`),
KEY `session_id` (`session_id`)
) ENGINE=MyISAM;

Gremmie · Posted: Sat Aug 09, 2008 6:54 pm

You don't have backups? Shocked

testy1 · Involved Joined: Apr 06, 2008 Posts: 483

Gremmie wrote:

You don't have backups? Shocked

i dont know why but i nearly fell off my chair lol

AwwYouDead · Hangin' Around Joined: Apr 02, 2006 Posts: 38

Gremmie wrote:

You don't have backups? Shocked

yeah actually i thought i did but apparently they are blank... Thats a different problem all together. useually my backups are fine. but with my last 4 being empty files my most recent back up is like 6 months old.

And thank you for the Table.