Hallo Webchills, Hallo zusammen,
bei der Instalation des Pakettracking Modules aus dem Git Hub kommt eine Weisse Seite und im Log folgender Fehler:
Ich verzweifloe, bzw. zweifle an mir selbst gerade.
Der Shop ist neu und leer bis auf die geänderte Template Datei.
Grüße und Danke Guido
bei der Instalation des Pakettracking Modules aus dem Git Hub kommt eine Weisse Seite und im Log folgender Fehler:
HTML-Code:
[03-Sep-2016 15:02:42 Europe/Berlin] Request URI: /a_team2013/sqlpatch.php?action=execute, IP address: 82.135.74.218 #1 trigger_error() called at [/var/WWW/xxx/xxx//web/ZC_SHOP_155/includes/classes/db/mysql/query_factory.php:167] #2 queryFactory->show_error() called at [/var/WWW/xxx/xxx//web/ZC_SHOP_155/includes/classes/db/mysql/query_factory.php:139] #3 queryFactory->set_error() called at [/var/WWW/xxx/xxx//web/ZC_SHOP_155/includes/classes/db/mysql/query_factory.php:266] #4 queryFactory->Execute() called at [/var/WWW/xxx/xxx//web/ZC_SHOP_155/a_team2013/sqlpatch.php:304] #5 executeSql() called at [/var/WWW/xxx/xxx//web/ZC_SHOP_155/a_team2013/sqlpatch.php:672] [03-Sep-2016 15:02:42 Europe/Berlin] PHP Fatal 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 '"zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking -' at line 1 :: INSERT INTO ZC155_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Package Tracking - Carrier 1 Status', 'CARRIER_STATUS_1', 'False', 'Enable Tracking for Carrier 1<br /><br />Set to false if you do NOT want Carrier 1 to be displayed on Admin and Customer page.', @gid, 1, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 1 Name', 'CARRIER_NAME_1', 'DHL', 'Enter name of Carrier 1 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: FedEx)', @gid, 2, now(), now(), NULL, NULL), ('Package Tracking - Carrier 1 Tracking Link', 'CARRIER_LINK_1', 'http://nolp.dhl.de/nextt-online-public/set_identcodes.do?lang=de&idc=', 'Enter the tracking link of Carrier 1<br /> <br /><strong>Example:</strong> http://nolp.dhl.de/nextt-online-public/set_identcodes.do?lang=de&idc=', @gid, 3, now(), now(), NULL, NULL), ('Package Tracking - Carrier 2 Status', 'CARRIER_STATUS_2', 'False', 'Enable Tracking for Carrier 2<br /><br />Set to false if you do NOT want Carrier 2 to be displayed on Admin and Customer page.', @gid, 4, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 2 Name', 'CARRIER_NAME_2', 'DPD', 'Enter name of Carrier 2 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: UPS)', @gid, 5, now(), now(), NULL, NULL), ('Package Tracking - Carrier 2 Tracking Link', 'CARRIER_LINK_2', 'http://extranet.dpd.de/cgi-bin/delistrack?typ=1&lang=de&pknr=', 'Enter the tracking link of Carrier 2<br /> <br /><strong>Example:</strong> http://extranet.dpd.de/cgi-bin/delistrack?typ=1&lang=de&pknr=', @gid, 6, now(), now(), NULL, NULL), ('Package Tracking - Carrier 3 Status', 'CARRIER_STATUS_3', 'False', 'Enable Tracking for Carrier 3<br /><br />Set to false if you do NOT want Carrier 3 to be displayed on Admin and Customer page.', @gid, 7, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 3 Name', 'CARRIER_NAME_3', 'UPS', 'Enter name of Carrier 3 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: USPS)', @gid, 8, now(), now(), NULL, NULL), ('Package Tracking - Carrier 3 Tracking Link', 'CARRIER_LINK_3', 'http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displ ayed=1&TypeOfInquiryNumber=T&loc=de_DE&InquiryNumber1=', 'Enter the tracking link of Carrier 3<br /> <br /><strong>Example:</strong>http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displ ayed=1&TypeOfInquiryNumber=T&loc=de_DE&InquiryNumber1=', @gid, 9, now(), now(), NULL, NULL), ('Package Tracking - Carrier 4 Status', 'CARRIER_STATUS_4', 'False', 'Enable Tracking for Carrier 4<br /><br />Set to false if you do NOT want Carrier 4 to be displayed on Admin and Customer page.', @gid, 10, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 4 Name', 'CARRIER_NAME_4', 'Hermes', 'Enter name of Carrier 4 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', @gid, 11, now(), now(), NULL, NULL), ('Package Tracking - Carrier 4 Tracking Link', 'CARRIER_LINK_4', 'http://tracking.hlg.de/Tracking.jsp?TrackID=', 'Enter the tracking link of Carrier 4<br /> <br /><strong>Example:</strong> http://tracking.hlg.de/Tracking.jsp?TrackID=', @gid, 12, now(), now(), NULL, NULL), ('Package Tracking - Carrier 5 Status', 'CARRIER_STATUS_5', 'False', 'Enable Tracking for Carrier 5<br /><br />Set to false if you do NOT want Carrier 5 to be displayed on Admin and Customer page.', @gid, 13, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 5 Name', 'CARRIER_NAME_5', 'Post Austria', 'Enter name of Carrier 5 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', @gid, 14, now(), now(), NULL, NULL), ('Package Tracking - Carrier 5 Tracking Link', 'CARRIER_LINK_5', 'http://www.post.at/sendungsverfolgung.php/details?pnum1=', 'Enter the tracking link of Carrier 5<br /> <br /><strong>Example:</strong> http://www.post.at/tnt_query.php?pnum1=', @gid, 15, now(), now(), NULL, NULL), ('Package Tracking - Carrier 6 Status', 'CARRIER_STATUS_6', 'False', 'Enable Tracking for Carrier 6<br /><br />Set to false if you do NOT want Carrier 6 to be displayed on Admin and Customer page.', @gid, 16, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"), ('Package Tracking - Carrier 6 Name', 'CARRIER_NAME_6', 'Deutsche Post Brief', '<b>NOTE: Carrier 6 is reserved for carriers which use more fields in their tracking links as just the ID. E.g. day, month and year.</b><br/><br/>Enter name of Carrier 6 <br /> <br /><strong>Example:</strong> Deutsche Post brief<br />(default: blank)', @gid, 17, now(), now(), NULL, NULL), ('Package Tracking - Carrier 6 Tracking Link Part 1', 'CARRIER_LINK_6_PART1', 'https://www.deutschepost.de/sendung/simpleQueryResult.html?form.sendungsnummer=', 'Enter the tracking link of Carrier 6 for Part 1 (Tracking ID)<br /> <br /><strong>Example:</strong> https://www.deutschepost.de/sendung/simpleQueryResult.html?form.sendungsnummer=', @gid, 18, now(), now(), NULL, NULL), ('Package Tracking - Carrier 6 Tracking Link Part 2', 'CARRIER_LINK_6_PART2', '&form.einlieferungsdatum_tag=', 'Enter part 2 of the tracking link of Carrier 6 (for the day)<br /> <br /><strong>Example:</strong> &form.einlieferungsdatum_tag=', @gid, 19, now(), now(), NULL, NULL), ('Package Tracking - Carrier 6 Tracking Link Part 3', 'CARRIER_LINK_6_PART3', '&form.einlieferungsdatum_monat=', 'Enter part 3 of the tracking link of Carrier 6 (for the month)<br /> <br /><strong>Example:</strong> &form.einlieferungsdatum_monat=', @gid, 20, now(), now(), NULL, NULL), ('Package Tracking - Carrier 6 Tracking Link Part 4', 'CARRIER_LINK_6_PART4', '&form.einlieferungsdatum_jahr=', 'Enter part 4 of the tracking link of Carrier 6 (for the year)<br /> <br /><strong>Example:</strong> &form.einlieferungsdatum_jahr=', @gid, 21, now(), now(), NULL, NULL), ('Package Tracking - Max display for Track Order sidebox', 'MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX', '3', 'The maximum number of orders to display on the Track Order sidebox ', @gid, 22, now(), now(), NULL, NULL), ('Package Tracking - Switch for Edit Orders v3.0 or Super Orders v3.0', 'TY_TRACKER', 'False', 'If you have the either Edit Orders v3.0 or Super Orders v3.0 installed, set this option to TRUE so that the Ty Package Tracker fields will display in Edit Orders or Super Orders<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS v3.0 OR SUPER ORDERS v3.0 INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod\(s\) installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', @gid, 23, now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"); ==> (as called by) /var/WWW/xxx/xxx//web/ZC_SHOP_155/a_team2013/sqlpatch.php on line 304 <== in /var/WWW/xxx/xxx//web/ZC_SHOP_155/includes/classes/db/mysql/query_factory.php on line 167
Der Shop ist neu und leer bis auf die geänderte Template Datei.
Grüße und Danke Guido
Kommentar