brantb Posted October 24, 2013 Posted October 24, 2013 I've been unable to find the answer to this question, but if a thread exists, then I'll be happy to be redirected to that thread. Here goes my question: I'm just trying to figure out how to change the sort option for products in the category section. Right now it's showing up as.. natural/alpha numeric? (It doesn't go 1-10 right now) I'd like to make it so that it goes in a normal 1-10 Fashion. Can someone please at the very least direct me to where this sort would be located in the code? Thanks
♥GLWalker Posted October 29, 2013 Posted October 29, 2013 Theres a few ways to sort, but perhaps something like this is what you want? http://addons.oscommerce.com/info/8311 Follow the community build: BS3 to osCommerce Responsive from the Get Go! Check out the new construction: Admin Gone to Total BS!
heppu Posted February 27, 2014 Posted February 27, 2014 Does anyone have solution for different categories problem. Older Oscommence had everything ok, but new version does not list Swedish/Finnish/Danish/Norwegian (Ä Ö Å etc) characters in correct alphabet order. http://en.wikipedia.org/wiki/Finnish_alphabet It makes category list like... Istuin Jääpalakone Jojo Hardware-> (6) ..while correct is... Istuin Jojo Jääpalakone Hardware-> (6) Or is this Mysql or PHP problem (different versions too)?
♥bruyndoncx Posted February 27, 2014 Posted February 27, 2014 that is because of collation settings, I guess they are different now from what they were https://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
heppu Posted February 27, 2014 Posted February 27, 2014 Thanks. I try to change this setting in Mysql (phpMyAdmin), but it does not let me change it. Default is utf8_general_ci, and I need the utf8_swedish_ci. Whats up here? No Privileges (it does not say anything)?
heppu Posted February 28, 2014 Posted February 28, 2014 Thanks. I try to change this setting in Mysql (phpMyAdmin), but it does not let me change it. Default is utf8_general_ci, and I need the utf8_swedish_ci. Whats up here? No Privileges (it does not say anything)? Problem is that if I change Collate settings, it will affect only new tables (?). So I did try this with my test server: -Export old database to file (make backup off the file too...) -delete old database -greate new database and user/passw for it (use same old, no need to modify config) -change Operations/Collate to utf8_swedish_ci -read the old database Export-file, if there is lines with utf8_general_ci, replace all off them with utf8_swedish_ci -Import fixed file to new database This seems to work, I also try to add new Categories in Oscommence, and they go in right place. But better test again before do it in real shop!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.