Totally Zenned
- Join Date:
- Oct 2006
- Posts:
- 5,422
- Plugin Contributions:
- 0
Views: 1,113,830
Totally Zenned
Totally Zenned
countrycharm:
Under links_aliases field there is
id
link_url
link_alias
status
alias_type
referring_id
permanent_linkThey are not unique keys. Should I delete link_url and link_alias?
Hey Country if you get this mod to work would you let me know how you did it. I just installed this mod 4 weeks ago on a different site and it worked fine till I start using the currency conversion when I start getting all kinds of error. I went to install it today and its a whole new files and structure. I am not sure why there is a new version almost every week.
Totally Zenned
I think we will get there someday. My data base is telling me that
#1071 - Specified key was too long; max key length is 1000 bytes
ALTER TABLE links_aliases ADD UNIQUE link_url ( link_url , link_alias ) ;
Totally Zenned
Thank you yellow for your help on this problem I was having upgrading. By dropping the links_aliases table in phpmyadmin and using the code you gave me work like a charm. Thank you again. I will let you know if the cron job work tomorrow. I have it set to run twice an hour.
Zen Follower
Hello yellow1912!
after a little war in Israel, I'm back and ready to TEST :) :flex:
Totally Zenned
xordox:
Hello yellow1912!
after a little war in Israel, I'm back and ready to TEST :) :flex:
Hi xordox, I'm very sorry to hear about that. And it's great to see you are back.
Zen Follower
Yellow,
I try to upgrade ssu to 3.6.3. but got error:
1071 Specified key was too long; max key length is 1000 bytes
in:
[ALTER TABLE links_aliases ADD UNIQUE link_url ( link_url , link_alias );]
I try to do it ( ALTER TABLE links_aliases ADD UNIQUE link_url ( link_url , link_alias ); ) by differents way, but no luck
Please tell me how I can resolve it?
Totally Zenned
This is what you can do:
drop the table, the run this (if you run on phpmyadmin, add the prefix to the table name)
REATE TABLE IF NOT EXISTS links_aliases (
id int(10) NOT NULL auto_increment,
link_url varchar(255) NOT NULL default '',
link_alias varchar(255) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '1',
alias_type varchar(100) NOT NULL default 'none',
referring_id int(10) NOT NULL default '0',
permanent_link tinyint(1) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY link_url (link_url,link_alias)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Then go to module_version_tracker table and manually change SSU to patch 14. I will now investigate why the alter command in the new patch always cause some problem.
Zen Follower
I just upgrade ssu to 3.6.3, the problem was in "collation" :
when it was :
link_url varchar(255) utf8_general_ci
link_alias varchar(255) utf8_general_ci
I got this error:
1071 Specified key was too long; max key length is 1000 bytes
When I changed to :
link_url varchar(255) latin1_swedish_ci
link_alias varchar(255) latin1_swedish_ci
I got:
Warning Your module needs to be upgraded
Success 3 statements processed.
Success Upgraded database to patch level 14
Please tell me can I now change back to utf8_general_ci ?
Totally Zenned
ahh, I see, but actually you can use utf8 since you may want to have some special utf8 alias in that, Just drop the unique key pair is okie, I'm changing the code a bit so that the "unique" checking will be done in php instead, this will avoid having to do this check in mysql
Regards
Raine
Zen Follower
Yellow,
I try to use ssu 3.6.3, and have some questions:
Totally Zenned
I installed this for a client today, and I must say its works pretty well... Cheers
I do have 2 questions...
The first is that when index.php is loaded it does deliver a proper canonical redirect... But to the incorrect canonical
so I am given
when it should be
Can I correct this easily?
Secondly, as this client would like to have the html added... can I do this without a big hassle?
Thanks for the contrib :clap:
~Melanie
Zen Follower
Yellow,
I checked ssu without Multi Language support (on site with 3 languages) and its generate many duplicate urls, and with Multi Language everething ok. and I think to fix it will take many time.
Instead, if we can only fix one redirection - Main page with default language (https://www.site.com/en to https://www.site.com), it will make first page with main language google friendly, and this page will get high page ranking
What do you think about it?
Totally Zenned
Ok after uninstalling and re-installing the latest version 3.6.4 from your site. The add to cart works for one item but If you try to add the same item twice to the shopping cart the quantity will not changed. Even if you go into the shopping cart and update the quantity to 2 or 3 the page will refresh but the quantity will remain on one. Is that a bug or its on my end.
Totally Zenned
Glamorousshoe:
Ok after uninstalling and re-installing the latest version 3.6.4 from your site. The add to cart works for one item but If you try to add the same item twice to the shopping cart the quantity will not changed. Even if you go into the shopping cart and update the quantity to 2 or 3 the page will refresh but the quantity will remain on one. Is that a bug or its on my end.
I am not having that issue.. would have to guess that is another mod or customization messing up or interfering.
~Melanie
Totally Zenned
Another question about this module in general I had it installed on a site 2 weeks ago and noticed that the customers are being redirected to a link that doesn't exist something like /includes/templates/your-template/buttons/english/mcnt_detail.gif
Now on this new site I am getting this link in the whose online page in the admin
/includes/templates/precutcartint/css/precutcartint/templates/precutcartint/images/header_bg.jpg
Is there an issue with the redirecting?
Totally Zenned
mprough:
I am not having that issue.. would have to guess that is another mod or customization messing up or interfering.
~Melanie
If I disable this mod in the admin, the quantity update works fine. I am guessing it has something to do with this mod.
Zen Follower
yellow1912:
I dont think version 3.5.8 has any bug that would cause this, but please upgrade right away to 3.6.3 first.
http://public.rubikintegration.com/Clearing cache then please let me know if the error is still there.
installed upgrade to 3.6.4 and still get redirect loop when customers try to login
Totally Zenned
I don't think this mod is interact well with other mods. I have tried to install it on 2 sites so far along with other mods installed and it seems to cause problems. So far I had to disable it on the 2 sites. Note I have installed the Ultimate SEO on my Aftermarket site found in the signature and don't have any redirecting problems. I had the same issue of redirecting on login but disabling this mod will eliminate the problem.
Totally Zenned
Glamorousshoe:
I don't think this mod is interact well with other mods. I have tried to install it on 2 sites so far along with other mods installed and it seems to cause problems. So far I had to disable it on the 2 sites. Note I have installed the Ultimate SEO on my Aftermarket site found in the signature and don't have any redirecting problems. I had the same issue of redirecting on login but disabling this mod will eliminate the problem.
I think you have to tell us your version as well as the modules you said it doesnt work well with, otherwise it wont help. I have a site where we installed all the major modules along with this module and we dont have any problem at all.
Tell staff why this post should be reviewed.