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...
Type: Posts; User: allthingsidLeroy
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...
Are all variables in a template required in the $html array?
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...
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...
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...
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.
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...
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...
Salesmaker probably doesn't update discount quantity pricing.
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...
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...
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 =...
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...
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)....
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...
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';
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...
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.
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.
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...
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.
If it's a popup, perhaps you've got popups disabled? That's the only thing I can think of off the cuff.
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...
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...
This looks like an Apache error.
Were you editing your Apache Sites-Enabled file, or any other Apache file?
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...
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...
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...
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,...
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...
It queries the database rather than parsing the webpage itself.
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.
...
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?...
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...
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...
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
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...
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...