Forum for users of JoomlaWatch / ExtraWatch for Joomla, Wordpress, Drupal, Magento, Prestashop

JoomlaWatch / ExtraWatch has following features: live real-time visitor statistics, location of your visitors on a map, blocking of users based on bad word list, front-end counters, click heat map, definition of goals and rules, graphs, directory size monitoring, monitoring of increase of database data in time, nightly email reports, interactive HTML5 chart of traffic flow within your website, SEO report with keyword statistics and keyword position trends

Welcome, Guest
Please Login or Register.    Lost Password?

1.2.18 failed to install - sql error
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: 1.2.18 failed to install - sql error
*
#3372
1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
Hi.

tried to update 1.2.17 > 1.2.18 on a Joomla 1.5.25 site but install of com_joomlawatch.zip failed, so had to reinstall 1.2.17

Checked settings to preserve them before deinstalling existing component and used the specified and latest 1.5 Joomlawatch file.
a

JInstaller::install: SQL Error. DB function failed with error number 1062
Duplicate entry \'/index.php?option=com_contact&view=contact&id=7&Item\' for key 2 SQL=alter table jos_joomlawatch_uri2title add unique(uri);
SQL =
alter table jos_joomlawatch_uri2title add unique(uri);
Component Install: SQL Error. DB function failed with error number 1062
Duplicate entry \'/index.php?option=com_contact&view=contact&id=7&Item\' for key 2 SQL=alter table jos_joomlawatch_uri2title add unique(uri);
SQL =
alter table jos_joomlawatch_uri2title add unique(uri);


Odd as this a published contact that has existed for years

mysite/index.php?option=com_contact&view=contact&id=7&Item
Wicky9 (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3373
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
1.2.18 is for joomla 1.6, Matto is busy making also an installer for joomla 1.5 because that version installs on a diffrent way
delliano (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3374
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 31
Hi,
no. It's not because it won't install on 1.5. It installs both on Joomla 1.5 and 1.6/1.7
The true reason behind this error is, that I made changes in table structures. (some keys must be unique). I will provide the solution for you, but you must be patient, because there are currently some higher priorities.
Now you can just keep the database dump from mysql and reinstall without KEEP_DATA option on. We will import it later.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3376
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
hi got the same sql error on joomla 1.7.3 with new joomlawatch ver
installed old joomlawatch ver and it's working again..
waiting for your solution thnx
gigatech (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3378
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 31
Hi Guys,
I fixed it with:

ALTER IGNORE TABLE #__joomlawatch_uri2title ADD UNIQUE INDEX(uri);

in install script.

Tested on Joomla 1.5 and 1.7

Latest file in customer zone.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3379
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
Hi Matto,

That worked a treat. many thanks for the speedy fix!

Cheeers Kpjm
Wicky9 (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3380
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
Small technical problem since installation. IP addresses that I click to ban doesn't work, it comes up with the pop up 'Really toggle blocking of IP ***.**' but it doesn't seem to get entered in the blocked database indicated by the strikethrough. The same happens when trying to manually enter the IP.

All the old blocked IP addresses appear intact and I'm able to enter new goals to achieve the same blocking effect.

Any ideas Matto?

Please contact me for the site's admin access if this will help.

Cheers
Wicky9 (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3381
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 31
this is because blocking table has more columns now.. didn't realize that.
I'll try to modify the install script the way that old table will have the desired columns.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3382
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 31
as a quick fix, please run the following SQL in your phpMyAdmin:

ALTER TABLE jos_joomlawatch_blocked add column `country` varchar(2) DEFAULT NULL;

ALTER TABLE jos_joomlawatch_blocked add column `badWord` varchar(255) DEFAULT NULL;
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3383
Re: 1.2.18 failed to install - sql error 4 Years, 11 Months ago Karma: 0
Cheers matto

IP blocking now works

Ta muchly J
Wicky9 (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1