artfulweb

Hello Rainer, Just upgraded to PHOENIX 1.0.7.7 and could not log in to my admin. Changing the admin/includes/modules/cfg_modules/cfgm_store.php to the following corrects the problem : <?php /* $Id: cfgm_store.php $Loc: catalog/admin/includes/modules/cfg_modules/ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com 2016 wholesale PRO 2.0 by @raiwa info@oscaddons.com www.oscaddons.com Copyright (c) 2020 osCommerce Released under the GNU General Public License */ class cfgm_store { const CODE = 'store'; const DIRECTORY = DIR_FS_CATALOG . 'includes/modules/store/'; const LANGUAGE_DIRECTORY = DIR_FS_CATALOG . 'includes/languages/'; const KEY = 'MODULE_STORE_INSTALLED'; const TITLE = MODULE_CFG_MODULE_STORE_TITLE; const TEMPLATE_INTEGRATION = true; }

Thanks Jack. For the moment it seems to work without causing problems so I can hold out till you give a cleaner solution!

Hi Jack, know you have enough on your plate but giving a head's up that PHOENIX 1.0.7.7 breaks the addon because of the new configure.php file : Use of undefined constant ENABLE_SSL - assumed 'ENABLE_SSL' (this will throw an Error in a future version of PHP) in /xx/xx/xx/xx/includes/classes/seo.class.php on line 755 Warning: Use of undefined constant HTTPS_SERVER - assumed 'HTTPS_SERVER' (this will throw an Error in a future version of PHP) in /xx/xx/xx/xx/includes/classes/seo.class.php on line 756 Warning: Use of undefined constant DIR_WS_HTTPS_CATALOG - assumed 'DIR_WS_HTTPS_CATALOG' (this will throw an Error in a future version of PHP) in /xx/xx/xx/htdocs/includes/classes/seo.class.php on line 756 Warning: Use of undefined constant DIR_WS_HTTP_CATALOG - assumed 'DIR_WS_HTTP_CATALOG' (this will throw an Error in a future version of PHP) in /xx/xx/xx/htdocs/includes/classes/seo.class.php on line 753 Warning: Use of undefined constant HTTP_COOKIE_DOMAIN - assumed 'HTTP_COOKIE_DOMAIN' (this will throw an Error in a future version of PHP) in /xx/xx/xx/htdocs/includes/classes/seo.class.php on line 775 Warning: Use of undefined constant HTTPS_COOKIE_DOMAIN - assumed 'HTTPS_COOKIE_DOMAIN' (this will throw an Error in a future version of PHP) in /xx/xx/xx/htdocs/includes/classes/seo.class.php on line 775 My "dirty" fix to keep my site up and running was to take the defines from the old configure file and add them in includes/languages/english.php define('HTTPS_SERVER', 'https://www.mydomain.com'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', 'www.mydomain.com'); define('HTTPS_COOKIE_DOMAIN', 'www.mydomain.com'); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', '/'); define('DIR_WS_HTTP_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); Know this is not good but it does work for the moment until you can help as I am no expert! Thanks so much.

Sorry Rainer, it does work fine. I reinstalled PHOENIX and installed this addon as the first one and all OK so there must have been a conflict with another addon. Will work it out from there. Thanks again for all your work!

Hi Rainer, first of all thank you for the update, timely as usual! I do have one problem though. In PHOENIX 1.0.7.5+ the products bunch up, not responding to the new row display of products and I do not see where I could possibly correct that.

Oops another little ick... If there is a second language, when you click on the "Language Specific" tab the hts fields appear at the top BEFORE the product name, description, etc instead of below it. Bizarre.

Hi Jack, I found a solution that works. In admin/categories.php ========================== FIND line 360 ========================== /*** Begin Header Tags SEO ***/ require_once('includes/functions/header_tags_general.php'); $hts_fields = GetHTSFieldList(); $db = [ 'products' => [ 'products_quantity' => null, 'products_model' => null, 'products_image' => null, 'products_price' => null, 'products_date_added' => 'NOW()', 'products_date_available' => null, 'products_weight' => null, 'products_status' => 0, 'products_tax_class_id' => null, 'manufacturers_id' => null, 'products_gtin' => null, ], 'products_description' => [ 'products_id' => null, 'language_id' => null, 'products_name' => null, 'products_description' => null, 'products_url' => null, 'products_viewed' => 0, 'products_seo_title' => null, 'products_seo_description' => null, 'products_seo_keywords' => null, $hts_fields['input'] ], ========================== CHANGE TO ========================== /*** Begin Header Tags SEO ***/ //require_once('includes/functions/header_tags_general.php'); //$hts_fields = GetHTSFieldList(); $db = [ 'products' => [ 'products_quantity' => null, 'products_model' => null, 'products_image' => null, 'products_price' => null, 'products_date_added' => 'NOW()', 'products_date_available' => null, 'products_weight' => null, 'products_status' => 0, 'products_tax_class_id' => null, 'manufacturers_id' => null, 'products_gtin' => null, ], 'products_description' => [ 'products_id' => null, 'language_id' => null, 'products_name' => null, 'products_description' => null, 'products_url' => null, 'products_viewed' => 0, 'products_seo_title' => null, 'products_seo_description' => null, 'products_seo_keywords' => null, //$hts_fields['input'] 'products_head_title_tag_alt' => null, 'products_head_title_tag_url' => null, 'products_head_breadcrumb_text' => null, 'products_head_listing_text' => null, 'products_head_sub_text' => null, 'products_head_additional_words' => null, ],

OK. It does the same thing with a fresh install of PHOENIX 1.0.7.5 also.

Yes, did a fresh install of Phoenix 1.0.7.4 into a new database and then installed HTSEO. Nothing else in the database.

Hello Jack, since the sites in question are large live sites I set up a new test site, PHOENIX 1.0.7.4, and I get the same error when trying to duplicate a product (no other addons). Editing works fine, filling tags works fine but not duplicating.

OK... I see that it occurs on 2 prexisting sites (1 English, 1 Bilingual), 1 PHOENIS 1.0.7.4 the other 7.5 that originally had HTSEO installed and using the "hybrid" database file to install but renaming/naming the fields changes nothing so I am really perplexed. Back to square one. Will study it more, thanks Jack.

My data base table is as follows `products_id` int(11) NOT NULL, `language_id` int(11) NOT NULL DEFAULT '1', `products_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `products_description` text COLLATE utf8_unicode_ci, `products_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `products_viewed` int(5) DEFAULT '0', `products_seo_description` text COLLATE utf8_unicode_ci, `products_seo_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `products_seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `products_head_title_tag_alt` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, `products_head_title_tag_url` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, `products_head_listing_text` text COLLATE utf8_unicode_ci, `products_head_sub_text` text COLLATE utf8_unicode_ci, `products_head_breadcrumb_text` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, `products_head_additional_words` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL

Does that come from the header tags sql during installation?

OOPS... now it gives me the 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 '0, products_head_title_tag_alt, products_head_title_tag_url, products_head_bread' at line 1 INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords, 0, products_head_title_tag_alt, products_head_title_tag_url, products_head_breadcrumb_text, products_head_listing_text, products_head_sub_text, products_head_additional_words) SELECT 18204, language_id, products_name, products_description, products_url, 0, products_seo_title, products_seo_description, products_seo_keywords, 0, products_head_title_tag_alt, products_head_title_tag_url, products_head_breadcrumb_text, products_head_listing_text, products_head_sub_text, products_head_additional_words FROM products_description WHERE products_id = 18199 [TEP STOP] Can not figure out what the ..to use near '0, products_head_title_tag_alt, products_head_title_tag_url, products_head_bread' at line 1 could be as the would seem to be.

Hi Jack, now just can not copy a product (duplicate it), getting the following 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 '0) SELECT 18202, language_id, products_name, products_description, products_url,' at line 1 INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords, 0) SELECT 18202, language_id, products_name, products_description, products_url, 0, products_seo_title, products_seo_description, products_seo_keywords, '', '', '', '', '', '' FROM products_description WHERE products_id = 18199 [TEP STOP]