Search:

Type: Posts; User: allthingsidLeroy

Search: Search took 0.01 seconds.

  1. v154 Re: zen_mail sends text-only emails

    Yeah, this ended up being the problem. The comments said that the HTML format would be assumed if one isn't specified (like in this case), but that never actually happens.

    I edited line 154 in...
  2. v154 Re: zen_mail sends text-only emails

    Are all variables in a template required in the $html array?
  3. v154 My zen_mail sends text-only emails

    During checkout, we're trying to send an html email to an email address. It works, but just not html. I've tested sending a newsletter and I can receive html emails fine from my zen cart install. All...
  4. v154 custom php pages are redirecting to /

    I just recently upgraded a Zen Cart website to 1.5.4.

    I've created some custom php pages that work with Zen Cart and I usually test and debug through php pages from the root. For example, if I am...
  5. Re: Is there a way to turn off categories and subcategories if all products are inact

    I didn't even take into consideration categories that technically have no products themselves, but have sub-categories with products.

    Unfortunately, I don't know of any place where Zen Cart stores...
  6. v139h Re: Can I del customers who haven't active or login over half of year by SQL?

    You can do this, but how do you know if your customers won't come back?

    Half a year is a fairly small time frame.
  7. Re: Is there a way to turn off categories and subcategories if all products are inact

    The above query will work, but it's a bit of a mess. Here's a better version of the above query:



    UPDATE categories
    SET categories_status = 0
    WHERE categories_id NOT IN
    (
    SELECT DISTINCT...
  8. Re: Is there a way to turn off categories and subcategories if all products are inact

    I whipped something up for you. It's fairly complex, so I'll explain it for you.

    You shouldn't attempt this on your live website and should do it on a test version of your database. Make backups...
  9. v139h Re: Quantity Discounts with salesmaker

    Salesmaker probably doesn't update discount quantity pricing.
  10. Re: Change Product Model Numbers en masse?

    As long as those column names match up to your, this seems correct.

    Yes, you can execute this from PHPMyAdmin. There should be a place to execute custom queries.

    Like I said, though, you should...
  11. Re: Change Product Model Numbers en masse?

    That looks right to me.



    I forgot about this. But in PHPmyAdmin usually there's a place where you can 'use' a database. In any case, if you do have a prefix, you can just use that. This query...
  12. Re: Change Product Model Numbers en masse?

    Let's say the manufacturer_id you wanted to work with was 1. Here's what the query would look like:



    UPDATE products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id =...
  13. Re: Change Product Model Numbers en masse?

    Back up your database first because bad things happen accidentally.



    UPDATE products SET products_model = CONCAT("GHD-",products_model);


    This will update every product to have its model...
  14. v150 Re: Our system has detected an unusual rate of unsolicited mail originating from your

    I suppose I might be parroting what the above posters have said, but I'll throw in my two cents.

    Setting up both SPF and DKIM require you to be able to change your DNS records (both TXT records)....
  15. v138a Re: Connect to database and variables in a javascript

    I'm pretty sure php and Javascript don't "work" with each other. So, if you're trying to load a Javascript script from a php file, I don't know that it will work.

    What are you trying to echo out...
  16. v139h Re: How to know 1 Years on sales base on Brand by SQL

    This should show you every order from January 1st 2012 till December 31st 2012:


    SELECT * FROM orders WHERE date_purchased <= '2012-12-31' AND date_purchased >= '2012-01-01';
  17. Re: Friendly URLs without add on module

    Since it is only a few products, categories, and pages, you should be able to pull this off with Apache's Mod Rewrite.

    You can hand-write the rewrites yourself. They go in your .htaccess in the...
  18. v151 Re: What Unique Name Did You Name Your Cart? www.MyDomain.com/??

    Assuming everything is setup correctly and you are absolutely sure you want this to go 'live', then, yes, that's what you need to do.
  19. Re: Customers enter their own price/donation

    This is most certainly possible, but I personally don't know of any plugins which have this feature.

    Most likely this is something that's going to have to be coded from scratch.
  20. v151 Re: What Unique Name Did You Name Your Cart? www.MyDomain.com/??

    Your site root isn't the zencart folder itself? So, your homepage is www.example.com/zencart instead of www.example.com?

    Anyway, why aren't you doing this on a development server, or a test...
  21. Replies
    1
    Views
    426

    v151 Re: data feed

    It depends on what kind of feed you are creating, which depends on who you are creating it for.

    In any case, there are plenty of plugins to choose from here.
  22. v139h Re: Server Settings preventing sending order number by javascript?

    If it's a popup, perhaps you've got popups disabled? That's the only thing I can think of off the cuff.
  23. v139a Re: zen-cart try catch exception

    If you're running a query that contains an error, MySQL will generally interrupt the query, but the data inserted before the error should still be inserted. From the command-line, you can pass an...
  24. v150 Re: Google Merchant Center Feeder for ZC v1.5.x

    In the Docs for this mod, it mentioned that using Stock By Attribute (another mod) could let Google Merchant Center Feeder create variant products for each product.



    I have Stock By Attribute...
  25. Replies
    4
    Views
    497

    Re: Need Error Log Help

    This looks like an Apache error.

    Were you editing your Apache Sites-Enabled file, or any other Apache file?
  26. v151 Re: Is there an admin option to not show a sidebox (or other container) during checko

    I don't understand the confusion. I originally wanted a container that could be turned off during checkout that held my analytics scripts:







    This solution is pretty succinct and easier...
  27. v151 Is there a way to skip analytics on checkout pages?

    I am trying to put some analytics feeds on my store, but I do not want to track the checkout process (for various reasons). So, I want to put the scripts inside a container and hopefully tell that...
  28. Replies
    1
    Views
    1,598

    v150 Re: Pinterest Verification Help

    Looking at this guide, it seems that you just need to add some meta tags to your header (or footer, maybe).

    Typically, these files are located at...
  29. v139h Re: SQL command to del the customer orders record from year 2006 to 2010

    You can delete all the orders from your database that match a certain time frame, but because Zen Cart's database does its referential integrity [1] via PHP instead of in the database, (cascade,...
  30. v139a Re: zen-cart try catch exception

    MySQL is telling you that you're trying to insert a Primary Key that already exists in the table. Primary Keys must be unique [1] and there can never be a duplicate.

    What data are you trying to...
  31. Replies
    10
    Views
    2,338

    Re: Hide disply only attributes

    It queries the database rather than parsing the webpage itself.
  32. Replies
    10
    Views
    2,338

    Re: Hide disply only attributes

    I've found this solution:

    Edit your /includes/modules/<template>/attributes.php file. If it doesn't exist, copy the attributes.php file from /includes/modules/attributes.php and put it there.
    ...
  33. v150 Re: External link to images get Error 404 page no found

    The first image's location: /images/vs_nitro_xp.jpg
    And the second location: /images/visualstyles/vs_nitro_xp.jpg

    Are you sure you aren't using some modifications to your Google spreadsheet?...
  34. v138a Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent he

    It really depends on how the permissions are set in the /etc folder. This whole scenario requires a hosting service which does not expect a user to have access to the root folders of a system. Most...
  35. v138a Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent he

    Sometimes hosting services that offer jailed access to the command line don't revoke the 'mount' command. If you need access and are doing this through the command-line, you might try creating a...
  36. v151 Re: Weird Characters - Need an SQL solution!

    For anyone else that might have this issue, here is a good link about the wrong character encoding in a MySQL database:

    detecting utf8 broken characters in mysql
  37. Replies
    2
    Views
    549

    v151 Re: Where are file uploads handled?

    I thought as much, but I figured I might ask to see if anyone else got a to file upload using this method:



    Because that functionality works fairly well, is already implemented, and is mostly...
  38. Replies
    2
    Views
    549

    v151 Where are file uploads handled?

    For my store, I'm creating an optional file upload form for artwork after a customer has made a purchase. Thus far, I have edited the define_checkout_success.php with an upload form (I am using the...
Results 1 to 38 of 38
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR