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?

SQL-fout DB function failed error 1064
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: SQL-fout DB function failed error 1064
#3527
SQL-fout DB function failed error 1064 4 Years, 6 Months ago Karma: 0
What to do with error 1064?!

JInstaller::install: SQL-fout. 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_general_ci, `referer` varchar(255) SQL=CREATE TABLE IF NOT EXISTS `jos_joomlawatch` ( `id` int unsigned auto_increment primary key, `ip` varchar(255) default NULL, `country` varchar(2) default NULL, `browser` varchar(255) default NULL COLLATE utf8_general_ci, `referer` varchar(255) default NULL COLLATE utf8_general_ci, `username` varchar(255) default NULL COLLATE utf8_general_ci, KEY `ip` (`ip`), KEY `browser` (`browser`), KEY `country` (`country`) );
SQL = CREATE TABLE IF NOT EXISTS `jos_joomlawatch` (
`id` int unsigned auto_increment primary key,
`ip` varchar(255) default NULL,
`country` varchar(2) default NULL,
`browser` varchar(255) default NULL COLLATE utf8_general_ci,
`referer` varchar(255) default NULL COLLATE utf8_general_ci,
`username` varchar(255) default NULL COLLATE utf8_general_ci,
KEY `ip` (`ip`),
KEY `browser` (`browser`),
KEY `country` (`country`)
);
component Installeer: SQL-fout. 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_general_ci, `referer` varchar(255) SQL=CREATE TABLE IF NOT EXISTS `jos_joomlawatch` ( `id` int unsigned auto_increment primary key, `ip` varchar(255) default NULL, `country` varchar(2) default NULL, `browser` varchar(255) default NULL COLLATE utf8_general_ci, `referer` varchar(255) default NULL COLLATE utf8_general_ci, `username` varchar(255) default NULL COLLATE utf8_general_ci, KEY `ip` (`ip`), KEY `browser` (`browser`), KEY `country` (`country`) );
SQL = CREATE TABLE IF NOT EXISTS `jos_joomlawatch` (
`id` int unsigned auto_increment primary key,
`ip` varchar(255) default NULL,
`country` varchar(2) default NULL,
`browser` varchar(255) default NULL COLLATE utf8_general_ci,
`referer` varchar(255) default NULL COLLATE utf8_general_ci,
`username` varchar(255) default NULL COLLATE utf8_general_ci,
KEY `ip` (`ip`),
KEY `browser` (`browser`),
KEY `country` (`country`)
);
sebastiaan87 (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2012/03/18 09:45 By sebastiaan87.
The administrator has disabled public write access.
 
#3536
Re: SQL-fout DB function failed error 1064 4 Years, 6 Months ago Karma: 31
You're using old MySQL.. This component requires MySQL version 5 or above
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3537
Re: SQL-fout DB function failed error 1064 4 Years, 6 Months ago Karma: 0
you have it Right.
i'm using MySQL 4.
i sent a mail to the Active 24 support: to upgrade my MySQL to 5
Thanks for the information.
sebastiaan87 (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1

Latest News

Get the latest freelance project announcements
Follow CodeGravity.com

Download ExtraWatch™

ExtraWatch™ FREE is Joomla, Wordpress, Prestashop, Magento plugin with following features: Live Stats, Nightly Email Reports, Goals, Graphs, Anti-spam, History and more