Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


MrPhil last won the day on April 10

MrPhil had the most liked content!

Profile Information

Recent Profile Visitors

108,471 profile views
  1. MrPhil

    My database do not work?

    osC 2.3.4? You're running an obsolete version. The proper one to run is "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" 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 or 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 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 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.