reinstall drop tables sys_catagories

Hello,

I was trying to remove some categories in myphp admin and like an idiot I drop tables as I thought it would delete the checked categories.

I have spent hours on getting it all tweaked and I don't want to use my back up as it's old.

Can you tell me how to get it imported to phpadmin back to it's original state as I am getting DB error

on the url.

Please note I am a noob, not hard to guess really !

Thanks

Steve

Yuck - you can try to recreate the table by extracting the appropriate part of the v70.sql file, which is in the install directory when you download a fresh install, that then pasting that back into phpmyadmin.  I'm not smart enought to know how to do this, however.  Maybe someone else here is.

what tables did you drop ?

Execute this mysql query with your phpmyadmin :

--
-- Table structure for table `sys_categories`
--

CREATE TABLE `sys_categories` (
`Category` varchar(32) NOT NULL default '',
`ID` int(10) unsigned NOT NULL default '0',
`Type` varchar(20) NOT NULL default 'photo',
`Owner` int(10) unsigned NOT NULL,
`Status` enum('active', 'passive') NOT NULL default 'active',
`Date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY  (`Category`, `ID`, `Type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Hi Sasha,

YOU SAVED MY LIFE !

Done the trick all back and running.

Thanks very much

Steve

you are welcome