Help, I got a big mess...

My bad, I installed an add-on without backing up my db :bangin: The add on wiped out my product_info_display, so I reverted back to my prior pages, deleted all of the add on pages to catalog & admin so the add on is no longer showing in admin, BUT I still have no product_info_display. Strangely, it is showing my old favicon which normally only shows up for my admin and not for the store -- could be that's a clue -- something in admin is screwing things up.

Here is a page so you can see the blankness of it.

And if you look here, you will a page with the correct favicon and everything is okey dokey.

So...I'm thinking...maybe I need to get rid of the sql statement that was inserted for the add on? I don't know how to do that, if anyone can help, this is the sql script:

#DROP TABLE IF EXISTS products_xsell;
CREATE TABLE products_xsell (
  ID int(10) NOT NULL auto_increment,
  products_id int(10) unsigned NOT NULL default 1,
  xsell_id int(10) unsigned NOT NULL default 1,
  sort_order int(10) unsigned NOT NULL default 1,
  PRIMARY KEY  (ID), 
  KEY idx_products_id_xsell (products_id)
) TYPE=MyISAM;


## add switches for:  MIN_DISPLAY_XSELL, MAX_DISPLAY_XSELL
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Cross-Sell Products', 'MIN_DISPLAY_XSELL', 1, 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', 2, 17, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Cross-Sell Products', 'MAX_DISPLAY_XSELL', 6, 'This is the maximum number of configured Cross-Sell products to be displayed.<br />Default: 6', 3, 66, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell Products Columns per Row', 'SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS', '3', 'Cross-Sell Products Columns to display per Row<br />0= off or set the sort order.<br />Default: 3', 18, 72, 'zen_cfg_select_option(array(0, 1, 2, 3, 4), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?<br />Default: false', 18, 72, 'zen_cfg_select_option(array(\'true\',\'false\'), ', now());

Thanks

PS - when you look at the page source of the blank page, there's nothing there :frusty:

I can't think of anything in the database that would cause a blank page, so I would be looking elsewhere. Have you run the Debug Utility, and if so, what were the results?

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=860

Most blank pages are caused by extra lines or characters added to the end of the file in question, so I would look at the product info file and tpl_product_info_display file for that first, especially if they were changed by the mod.

I'll take a look at that mod. The only changes to those 2 pages were intalling a few lines of code but I reuploaded my pages without the changes.

Thanks, I never heard of the debug utility, hopefully it'll do the trick.

Ok, got the results but I can't seem to fix it. I even uploaded the original unchanged english/product_info.php from zc installation. I ran the debug 4 times & each time it's the same error.

<?php ``` PHP Parse error: syntax error, unexpected T_STRING in /home/weddivas/public_html/store/includes/languages/english/product_info.php on line 1 ``` Here is my page: ``` <?php /** * @package languageDefines * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: product_info.php 6371 2007-05-25 19:55:59Z ajeh $ */ define('TEXT_PRODUCT_NOT_FOUND', 'Sorry, the product was not found.'); define('TEXT_CURRENT_REVIEWS', 'Current Reviews:'); define('TEXT_MORE_INFORMATION', 'For more information, please visit this product\'s <a href="%s" target="_blank">webpage</a>.'); define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.'); define('TEXT_DATE_AVAILABLE', 'This product will be in stock on %s.'); define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased...'); define('TEXT_PRODUCT_OPTIONS', 'Please Choose: '); define('TEXT_PRODUCT_MANUFACTURER', 'Manufactured by: '); define('TEXT_PRODUCT_WEIGHT', 'Shipping Weight: '); define('TEXT_PRODUCT_QUANTITY', ' Units in Stock'); define('TEXT_PRODUCT_MODEL', 'Style #: '); // previous next product define('PREV_NEXT_PRODUCT', 'Product '); define('PREV_NEXT_FROM', ' from '); define('IMAGE_BUTTON_PREVIOUS','Previous Item'); define('IMAGE_BUTTON_NEXT','Next Item'); define('IMAGE_BUTTON_RETURN_TO_PRODUCT_LIST','Back to Product List'); // missing products //define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s'); //define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products'); //define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected'); define('TEXT_ATTRIBUTES_PRICE_WAS',' [was: '); define('TEXT_ATTRIBUTE_IS_FREE',' now is: Free]'); define('TEXT_ONETIME_CHARGE_SYMBOL', ' *'); define('TEXT_ONETIME_CHARGE_DESCRIPTION', ' One time charges may apply'); define('TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK','Quantity Discounts Available'); define('ATTRIBUTES_QTY_PRICE_SYMBOL', zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . ' '); define('ATTRIBUTES_PRICE_DELIMITER_PREFIX', ' ( '); define('ATTRIBUTES_PRICE_DELIMITER_SUFFIX', ' )'); define('ATTRIBUTES_WEIGHT_DELIMITER_PREFIX', ' ('); define('ATTRIBUTES_WEIGHT_DELIMITER_SUFFIX', ') '); ?>

I'm not seeing a blank page there anymore, but a 500 error page.

hmmm...well, I'll take out the double-spaces but I believe it's always been like that. I have alot of files like that, as a matter of fact. I've always wondered why there's so many double-spaced lines!

But as far uploading, I've tried through my ftp program, which is Core FTP Lite, and also through my File Manager in cPanel.

For the heck of it, I changed permissions on the file, and that didn't help either.

Another thing I can't understand, is why THAT page is going to http://.. instead of http://www...

I could swear that before this, all of the store pages were www.

Last night, I changed the configure files to be www, but then I got locked out of admin, so I changed them back and then I was back in again :wacko:

I don't know what's going on. This store doesn't even have that many add-ons, just a few & no troubles at all until this.

Anyway, off to get rid of the double-spaced lines & see if that does anything...

stevesh:

I'm not seeing a blank page there anymore, but a 500 error page.

What's a 500 error? I'm still getting a blank page.

Ok, I see in IE it shows a 500 error (got that now) and in FF it's still a blank page.

I dunno what to do...

Took out the double-spaced lines, still have the same problem. Nothing seems to fix this.

Any of this apply?:

https://www.zen-cart.com/tutorials/index.php?article=390

No, I don't get any errors when updating in Admin, or any errors in Admin at all. In fact, the site will even show a product with a blank page as a "recently seen" in the sidebox, with the picture and all, as if it was seen. Weird. So, I got the bright idea of looking at the page that's actually on the server through cPanel and sure enough, something is going wrong (or I think so anyway), now this is after deleting all of the double-spaced lines:

<?php
/** * @package languageDefines * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: product_info.php 6371 2007-05-25 19:55:59Z ajeh $ */
define('TEXT_PRODUCT_NOT_FOUND', 'Sorry, the product was not found.');define('TEXT_CURRENT_REVIEWS', 'Current Reviews:');define('TEXT_MORE_INFORMATION', 'For more information, please visit this product\'s <a href="%s" target="_blank">webpage</a>.');define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.');define('TEXT_DATE_AVAILABLE', 'This product will be in stock on %s.');define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased...');define('TEXT_PRODUCT_OPTIONS', 'Please Choose: ');define('TEXT_PRODUCT_MANUFACTURER', 'Manufactured by: ');define('TEXT_PRODUCT_WEIGHT', 'Shipping Weight: ');define('TEXT_PRODUCT_QUANTITY', ' Units in Stock');define('TEXT_PRODUCT_MODEL', 'Style #: ');
// previous next productdefine('PREV_NEXT_PRODUCT', 'Product ');define('PREV_NEXT_FROM', ' from ');define('IMAGE_BUTTON_PREVIOUS','Previous Item');define('IMAGE_BUTTON_NEXT','Next Item');define('IMAGE_BUTTON_RETURN_TO_PRODUCT_LIST','Back to Product List');// missing products//define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');//define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');//define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');
define('TEXT_ATTRIBUTES_PRICE_WAS',' [was: ');define('TEXT_ATTRIBUTE_IS_FREE',' now is: Free]');define('TEXT_ONETIME_CHARGE_SYMBOL', ' *');define('TEXT_ONETIME_CHARGE_DESCRIPTION', ' One time charges may apply');define('TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK','Quantity Discounts Available');define('ATTRIBUTES_QTY_PRICE_SYMBOL', zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . ' ');define('ATTRIBUTES_PRICE_DELIMITER_PREFIX', ' ( ');define('ATTRIBUTES_PRICE_DELIMITER_SUFFIX', ' )');define('ATTRIBUTES_WEIGHT_DELIMITER_PREFIX', ' (');define('ATTRIBUTES_WEIGHT_DELIMITER_SUFFIX', ') ');
?>

When looking at the page in my browser, everything is crammed together and takes up about 6 lines. So, I'm going to upload the page with the double-space and see what happens with that.

I was just able to get to this now, changed the file through cpanel, still have the same error.

This is my product_info.php, I can't for the life of me see what's wrong with it and where "unexpected T_STRING on line 1" is coming from :censored:

<?php
/**
 * @package languageDefines
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: product_info.php 6371 2007-05-25 19:55:59Z ajeh $
 */

define('TEXT_PRODUCT_NOT_FOUND', 'Sorry, the product was not found.');
define('TEXT_CURRENT_REVIEWS', 'Current Reviews:');
define('TEXT_MORE_INFORMATION', 'For more information, please visit this product\'s <a href="%s" target="_blank">webpage</a>.');
define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.');
define('TEXT_DATE_AVAILABLE', 'This product will be in stock on %s.');
define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased...');
define('TEXT_PRODUCT_OPTIONS', 'Please Choose: ');
define('TEXT_PRODUCT_MANUFACTURER', 'Manufactured by: ');
define('TEXT_PRODUCT_WEIGHT', 'Shipping Weight: ');
define('TEXT_PRODUCT_QUANTITY', ' Units in Stock');
define('TEXT_PRODUCT_MODEL', 'Style #: ');

// previous next product
define('PREV_NEXT_PRODUCT', 'Product ');
define('PREV_NEXT_FROM', ' from ');
define('IMAGE_BUTTON_PREVIOUS','Previous Item');
define('IMAGE_BUTTON_NEXT','Next Item');
define('IMAGE_BUTTON_RETURN_TO_PRODUCT_LIST','Back to Product List');

// missing products
//define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');
//define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');
//define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');

define('TEXT_ATTRIBUTES_PRICE_WAS',' [was: ');
define('TEXT_ATTRIBUTE_IS_FREE',' now is: Free]');
define('TEXT_ONETIME_CHARGE_SYMBOL', ' *');
define('TEXT_ONETIME_CHARGE_DESCRIPTION', ' One time charges may apply');
define('TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK','Quantity Discounts Available');
define('ATTRIBUTES_QTY_PRICE_SYMBOL', zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . ' ');
define('ATTRIBUTES_PRICE_DELIMITER_PREFIX', ' ( ');
define('ATTRIBUTES_PRICE_DELIMITER_SUFFIX', ' )');
define('ATTRIBUTES_WEIGHT_DELIMITER_PREFIX', ' (');
define('ATTRIBUTES_WEIGHT_DELIMITER_SUFFIX', ') ');

?>

I'm not sure, but you may have to escape the '#' in:

define('TEXT_PRODUCT_MODEL', 'Style #: ');

define('TEXT_PRODUCT_MODEL', 'Style #: ');

Everything else looks OK to me.

Thanks for looking, but it's been like that since the beginning and no issues so I doubt that's the problem. So, I'm back to...is it at all possible that the SQL statement needs to be removed? If the page looks fine (and it does appear to be 100% ok) then I just can't fathom why I continue to get this error.

I also uploaded the debug to admin, but I get no errors from there.

I'm coming up with something that I think might be part of my problem, it seems that files are not being overwritten when I upload a new one even when I change permissions.

Any ideas out there????

I'd guess that's all of the problem. If I had that happen, I'd open a ticket with my host. They may have to change some ownership settings on your files.

Yeah, did that. He actually worked on the problem for a few hours, the consensus is...maybe an issue with my ftp program which seems to be corrupting files every once in a while. I dunno, still can't get this resolved so am going to try restoring from last weeks backup -- soon as I figger that one out.

Meanwhile, I need to go dl a new ftp program.

I use the FireFTP plugin for Firefox - does the job for me.