Can anyone please tell me what I need to do for the following:
1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="107" order by...
Type: Posts; User: countingsheep
Can anyone please tell me what I need to do for the following:
1054 Unknown column 'sort' in 'order clause'
in:
[select * from zen_products_with_attributes_stock where products_id="107" order by...
Using :
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-11-20 22:01:01] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-16 10:59:26] (Fresh Installation)
PHP Version 5.2.11
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-11-20 22:01:01] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-16 10:59:26] (Fresh Installation)
I am getting the product and...
muddkids_nonupgradezc.zen_address_book OK
muddkids_nonupgradezc.zen_address_format OK
muddkids_nonupgradezc.zen_admin OK...
I am still struggling with this site... I have attempted to load the entire site as it was on the OLD server to the new one to at least get something functioning, now, I am getting this message:
...
Does it make a difference that I need to change the files?
Can anyone tell me if this is an actual change that is needed? It looks to me like a paragraph difference...
http://black.countingsheepwebdesigns.com/~muddkids/screenshot-winmerge.JPG
You are correct, I did not follow it the last time...
Ignore my question I understand what I did now. I installed the cart, and it created a database and I was trying to load the database that had not been updated into it. So, I am creating another...
Thanks, I see where that made a difference but, what does this mean:
#1062 - Duplicate entry '1' for key 1
every section I try gives me that..
Ok, so, based on your info, then my best approach is to break apart the database and load it? Sorry for my uneducated terminology. Just trying to learn is all.
relevant info:
--Most current version of zen cart installed on new server
---PHP Version information: 3.4.5
---mysql:
Server: Localhost via UNIX socket
Server version: 5.0.92-community...
*Site in question is http://www.babysewcute.com/
*She notified me of the problem on Sept 1 saying that she had two customers and herself to have the problem.
*There are no addons that I...
Here is the info for the same issue that this client is having:
Zen Cart 1.3.9h
Database Patch Level: 1.3.9c
Server Information
Database Host: localhost (127.0.0.1)
Server OS: Linux...
I have a site that is doing the same thing?
Thank you, I deleted and reloaded and it is now functioning. I appreciate the quick response! :)
Sorry, I pasted more than once!
Ok, my evil eye is almost closed after the long day I have had today. But I dont have all that the other person had. So, I deleted the only one that was similar, and it left me with :
1emailAll...
Looks like there is a newsletter and product notification link under Tools in her storeadmin, which I clicked on and get:
1064 You have an error in your SQL syntax; check the manual that...
Please let me know what I need to do:
I upgraded from 1.3.9d to 1.3.9h, and am getting this error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL...
Its on a linux server.
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.38
She is getting an error with this:
editors/htmlarea/plugins/ImageManager/manager.php#
UPDATE: Here is the info I get from ftp, when I try to change the permissions:
Status: Set permissions of '/public_html/images/Custom_Orders' to '755'
Command: SITE CHMOD 755 Custom_Orders...
It appears that this person's site is a mess. She is using image handler (Not sure what version - I need to know how to find out what version) and her site is wide open with alot of directories set...
I found the answer here: http://www.zen-cart.com/wiki/index.php/Important_Site_Security_Recommendations
After all is said and done - installation, upgrading, etc, what should the image directory and the files inside it be set to? Just want to clarify so I will know for sure.
Ok for some reason there were two folders of images, so, I think that was the issue. Disregard this post!
I have upgraded the cart, as instructed, but any image that had a capital letter in the name, is now lower case and those products are now displayed as red x's. Any suggestions short of going through...
Thanks! Thats exactly what I did was rename the directory they were in to something like nogood1 and nogood2 :) She's all set and good to go. Thank you for your help.
Ok, I have a tiny problem that maybe you can answer for me.. there is some files that are remainder of the recent hack she had, but I am unable to delete them. I was told that only the root could do...
Ok, thanks I thought renaming the public_html directory could cause issues which is why I hadnt ever done it. Thank you for your prompt replies! I appreciate it!
Ok, in the upgrade instructions it says to go live after testing is complete on your temp directory. Ok, in the instructions it says to change the old directory's name to something different and...
Update- I created a "temp" database, and installed the new cart into that database, applied my overrides since I didnt have any changes to the files otherwise.. once that was completed, I switched it...
Technically, I didnt "install" it, I just upgraded the database... but it is 1.3.9 files
OK, thank you, that worked. Now it is saying that I am still using 1.3.8 version in the sub directory. I assume I should have installed it instead of just upgrading the database?
Basically what I did was add the template overrides to the new version of 1.3.9, installed my database into a new database, and upgraded the database from 1.3.8 to 1.3.9 in the new directory.
// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace...
(Edited this to clarify better)
Ok, I am able to see the login page for my upgraded directory.. However when I click on the login button I am directed to a link that removes the subdirectory...
Ok, I am able to see the login page. However when I click on the login button I am directed to the main directory not my testing directory. Which then gives me an oops, that is a broken link. So, I...
I am working on an upgrade for a friend, (she was hacked) and I have it installed in a temp directory as instructed. The public side is viewable (in maintenance mode right now) both in the current...
I have the option off for viewing line differences, but it still shows a difference of some kind. Is there something else that I am missing? Or am I just the lucky one who gets sites that are all...
I am comparing files for an upgrade, and when I do, I get entire directories that show the files are different, yet, when I view the files, I see nothing different unless I select the option to view...
Ignore this for now, I Am so tired I dont know what I did if someone else ran into the problem, but I think I have it fixed in one of the directories. 1.3.9d ... I have to put in the custom files and...
Here is my configure.php file from includes/
<?php
/**
* @package Configuration Settings circa 1.3.8
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions...
Anyone? I have gone through any threads I can find on internal server errors, and nothing has been successful, ran the install again just in case? nothing...
On the setup one, I have gone...
Hey, I wanted to let you know what I have now:
Ok, here on my test site... I have 3 directories:
first directory:
all looks the public side...
but in the admin I get the internal...
Im pretty certain the line breaks are there. It is only in the adobe program that I see it incorrectly.
Typically I use an ftp program like wsftp995 to load all of the files. However it seems...
UPDATE - I just checked on my new laptop, the same file in Adobe Dreamweaver and in Macromedia Dreamweaver, and Macromedia dreamweaver shows the exact code as this message. So, if this code is...
Which file is correct? The one I posted above with line breaks or this one:
<?php
/**
* counter.php
*
* @package general
* @copyright Copyright 2003-2009 Zen Cart Development Team
*...
I didnt edit it? I wouldnt have a clue. So, I cant say for sure.
I am going through all of the files again, so hang tight, hopefully I will be able to fix this myself. If so, thank you for all of your help, I have learned!