
Originally Posted by
econcepts
The SQL query you referenced in this post should be run from a tool like phpmyadmin (all others in the install package should be run by copy and pasting them into the SQL Patch tool within your Zen Cart admin (under "Tools" menu.). All the query you listed is used for is to get your "id" that needs to be plugged into the proper location in the file referenced in my original post.
This query does not do anything in the way of installing the mod. You already ran that one earlier (you said) and that should be complete.
Let me know if that helps.
SO MANY PEOPLE ARE HAVING PROBLEMS WITH YOUR SQL CODE BECAUSE YOU NEED TO CORRECT YOU BASIC CODING!!!!!!!!
THANKS FOR THE FRUSTRATION & WASTING HOURS OF MY LIFE I WILL NOT GET BACK ECONCEPTS!!!!!!!!
For SQL File (googleanalytics-INSTALL.sql) the following need to be corrected:
Code:
DROP TABLE IF EXISTS google_analytics_languages;
CREATE TABLE google_analytics_languages (
languages_id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
code char(10) NOT NULL default '',
sort_order int(3) default NULL,
PRIMARY KEY (languages_id),
KEY idx_languages_name_zen (name)
) TYPE=MyISAM;
TO:
Code:
DROP TABLE IF EXISTS google_analytics_languages;
CREATE TABLE google_analytics_languages (
languages_id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
code char(10) NOT NULL default '',
sort_order int(3) default NULL,
PRIMARY KEY (languages_id),
KEY idx_languages_name_zen (name)
) ENGINE=MyISAM;
IM SO MAD AT YOU RIGHT ABOUT NOW!!!!!
Bookmarks