Jump to content
Latest News: (loading..)

MrPhil

Members
  • Content count

    7,976
  • Joined

  • Last visited

  • Days Won

    106

Everything posted by MrPhil

  1. MrPhil

    My database do not work?

    osC 2.3.4? You're running an obsolete version. The proper one to run is 2.3.4.1BS "Frozen" (plus patches) -- see links below in my signature. PHP 7.2 is way too up-level for osC 2.3.4. Did your host just upgrade your server's PHP? It's not good to roll back for long to an unsupported PHP version (e.g., 5.4), but you might ask if there is a way for you to do that. See if your server control panel has something like "MultiPHP Manager" or the like, to let you select your PHP. If you can roll back PHP to the point where your store resumes working, use the grace period gained to upgrade to Frozen and transfer your store's data over. Long term, you should be running PHP 7.1 (or higher), the current lowest supported PHP version, which means going to Frozen. There is never a need to re-enter your store's data. You can always migrate the database content to the new layout (schema). It's a fairly simple (although tedious) job. Your configure.php files, in their database section, will tell you the name of the database you're using. You can then use your server control panel to delete the unused one, if you wish. Do NOT post your configure.php file content here without first removing or ***-ing out your database information!
  2. MrPhil

    Where is The Orders

    If the site is working (showing products, allowing account creation and signon, etc.) the database is correctly connected. The usual cause of trouble like you're seeing is that the user does not proceed correctly after going offsite to make a payment (is that what CCBill does?), but exits at that point (after payment) without returning to the store. Have you tried carefully going through a purchase, returning to the store after completing the payment? It's also possible that you did not configure CCBill correctly to return to the store. I'm not familiar with CCBill, so I can't offer any more information on it. Maybe they have a log of what happened and where it tried to go (URL). Before going any further, what osCommerce release have you installed? I suspect you installed the "official" 2.3.4.1 version off this site, but unfortunately it is totally obsolete. The one you should be running is "Frozen" + patches (see links below), or "Edge" if you're adventurous. These are sometimes generically referred to as 2.3.4.1BS or 2.3.4.1 CE. Did some consultant select this for you, who also provided the custom template? Who knows what you're running on. Templates can range anything from some CSS settings in user.css to a complete replacement for much of the store. A template built for the official version is usually not going to work with Frozen or Edge, so that's money down the drain.
  3. You want to make sure you're at "Frozen" + patches (see links below). That's the one you should be running at (use "Edge" only if you enjoy being on the bleeding edge of development). Anything else is totally obsolete, and even the official release 2.3.4 or 2.3.4.1 kludged to use Bootstrap is questionable (if that's what PL is selling -- I don't know). If there are added features or templating in this version you purchased, they would have to be replicated in some manner (add-ons and custom code). Even if their release is Frozen- or Edge-based, you are likely still locked in to their support and upgrades in the future, as anything here may not be compatible or applicable. Just keep that in mind.
  4. Uh, in case this is leading anyone astray, it's a lot more than just linking in some .css and .js files. All the display code (.php) needs to be updated to make use of Bootstrap's functionality. The official osC code won't take advantage of anything in Bootstrap. It may not be official osC, but it's the only game in town. osC is dead, and there will almost certainly never be another official release. The current official release is quite obsolete -- in addition to being non-responsive (fatal in today's market) it only works properly up to PHP 5.4 or so. Official 2.3.4.1 has PHP 7 "deprecated" warnings turned off, but apparently had no other work done to be PHP 7 compliant. You use the Community Edition or you take your ball and go home. Harald has dropped hints that he's alive and well, but failing to interact with the community in over a year and a half is unacceptable. Even if he is working on a super osC 2.4 or 3.1 to surprise and delight us with, that is unacceptable behavior. Waiting so long between official releases kills the product -- it has to start all over again each time to (re)gain mindshare and acceptance in the ecommerce market. As far as I'm concerned, he's killed osC. Only Gary's unofficial CE releases are keeping it somewhat alive. It's become his personal project.
  5. MrPhil

    value output

    Well, you didn't answer my question about the data type, but I'll assume this is for table (weight) shipping cost, so it would be a string in PHP. The more general case would be $table_list being a string of comma-separated fields, each max_weight:cost. The following would split up this long list $table_list into two numbers per entry: $max_weight and $cost. $entries = explode(',', $table_list); foreach ($entries as $entry) { ($max_weight, $cost) = explode(':', $entry); // do what you want with this weight and cost } I didn't get fancy and try to split it with preg_split(), because there might be spaces at both the commas and the colons. You'll have to trim off any leading and trailing spaces around the number, if you want pretty formatting. If all you have is the $entry, as in your first post, the explode(':', $entry) line would do the job.
  6. MrPhil

    value output

    What kind of data is this in the database? Is it a string (TEXT, etc.)? Is its format consistent, or is it something that could vary quite a bit? By the way, a question like this belongs in PHP / SQL / Web Design.
  7. If you want your entire store to be under SSL, you need to change all the HTTP_ entries from http: to https:. It's not just the one Jack mentioned; there are several.
  8. Yes, if the customer's browser doesn't have that file cached, it could be ugly. You can always copy the file to your site, and modify the references to it in your store to point to your local copy. Bootstrap and "hooks" are two entirely separate things. The "CE"/Frozen/Edge versions have both, the official release has neither. Unfortunately, you'll be in for a bit of code editing to either put Bootstrap into the official release (a bad idea anyway, since it still leaves you at PHP 5.4 compatibility) or removing hooks from the CE version (I'm sure that's quite a bit of effort). Wouldn't it so much easier to modify add-ons you want to use, to use hooks (if necessary) rather than modifying the base store to be hookless?
  9. You could certainly set up a processor on your PC to take the incoming .csv or .txt file and write a new .csv file back out, ready for either manual database import or through Easy Populate. There would be several data configuration files associated with it: markup per category, markup for specific products (override per category), and category per product. You would manually maintain these configuration files with an ordinary editor. When you run the new .csv or .txt file through the processor, it would tell you if any products are missing a category (likely new products) and you would update the category file and rerun the processor. A bonus feature would be to compare the new output to the previous one (saved from the previous time it was run) and only write new and changed entries, in order to run the update faster (dozens or hundreds of updates rather than tens-of-thousands each time).
  10. Why are you going into Excel (or any other spreadsheet) to add columns and calculate prices? You should be able to read the CSV file with a scripting language such as Perl, and write it back out with new columns with prices and such. How many manual decisions do you need to make for each product? Can it all be reduced to a formula? What about categorizing new products -- is that manually done? You should only have to do it once, for a product or manufacturer, and keep that information around in a file. For routine functions, you should be able to take an incoming CSV or txt file and convert it to something useful to read in either manually or via Easy Populate, without any human intervention.
  11. Is there any time you would not need the without-tax price? You could just price it "with tax" and be done with it, I suppose. Or, add a new database column for "with tax" price, and use that always or on a selector of some sort (modified query)? Are tax rates going to vary by customer?
  12. MrPhil

    Flat Rate Shipping

    It sounds like you want to start with a flat rate for each class (size) of item, and then offer a shipping discount for multiples of a given product. Is that correct? You're going to have to be able to explain this clearly to your customers! I'm not sure why it would cost £18.00 to ship one each of A, B, and C, while only £6.00 to ship three of A, but moving on... I don't think there's anything built in to osC to do this. You'd have to add code to the shipping module to calculate everything flat rate, then look at the quantity for each item and offer a discount: 2 of A, discount £6.00, 3 or 4 of A, discount £12.00, 5 of A, discount £18.00 ??, etc. If I understand you. That ought to be reducible to a formula, but will have to be custom code (unless you can find an add-on that already handles this).
  13. There are some "Easy Populate" modules floating around, that let you update product information from a CSV (text) file. Take a look at that and see if any do the job.
  14. That's going to be complicated. I understand that sorting is done during the SQL query, which is without tax, and then any tax is added on in a separate step. Someone might write code to take a large array of product information, after tax has been added, and re-sort it to fix the order. It's ugly, but unless you can find a way to have the tax added to the price during the SQL query (before sort), that's the only way that I know of doing it. I take it you're in a country that requires that prices be displayed with tax (where applicable), rather than allowing prices without tax?
  15. MrPhil

    version with php7.2

    @zpupster, Lunarpages has been slowly upgrading its shared servers to 7.2 by default, with 5.6 and 7.1 available. Mine was done just a couple months ago. They added in cPanel (possibly LPCP on your server) a "MultiPHP manager" which lets me select the PHP level -- the default was 7.2, but I set mine back to 7.1 so Frozen would run. They would not force everyone to 7.2 with no way to switch to an earlier version, as that would break too many sites. Obviously you've missed something, or haven't communicated clearly to them what the problem is. There's no way any host is going to change default PHP levels just for one user. If you're not on a shared server, you should have enough control over the PHP version to do the change. Frozen is 7.1 compliant. I think it still has a lot of problems on 7.2. Edge I think is mostly or entirely 7.2 compliant, but you'll have to check with @burt to be absolutely sure.
  16. Is it really worth the effort to come up with a blog or forum, and integrate it with osC? You're going to find yourself spending an incredible amount of time adding new features to your blog so that it looks decent and has an acceptable set of features. I would think it would be a much better investment (in your time) to just install a full blog (e.g., Wordpress) or forum (e.g., SMF) on the site and use that. If it is critical that a single signon work for both, I think something has been done along those lines in the past. If not, there's always a CMS (Wordpress, Joomla, Drupal) with a shopping cart module -- single signon, ability to arbitrarily jump all over the place, and consistent styling (at the cost of not as good a cart).
  17. MrPhil

    version with php7.2

    If it's 2.3.4BS you're on, it's not Frozen or Edge (perhaps Gold). Anyway, 2.3.4.1BS Edge I think is 7.2 compatible, though you'd have to check with @burt to be sure. If it isn't, it should be close. I don't think Frozen is fully 7.2 compatible, though it shouldn't be too far off (it is PHP 7.1 compatible, if you can get your site backed down to 7.1). Any chance of going to PHP 7.1? It is still in service (is current). I'm not sure, though, that anything earlier than Frozen will work on 7.1 without some fixes.
  18. MrPhil

    Header Tags SEO

    GDPR or the like? Maybe IP tracking violates some privacy laws.
  19. You're not adding multiple products -- you have one product with attributes (options), which are adds/decreases to the base product price. It would take some changes to the code to do what you want. Perhaps give the base price as 0.00 (and automatically suppress its display because it's 0.00) and just give the "add-on" prices for the attributes (suppress the "+") as the final price. In this case, the base price would be 0.00 instead of 120.00, and wouldn't be shown. Size 120cm would show "120.00" as the price, 150cm would show "158.40" as the price, and 180cm would show "174.00" as the price ("+" suppressed because the base price is 0.00). Internally, the calculated prices would be 0.00+120.00, 0.00+158.40, etc. Naturally, something would have to be done to require that at least one option (attribute) be selected for each item, so that it can't be purchased for the 0.00 base price. (Sorry, I'm in the US and don't have access to a Pounds symbol). I vaguely recall this being requested a number of times before. Have you carefully checked the add-ons catalog for such capability?
  20. MrPhil

    problem with currency conversion

    There was discussion recently (here) about some major currency exchange rate system shutting off its free service because of abuse by certain parties. Maybe that's what you're seeing. Do some search on this forum and I'll think you'll find the information.
  21. I don't think there are specific installation instructions in one place -- they're kind of scattered around. It's pretty simple, though. You unzip the file and copy the files over, update them per the patches, create the empty database, and run install. It will lead you through the process. My "Frozen" link in my signature (below) is to the latest and greatest Frozen on GitHub. Other links may take you to discussions about CE/Edge/Frozen, but that one is a direct link to the package itself. There may also be some old links floating around to Edge, to Gold, or to other earlier versions, but don't use those.
  22. MrPhil

    Changing Address Format

    In your store admin, go to Locations/Taxes > Countries, scroll down to Canada and select it. It will probably show you "address format 1". Click "Edit", change to format 2, and Save.
  23. MrPhil

    Changing Address Format

    You could go into the database and change the address_format value for the country in question from 1 to 2. For example, USA is 2 (state, zip) and Canada is 1 (postal code, province). I don't know why Canada was set up that way, but you should be able to change it. You might look in the admin area first, to see if you can change it there.
  24. I have been keeping a patched copy of "Frozen", with much of the bug list applied to it, for my own work with clients. I don't want to get into distributing it (as yet another fork), but I will distribute a consolidated list of patches that I applied to my copy. There are two files: Frozen.diff is Linux "diff" format Frozen.fc is Windows File Compare (fc command) format Both can be found at my site: https://www.catskilltech.com/FreeSW/product/Frozen-patches/title/Frozen+patches/freeSW_full. I thought the patch files were a little large to attach to this forum, especially as they will be replaced from time to time and are not a one-shot deal. It's a command-line utility to run to generate the patches, so it's no big deal to update them. I will attempt to keep the list updated as new patches are announced, both in this thread and elsewhere. If you think I've overlooked an important patch, please feel free to bring it to my attention. I may not have put some patches in simply because they were too vaguely stated, or seemed to be too specialized. Also, I only seriously looked at this one thread (there may be other Frozen patches floating around). If you spot an error in how I applied a patch, please let me know! The patch files are semi-manually consolidated, and probably won't work if you try to feed them to a patch utility. At the least, you'll have to split them apart with an editor. You can also manually edit the osCommerce files (as well as oscommerce.sql, although it won't update an existing database), using them as instructions. If anyone knows the format for consolidated diff and fc files, so that the whole thing could be fed to a patch utility in one go, without breaking the file apart, please chime in!
  25. OK, I suppose it's possible that you could screw up your product description HTML, and it wouldn't be something malicious. However, something like that ought to be noticed pretty quickly, and would probably affect the full-page product listing (not just the grid or list format). Perhaps it's time to step back and consider what the purpose is of stripping HTML tags: presumably to linearize and compact the product description that it will fit in a small space? If so, why not leave bold, italic, underline, etc. active? Paragraph and break tags (also list and heading tags), which alter the layout of the material, should be converted to spaces so that text doesn't get run together as in the original complaint. This whole discussion is probably getting outside of the purview of Frozen Bugs, and probably ought to get its own thread.
×