ya_dood Posted March 14, 2006 Posted March 14, 2006 Hi, The first step in the instruction to install the Header Tag Controller v1 contribution is: TABLE CHANGES: Add the following new fields to products_description table. NOTE: The lengths can be anything you perfer to use. products_head_title_tag varchar 50 products_head_desc_tag longtext 300 products_head_keywords_tag longtext 300 When referring to table is that mySQL? I've gone into phpMyAdmin and found the products_description file. Do I simply click on the 'insert' button on the top to add to this file? I've never worked with Databases before so I'm not sure. Also, do I use the export button on the top to backup the file just in case I break the whole site when editing. Thanks
rabbitseffort Posted March 14, 2006 Posted March 14, 2006 first thing is always take a database backup before changing anythin! Very important. you can back up the whole database thru either your host cpanel or thru the admin area of osc. to answer the question--yes those are sql lines--good luck! "I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings." ---Margaret Mead--- "The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer. --Ken Kesey"
ya_dood Posted March 14, 2006 Author Posted March 14, 2006 I could backup my database before by going to tools/database backup but yesterday I moved everything over to the root to make the site live. I edited all of the configure files to reflect the move-everything seems to work with the site but now when I go to tools/database it says ' Error: Backup directory is not writeable.' I changed two lines to the following in admin/includes/configure.php to reflect the move to the root define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/nina/public_html/admin/'); // absolute pate required Could it be this or something else? thanks,
ya_dood Posted March 14, 2006 Author Posted March 14, 2006 oh man, I see that the same is when I go to the products area in admin as well: Error: Catalog images directory is not writeable: /home/nina/public_html/images/
Avec Posted March 14, 2006 Posted March 14, 2006 Make sure that you have a backup directory where it is supposed to be and the permission should be 777, I believe. The image directory should be 755. To make the changes, use your FTP program or host provided file manager.
ya_dood Posted March 14, 2006 Author Posted March 14, 2006 Make sure that you have a backup directory where it is supposed to be and the permission should be 777, I believe. The image directory should be 755. To make the changes, use your FTP program or host provided file manager. Do you mean to change the admin folder to 777 and the image folder to 755 or just the specific files admin/includes/configure.php, admin/configuration.php? thanks,
ya_dood Posted March 14, 2006 Author Posted March 14, 2006 I just changed both folders to 777 as that was the only combination that would let me edit them when in admin Is there a security issue here or are they always 777 by default?
ya_dood Posted March 14, 2006 Author Posted March 14, 2006 Also, In the admin the product images aren't showing up. Even when I reupload them they aren't working. Does this also involve admin/includes/configure.php and if so which line there should I change. Here is what I have for the top part of this file: // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://mysitesname.com'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://mysitesname.com'); define('HTTPS_CATALOG_SERVER', 'http://mysitesname.com'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/home/nina/public_html/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/nina/public_html/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/'); // absolute path required define('DIR_FS_CATALOG', '/home/nina/public_html/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); Thanks
ya_dood Posted March 15, 2006 Author Posted March 15, 2006 I got the images to come up in the admin area. I should have thought of this before but I just looked at an unedited version of admin/includes/configure.php and removed the one folder to reflect all the changes to the root. so before I had /home/nina/public_html/test_folder now I simply change it to /home/nina/public_html/ now i have to figure out how to fix the thumbnail contrib as it's still broken. :-"
Recommended Posts
Archived
This topic is now archived and is closed to further replies.