Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by MrPhil

  1. Please cut and paste the first 10 lines of your calendar.php file here so we can look at what's wrong. Register globals would probably have nothing to do with a parse error.
  2. MrPhil

    Is SSL required?

    Well yes, PCI-DSS does cover much more than just using SSL-protected pages. It also covers the secure storage and handling of such information, so that no unauthorized parties get access to sensitive financial data at any point. With all the massive credit card information thefts in the last few years, it is evident that the bad guys put a lot of effort into stealing this valuable data, and that merchants/payment gateways/banks have to do a much better job than they have been at protecting it. SSL protection at $40+ per month? No way! You're being royally ripped off if they charge that much. Generally you buy a certificate on an annual basis, and pay a one-time installation fee. Certainly less than $500 a year!
  3. MrPhil

    Is SSL required?

    If you're using a payment system where you handle (or just see in passing) customer credit card information on your site, you will have to be PCI-DSS compliant. That's complicated and expensive, and requires much more than just an SSL certificate for your site. You may want to look at "third party" payment systems (PayPal [non-Pro], et al.) where the customer is sent off to their site to enter credit card details (under https). Is that what you had with Viaklix? SSL isn't absolutely required if you use a third party to handle credit cards, but it's generally considered good practice to protect other customer information (name and address, phone, email, etc.) under https. Customers will be more willing to make a purchase if they see that you are taking steps to protect their personal data. If you do not wish to spring for a private SSL certificate, most hosts offer a free shared SSL certificate (you use a URL of something similar to https://server.hostname.com/~ACCOUNTNAME/path-to-your-shop/...). Talk to your host to confirm that a PHP application such as osC will work with a shared certificate.
  4. MrPhil

    SQL Syntax Error

    The value for "limit" should be a number greater than 0 (it's the number of rows to grab). This error must be the result of a code change (custom code or add-on installation), as I can't find any "limit" in the admin side that has one value and isn't a hardcoded number. I would look through your code for "limit " in queries and see if anything is other than a hardcoded number. For defined values such as MAX_PRODUCTS_TO_DISPLAY (etc.) check their definition to see if someone changed them from a number to "false". Some of these defined values may be in the database "configuration" table, rather than in a PHP file.
  5. MrPhil

    Packing Algorithm's

    Yes, it would be quite complex. You could take a rough swag at which box to use by adding up the volumes of the items and the ordered dimensions (largest-to-smallest) of each item, compared to the box dimensions. That would give you a minimum box size, but it's far harder to determine if that box is sufficient. For that, you need to try all sorts of (reasonable) packing orders and orientations. I'm sure it's been done by someone -- have you tried googling for shipping packing order and similar? Don't forget to allow some extra room for padding around fragile items, putting delicate items on top, and avoiding items next to each other that could damage each other. Let's not even think about irregularly shaped objects (anything other than a rectangular volume). Watch the weight limit on the box itself (you don't want the box to fail in transit), and allow some space under the top so that when someone slices open the tape with a boxcutter knife, it doesn't nick the merchandise. Have fun!
  6. MrPhil

    How'd you hear about is report.

    You're still getting the "select 0 SELECT ..." error? I dunno. About all I can think of at this point is that you're pulling in the wrong "include" branch -- the "catalog" side rather than the "admin" side. What PHP version? Do you have an "include_path" setting in your php.ini that specifies your store root (e.g., ..../catalog)? If so, that might be picking up the includes/... rather than admin/includes/... You could check this by explicitly adding admin/ to the "require" or "include" paths: require('admin/includes/application_top.php'); etc. and see if the behavior changes. If it then works, that was the problem. If no difference, at this point I have no idea.
  7. At 50, <tr> does not have width= attributes. A row is always 100% of the table width. At 310, you have an empty and unclosed <tr> and a <tr> in the next line. All you have to do is carefully follow the validator's instructions and clean up your very messy code. Removing line 310 (empty, unclosed tr) ought to fix many of the errors.
  8. You can start by removing the self-closing / (as in />) from tags which shouldn't have it, such as <html>. That should start to clear up a lot of your errors. <html> has its own explicit close tag </html> way down at the other end of the page.
  9. MrPhil

    How'd you hear about is report.

    You have to look at the page in Preview, and manually hit the Enter key where you want a "hard carriage return" inserted, so that it doesn't extend beyond the box. My point about splitPageResults is that I think you're calling it wrong. If this is the catalog version of the class you're using, the SQL query needs to be first. If you're using the admin version, I think it's correct. Make sure of which one you're using -- they have the same name, but different calls!
  10. MrPhil

    How'd you hear about is report.

    Are you still getting the "select 0 SELECT..." error, or is it something else now? I can't read your code listing... please "Preview" it and "wrap" long lines like your query statements (insert hard carriage returns) so I don't have to scroll way down to the bottom of the listing, scroll right, scroll the page back up, and try to figure out which line I should be looking at. I just keep losing my position in a long code listing (spanning several screens). Are you using the split_page_results() constructor correctly? The definition for it is function splitPageResults($query, $max_rows, $count_key = '*', $page_holder = 'page') { where the query string comes first (you have a page number?). That might account for the "select 0".
  11. MrPhil

    phplist and Simple Visitor Newsletter

    PHPlist wants its address lists in a comma-separated-variables (CSV) file. You'll have to find a way to export your email list to such a file. As a manual operation, I'm pretty sure that phpMyAdmin can do it, but to automate it you could write a PHP script (to run just before the newsletter is to be sent) that reads the database and spits out the CSV file with the pertinent information. It might even exclude some addresses based on various criteria (note that PHPlist can also exclude some addresses based on other fields in the list). I have no idea what the Simple Visitor Newsletter address list looks like, or whether it's stored in the database or generated on the fly.
  12. MrPhil

    Admin Error Message

    http://forums.oscommerce.com/topic/350012-error-in-all-page-submits/page__gopid__1467801entry1467801 Your english.php file at or near line 337 is outputting text to the browser. As that's the end of the file, most likely you have a blank or two after the closing ?>. Clean up the file.
  13. MrPhil


    You must have missed a step somewhere. Assuming the file isn't named FILENAME_comparemyprice, you need to define that macro (name) somewhere (includes/filenames.php?): define('FILENAME_comparemyprice','comparemyprice.php'); or whatever the actual name is. Is there a file includes/modules/comparemyprice.php or something similar?
  14. MrPhil

    Adding a simple meta tag

    Unfortunately, each page has its <meta> tags hardcoded. For each page where you want this new tag, you'll have to manually add the code in the <head> section of that page. Maybe there's an add-on to insert a new <meta> tag more easily? To do it manually, in /index.php, look for <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> and insert your BING <meta> tag right after it. Repeat for any other PHP files you need it in. Look at http://addons.oscommerce.com/info/5497 , but it appears that most of the "meta tag" contributions (add-ons) are oriented towards general SEO. I took a quick look, but didn't see anything else that sounded like a general meta tag inserter.
  15. MrPhil

    How'd you hear about is report.

    Your SQL query was select 0 SELECT ci.... Where did that "select 0" come from? Was there some other piece of code trying to build a query, starting with "select $value"? Is $referrals_query_raw what's fed to mysql_query(), or is there further processing that adds more stuff? Sorry to not get back to you before, but today is the first time that the forum has let me see your replies!
  16. MrPhil


    I'd be concerned about trying to use file names such as "Diapason actie 10 + 1 gratis.jpg". Even if you're on a Windows server, where blanks may be allowed, the Web doesn't particularly like blanks and special characters in names. Do you have any control over the names? If you do, remove '+' or change it to 'plus', and change blanks to underscores: "Diapason_actie_10_plus_1_gratis.jpg". A browser sending this name back to the server is less likely to have problems.
  17. I don't know this particular contrib (add-on), but you could certainly do something about it, if the author won't respond to your question. You could temporarily re-enable register global variables, if your host will let you. If it functions properly then, you know that's the problem. Even if you can't try that, you can look through the contrib's code and see if there are any variables that just seem to be expected to appear "out of nowhere". You need to find all such variables (anything not explicitly initialized before being used, is suspect) and ahead of their first use, define them: $varname = $_REQUEST['varname']; That should fix it. There are other PHP 5.x problems that you might hit. If this contrib doesn't use the "compatibility layer" to define "long array names" (e.g., $HTTP_POST_VARS), code might break. If you run at PHP 5.3+, you'll get lots of warnings about "deprecated functions". And finally, if you're going from MySQL 4 to 5 at the same time, you need to fix the LEFT JOIN problem.
  18. MrPhil

    Particular product data

    There are add-ons to handle custom attributes, with price changes (+ or -) for each. Is that what you're looking for? Look through the contributed add-ons for "attribute".
  19. I realize that this is a development board. What I'm saying is that for the vast majority of osC users, including almost all those who sign up for this site's forum, they don't want to have to go fishing through github to get the latest and greatest. They want a packaged, tested, approved, endorsed, production-ready (in the case of 2.2) release that they can put on their site and be confident that it will work and solve most of their problems. Most osC users are not developers or even programmers. They want something that works out of the box. They don't want to fool with the innards of osC -- at most, they'll install an add-on to fix something or gain new function, but that's pushing it for most store owners. So, telling people reporting problems with 2.2 (problems that have been known literally for years) to go to github to get the latest and greatest just doesn't cut it. They want an RC3 (or better, Gold) that they can install/update in a clean and predictable fashion, so that they can install their add-ons, preserve their product and account base, and be up and running quickly. After all, most osC users are not here to indulge a programming hobby. They're here to run a business. It's obvious that you don't understand either the abilities or the mindset of most osC users -- they regard osC as a tool to get a needed job done, not as a "fun" project. They need "out of the box" solutions that work, or they'll go elsewhere.
  20. Sorry, but github updates don't count. What counts is only a formal release, be it 2.2 RC3 or 3.0 Beta 1. This is what Fantastico and other packaging services will pick up. This is what appears under "Downloads" on this site. This is the only source of osC that most people will ever try to use -- they don't want to mess with live development repositories (or what appear to be unstable development). In short, you can't just leave "the latest osC" on github and expect everyone to use it.
  21. Unfortunately, the page "overhead" is hardcoded in each file, rather than being included from a common source. And, it will take several include files to handle it, because some files have Javascript or additional <meta> tags to insert into the <head> section. It would have been a much cleaner design to include all this stuff in an include or a function call, but for whatever reason, no one ever bothered to. Even more unfortunately, don't count on any more development in version 2.2. We've been stuck at RC2a for years now. RC3 was promised to be released a month ago, but I'm not holding my breath. All development effort, such as there is, appears to be going into 3.0, leaving 2.2 abandoned. Such is life. I'm sure Mark or Harald will respond in some fashion to deny this, but the fact is that no progress has been made on 2.2 in years. They can claim all they want that 2.2 is still under development, but until fresh releases appear, I'm not believing it.
  22. MrPhil


    In your browser, View > Page source and see where it is looking for the images. Maybe the database still has an old domain name or URL? Are you producing images on-the-fly, or just showing canned images? If on-the-fly, are you missing any PHP libraries, such as GD, used to manipulate images? You've got to do some detective work here. Are you getting any errors logged anywhere on your site? Do you have "hotlink protection" enabled and your site isn't in the whitelist of allowed sites? Were image names changed while going from one server to another? E.g., underscores became hyphens, or everything folded to lower case? Was your previous server on Windows and your new one Linux, and you never bothered to consistently capitalize names, such that a file is "Product_1234.jpg" and the reference in the database is "product_1234.jpg"? Lots of things could have happened, and you've given us no information to work with.
  23. MrPhil

    Particular product data

    Give an example of "what's different" about this product. Your description was way too vague.
  24. MrPhil

    FATAL ERROR: register_globals

    Your next step is to ask your hosting service for specific instructions on how to enable register global variables. There might be other steps needed besides making a php.ini file.
  25. MrPhil

    FATAL ERROR: register_globals

    You are running an ancient version of osC that requires that "register global variables" be enabled (on) in order to function. Your host has upgraded PHP to a new version, or at least, disabled register global variables because they are a security problem. Hopefully they will allow you to re-enable register global variables for your site. Usually this involves editing (or creating) a file /php.ini with the contents register_globals = on Other things may have to be done, depending on the specifics of how your server is set up (such as if it's running suPHP). The best long term solution is to upgrade to the current osC, version 2.2 RC2a. It does not require register global variables to be on. If your host will not allow you to enable register global variables, you will have to do this.