Hi! I have a big problem and I'll thank very much if somebody can help me...
I deleted by mistake the folder istats of Web Stats module. I copied it again and put it inactive and uninstalled it, but it showed me some uninstalling errors. And now I'm trying to install it again and this error message appears:

Installing Web Stats
Table 'xoops_is_daycount' already exists
Unable to install istats. Error(s):
Back to Module Administration page

Anybody knows how can I fix it?
Thank a lot in advance

ReySolar

Hi ReySolar,

First just try running istats, if you just deleted the folder and did not touch the database it should run fine after reuploading the files.

If that dosen't work the you will have to drop the tables for istats in the database manually, using phpmyadmin or equivalent tool.

If you ever delete a module directory by accident just reupload and continue using. should be no problems as long as the database is intact.

HTH.

Thanks for the fast answer!
I reuploaded the files immediately I realized the mistake and it worked fine I suppose, and so I thought that the problem was solved. Then I tried to uninstall istats (Web Stats) correctly. The module was uninstalled succesfully as it said, but it shows some errors for three tables that were not dropped. That's why I think that something changed in the database.
Now istats is uninstalled and it don't let me install it again...
So, how I drop the tables for istats in the database manually and how I identify the files or lines that I have to delete?
Where I get phpmyadmin or equivalent tool?
Thanks again!!!

ReySolar

You host should supply some kind of interface to the database.

I prefer and shop for cPanel hosting, as it gives me complete control of my site.

The tables will looks something like this:



Quote:

Drop all tables found like this, the xxxps is a fake prefix as I copied mine.

Thanks! But I have some more questions...
1) In what file are these rows?
2) Drop means delete?
3) Can I use some freeware instead of cpanel?

ReySolar

is your data on a remote or local server?

Remote check with your host for how to access the tables. Local there are several utilities that ship with MySQL that can do this.

Within these tables is the data that istats displays.

Thanks a lot jdseymour!

My data in on a remote server. Tomorrow I 'll ask my host how to acces the database (the .sql file, I think) to delete these tables (the rows you say, I think).
A final question: drop means delete... is it true?

ReySolar

Yes drop means delete.

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

Anybody?

ReySolar