Forums / General Questions / Product Description and Image not showing

Product Description and Image not showing

Views: 1,363

Results 1 to 11 of 11
8 Jul 2012, 5:48 AM
#1
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Product Description and Image not showing

I recently moved to a new host and have come across a new issue that i can not resolve. All the categories are there and all the products are listed in them as they were with the previous host. When I click on a some categories none of the products that should be there show up:
http://www.bmnedirect.com.au/index.php?main_page=index&cPath=27 - there are 22 products in this category

I tried to set up a new category and put a new product in the category and it will not show up.
http://www.bmnedirect.com.au/index.php?main_page=product_info&cPath=134&products_id=2084

Earlier I updated stock levels of some products and now those product description are not there when you click on that product.
http://www.bmnedirect.com.au/index.php?main_page=index&cPath=1 - main category
http://www.bmnedirect.com.au/index.php?main_page=product_info&cPath=1&products_id=7 - the first product in that category which was updated this morning.
http://www.bmnedirect.com.au/index.php?main_page=product_info&cPath=1&products_id=4 - also updated this morning. The descriptions and images for those products are not showing.

I have hunted everywhere for an answer to this but can't find anything. Can anyone please help me and send me off it the right direction?

8 Jul 2012, 5:55 AM
#2
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

Should have mentioned it is version 1.3.9h

8 Jul 2012, 6:52 AM
#3
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Product Description and Image not showing

Navigating from

http://www.bmnedirect.com.au/index.php?main_page=product_info&cPath=1&products_id=2

to next I received this error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select categories_id from products_to_categories where products_id = ]

Check in your host provided DB manager and check tables then repair tables to see if that will correct this

Zen-Venom Get Bitten

8 Jul 2012, 7:03 AM
#4
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

Done, repairs products_to_catgegories and products in the DB... no change when viewing the website.

10 Jul 2012, 2:15 AM
#5
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

I am still having this issue, does anyone have any ideas on where I can start looking to fit it?

10 Jul 2012, 2:50 AM
#6
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,870
Plugin Contributions:
19

Re: Product Description and Image not showing

You need to give us more information other than 1.3.9h and a link.
Please reply with some answers to the posting tips or contact the folks reported as the authors and generators of this site.> <meta name="author" content="BMNE Direct Pty Ltd" /> <meta name="generator" content="Wholesale Nail and Beauty Supplies;, <http://www.bmnedirect.com.au> shopping" />Maybe the author or generator has an answer.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

11 Jul 2012, 1:31 AM
#7
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

kobra:

Navigating from

http://www.bmnedirect.com.au/index.php?main_page=product_info&cPath=1&products_id=2

to next I received this error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select categories_id from products_to_categories where products_id = ]

> 
> Check in your host provided DB manager and check tables then repair tables to see if that will correct this

Did this and no change.
11 Jul 2012, 1:39 AM
#8
balaji avatar

balaji

New Zenner

Join Date:
Nov 2009
Location:
Chennai, India
Posts:
50
Plugin Contributions:
0

Re: Product Description and Image not showing

Please check the image size. Try to keep the image sizes in kbs and not mbs.

It should solve your trouble :)

Balaji R

11 Jul 2012, 1:48 AM
#9
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

What version of Zen Cart are you using?
Has your site been upgraded? When? From what version(s)? NO UPGRADE - 1.3.9h

What addons have you installed? When? AJAX SHOPPING CART, LIGHTBOX, REWARDS,  REPORTS
HOW did you install it? (upload via FTP and run zc_install, or a one-click install from your hosting company? (one-click installs are NOT recommended)) - MOVED ACROSS AND INSTALLED BY NEW HOSTING COMPANY.
In what ways is your site customized or different from a brand new uncustomized install? Purcahsed Template, but this was used before it was moved.
If you're encountering display/layout problems, post your site URL* so it can be seen in action. URL'S IN ORIGINAL POST.
If you're encountering problems that could be related to your server or hosting company, include the name of your hosting company (not their URL). WEBNETHOSTING.NET
HAVE YOU LOOKED IN THE FAQ AREA for answers to your question? (ie: a search for your error message or what you want to edit/change, etc) - HUNTED EVERYWHERE ON THE NET AND THIS FORUM
Have you searched the FORUM for your error message or for answers to the question you're asking? YES
WHEN did the problem "start"? How does that compare with other events of your hosting company, changes you've made to your site files/addons, or your admin settings, etc? AFTER THE CART WAS MOVED

The error message I am getting now is:
[10-Jul-2012 14:04:30] PHP Warning: require(DIR_FS_CATALOG_LANGUAGESenglish/meta_tags.php) [function.require]: failed to open stream: No such file or directory in /home/website/public_html/admin/includes/languages/english.php on line 54
[10-Jul-2012 14:04:30] PHP Warning: require(DIR_FS_CATALOG_LANGUAGESenglish/meta_tags.php) [function.require]: failed to open stream: No such file or directory in /home/website/public_html/admin/includes/languages/english.php on line 54
[10-Jul-2012 14:04:30] PHP Fatal error: require() [function.require]: Failed opening required 'DIR_FS_CATALOG_LANGUAGESenglish/meta_tags.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/website/public_html/admin/includes/languages/english.php on line 54

I did a file backup before the move and have uploaded the configure.php files from that back up - didn't solve the issue.
I have uploaded the meta_tags.php file from that back and that didn't solve the problem.

Line 54 on the english.php file:
/ include template specific meta tags defines
if (file_exists(DIR_FS_CATALOG_LANGUAGES . $_SESSION['language'] . '/' . $template_dir . '/meta_tags.php')) {
$template_dir_select = $template_dir . '/';
} else {
$template_dir_select = '';
}
require(DIR_FS_CATALOG_LANGUAGES . $_SESSION['language'] . '/' . $template_dir_select . 'meta_tags.php');
//die(DIR_FS_CATALOG_LANGUAGES . $_SESSION['language'] . '/' . $template_dir_select . 'meta_tags.php');

I don't know where else to look or how to fix this.

11 Jul 2012, 2:01 AM
#10
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Product Description and Image not showing

DIR_FS_CATALOG_LANGUAGES doesn't appear to be defined in your admin/includes/configure.php

It should be
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

11 Jul 2012, 2:10 AM
#11
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: Product Description and Image not showing

The configure file from admin

<?php /** * @package Configuration Settings circa 1.3.9 * @copyright Copyright 2003-2010 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * File Built by zc_install on 2011-05-13 11:52:17 */ /*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ // Define the webserver and path parameters // Main webserver: eg-http://www.your_domain.com - // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com // HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.your_domain.com // HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.your_domain.com /* * URLs for your site will be built via: * HTTP_SERVER plus DIR_WS_ADMIN or * HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or * HTTP_SERVER plus DIR_WS_CATALOG or * HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG * ...depending on your system configuration settings * * If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following: */ define('HTTP_SERVER', 'https://www.bmnedirect.com.au'); define('HTTPS_SERVER', 'https://www.bmnedirect.com.au'); define('HTTP_CATALOG_SERVER', 'https://www.bmnedirect.com.au'); define('HTTPS_CATALOG_SERVER', 'https://www.bmnedirect.com.au'); // Use secure webserver for catalog module and/or admin areas? define('ENABLE_SSL_CATALOG', 'true'); define('ENABLE_SSL_ADMIN', 'true'); // 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 ... (ie: under the public_html or httpdocs folder) define('DIR_WS_ADMIN', '/admin/'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_ADMIN', '/admin/'); define('DIR_WS_HTTPS_CATALOG', '/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/'); define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/'); 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', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/ define('DIR_FS_ADMIN', '/home/website/public_html/admin/'); define('DIR_FS_CATALOG', '/home/website/public_html/'); 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_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', ''); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'XXXXX_XXXX'); define('DB_SERVER_PASSWORD', 'XXXXXX'); define('DB_DATABASE', 'XXXX_store'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'db'); // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'database'); define('DIR_FS_SQL_CACHE', '/home/website/public_html/cache'); // EOF