Jump to content

bsmither

Member
  • Posts

    16,536
  • Joined

  • Last visited

  • Days Won

    541

Everything posted by bsmither

  1. Just a few thoughts: Maybe the problem happened "around" the 1000th category (or sub-category), but not exactly at the 1000th. I do see anything that would limit the drop-down box to 1000 entries. In /admin/products/index.php, line 347, a query is pulling three columns from the _category table, then in line 373, a list of OPTION statements is being built from the rowset. And apparently that's where the code generation stops. If you are still having this problem, what we need to see are the last few lines of the web page source that was delivered to your browser. (View Source in your browser.) I'm thinking the last line will contain a clue as to what's stalling the PHP of your store's delivery of the page's HTML. If you are, in fact, receiving the entire page, then look for the string of OPTION tags in the source. There might be about a thousand of them! I'm going to make a gentleman's wager that one of your category names has an illegal character. If so, then what you are seeing might be a problem with your browser's inability to make sloppy guesses as to what it should do. IE6 was reasonably good this, maybe IE7 not so much.
  2. Do you actually mean to say that some subs have multiple parents in your source data? The table column _category.cat_father_id is an integer value (0 = top-level category). To have multiple parents, you would need to change the datatype of this column to... well, I'm not an expert on MySQL, so I don't know if there's a column datatype of array, or if it needs to be text. Then, there's line 52 in viewCat.inc.php that has a SELECT statement that's looking for a single value, not an array or comma separated list. On the category page that lists all products in that category, at the top, there's a "breadcrumb" feature. This is built by code in the functions.inc.php file, getCatDir(). I haven't figured out that function but I'm sure that having multiple parents is going to break this. I suppose you could comment out line 235 in viewCat.inc.php to inhibit this function. You might also need to do something about line 19 in viewCat.tpl.
  3. bsmither

    MasterEmail

    I tried to place two e-mails seprated by a comma on the Store Settings page and a "500 Internal Server Error" message for my effort. Then I thought to create an alias e-mail (since I own the domain name) and have that redirected to as many e-mails as I need.
  4. Right-click on the blank image placeholder and select properties. The properties window should tell you where your browser is asking for the images. If the URL shown has too many or missing backslashes, then there's a misunderstanding in your responses to the URL field's of your store during installation. But missing images during the installation? Hmm... Maybe, by chance, did you upload the "upload" folder from the CC distribution archive? Or did you upload the "contents" of the upload folder onto your site? Maybe you have a firewall or pop-up blocker that prevents images from being downloaded from unapproved sites? Did you FTP the contents of the upload folder having a setting in the FTP program that forces all file and folder names lowercase when transferring? If the properties page of the graphic that's supposed to be there says "cclogo.gif" instead of ccLogo.gif", then that's what happened.
  5. Woohoo! Can you use escaped quotes?
  6. In addition to a skewed cookie that somehow got into your browser's cache, your firewall, or pop-up blocker, or anti-virus, or all-in-one Internet Security Suite, or Cookie Cruncher, or Javascript Annihilator, or IE6/7 Security Settings may be munging the cookie, or returning a munged cookie. Please investigate the possibility that the protective screens you've installed on your computer may be causing the problem.
  7. Verify what you have in your \includes\global.inc.php: The name of your MySQL database as installed on your Windows server (dbdatabase) is 'ocal1_ocal'. You have not set a prefix (dbprefix) for CubeCart's set of tables in this database. It's a zero-length string. For the rootDir path, try this - for every backslash, make it four backslashes. That is: $glob['rootDir'] = 'D:\\\\hshome\\\\ocal\\\\mysite.com'; And for the storeURL, try not putting the trailing slash on it. See what happens - let us know.
  8. I got that on a totally unrelated application. Decided to switch to the ISAPI.DLL mode as opposed to the CGI mode of running PHP. That solved it for me. However, if I were to troubleshoot the exact cause, I would start with using Firefox and Live HTTP Headers (although I don't know if you actually need Firefox for this). I would find out what headers are missing. As a general point to investgate, I would study what ended up with capital letters and what didn't when compared to your Unix installation. Database table names, folder/file names, etc.
  9. My (novice) conclusion is that the role of a gateway sends and receives only that information necessary for you to confirm that you got your money from your customer. The gateway e-mails that I get only detail the transaction, not any information about *what* was purchased. I do not know if or how one can get CubeCart to send an administrative e-mail for each order placed. I would imagine that once your store starts processing dozens or hundreds of sales a day, you won't need the e-mails -- just do your daily managerial duties.
  10. Perhaps the *entire* domain space was changed to, what?, 000? Anyway, maybe more than just the global.inc.php needs to have permissions checked out. And, just to cover more bases, have you cleared your browser's cache? Have you verified that a computer other than yours can ascertain that your store is still non-functional?
  11. My way would be to identify the skin you want for the store at location 1, copy and rename that skin folder to "thisSite". Identify the skin you want for the store at location 2, copy and rename that skin folder to "thisSite". In either store's admin panel (because you are sharing the database), for Store Skin, choose "thisSite". Let us know how it works.
  12. I'm not too sure about the "pear:.:/public_html/" portion of the address. Part of it is duplicated and part of it has characters I would never use in a URL string. In your admin panel, click Server Info, scroll to Configuration, PHP Core section, and look at the value for "include_path". It might say something like ".:/usr/local/lib/php". There might be something seriously wrong with this value of this variable. If there is, to have it fixed, your hosting support might have to get involved.
  13. Yeah, I also think it's a good idea to go over to CubeCartForums. There, you enter a new topic and I'll post the same response as I did here. Then one of the programming people can figure out what the PHP code should be. But conceptually, I think this is what you want. You might even try: $view_doc=file_get_contents("includes/docs/".mySQLSafe($_GET['docId'])."html"); And did you copy "mySQLSafe()" capitalized as I wrote it?
  14. Here's what I would look into (since I haven't actually done it): In /includes/content/viewDoc.inc.php, insert before this line (should be 38 in CC3.0.15): if($lang_folder !== $config['defaultLang']){ the following (perhaps not perfect php code): $view_doc->include("includes/docs/".mySQLSafe($_GET['docId'])."html"); (Maybe the "->" needs to be an "=", I don't know.) Then comment out everything afterwards but the last two lines: $page_content = $view_doc->text("view_doc"); ?> So, when a visitor clicks a siteDoc link, the form sends a URL containing "?act=viewDoc&docId=4" (for example). The new line above is going to use the "4" to construct "4.html" which will be found in the folder of your specification. The include will assign it to the already present variable and be processed out to the page's content normally. Let us know if this works.
  15. walter4, did this fix your problem?
  16. There might be something up with the database. To be sure, you need to visually inspect the table names of your store's database using something like phpMyAdmin. See a write-up about this here: http://www.cubecart.com/site/forums/index....st&p=130180 Basically, if your IIS6 has a MySQL system variable set a certain way, lettercase of table names become an issue. You said you had copied your development installation over to your production environment. What OS is your MAC running? That *nix variant? And what is the value of that system variable in your MAC's installation of MySQL? Are the table names in all lower case? For a good explanation of the consequences of that system variable, "lower_case_table_names", search the MySQL developer's site's MySQL manual pages for it.
  17. Yup. That was the problem. Admin, General Settings (Store Settings), Styles and Misc: Email Address You cannot put more than one e-mail address in this field. I thought this address was to be used only to send relevant status notices To:, not From:. But I see that it's used as both. The email address specified when Administrators are created must receive something from the store???
  18. Brilliant! (And I say that in a good way!) Thanks for the response!
  19. Line 27 in /index.php is a line commented out in a block describing the ownership of this application. Same with line 28 in /admin/index.php. Is your new domain on a different server, that is, running under a different installation PHP? Maybe you've made an adjustment to how PHP runs on this new server? Have you looked at the code of these files mentioned in the error report? The line where sessionStart is called in is on line 56. And if you removed the 28-line chunk of commented out text, then the line where sessionStart is called would indeed end up on line 28. In the file /includes/global.inc.php, see what the value is for 'rootRel'. If this store is at the root, I believe 'rootRel' needs to be '/'.
  20. When editing an order's status, if I check the "Inform customer" checkbox, I always get a 500 Internal Server Error. If it's not checked, I get the order status updated successfully. So maybe there's a problem with how e-mails addresses are being manipulated here? I was also told of several 500 ISE's when customers called to say that when moving from step 4 to step 5 of checking out (step five is when the customer is asked for their credit card number, if I recall), it crashed. It happened to me (as a prior successful customer) as I was making a test run through it. Backing up and trying again, I got through. So here it might *not* be an e-mail issue. I mention e-mail because I've stumbled across several messages that pin the blame on mis-matched e-mails for customer and/or administrator when CC didn't work quite right. CCv3.0.15 hosted on Godaddy shared server, Apache Linux.
  21. Low priority question, I know, but it will help me understand how CC works... (for developing a mod) I'm looking at the _order_sum table and seeing fields that replicate fields found in the _customer table. Is there a reason why _order_sum.customer_id isn't enough? Thanks.
  22. Did this and divined a major mess-up spot in the procedure. It involves backing up (moving/copying) from/to a *nix platform and IIS6 platform. On an IIS6 platform, the mySQL system variable "lower_case_table_names" probably should be set equal to 2 as this will preserve the case of table names during a CREATE statement. I had requested a SQL script be created by phpMyAdmin of my (production) store running *nix, then executed that script on a localserver (development) store running IIS6. The table names all came out lower case as viewed in MySQL Query Browser (MySQL AB). Knowing that PHP is case-sensitive, I was concerned what problems this might cause. Apparently none. However, going the other way may be highly problematic - IMHO. If the MySQL administrator on the IIS6 system allows for the total disregard of lettercase, I see problems ahead when moving/copying a store to *nix. The MySQL system variable "lower_case_table_names" may be by default set to equal 1 during installation on IIS6 systems, which is to CREATE all table names in lowercase and to convert all queries to lowercase. (Corrections to my conclusions are welcome.)
  23. OK, so 35 fields. Is this a hard and fast number. I'm thinking of adding a mod to allow me to add custom fields that need to be included in however I manage to get data brought into Quickbooks. Once these custom fields are added, are they then seen by Order Import and presented in the list for inclusion/exclusion?
  24. Yes, but even when there's only one choice (MC/Visa in my case), I still have to click my way through the page that offers the payment methods. The OP and I hope there's an "understanding" with CC that if there's only one enabled choice, just accept it as the default and move on. Maybe a customization of the code? Now, on the other side of the fence, I can suppose that if the one and only payment method offered does not suit the customer, then the the customer, realizing this, can bail. And I can see this side of the fence clearly since if PayPal is the only option available, I will bail. Many an item on eBay did not get my bid because the seller only accepted PayPal.
  25. I messed up once on an FTP upload of my store - my FTP client has a setting that forces all transferred names to lowercase. If your FTP client has this setting, make sure it is not set. These *nix servers are picky about upper/lower case file and directory names. Maybe /store/index.php is being found, but there's nothing else gonna work if the file/directory names got changed, even by lettercase.
×
×
  • Create New...