Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BrockleyJohn

Members
  • Posts

    1,427
  • Joined

  • Last visited

  • Days Won

    37

Everything posted by BrockleyJohn

  1. I can't figure where your encoding gets changed - when I download the add-on it comes out with a £. Anyway, I've moved it to the end so if it fails it doesn't destroy anything else.
  2. There's a note in the install that at the time of writing (20/7/2008) SPPC 4.2.2 wasn't compatible with QBPPC version 1.3 Maybe that's still true of the download - but if you're lucky, someone that's fixed it will be following this thread ;) If not, and you can't work out why, you might need to use an earlier version of QBPPC
  3. I don't think that's anything to do with the breadcrumb bit; the updates higher up in application_top.php (beginning around line 315 and ending around line 494) will redirect you to the front page of the site in some circumstances. That's why I think the breadcrumb change probably isn't really needed. If you're prevented from taking a cart with no hidden products into checkout, there's probably a problem in these edits and I suggest using a file compare tool to see what the differences are between your application_top and the one in the add-on.
  4. Try replacing $name_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] ."' and language_id = '" . (int)$languages_id . "'"); with // BOF SPPC Hide products and categories from groups $name_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] ."' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and language_id = '" . (int)$languages_id . "'"); // EOF SPPC Hide products and categories from groups In all honesty, this is an educated guess ;) If it gives problems, I suggest just keeping the original. I've just been having a think how you would test it, and I believe you'd only need the code if you tried to display a product that's hidden from your group - eg. on a link direct to a product. So to test it, view a product, then in admin hide the product from the group, then refresh the view and see what happens. HTH
  5. The original file contains '£' Most likely you used Import in phpAdmin with the wrong character set (as then the £ can be interpreted as a carriage return and you lose one quote). If, however, the zip file you downloaded doesn't contain '£', then it's surprising that it's not been mentioned before as you're not the first to download and use it.
  6. It may be as a result of a character set problem in the first statement. Try rerunning the rest of the statements, starting with just the one where the error came, ie. UPDATE configuration SET configuration_value='222' WHERE configuration_key = 'SHIPPING_ORIGIN_COUNTRY';
  7. It's TEXT_GREETING_PERSONAL in includes/languages/english.php if I remember right (or maybe ....._RELOGON?)
  8. I don't know if you have been, but report your problems in the support thread for the addon. You may not get any help, but at least you're letting other people know what to expect. Then maybe if you're lucky and someone needs to fix it, they'll let you know when they've done it, or you'll find they already did. It's not unusual for files to get missed out of a package, and it's not easy for the developer to pick up on either; you might just be missing a file. I spent several hours debugging a problem with one addon, only to find later by reading the instructions for modifying the code that there was a file missing from the package. It was clear the whole time from the support thread that loads of people already had it working, so I knew it had to be something obvious.
  9. Glad you've got it going... and in case the lesson hasn't sunk in, always make sure you can revert to how it was before you started installing the last contribution; the easiest way is to keep copying your files (you don't have to keep all the copies forever and they're a lot smaller if you zip them).
  10. Sorry, my bad. Download the previous version; you need both uploads by escri in 2009..
  11. Yes, either that or use the files from the directory new_installations_2.2 which are unchanged from the previous download (I have just double-checked that they don't include the text template_top). You must have used new_installations_2.3.1
  12. Thanks Jerry. Sending emails and newsletters worked ok in mine too, so does hiding attributes from groups (e.g. only offer deluxe model to retail customers). It occurs to me that I didn't test if tax id number is properly handled; I know the field appears on the page when company is enabled, but I didn't check it's inserted to the database, retrieved & displayed, updated correctly if amended.
  13. Here's a tip you may find useful if you're going to be adding add-ons; keep a copy of your original files, and any changes you make to them so it's easy to go back to how it was before. If you've plenty of diskspace you can just copy the whole site, or you can just keep accumulations of the changed files, which is quicker if you have to upload them. Now for your problem. First, it sounds like you might have downloaded the files from your web site over the top of the UK files, which would replace them with the standard ones. You can tell by comparing the file sizes, or go into create an account and see where postcode comes in the order of fields. If you have to, copy the files again and upload again - this will give you UK date format, county instead of state, Town / County / Postcode order in the account address pages, but the store will still think it's in Florida and the prices will still be in dollars and euros. The sql isn't totally essential; you can add the GBP currency and change all the store settings manually if you have to. But it's certainly quicker if you can run it. Your hosting almost certainly gives you a way to do it, and for many add-ons it'll be essential for installing them so it's worth finding out how. If you have cpanel, it's probably got a tool called phpAdmin which you can use to 'import' the whole file. Alternatively, there might be forms to 'run a query' and you can copy and paste from the sql file into here (probably in one go). If it's still not obvious, I suggest checking your hosting FAQ before calling their support. If you happen to end up with a funny character instead of a pound sign (eg. a white question mark in a black diamond), you had a problem with the "character set". Just go to osc admin / localization / currencies and edit GBP to replace it with the proper sign. Incidentally, if you have a browser that's looking at the website while you run the sql, you'll find that when you browse afterwards all the prices go to zero. This is just because it's confused by the changes, closing and reopening it or switching currency to euros and back will sort it out. HTH
  14. My set of 2.3.1 files are now uploaded and awaiting moderation. I've applied code changes as described in the SPPC 4.2.2 documentation (including the optional ones for emails and newsletters), changing them where appropriate for 2.3.1. There were only a few places that needed to be a lot different, but quite a lot of places that had to be a bit different. I've been through the usage documentation and checked that all the features behave as described; I can't put hand on heart and say I've designed and gone through a complete set of test cases (cos I haven't!), but I have spent more than half a day testing and bug-fixing. In particular, if there were any bugs in the SPPC 4.2.2 code that have been fixed in the supplied 2.2 files but not in the code changes in the implementation documentation, they won't be fixed in my uploaded code unless I came across them in testing.
  15. I'm about to embark on a 2.3.1 install of SPPC for the new client, and I'd be happy to apply SPPC as the first add-on to an unmodified 2.3.1 store so the files can be put together for others to use. However, I think it would be a good idea if one or two people with good experience of 2.2 SPPC implementations were to volunteer to do some beta testing before it's released, as I've not used the add-on yet myself and won't be using the full breadth it for my client. If you'd be willing, please PM me and I'll be in touch when I think it's in a fit state (sometime in March). Incidentally, the second add-on is likely to be Hide products from customer groups for SPPC.
  16. Version 1.1 now available; now there are two implementation methods: - you can overwrite the files downloaded for osc 2.3.1 and then just run an install - if the store's ready-loaded (eg. from hosting panels), you can update it to be UK-based
  17. You can overwrite the php files anytime, it won't make a difference, but you'll have to run the sql after you've run the install. If you want to run the sql as part of the install, it needs adding to the end of catalog/install/oscommerce.sql I'll upload a new version of the addon including this edited sql too, but I'll have to test it first.
  18. This add-on is for a complete install of 2.2 with UK bits and pieces. I've just uploaded a separate add-on to convert a fresh osc 2.3.1 install into a UK version, it's at http://addons.oscommerce.com/info/7845
  19. It's a quick-and-dirty adaptation for a virgin install that converts the sample data into UK versions. Background ========== Intended for use with a newly installed osCommerce store, either from download or through cpanel, fantastico etc It will change the installed US currency & tax to UK versions by updating them, so that the sample data still works. It sets up a tax zone for all Europe. Doesn't install counties so the field remains free text. Address pages are changed to move postcode above country. Language files have UK date formats, county instead of state.
  20. Hi again, Jack. I think there's something with the editor code in articles.php for TinyMCE Anywhere: When creating or editing an article it's invoked ok, but in the preview page, below the preview of the article, you get editable fields for all the descriptions, with the content in them too. Further, if you go ahead and save, the fields are all wiped (like, I read somewhere, if you don't use the Anywhere version of TinyMCE), so in my install you can't use this editor. If it's a problem with my TinyMCE installation, it's not exhibited for products, categories etc configured through Header Tags SEO. If others have this problem and an immediate workaround is needed, CKEditor works fine (I didn't try FCKEditor). Incidentally, I think I'll take the editor off the meta description fields; unless you remembered what the reason was for including that option in Header Tags SEO?
  21. Apologies if this also has been mentioned, though I didn't find it. (Using the _other versions of 1.57_6) In admin article manager, when you go back in to edit an article with both status and blog status set to green, after updating the blog status goes back to red. Is this by design? cheers, J
  22. another bit of missing SQL: DROP TABLE IF EXISTS articles_blog; CREATE TABLE articles_blog ( unique_id int(11) NOT NULL auto_increment, articles_id int(11) NOT NULL default 0, customers_id int(11) NOT NULL default 0, commenters_name varchar(54) default NULL, comment_date_added datetime NOT NULL default '0000-00-00 00:00:00', comments_status tinyint(1) NOT NULL default '0', comment text NOT NULL default '', language_id int(11) NOT NULL default '1', PRIMARY KEY (unique_id), KEY idx_articles_id (articles_id) ) TYPE=MyISAM;
  23. Hi Jack; some great new features in the last year. A couple of errata in update_v_1.57_5_to_1.57_6.txt to report. Symptom of the first was the following error when opening the admin/Article Manager menu (if anyone's searching for a solution): 1054 - Unknown column 'a.articles_is_blog' in 'field list' missing SQL statement in 1): ALTER TABLE `articles` ADD `articles_is_blog` TINYINT( 1 ) NOT NULL AFTER `articles_status`; missing define in 9) (updates to includes/languages/english.php): define('BOX_ALL_BLOG_ARTICLES', 'All Blog Articles'); Plus, when I was looking in the clean install files for the above define, I noticed that the one specified in the update file isn't in oscommerce_other/catalog/includes/languages/english.php - specifically define('BOX_ARTICLES_BLOG_COMMENTS', 'Blog Comments'); cheers, John
  24. bah! If I'd searched everywhere for "hide" instead of "show" or "visibility", I'd have found it a lot sooner... (if anyone else can't find it, it's Hide products from customer groups for SPPC, http://addons.oscommerce.com/info/2970)
  25. I'm looking into starting with SPPC as the basis of a solution for a client who wants to offer different pricing to non-members & maybe have different levels of membership too. As far as I can gather from the documentation, the module only affects visibility of pricing (and specials) but all products and default prices are visible to everyone. If that's the case, has anyone already implemented a version that affects the visibility of products by group? Or does anyone have a similar requirement and we could see if there's any scope for collaboration?
×
×
  • Create New...