deleting the old database

[mankind]

hello,


I want to delete the old database that contains categories & links
how can i do this step ???

[piet]

phpmyadmin would be my choiche

[Bruceper]

Log into phpmyadmin and flush idx_category and idx_link

[mankind]

Thank you both piet and Bruceper


* Bruceper if u use PayPal is easier 4 us to pay you for valuable services than moneybookers.com

[mankind]

should I delete the idx_category and idx_link or

only make them empty , a fatal error has appeared in my site

when i deleted those 2 databases

Fatal error: Call to a member function Fields() on a non-object in /home/dalemah6/public_html/globeuniversities/lib/category.class.php on line 393

www.globeuniversities.com

[Bruceper]

No, do not delete idx_category or idx_link. You only empty (truncate) them.

I do not accept paypal. I accept credit cards via my merchant account, moneybookers or money orders.

[mankind]

No, do not delete idx_category or idx_link. You only empty (truncate) them.
.

how can I return this file because i have deleted it

idx_category

[FSGDAG]

You should be able to re-create the table through phpMyAdmin. Use the following:

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(9) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `image` varchar(100) default NULL,
  `content` text,
  `visible` char(1) default NULL,
  `links` mediumint(9) default NULL,
  `meta_keyword` text,
  `meta_description` text,
  `permission` char(2) default NULL,
  `registered_only` char(1) default NULL,
  `header` text NOT NULL,
  `footer` text NOT NULL,
  `related` mediumint(6) NOT NULL default '0',
  `page_title` varchar(200) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `order_num` smallint(6) NOT NULL default '0',
  `basic_price` double unsigned NOT NULL default 0,
  `premium_price` double unsigned NOT NULL default 0,
  `sponsored_price` double unsigned NOT NULL default 0,
  PRIMARY KEY  (`category_id`)
);