Help, I got a big mess...

[CharInLasVegas]

My bad, I installed an add-on without backing up my db 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

[CharInLasVegas]

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

[stevesh]

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?ma...roducts_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.

[CharInLasVegas]

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.

[CharInLasVegas]

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) . '&nbsp;');





define('ATTRIBUTES_PRICE_DELIMITER_PREFIX', ' ( ');


define('ATTRIBUTES_PRICE_DELIMITER_SUFFIX', ' )');


define('ATTRIBUTES_WEIGHT_DELIMITER_PREFIX', ' (');


define('ATTRIBUTES_WEIGHT_DELIMITER_SUFFIX', ') ');





?>

[stevesh]

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

[CharInLasVegas]

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

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...

[CharInLasVegas]

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.

[CharInLasVegas]

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...

[CharInLasVegas]

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