XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk

Subject:*
<
Name/Email:*
<
Message Icon:*
<
Select*
<
Message:*
<

 
 
 


Click the Preview to see the content in action.
Options:*
<
Confirmation Code*
< 		1 + 4 = ?  
Input the result from the expression
Maximum attempts you can try: 10
*
< 		   

Help!!! I have to drop istat tables from database
by ReySolar on 2005/3/29 19:01:27

Hi jdseymour!

For avoiding more mistakes, please confirm me if these are the rows that I have to delete. This is: from the row before "-- Table structure for table `xoops_is_daycount`" to two rows before "--
-- Table structure for table `xoops_marquee`". Is it right? Please, I wait your answer to delete it...
Thank you very much

ReySolar



--
-- Dumping data for table `xoops_imgsetimg`
--



--
-- Table structure for table `xoops_is_daycount`
--

CREATE TABLE `xoops_is_daycount` (
`id` int(10) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`daycount` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_daycount`
--



--
-- Table structure for table `xoops_is_mth`
--

CREATE TABLE `xoops_is_mth` (
`id` int(5) NOT NULL auto_increment,
`mth` char(2) NOT NULL default '',
`year` int(5) NOT NULL default '0',
`count` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_mth`
--



--
-- Table structure for table `xoops_is_mth_days`
--

CREATE TABLE `xoops_is_mth_days` (
`day` char(2) NOT NULL default '',
`count` int(10) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_mth_days`
--


INSERT INTO `xoops_is_mth_days` VALUES ('01',0);
INSERT INTO `xoops_is_mth_days` VALUES ('02',0);
INSERT INTO `xoops_is_mth_days` VALUES ('03',0);
INSERT INTO `xoops_is_mth_days` VALUES ('04',0);
INSERT INTO `xoops_is_mth_days` VALUES ('05',0);
INSERT INTO `xoops_is_mth_days` VALUES ('06',0);
INSERT INTO `xoops_is_mth_days` VALUES ('07',0);
INSERT INTO `xoops_is_mth_days` VALUES ('08',0);
INSERT INTO `xoops_is_mth_days` VALUES ('09',0);
INSERT INTO `xoops_is_mth_days` VALUES ('10',0);
INSERT INTO `xoops_is_mth_days` VALUES ('11',0);
INSERT INTO `xoops_is_mth_days` VALUES ('12',0);
INSERT INTO `xoops_is_mth_days` VALUES ('13',0);
INSERT INTO `xoops_is_mth_days` VALUES ('14',0);
INSERT INTO `xoops_is_mth_days` VALUES ('15',0);
INSERT INTO `xoops_is_mth_days` VALUES ('16',0);
INSERT INTO `xoops_is_mth_days` VALUES ('17',0);
INSERT INTO `xoops_is_mth_days` VALUES ('18',0);
INSERT INTO `xoops_is_mth_days` VALUES ('19',0);
INSERT INTO `xoops_is_mth_days` VALUES ('20',0);
INSERT INTO `xoops_is_mth_days` VALUES ('21',0);
INSERT INTO `xoops_is_mth_days` VALUES ('22',0);
INSERT INTO `xoops_is_mth_days` VALUES ('23',0);
INSERT INTO `xoops_is_mth_days` VALUES ('24',0);
INSERT INTO `xoops_is_mth_days` VALUES ('25',0);
INSERT INTO `xoops_is_mth_days` VALUES ('26',0);
INSERT INTO `xoops_is_mth_days` VALUES ('27',0);
INSERT INTO `xoops_is_mth_days` VALUES ('28',0);
INSERT INTO `xoops_is_mth_days` VALUES ('29',0);
INSERT INTO `xoops_is_mth_days` VALUES ('30',0);
INSERT INTO `xoops_is_mth_days` VALUES ('31',0);

--
-- Table structure for table `xoops_is_referer`
--

CREATE TABLE `xoops_is_referer` (
`id` int(10) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`count` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_referer`
--



--
-- Table structure for table `xoops_is_today_hour`
--

CREATE TABLE `xoops_is_today_hour` (
`hour` char(2) NOT NULL default '',
`count` int(10) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_today_hour`
--


INSERT INTO `xoops_is_today_hour` VALUES ('00',0);
INSERT INTO `xoops_is_today_hour` VALUES ('01',0);
INSERT INTO `xoops_is_today_hour` VALUES ('02',0);
INSERT INTO `xoops_is_today_hour` VALUES ('03',0);
INSERT INTO `xoops_is_today_hour` VALUES ('04',0);
INSERT INTO `xoops_is_today_hour` VALUES ('05',0);
INSERT INTO `xoops_is_today_hour` VALUES ('06',0);
INSERT INTO `xoops_is_today_hour` VALUES ('07',0);
INSERT INTO `xoops_is_today_hour` VALUES ('08',0);
INSERT INTO `xoops_is_today_hour` VALUES ('09',0);
INSERT INTO `xoops_is_today_hour` VALUES ('10',0);
INSERT INTO `xoops_is_today_hour` VALUES ('11',0);
INSERT INTO `xoops_is_today_hour` VALUES ('12',0);
INSERT INTO `xoops_is_today_hour` VALUES ('13',0);
INSERT INTO `xoops_is_today_hour` VALUES ('14',0);
INSERT INTO `xoops_is_today_hour` VALUES ('15',0);
INSERT INTO `xoops_is_today_hour` VALUES ('16',0);
INSERT INTO `xoops_is_today_hour` VALUES ('17',0);
INSERT INTO `xoops_is_today_hour` VALUES ('18',0);
INSERT INTO `xoops_is_today_hour` VALUES ('19',0);
INSERT INTO `xoops_is_today_hour` VALUES ('20',0);
INSERT INTO `xoops_is_today_hour` VALUES ('21',0);
INSERT INTO `xoops_is_today_hour` VALUES ('22',0);
INSERT INTO `xoops_is_today_hour` VALUES ('23',0);

--
-- Table structure for table `xoops_marquee`
--
Re: Help!!! Uninstall problem
by jdseymour on 2005/3/29 0:11:09

Yes you can use either notepad or wordpad, or any other text editor that does not add formatting to the text.

The sql file from what I see looks correct. It will drop, create tables, then insert data into those tables. Would not know for sure with out testing. For anything adding tables manually to my database I test it on my test site first.

HTH.
Re: Help!!! Uninstall problem
by ReySolar on 2005/3/28 22:07:44

Anybody?

ReySolar
Re: Help!!! Uninstall problem
by ReySolar on 2005/3/28 11:31:39

Hi! I was making some experiment with an old database about the suggested solution and, in order to don't make more mistakes, I ask:

1) The database icon is the windows's symbol (that shows no program association), but when I edit the database file with notepad and I save it as .sql, the icon changes and it shows a notepad icon as a txt file. Is it ok? Can I also use wordpad?
2) In the following example, in what row begins and in what row ends any table to realize exactly what I have to delete in the database file?
3) Example:

(...)

DROP TABLE IF EXISTS xoops_avatar_user_link;
CREATE TABLE xoops_avatar_user_link (
avatar_id mediumint(8) unsigned NOT NULL default '0',
user_id mediumint(8) unsigned NOT NULL default '0',
KEY avatar_user_id (avatar_id,user_id)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `xoops_avatar_user_link` DISABLE KEYS */;

--
-- Dumping data for table `xoops_avatar_user_link`
--


LOCK TABLES xoops_avatar_user_link WRITE;
INSERT INTO xoops_avatar_user_link VALUES (1,1);

/*!40000 ALTER TABLE `xoops_avatar_user_link` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xoops_banner`
--

DROP TABLE IF EXISTS xoops_banner;
CREATE TABLE xoops_banner (
bid smallint(5) unsigned NOT NULL auto_increment,
cid tinyint(3) unsigned NOT NULL default '0',
imptotal mediumint(8) unsigned NOT NULL default '0',
impmade mediumint(8) unsigned NOT NULL default '0',
clicks mediumint(8) unsigned NOT NULL default '0',
imageurl varchar(255) NOT NULL default '',
clickurl varchar(255) NOT NULL default '',
date int(10) NOT NULL default '0',
htmlbanner tinyint(1) NOT NULL default '0',
htmlcode text NOT NULL,
PRIMARY KEY (bid),
KEY idxbannercid (cid),
KEY idxbannerbidcid (bid,cid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `xoops_banner` DISABLE KEYS */;

--
-- Dumping data for table `xoops_banner`
--


LOCK TABLES xoops_banner WRITE;
INSERT INTO xoops_banner VALUES (1,1,0,315,1,'http://www.periodistas-online.com.ar/images/banners/xoops_banner.gif', 'https://xoops.org/',1008813250,0,''),
(2,1,0,325,2,'http://www.periodistas-online.com.ar/images/banners/xoops_banner_2.gif', 'https://xoops.org/',1008813250,0,''),
(3,1,0,320,0,'http://www.periodistas-online.com.ar/images/banners/banner.swf', 'https://xoops.org/',1008813250,0,''),
(4,2,0,147,1,'http://www.porloschicos.com/PorLosChicos.NET/img/ban5.gif', 'http://www.porloschicos.com/PorLosChicos.NET/PorLosChicos.aspx? comando=donar',1107636125,0,'');

/*!40000 ALTER TABLE `xoops_banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xoops_bannerclient`
--

(...)

4) BY EXAMPLE, I SUPPOSE THAT TABLE 'XOOPS_BANNER' BEGINS IN:

--
-- Table structure for table `xoops_banner`
--


5) AND ENDS BEFORE:

--
-- Table structure for table `xoops_bannerclient`
--


6) SO I'LL HAVE TO DELETE ALL THIS TOO:

--
-- Dumping data for table `xoops_banner`
--


LOCK TABLES xoops_banner WRITE;
INSERT INTO xoops_banner VALUES (1,1,0,315,1,'http://www.periodistas-online.com.ar/images/banners/xoops_banner.gif', 'https://xoops.org/',1008813250,0,''), (2,1,0,325,2,'http://www.periodistas-online.com.ar/images/banners/xoops_banner_2.gif', 'https://xoops.org/',1008813250,0,''), (3,1,0,320,0,'http://www.periodistas-online.com.ar/images/banners/banner.swf', 'https://xoops.org/',1008813250,0,''), (4,2,0,147,1,'http://www.porloschicos.com/PorLosChicos.NET/img/ban5.gif', 'http://www.porloschicos.com/PorLosChicos.NET/PorLosChicos.aspx? comando=donar',1107636125,0,'');


/*!40000 ALTER TABLE `xoops_banner` ENABLE KEYS */;
UNLOCK TABLES;

--


7) IS IT TRUE?
Thanks, thanks and thanks

ReySolar
Re: Help!!! Uninstall problem
by jdseymour on 2005/3/28 1:47:59

Yes drop means delete.

Search

Advanced Search

Recent Posts

Who's Online

233 user(s) are online (174 user(s) are browsing Support Forums)

Members: 0

Guests: 233

more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits