Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Quote:
Originally Posted by
marton_1
I assume this is the best thread for questions on the super data Markup plug in?
I am updating from V155f with the responsive green classic template and PHP 5x and plugin structured data markup
to V157 with responsive green classic template and PHP 7x.
I downloaded the newest Super Data Markup plugin, ran the uninstall SQL for the old plugin, and the install SQL for the new.
I got a whole string of "ERROR_LINE_INCOMPLETE" messages.
I do not know what they mean?
I cannot find the constant "ERROR_LINE_INCOMPLETE" on my web site
The Super Data configuration page on my new web site V157 is set up OK and I can enter my data.
My other problem is I do not find the following code in my html_header.php
Code:
<!DOCTYPE html PUBLIC "-//W3C//.......
There is
Code:
<!DOCTYPE html >
<html <?php echo HTML_PARAMS; ?>>
so I added the new code after <html...
I do not find any code like
Code:
// DEBUG: echo '<!-- I SEE cat: ' . $current_category_id . ' ......
I found a thread and a fix for my problem "with a whole string of "ERROR_LINE_INCOMPLETE" messages".
https://www.zen-cart.com/showthread....sing-semicolon
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
I changed the format a bit on the SQLs and now they run without ""ERROR_LINE_INCOMPLETE" " messages
uninstall
Code:
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'SUPER DATA' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id !=0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM admin_pages WHERE page_key = 'configSuperData';
Install
Code:
# FACEBOOK OPEN GRAPH forked for super data
#
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Super Data' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Super Data', 'Set Super Data Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Enable Module', 'FACEBOOK_OPEN_GRAPH_STATUS', 'true', 'Enable Super Data?', @configuration_group_id, 30, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Application ID', 'FACEBOOK_OPEN_GRAPH_APPID', '', 'Please enter your application ID (<a href="http://developers.facebook.com/setup/" target="_blank">Get an application ID</a>)', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Application Secret', 'FACEBOOK_OPEN_GRAPH_APPSECRET', '', 'Please enter your application secret', @configuration_group_id, 32, NOW(), NULL, NULL), (NULL, 'Admin ID', 'FACEBOOK_OPEN_GRAPH_ADMINID', '', 'Enter the Admin ID(s) of the Facebook user(s) that administer your Facebook fan page separated by commas (<a href="http://www.facebook.com/insights/" target="_blank">Insights for your domain</a>)', @configuration_group_id, 33, NOW(), NULL, NULL), (NULL, 'Default Image', 'FACEBOOK_OPEN_GRAPH_DEFAULT_IMAGE', '', 'Enter the full path to your default image or leave blank to disable. The default image is only used when the product image cannot be found.', @configuration_group_id, 34, NOW(), NULL, NULL), (NULL, 'Type', 'FACEBOOK_OPEN_GRAPH_TYPE', 'website', 'Enter an Open Graph type for your products (<a href="http://developers.facebook.com/docs/opengraph#types" target="_blank">Open Graph Types</a>)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Use cPath', 'FACEBOOK_OPEN_GRAPH_CPATH', 'true', 'Include the cPath in your URLs?', @configuration_group_id, 36, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Language', 'FACEBOOK_OPEN_GRAPH_LANGUAGE', 'false', 'Include the language in your URLs?', @configuration_group_id, 37, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Use Canonical URL', 'FACEBOOK_OPEN_GRAPH_CANONICAL', 'true', 'Use the canonical URL from ZC 1.3.9 or try and recreate the URL?', @configuration_group_id, 38, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Google Publisher', 'FACEBOOK_OPEN_GRAPH_GOOGLE_PUBLISHER', '', 'Please enter your full Google Publisher url/link (https://plus.google.com/+Pro-websNet/)', @configuration_group_id, 39, NOW(), NULL, NULL), (NULL, 'Your Logo', 'FACEBOOK_OPEN_GRAPH_LOGO', '', 'Please enter your full link to your logo url/link https:// is better!', @configuration_group_id, 40, NOW(), NULL, NULL), (NULL, 'Street Address', 'FACEBOOK_OPEN_GRAPH_STREET_ADDRESS', '', 'Please enter your street address', @configuration_group_id, 41, NOW(), NULL, NULL), (NULL, 'City', 'FACEBOOK_OPEN_GRAPH_CITY', '', 'Please enter your city', @configuration_group_id, 42, NOW(), NULL, NULL), (NULL, 'State', 'FACEBOOK_OPEN_GRAPH_STATE', '', 'Please enter your state', @configuration_group_id, 43, NOW(), NULL, NULL), (NULL, 'Postal Code', 'FACEBOOK_OPEN_GRAPH_ZIP', '', 'Please enter your postal code/zip', @configuration_group_id, 44, NOW(), NULL, NULL), (NULL, 'Country', 'FACEBOOK_OPEN_GRAPH_COUNTRY', '', 'Please enter your 2 letter country code such as US', @configuration_group_id, 45, NOW(), NULL, NULL), (NULL, 'Email', 'FACEBOOK_OPEN_GRAPH_EMAIL', '', 'Please enter your customer service email address (all lower case!)', @configuration_group_id, 46, NOW(), NULL, NULL), (NULL, 'Phone', 'FACEBOOK_OPEN_GRAPH_PHONE', '', 'Required. An internationalized version of the phone number, starting with the “+” symbol and country code (+1 in the US and Canada). Like this +1-330-871-4357', @configuration_group_id, 47, NOW(), NULL, NULL), (NULL, 'Twitter Handle', 'FACEBOOK_OPEN_GRAPH_TWUSER', '', 'Please enter your Twitter Handle like this @prowebs', @configuration_group_id, 48, NOW(), NULL, NULL), (NULL, 'Facebook Page', 'FACEBOOK_OPEN_GRAPH_FBPG', '', 'Please enter your full url/link to your facebook page (https://www.facebook.com/prowebs)', @configuration_group_id, 49, NOW(), NULL, NULL), (NULL, 'Locale', 'FACEBOOK_OPEN_GRAPH_LOCALE', '', 'Optional details about the language spoken. Languages may be specified by their common English name. If omitted, the language defaults to English.', @configuration_group_id, 50, NOW(), NULL, NULL), (NULL, 'Currency', 'FACEBOOK_OPEN_GRAPH_CUR', '', 'Please enter your currency code such as USD', @configuration_group_id, 51, NOW(), NULL, NULL), (NULL, 'Lead Time', 'FACEBOOK_OPEN_GRAPH_DTS', '', 'Please enter the average days until you ship orders such as 2', @configuration_group_id, 52, NOW(), NULL, NULL), (NULL, 'Condition', 'FACEBOOK_OPEN_GRAPH_COND', '', 'Please enter your products condition (NewCondition, UsedCondition, RefurbishedCondition, DamagedCondition)', @configuration_group_id, 53, NOW(), NULL, NULL), (NULL, 'Payment Type 1', 'FACEBOOK_OPEN_GRAPH_PAY1', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 54, NOW(), NULL, NULL), (NULL, 'Payment Type 2', 'FACEBOOK_OPEN_GRAPH_PAY2', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 55, NOW(), NULL, NULL), (NULL, 'Payment Type 3', 'FACEBOOK_OPEN_GRAPH_PAY3', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 56, NOW(), NULL, NULL), (NULL, 'Payment Type 4', 'FACEBOOK_OPEN_GRAPH_PAY4', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 57, NOW(), NULL, NULL), (NULL, 'Payment Type 5', 'FACEBOOK_OPEN_GRAPH_PAY5', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 58, NOW(), NULL, NULL), (NULL, 'Payment Type 6', 'FACEBOOK_OPEN_GRAPH_PAY6', '', 'Please enter ONE of the following payment types EXACTLY (ByBankTransferInAdvance, ByInvoice, Cash, CheckInAdvance, COD, DirectDebit, PayPal, PaySwarm, AmericanExpress, DinersClub, Discover, MasterCard, VISA, JCB, GoogleCheckout)', @configuration_group_id, 59, NOW(), NULL, NULL), (NULL, 'Tax ID', 'FACEBOOK_OPEN_GRAPH_TID', '', 'The Tax / Fiscal ID of the organization (e.g. the TIN in the US or the CIF/NIF in Spain))', @configuration_group_id, 60, NOW(), NULL, NULL), (NULL, 'DUNS', 'FACEBOOK_OPEN_GRAPH_DUNS', '', 'The Dun & Bradstreet DUNS number for identifying an organization or business person.', @configuration_group_id, 61, NOW(), NULL, NULL), (NULL, 'Fax', 'FACEBOOK_OPEN_GRAPH_FAX', '', 'Please enter your fax number like this +1-877-453-1304.', @configuration_group_id, 62, NOW(), NULL, NULL), (NULL, 'VAT ID', 'FACEBOOK_OPEN_GRAPH_VAT', '', 'Value-added Tax ID of your organization.)', @configuration_group_id, 63, NOW(), NULL, NULL), (NULL, 'Legal Name', 'FACEBOOK_OPEN_GRAPH_LEG', '', 'The official name of the organization, e.g. the registered company name.)', @configuration_group_id, 64, NOW(), NULL, NULL), (NULL, 'Area Served', 'FACEBOOK_OPEN_GRAPH_AREA', '', 'Optional. The geographical region served by the number, specified as a Schema.org/AdministrativeArea. Countries may be specified concisely using just their standard ISO-3166 two-letter code, as in the examples at right. If omitted, the number is assumed to be global..)', @configuration_group_id, 65, NOW(), NULL, NULL), (NULL, 'Twitter Page', 'FACEBOOK_OPEN_GRAPH_TWIT', '', 'Please enter your full url/link to your twitter page (https://twitter.com/prowebs)', @configuration_group_id, 66, NOW(), NULL, NULL), (NULL, 'Linkedin Page', 'FACEBOOK_OPEN_GRAPH_LINK', '', 'Please enter your full url/link to your Linkedin page (http://www.linkedin.com/company/pro-web-inc-/)', @configuration_group_id, 67, NOW(), NULL, NULL), (NULL, 'Another Profile Page', 'FACEBOOK_OPEN_GRAPH_PROF1', '', 'Please enter your full url/link to your profile page (https://www.dandb.com/businessdirectory/prowebsinc-woodbine-ga-37349028.html)', @configuration_group_id, 68, NOW(), NULL, NULL), (NULL, 'Another Profile Page', 'FACEBOOK_OPEN_GRAPH_PROF2', '', 'Please enter your full url/link to your profile page (http://www.yelp.com/biz/pro-webs-woodbine)', @configuration_group_id, 69, NOW(), NULL, NULL), (NULL, 'Shipping to', 'FACEBOOK_OPEN_GRAPH_ELER', '', 'The ISO 3166-1 (ISO 3166-1 alpha-2) or ISO 3166-2 code, or the GeoShape for the geo-political region(s) for which the offer or delivery charge specification is valid. Such as US', @configuration_group_id, 70, NOW(), NULL, NULL);
# Register the configuration page for Admin Access Control INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configSuperData','BOX_CONFIGURATION_SUPERDATA','FILENAME_CONFIGURATION',CONCAT('gID=',@configuration_group_id),'configuration','Y',@configuration_group_id);
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Quote:
Originally Posted by
marton_1
Instead of changing the SQL, did using v157a (which contains the fix) avoid the issue?
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
I tried copying admin/sqlpatch.php from 157a to 157 but that did not fix the problem.
A lot of files have changed from 157 to 157a so I had to leave that change for another day.
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Hi Steve - just a heads up - installed this in 1.5.7b and it worked a treat from word go - great plugin!! appreciated!!
cheers,
Mike
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Quote:
Originally Posted by
shags38
Hi Steve - just a heads up - installed this in 1.5.7b and it worked a treat from word go - great plugin!! appreciated!!
cheers,
Mike
Me too.
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Will this plugin work on ZC v1.5.1 ?? .... (yes I know the site should be upgraded ... but needs as need be :smile:)
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Quote:
Will this plugin work on ZC v1.5.1
Probably, you'll have to check first on your development server...
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Quote:
Originally Posted by
torvista
Probably, you'll have to check first on your development server...
Thanks Steve - FYI it works fine on v1.5.1 - now have it working in 1.5.1, 1.5.5f and 1.5.7b sites - it is a very good plugin :smile:
Re: Structured Data Markup for Schema, Facebook Open Graph, Twitter...
Products Shipping Weight doesn't appear to be in my product info data. Is this something that has been updated?
