1
ReySolar
Help me!!! Where istat tables begins and where it ends?
  • 2005/3/30 0:29

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi everybody!

I have to drop istat tables from the database and, for avoiding more mistakes, I need that somebody tells 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'll wait an answer to delete it...
Thanks

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`
--

2
jdseymour
Re: Help me!!! Where istat tables begins and where it ends?

Hi again ReySolar,

Here is the entire table list for istats:

xxxxps_is_browser
Browse: (5 Rows) xxxxps_is_color
Browse: (1 Rows) xxxxxps_is_count
Browse: (129 Rows) xxxxps_is_daycount
Browse: (1388 Rows) xxxxps_is_hostname
Browse: (24 Rows) xxxxps_is_hour
Browse: (5 Rows) xxxxps_is_mth
Browse: (31 Rows) xxxxps_is_mth_days
Browse: (24 Rows) xxxxps_is_os
Browse: (1113 Rows) xxx2xps_is_page
Browse: (190 Rows) xxxxps_is_referer
Browse: (7 Rows) xxxxps_is_screen
Browse: (24 Rows) xxxxps_is_today_hour
Browse: (7 Rows) xxxxps_is_week
Browse: (21 Rows) xxxxps_is_week_count

14 tables total.

3
ReySolar
Re: Help me!!! Where istat tables begins and where it ends?
  • 2005/3/30 11:37

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi!
Thanks a lot jdseymour, but you didn't answer my last question... Please, read it to realize what I'm tryng to say.
I understood what you're telling me, but I need to know exactly which rows I have to delete in order to don't make more mistakes, 'cause the number of istat table's rows in my database don't coincide with your specifications.
I have

xoops_is_daycount (17 rows, not 127 as you say)
xoops_is_mth (18 rows, not 5)
xoops_is_mth_days (46 rows, not 31)
xoops_is_referer (17 rows, not 187)
xoops_is_today_hour (39 rows, not 24)

That's why I include in the previous message the database file's rows I think that I have to delete...
Anybody knows or it's to try and try again till I found the right solution?
Thanks again and I'll appreciate specially a fast answer...

ReySolar

4
jdseymour
Re: Help me!!! Where istat tables begins and where it ends?

Yes ReySolar, that sounds right. The rows are records within the database. I may have more or less records in my database than you. It should work OK.

5
ReySolar
Re: Help me!!! Where istat tables begins and where it ends?
  • 2005/3/30 12:03

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


OK, thanks for your fast answer. I'll try to solve this and then I'll tell you what happened...

ReySolar

6
ReySolar
Re: Help me!!! Where istat tables begins and where it ends?
  • 2005/3/31 13:00

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi jdseymour!
1) Finally, I deleted de istat tables from the database and, in order to test it, I installed and uninstalled correctly the istats module again. So I realized that all the message errors during the first uninstallation were caused by a istat module's bug: while the istat tables are named "xoops_is_mth", "xoops_is_mth_days" and "xoops_is_today_hour", the uninstall instructions try to delete "xoops_is_month", "xoops_is_month_days" and "xoops_is_todayhour". Obviously, these tables can not be deleted in that way.
2) But now, I have another problem. Today, when I entered in my site, I found that the page works but it shows the known message error: "Done, with errors in the page" and I see that the attached photos at the news module are corrupted. Then I entered in the image manager and I saw that some files are missing and others are visually corrupted. Do you know what happened? How can I fix it? You can see it at http://www.periodistas-online.com.ar
Thank you very much

ReySolar

Login

Who's Online

205 user(s) are online (183 user(s) are browsing Support Forums)


Members: 0


Guests: 205


more...

Donat-O-Meter

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

Latest GitHub Commits