Tag Module Install Error
Posted: 29 October 2008 06:44 AM   [ Ignore ]
Newbie
Rank
Total Posts:  5
Joined  2008-10-29

Hi There,

I have working version of Expression Engine Core installed on my webserver.

I have purchased the Tag module from Solspace and followed the installation instructions at the following URL:

http://www.solspace.com/how_to_install

When performing the following step I get a MySQL error and cannot get the module to install.

2. a) Go to your Modules tab inside your EE control panel. Find the module you uploaded in the list and click Install.

This is the MySQL output:

NoticeUndefined indexcharacter_set_client in /home/webfeatc/domains/web-feat.co.uk/public_html/EE/system/modules/tag/mcp.tag.php on line 161
MySQL ERROR
:

Error Number1064

Description
You have an error in your SQL syntaxCheck the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 15

Query
CREATE TABLE exp_tag_tags tag_id int(10unsigned NOT NULL auto_incrementtag_alpha char(3NOT NULLtag_name varchar(200NOT NULLsite_id smallint(3unsigned NOT NULL default '1'author_id int(10unsigned NOT NULLentry_date int(10NOT NULLedit_date int(10NOT NULL default '0'clicks int(10NOT NULL default '0'total_entries int(10NOT NULL default '0'weblog_entries int(10NOT NULL default '0'gallery_entries int(10NOT NULL default '0'PRIMARY KEY (tag_id), KEY (tag_name) ) CHARACTER SET utf8 COLLATE utf8_general_ci 

Could anyone suggest a reason for this problem, as up until this I have had absolutely no problems using expression engine!

Regards,
Freddy

Profile
 
 
Posted: 29 October 2008 06:50 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  8238
Joined  2006-10-18

Hey Fred,

(Got your email)
What is your Default Character Set set here: smile

CP Home ›  Admin ›  System Preferences ›  General Configuration

 Signature 
Profile
 
 
Posted: 29 October 2008 07:01 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  5
Joined  2008-10-29

My default character set is currently set to “utf-8”.

Thanks,
Fred

Profile
 
 
Posted: 29 October 2008 07:11 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  8238
Joined  2006-10-18

Sorry… I missed the part where you said you are running EE Core… that might the issue here wink

Would you be able to provide CP and FTP access?

Which version of EE Core are you running? smile

 Signature 
Profile
 
 
Posted: 29 October 2008 07:40 AM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  5
Joined  2008-10-29

Please could you advise how I can send these to you as the forum says I do not have sufficient privileges to send PMs!

Fred.

Profile
 
 
Posted: 29 October 2008 07:46 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  8238
Joined  2006-10-18

Strange… you should be able to…

Email them to me: kelsey AT solspace.com smile

 Signature 
Profile
 
 
Posted: 29 October 2008 08:01 AM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  5
Joined  2008-10-29

Sent :d

Fred

Profile
 
 
Posted: 29 October 2008 11:44 AM   [ Ignore ]   [ # 7 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  8238
Joined  2006-10-18

Fred,

It appears you’re using below MySQL version 4.1, and Tag 2.5 is not compatible.
I would suggest that if you own/run the server, you upgrade MySQL, or contact your webhost smile

If you cannot do either of these, let me know, and I can give you a refund.
Otherwise, we could try an earlier version of Tag.

 Signature 
Profile
 
 
Posted: 30 October 2008 05:20 AM   [ Ignore ]   [ # 8 ]
Newbie
Rank
Total Posts:  5
Joined  2008-10-29

Okay, I will have to move the site to a different hosting account then!

Thanks for your help!

Fred

Profile