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?

500 Error - bad mySQL query
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: 500 Error - bad mySQL query
#3521
500 Error - bad mySQL query 4 Years, 8 Months ago Karma: 0
500 - JDatabaseMySQLi::query: 1054 - Unknown column 'browser' in 'where clause' SQL=DELETE FROM wxyz_joomlawatch_uri WHERE browser is not NULL and fk < 7743

Doing a text search I see there 2 queries that reference the 'browser' field in class.joomlawatch.visit.php

No such field exists.

In JoomlaWatch-1.2.18-PRO-Joomla-UnzipFirst.zip - the sql code does not add this field to the #__joomlawatch_uri table.

Should this be the #__joomlawatch_history table instead?
pjbauer (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3526
Re: 500 Error - bad mySQL query 4 Years, 8 Months ago Karma: 31
Hi, fixed it in the latest version, please just download it from the 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.
 
Go to topPage: 1