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?

JoomlaWatch SQL issue [solved]
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: JoomlaWatch SQL issue [solved]
#229
JoomlaWatch SQL issue [solved] 9 Years, 1 Month ago Karma: 0
This is the fault message that i got: is there someone who can help me to solve this problem, using joomla 1.013 thanks milo


SQL Error DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci default NULL, `uri` varchar(255) c SQL=CREATE TABLE IF NOT EXISTS `jos_joomlawatch` ( `id` int(11) NOT NULL auto_increment, `timestamp` int(11) default NULL, `ip` varchar(255) collate utf8_unicode_ci default NULL, `uri` varchar(255) collate utf8_unicode_ci default NULL, `title` varchar(255) collate utf8_unicode_ci default NULL, `country` varchar(2) collate utf8_unicode_ci default NULL, `browser` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=160040 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=160040;
SQL =

CREATE TABLE IF NOT EXISTS `jos_joomlawatch` (
`id` int(11) NOT NULL auto_increment,
`timestamp` int(11) default NULL,
`ip` varchar(255) collate utf8_unicode_ci default NULL,
`uri` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`country` varchar(2) collate utf8_unicode_ci default NULL,
`browser` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=160040
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=160040;<br><br>Post edited by: matto, at: 2007/10/31 14:18
milobaron (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#236
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 0
I am having the same issue, joomla version 1.0.12 stable

SQL Error DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci default NULL, `uri` varchar(255) c SQL=CREATE TABLE IF NOT EXISTS `jos_joomlawatch` ( `id` int(11) NOT NULL auto_increment, `timestamp` int(11) default NULL, `ip` varchar(255) collate utf8_unicode_ci default NULL, `uri` varchar(255) collate utf8_unicode_ci default NULL, `title` varchar(255) collate utf8_unicode_ci default NULL, `country` varchar(2) collate utf8_unicode_ci default NULL, `browser` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=160040 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=160040;
SQL =
CREATE TABLE IF NOT EXISTS `jos_joomlawatch` (
`id` int(11) NOT NULL auto_increment,
`timestamp` int(11) default NULL,
`ip` varchar(255) collate utf8_unicode_ci default NULL,
`uri` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`country` varchar(2) collate utf8_unicode_ci default NULL,
`browser` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=160040
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=160040;
saumz (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#240
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 31
It's because you are using old version of MySQL.

Try to remove the COLLATE=... attribute in the joomlawatch.xml and please report if it worked.

I'll fix it later and put the updated .zip online.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#241
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 31
Done..

I made the create table queries much more simple:

CREATE TABLE IF NOT EXISTS `#__joomlawatch` (
`id` int(11) NOT NULL auto_increment,
`timestamp` int(11) default NULL,
`ip` varchar(255) collate utf8_unicode_ci default NULL,
`uri` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`country` varchar(2) collate utf8_unicode_ci default NULL,
`browser` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`) );

and:

CREATE TABLE IF NOT EXISTS `#__joomlawatch_ip2c` (
`start` int(10) unsigned NOT NULL default '0',
`end` int(10) unsigned NOT NULL default '0',
`a2` char(2) collate utf8_unicode_ci NOT NULL default '',
`a3` char(3) collate utf8_unicode_ci NOT NULL default '',
`country` varchar(100) collate utf8_unicode_ci NOT NULL default '',
PRIMARY KEY (`start`,`end`) );


It should work hopefully on most of the databases.

So, just download the changed .zip file again and re-install the component.

Please report if it worked.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#246
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 0
We have same problem too , and the server stop with HTTP 500 faulire
JOOMLA ver:1.013 stable
Where is the changed zip file?

Thank you your work!

Greeteings from Budapest!

::
Greeting to nice city of Budapest, I've been there two weeks ago.

Just re-download it from www.codegravity.com/download/
It's the same filename, but the content is updated.<br><br>Post edited by: matto, at: 2007/10/29 03:55
oldies (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#247
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 0
Thank YOU matto!
On the front side they work but the icon is l, but the administrator menu when i click to the wach icon the system hung, and iget the HTTP 500 page.

the first edition 3 days ago also that was the problem, and today i make one fress installation to test it again.

I runing the latest wamp server in localhost Apache/2.2.4 (Win32), 5.2.4
and MySQL version.

any deal?

Next trip in Budapest call me....+36 30 9328 661

Misi

And Thanks again!
oldies (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#251
Re:JoomlaWatch install problem 9 Years, 1 Month ago Karma: 31
In such cases HTTP error 500 please contact your system administrator. He should be responsible for that.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1