Error log record number: ee79eb9e8a5509ffec4a5cd3aed33c2fba517c95624e2aeed2f59dde9f54ce94 {"0":"Please upgrade your database: Run \"bin\/magento setup:upgrade\" from the Magento root directory.\nThe following modules are outdated:\n Magento_AuthorizenetAcceptjs schema: current version - none, required version - 1.0.0\n Magento_AuthorizenetAcceptjs data: current version - none, required version - 1.0.0\n Unable to change status of modules because of the following constraints: Cannot disable Magento_AuthorizenetAcceptjs because modules depend on it: Magento_AuthorizenetCardinal: Magento_AuthorizenetCardinal->Magento_AuthorizenetAcceptjs MSP_ReCaptcha schema: current version - none, required version - 1.6.0\n MSP_ReCaptcha data: current version - none, required version - 1.6.0\n Amazon_Core schema: current version - none, required version - 3.3.1\n Amazon_Core data: current version - none, required version - 3.3.1\n Dotdigitalgroup_Email schema: current version - none, required version - 4.1.0\n Dotdigitalgroup_Email data: current version - none, required version - 4.1.0\n Klarna_Core schema: current version - none, required version - 5.2.3\n Klarna_Core data: current version - none, required version - 5.2.3\n Klarna_Ordermanagement schema: current version - none, required version - 5.0.7\n Klarna_Ordermanagement data: current version - none, required version - 5.0.7\n Vertex_Tax schema: current version - none, required version - 100.5.1 Vertex_Tax data: current version - none, required version - 100.5.1","1":"#1 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:73]\n #2 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n #3 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n #4 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n #5 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/Http.php:116]\n #6 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n #7 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n #8 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:40]\n ","url":"\/admin_lak7t5\/admin\/dashboard\/index\/key\/2563634bae9d02af03ad6f1f758d44dbb229090417be81d82e80e939944bb1f9\/","script_name":"\/index.php","report_id":"ee79eb9e8a5509ffec4a5cd3aed33c2fba517c95624e2aeed2f59dde9f54ce94"} -------------------------------------------------------------------------- cd /var/www/magento2/var/report cp xxxx /var/www/html/err-002 http://3.134.105.225/err-002 {"0":"Please upgrade your database: Run \"bin\/magento setup:upgrade\" from the Magento root directory.\n The following modules are outdated: \nMagento_GoogleShoppingAds data: current version - none, required version - 3.0.1 \nMagento_AuthorizenetAcceptjs schema: current version - none, required version - 1.0.0 \nMagento_AuthorizenetAcceptjs data: current version - none, required version - 1.0.0 \nMSP_ReCaptcha schema: current version - none, required version - 1.6.0 \nMSP_ReCaptcha data: current version - none, required version - 1.6.0 \nAmazon_Core schema: current version - none, required version - 3.3.1 \nAmazon_Core data: current version - none, required version - 3.3.1 \nAmazon_Login schema: current version - none, required version - 3.3.1 \nAmazon_Login data: current version - none, required version - 3.3.1 \nAmazon_Payment schema: current version - none, required version - 3.3.1 \nAmazon_Payment data: current version - none, required version - 3.3.1 \nDotdigitalgroup_Email schema: current version - none, required version - 4.1.0 \nDotdigitalgroup_Email data: current version - none, required version - 4.1.0 \nDotdigitalgroup_Chat schema: current version - none, required version - 1.0.0 \nDotdigitalgroup_Chat data: current version - none, required version - 1.0.0 \nKlarna_Core schema: current version - none, required version - 5.2.3 \nKlarna_Core data: current version - none, required version - 5.2.3 \nKlarna_Ordermanagement schema: current version - none, required version - 5.0.7 \nKlarna_Ordermanagement data: current version - none, required version - 5.0.7 \nKlarna_Kp schema: current version - none, required version - 6.4.0 \nKlarna_Kp data: current version - none, required version - 6.4.0 \nMagento_PaypalReCaptcha schema: current version - none, required version - 2.0.0 \nMagento_PaypalReCaptcha data: current version - none, required version - 2.0.0 \nMSP_TwoFactorAuth schema: current version - none, required version - 3.1.0 \nMSP_TwoFactorAuth data: current version - none, required version - 3.1.0 \nTemando_Shipping schema: current version - none, required version - 1.6.0 \nTemando_Shipping data: current version - none, required version - 1.6.0 \nVertex_Tax schema: current version - none, required version - 100.5.1 \nVertex_Tax data: current version - none, required version - 100.5.1 \nVertex_AddressValidation schema: current version - none, required version - 100.5.0 \nVertex_AddressValidation data: current version - none, required version - 100.5.0 \nYotpo_Yotpo schema: current version - none, required version - 3.0.1 \nYotpo_Yotpo data: current version - none, required version - 3.0.1","1":" #1 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:73]\n #2 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n #3 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n #4 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n #5 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/Http.php:116]\n #6 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n #7 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n #8 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:40]\n","url":"\/","script_name":"\/index.php","report_id":"97e80435f56695c870a389ad5a1414089d393a6cceccfb379b2a7599aaad412b"} xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx php bin/magento module:disable --clear-static-content Magento_GoogleShoppingAds php bin/magento module:disable --clear-static-content Magento_AuthorizenetAcceptjs -> Magento_AuthorizenetCardinal php bin/magento module:disable --clear-static-content MSP_ReCaptcha php bin/magento module:disable --clear-static-content Amazon_Core php bin/magento module:disable --clear-static-content Amazon_Payment php bin/magento module:disable --clear-static-content Amazon_Login php bin/magento module:disable --clear-static-content Amazon_Payment php bin/magento module:disable --clear-static-content Dotdigitalgroup_Email php bin/magento module:disable --clear-static-content Dotdigitalgroup_Chat php bin/magento module:disable --clear-static-content Klarna_Core -> Klarna_Ordermanagement php bin/magento module:disable --clear-static-content Klarna_Ordermanagement php bin/magento module:disable --clear-static-content Klarna_Kp php bin/magento module:disable --clear-static-content Magento_PaypalReCaptcha php bin/magento module:disable --clear-static-content MSP_TwoFactorAuth php bin/magento module:disable --clear-static-content Temando_Shipping php bin/magento module:disable --clear-static-content Vertex_Tax php bin/magento module:disable --clear-static-content Vertex_AddressValidation php bin/magento module:disable --clear-static-content Yotpo_Yotpo php bin/magento module:disable --clear-static-content Magento_InventoryCatalog -> Magento_InventoryGraphQl xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx List of disabled modules: Magento_GoogleShoppingAds Magento_AuthorizenetAcceptjs Magento_AuthorizenetCardinal MSP_ReCaptcha Amazon_Core Amazon_Login Amazon_Payment Bss_DisableCompare Dotdigitalgroup_Email Dotdigitalgroup_Chat Klarna_Core Klarna_Ordermanagement Klarna_Kp Magento_PaypalReCaptcha MSP_TwoFactorAuth Temando_Shipping Vertex_Tax Vertex_AddressValidation Yotpo_Yotpo -------------------------------------------------------------------------- lee@ip-172-31-40-85:/var/www/magento2-20200404-ok$ php bin/magento indexer:reindex Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index is locked by another reindex process. Skipping. Category Products indexer process unknown error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento8pm.catalog_category_product_index_replica' doesn't exist, query was: DESCRIBE `catalog_category_product_index_replica` Product Categories indexer process unknown error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento8pm.catalog_category_product_index_replica' doesn't exist, query was: DESCRIBE `catalog_category_product_index_replica` Catalog Rule Product index has been rebuilt successfully in 00:00:00 Table "catalog_product_index_eav_replica" does not exist Table "cataloginventory_stock_status_replica" does not exist Inventory indexer process unknown error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento8pm.inventory_stock' doesn't exist, query was: SELECT `inventory_stock`.`stock_id` FROM `inventory_stock` Catalog Product Rule index has been rebuilt successfully in 00:00:00 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_store_id' in 'field list', query was: INSERT INTO `catalog_product_index_website` (`website_id`,`website_date`,`rate`,`default_store_id`) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE `website_id` = VALUES(`website_id`), `website_date` = VALUES(`website_date`), `rate` = VALUES(`rate`), `default_store_id` = VALUES(`default_store_id`) Google Product Removal Feed index has been rebuilt successfully in 00:00:00 Google Product Feed index has been rebuilt successfully in 00:00:00 Catalog Search indexer process unknown error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento8pm.inventory_stock_sales_channel' doesn't exist, query was: SELECT `inventory_stock_sales_channel`.`stock_id` FROM `inventory_stock_sales_channel` WHERE (type = 'website') AND (code = 'base') -------------------------------------------------------------------------- Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index has been rebuilt successfully in 00:00:02 Category Products index has been rebuilt successfully in 00:00:01 Product Categories index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:00 Product EAV index has been rebuilt successfully in 00:00:00 Stock index has been rebuilt successfully in 00:00:00 Inventory index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:00 Google Product Removal Feed index has been rebuilt successfully in 00:00:00 Google Product Feed index has been rebuilt successfully in 00:00:00 ------------------------------------- Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index has been rebuilt successfully in 00:00:02 Category Products index has been rebuilt successfully in 00:00:01 Product Categories index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:01 Product EAV index has been rebuilt successfully in 00:00:01 Stock index has been rebuilt successfully in 00:00:01 Inventory index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:02 Google Product Removal Feed index has been rebuilt successfully in 00:00:01 Google Product Feed index has been rebuilt successfully in 00:00:00 ------------------------------------- php bin/magento setup:upgrade SQLSTATE[42000]: Syntax error or access violation: 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 WHERE `Non_unique` = 1' at line 1, query was: SHOW INDEXES FROM ves_megamenu_item-0 WHERE `Non_unique` = 1 Unable to apply patch Magento\InventoryCatalog\Setup\Patch\Schema\InitializeDefaultStock for module Magento_InventoryCatalog. Original exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY', query was: INSERT INTO `inventory_stock` (`stock_id`, `name`) VALUES (?, ?) ------------------------------------- root@ip-172-31-40-85:/var/www/magento2# php bin/magento indexer:reindex Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index has been rebuilt successfully in 00:00:03 Category Products index has been rebuilt successfully in 00:00:01 Product Categories index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:00 Product EAV index has been rebuilt successfully in 00:00:00 Stock index has been rebuilt successfully in 00:00:00 Inventory index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:00 Google Product Removal Feed index has been rebuilt successfully in 00:00:00 Google Product Feed index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:06 ------------------------------------- Unable to apply patch Magento\InventoryCatalog\Setup\Patch\Schema\InitializeDefaultStock for module Magento_InventoryCatalog. Original exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'default' for key 'PRIMARY', query was: INSERT INTO `inventory_source` (`source_code`, `name`, `enabled`, `description`, `latitude`, `longitude`, `country_id`, `postcode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ------------------------------------- Unable to apply patch Magento\InventoryCatalog\Setup\Patch\Schema\InitializeDefaultStock for module Magento_InventoryCatalog. Original exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY', query was: INSERT INTO `inventory_stock` (`stock_id`, `name`) VALUES (?, ?) Unable to apply patch Magento\InventoryCatalog\Setup\Patch\Schema\InitializeDefaultStock for module Magento_InventoryCatalog. Original exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'default' for key 'PRIMARY', query was: INSERT INTO `inventory_source` (`source_code`, `name`, `enabled`, `description`, `latitude`, `longitude`, `country_id`, `postcode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Unable to apply patch Magento\InventoryCatalog\Setup\Patch\Schema\InitializeDefaultStock for module Magento_InventoryCatalog. Original exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'default' for key 'PRIMARY', query was: INSERT INTO `inventory_source` (`source_code`, `name`, `enabled`, `description`, `latitude`, `longitude`, `country_id`, `postcode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) php bin/magento module:disable --clear-static-content Magento_InventoryGraphQl php bin/magento module:disable --clear-static-content Magento_InventoryCatalog php bin/magento module:disable --clear-static-content Magento_InventoryCatalogAdminUi php bin/magento module:disable --clear-static-content Magento_InventoryCatalogApi php bin/magento module:disable --clear-static-content Magento_InventoryCatalogSearch php bin/magento module:disable --clear-static-content Bss_DisableCompare php bin/magento module:status php bin/magento cache:flush php bin/magento indexer:reset php bin/magento indexer:reindex php bin/magento setup:upgrade php bin/magento setup:di:compile->卡住?加上插件要花很長時間 1.)改mysql password(原為frevres88->revres88) mysql -u root -p mysql> set password for root@localhost = password('revres88'); set password for magento_user@localhost = password('revres88'); 2.)改mag2-mysql password(原為frevres88->revres88) cd /var/www/magento2/app/etc joe env.php-> 'password' => 'revres88', 3.)建新圖片目錄pagepic su lee cd /var/www/pwpic/ mkdir pagepic ln -s /var/www/pwpic/pagepic/ /var/www/magento2/pub/media/ CREATE ALGORITHM=UNDEFINED DEFINER=`magento_user`@`localhost` SQL SECURITY INVOKER VIEW `magento2-0`.`inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`magento2`.`cataloginventory_stock_status` `legacy_stock_status` join `magento2`.`catalog_product_entity` `product` on((`legacy_stock_status`.`product_id` = `product`.`entity_id`))) ; tar -xzf magento8pm-20200325-new-ro-online-bk.tar.gz --- 20200406 AWS-QT 改 mysql password ========================================================================================================================= 1.)安裝 Theme Zou demo su lee cd /var/www/magento2/app/design/frontend/ wget 118.163.15.73/Zou.zip unzip Zou.zip cd /var/www/magento2/ x->2.)安裝插件 Bannerslider(slider manage沒有list無法管理->不使用了) cd /var/www/magento2/ git clone https://github.com/Magestore/Bannerslider-Magento2.git mkdir -p app/code/Magestore/Bannerslider cp Bannerslider-Magento2/* app/code/Magestore/Bannerslider/ -rf rm Bannerslider-Magento2 -rf php bin/magento module:enable --clear-static-content Magestore_Bannerslider php bin/magento setup:upgrade 3.)下載滾動js OwlCarousel2(可以不用作,sample中已含) wget https://github.com/OwlCarousel2/OwlCarousel2/archive/2.3.4.zip mv 2.3.4.zip app/design/frontend/Zou/demo/web/js/ cd app/design/frontend/Zou/demo/web/js unzip 2.3.4.zip rm 2.3.4.zip php bin/magento setup:static-content:deploy en_US -f ->Execution time: 15.878460168839 cd /var/www/magento2/app/design/frontend/Zou/demo/web/js/ joe demo.js http://owlcarousel2.github.io/OwlCarousel2/docs/api-options.html cd /var/www/magento2/app/design/frontend/Zou/demo/Magento_Cms/layout/ joe cms_index_index.xml cd /var/www/magento2/app/design/frontend/Zou/demo/web/css/ joe demo.css cd /var/www/magento2/app/design/frontend/Zou/demo/Magento_Cms/templates/html/homepage/ joe home_content.phtml --- 20200405 AWS-QT 裝 Theme Zou demo ========================================================================================================================= 2020年4月5日 UTC+8下午7:46:15 (19:46:15)->ADA重開機 新IP->3.22.57.63 System information as of Sun Apr 5 12:06:35 UTC 2020 System load: 1.05 Processes: 92 Usage of /: 99.9% of 29.02GB Users logged in: 0 Memory usage: 33% IP address for eth0: 172.31.32.158 Swap usage: 0% => / is using 99.9% of 29.02GB * Canonical Livepatch is available for installation. - Reduce system reboots and improve kernel security. Activate at: https://ubuntu.com/livepatch 120 packages can be updated. 0 updates are security updates. Last login: Sat Apr 4 02:03:50 2020 from 58.252.52.165 System information as of Sun Apr 5 12:33:58 UTC 2020 System load: 0.09 Processes: 110 Usage of /: 94.9% of 29.02GB Users logged in: 1 Memory usage: 62% IP address for eth0: 172.31.32.158 Swap usage: 0% => / is using 94.9% of 29.02GB 2.)清/var/www/html/magento8pm/var/page_cache-> 553M->5.9G ->SYSTEM->Cache Management->Flush Cache Storage + 最下方Additional Cache Management三按鍵 ->/dev/xvda1 30G 22G 7.7G 74% / 3.)刪沒用 cd /var/www/html rm magento8pm-zou-er -r -> /dev/xvda1 30G 21G 8.5G 72% / rm magento232-bk -r -> /dev/xvda1 30G 20G 9.4G 68% / rm mag-wg-1 -r 備份 magento2->tar -czf magento2-20200405.tar.gz * rm magento2 -r -> /dev/xvda1 30G 20G 9.9G 66% / 備份 magento232->tar -czf magento232-20200405.tar.gz * rm magento232 -r ->/dev/xvda1 30G 19G 11G 64% / --- 20200405 AWS-DV 空間爆滿100% 死機 ========================================================================================================================= 1.)還原magento2->20200404(未裝任何插件) tar -xzvf magento2-20200404.tar.gz bin/magento setup:di:compile -> Compilation was started. Repositories code generation... 1/7 [===>------------------] 14% 1 sec 78.5 MiB Interception cache generation... 7/7 [=============] 100% 59 secs 357.0 MiB Generated code and dependency injection configuration successfully. 2.)恢復magento2->裝了插件x3(DisableCompare,Ves,SliderBanner) joe /etc/php/7.2/fpm/php.ini joe /etc/php/7.2/cli/php.ini -> display_errors = On (原 Off) log_errors = On ;error_log = php_errors.log -> touch /var/log/php_error.log(後來改 chown lee:lee) find . -name "php_errors.log"(找不到) systemctl restart php7.2-fpm cd /var/www/magento2/ php -dmemory_limit=2G bin/magento setup:di:compile -> Compilation was started. Repositories code generation... 1/7 [==>-----------------] 14% < 1 sec 78.5 MiB Service data attributes generation... 2/7 [===>---------] 28% 19 secs 213.0 MiB Application code generator... 3/7 [=====>-------] 42% 20 secs 213.0 MiB 3.)刪去Ves,SliderBanner>只留DisableCompare Compilation was started. Repositories code generation... 1/7 [==>-----------------] 14% < 1 sec 78.5 MiB Application code generator... 3/7 [=====>-------] 42% 15 secs 209.0 MiB Interceptors generation... 4/7 [=======>-----] 57% 34 secs 233.0 MiB 08:58->09:26->ctrl-c->中斷 --- 20200404-06 研究 bin/magento setup:di:compile (失敗或不知是需時太久) ========================================================================================================================= 1.)新增Attribute b4_free_shipping ------------ To Do----------------- import 產品自動建目錄(不可以有1/,先改其他 取消目錄PWC? google reCaptcha? 建新根目錄? 取消review? ---------------------- --- 20200404 AWS-QT 更新 Attribute set + import product.csv ========================================================================================================================= 1.)安裝 Theme 8pm su lee cd /var/www/magento2/app/design/frontend wget 118.163.15.73/theme8pm.zip unzip theme8pm.zip cd /var/www/magento2/ php bin/magento indexer:reindex php bin/magento cache:flush 2.)安裝插件 DisableCompare su lee cd /var/www/magento2/app/ mkdir code/Bss/DisableCompare cd code/Bss/DisableCompare wget 118.163.15.73/mag-ext-1.zip unzip mag-ext-1.zip cd /var/www/magento2/ php bin/magento module:status php bin/magento module:enable --clear-static-content Bss_DisableCompare php bin/magento setup:upgrade php bin/magento setup:di:compile->卡住?加上插件要花很長時間 Compilation was started. Application code generator... 3/7 [=====>-------] 42% 15 secs 209.0 MiB 3.)安裝插件 Ves 全部不能用 cd /var/www/magento2/app/code/ wget 118.163.15.73/mag-ext-2.zip unzip mag-ext-2.zip php bin/magento module:enable --clear-static-content Ves_All php bin/magento module:enable --clear-static-content Ves_Megamenu php bin/magento module:enable --clear-static-content Ves_Setup php bin/magento module:enable --clear-static-content Ves_BaseWidget php bin/magento module:enable --clear-static-content Ves_Themesettings php bin/magento module:enable --clear-static-content Ves_PageBuilder php bin/magento module:enable --clear-static-content Ves_Productlist php bin/magento setup:upgrade wget 118.163.15.73/mag-ext-3.zip(只有Ves 3x) unzip mag-ext-3.zip php bin/magento module:uninstall --clear-static-content Ves_Megamenu ->Ves_Megamenu is not an installed composer package php bin/magento module:disable --clear-static-content Ves_All php bin/magento module:disable --clear-static-content Ves_Megamenu php bin/magento module:disable --clear-static-content Ves_Setup php bin/magento module:disable --clear-static-content Ves_BaseWidget php bin/magento module:disable --clear-static-content Ves_Themesettings php bin/magento module:disable --clear-static-content Ves_PageBuilder php bin/magento module:disable --clear-static-content Ves_Productlist --- 20200404 AWS-QT 安裝 Theme 8pm + Ext DisableCompare + Ves ========================================================================================================================= 0.)copy pwpic from aws-dv cd /var/www/pwpic/ chown www-data:www-data . 舊aws-dv joe /etc/apache2/sites-available/aws-wg-1.conf DocumentRoot /var/www/html/pwpic/webimg ServerName aws.wg-1.com ErrorLog /var/log/apache2/error_log CustomLog /var/log/apache2/access_log common Options FollowSymLinks AllowOverride all Require all granted # Order allow,deny # Allow from all 1.)新aws-qt->qtpic-wg-1->qtpic.wg-1.com指向3.134.105.225(AWS-QT) joe /etc/nginx/sites-available/qtpic-wg-1 server { listen 80; server_name qtpic.wg-1.com; root /var/www/pwpic/webimg; } -> 測if OK->sudo nginx -t sudo ln -s /etc/nginx/sites-available/qtpic-wg-1 /etc/nginx/sites-enabled/ sudo systemctl restart nginx 2.)新aws-qt->aws-wg-1 joe /etc/nginx/sites-available/aws-wg-1 server { listen 80; server_name aws.wg-1.com; root /var/www/pwpic/webimg; } 3.)aws.wg-1.com指向3.134.105.225(AWS-QT) 4.)備份mag2 + sql cd /var/www/magento2 備份mag2->tar -czf magento2-20200403.tar.gz * 解壓->tar -xzvf magento2-20200403.tar.gz 備份sql->copy magento2 -> magento2_20200403 備份mag2->tar -czf magento2-20200404.tar.gz * (裝完theme 8pm) 備份sql->copy magento2 -> magento2_20200404 (裝完theme 8pm) 5.)建立圖片連結 cd /var/www/pwpic/catalog/ chown -R lee:lee . su lee ln -s /var/www/pwpic/catalog/ /var/www/magento2/pub/media/ php bin/magento indexer:reindex php bin/magento cache:flush find . -name "22-08.jpg" --- 20200403-04 AWS-DV圖片移至 AWS-QT ========================================================================================================================= (20200402 22:10) aws-hdd-100%-> Filesystem Size Used Avail Use% Mounted on /dev/xvda1 30G 28G 1.1G 97% / cd /var/www/html rm Magento-CE-2.3.2.tar.bz2 rm magento8pm.tar.gz rm php-7.0.4.tar.gz rm ves_8pmfriday_quickstart.zip rm magento8pm-20200324-new-ro-online-bk.tar.gz rm magento8pm-20191107-ok.tar.gz rm magento8pm-20191107-pm-ok.tar.gz login as: ubuntu Authenticating with public key "imported-openssh-key" Welcome to Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-1060-aws x86_64) * Documentation: https://help.ubuntu.com * Management: https://landscape.canonical.com * Support: https://ubuntu.com/advantage System information as of Thu Apr 2 14:04:31 UTC 2020 System load: 0.17 Processes: 122 Usage of /: 99.9% of 29.02GB Users logged in: 1 Memory usage: 78% IP address for eth0: 172.31.32.158 Swap usage: 53% => / is using 99.9% of 29.02GB * Kubernetes 1.18 GA is now available! See https://microk8s.io for docs or install it with: sudo snap install microk8s --channel=1.18 --classic * Multipass 1.1 adds proxy support for developers behind enterprise firewalls. Rapid prototyping for cloud operations just got easier. https://multipass.run/ * Canonical Livepatch is available for installation. - Reduce system reboots and improve kernel security. Activate at: https://ubuntu.com/livepatch 123 packages can be updated. 0 updates are security updates. *** System restart required *** Last login: Wed Apr 1 02:47:24 2020 from 114.34.53.65 ubuntu@awsko:~$ sudo su root@awsko:/home/ubuntu# df -h Filesystem Size Used Avail Use% Mounted on udev 480M 0 480M 0% /dev tmpfs 99M 11M 88M 11% /run /dev/xvda1 30G 30G 0 100% / tmpfs 492M 0 492M 0% /dev/shm tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 492M 0 492M 0% /sys/fs/cgroup /dev/loop0 18M 18M 0 100% /snap/amazon-ssm-agent/1480 /dev/loop3 92M 92M 0 100% /snap/core/8689 /dev/loop4 18M 18M 0 100% /snap/amazon-ssm-agent/1566 /dev/loop1 94M 94M 0 100% /snap/core/8935 tmpfs 99M 0 99M 0% /run/user/1000 root@awsko:/home/ubuntu# cd /var/www/html rm magento8pm-20191220-dv-fail.tar.gz rm magento8pm-20200227-card-braintree-error.tar.gz apt-get autoclean apt-get clean zip -r pwpic-0.zip pwpic-0/ PC下載 -> http://18.218.158.219/pwpic-0.zip rm pwpic-0.zip rm pwpic-0 -r aws-qt: wget http://18.218.158.219/pwpic-0.zip wget http://18.218.158.219/pwpic.zip wget http://18.218.158.219/magento8pm-20191107-bk-for-dv.tar.gz wget http://18.218.158.219/magento8pm-20191123-bk.tar.gz wget http://18.218.158.219/magento8pm-20191230-before-md5-patch.tar.gz wget http://18.218.158.219/magento8pm-20200121-bk.tar.gz wget http://18.218.158.219/magento8pm-20200221-dv.tar.gz wget http://18.218.158.219/magento8pm-20200311-braintree-ok-20200121-recover-dv-fix-ok.tar.gz --aws未刪 wget http://18.218.158.219/magento8pm-20200319-braintree-ok-dv-fix-chen-test-ok.tar.gz wget http://18.218.158.219/magento8pm-20200325-new-ro-online-bk.tar.gz aws-dv: zip -r pwpic.zip pwpic/ rm pwpic.zip rm pwpic-0.zip rm pwpic-0 -r rm magento8pm-20191107-bk-for-dv.tar.gz rm magento8pm-20191123-bk.tar.gz rm magento8pm-20191230-before-md5-patch.tar.gz rm magento8pm-20200121-bk.tar.gz rm magento8pm-20200221-dv.tar.gz rm magento8pm-20200311-braintree-ok-20200121-recover-dv-fix-ok.tar.gz 3.22.57.63 --- 20200403 AWS 空間爆滿100% ========================================================================================================================= aws-qt 3.134.105.225 qt.wg-1.com 0.)預裝系統 sudo apt-get update && sudo apt-get -y upgrade sudo apt-get -y install curl nano git sudo apt install unzip sudo apt-get install joe 1.)nginx sudo apt-get install nginx sudo systemctl start nginx(會報錯) 2.)PHP 7.2 sudo apt-get update -y sudo apt install software-properties-common sudo add-apt-repository -y ppa:ondrej/php sudo add-apt-repository -y ppa:ondrej/nginx sudo apt-get update -y 以下都要先安裝-> sudo apt-get install libcurl4-openssl-dev sudo apt-get install php-pear sudo apt-get -y install gcc make autoconf libc-dev pkg-config sudo apt-get -y install php7.2-dev sudo apt-get -y install libmcrypt-dev pecl channel-update pecl.php.net sudo pecl install mcrypt-1.0.1 檢查已安裝-> apt-cache pkgnames | grep php7.2 要修改->libcurl4->為libcurl4-openssl-dev x->sudo apt-get install -y php7.1 php7.1-fpm php7.1-mcrypt php7.1-curl php7.1-cli php7.1-mysql php7.1-gd php7.1-xsl php7.1-json php7.1-intl php-pear php7.1-dev php7.1-common php7.1-mbstring php7.1-zip php7.1-bcmath php7.1-fileinfo php7.1-soap php7.1-imagick libcurl4 curl -y x->sudo apt-get install -y php7.1 php7.1-fpm php7.1-mcrypt php7.1-curl php7.1-cli php7.1-mysql php7.1-gd php7.1-xsl php7.1-json php7.1-intl php-pear php7.1-dev php7.1-common php7.1-mbstring php7.1-zip php7.1-bcmath php7.1-fileinfo php7.1-soap php7.1-imagick libcurl4-openssl-dev curl -y x->sudo apt-get install -y php7.2 php7.2-fpm php7.2-mcrypt php7.2-curl php7.2-cli php7.2-mysql php7.2-gd php7.2-xsl php7.2-json php7.2-intl php-pear php7.2-dev php7.2-common php7.2-mbstring php7.2-zip php7.2-bcmath php7.2-fileinfo php7.2-soap php7.2-imagick libcurl4-openssl-dev curl -y sudo apt-get install -y php7.2 php7.2-fpm php7.2-curl php7.2-cli php7.2-mysql php7.2-gd php7.2-xsl php7.2-json php7.2-intl php-pear php7.2-dev php7.2-common php7.2-mbstring php7.2-zip php7.2-bcmath php7.2-fileinfo php7.2-soap php7.2-imagick libcurl4-openssl-dev curl -y 刪除如果有裝老版本-> sudo apt-get purge php7.0 php7.0-common sudo apt-get purge php7.1 php7.1-common 設環境參數-> sudo rm /usr/bin/php sudo cp /usr/bin/php7.2 /usr/bin/php php –v -> PHP 7.2.29-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Mar 20 2020 13:54:16) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies with Zend OPcache v7.2.29-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies 改php.ini-> joe /etc/php/7.2/fpm/php.ini joe /etc/php/7.2/cli/php.ini -> memory_limit = 1024M max_execution_time = 1800 zlib.output_compression = On -> sudo systemctl restart php7.2-fpm 3.)mysql sudo apt-get install mysql-server-5.7 ->root + frevres88(20200406改revres88) mysql -u root -p mysql> CREATE DATABASE magento2 CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL ON magento2.* TO magento_user@localhost IDENTIFIED BY 'frevres88'; quit -> cd /etc/nginx/sites-available/ joe qt-wg-1 upstream fastcgi_backend { server unix:/run/php/php7.2-fpm.sock; } server { listen 80; server_name qt.wg-1.com; set $MAGE_ROOT /var/www/magento2; set $MAGE_MODE developer; include /var/www/magento2/nginx.conf.sample; error_log /var/log/nginx/error.log; } -> 測if OK->sudo nginx -t sudo ln -s /etc/nginx/sites-available/qt-wg-1 /etc/nginx/sites-enabled/ sudo systemctl restart nginx 4.)phpmyadmin 3.134.105.225/admin_7s9q2 sudo apt-get purge phpmyadmin sudo apt-get install phpmyadmin sudo ln -s /usr/share/phpmyadmin /var/www/html/admin_7s9q2 joe /etc/nginx/sites-available/default-> index index.html index.htm index.php index.nginx-debian.html; location /phpmyadmin { index index.php; } location ~ \.php$ { include snippets/fastcgi-php.conf; # # # With php7.0-cgi alone: # fastcgi_pass 127.0.0.1:9000; # # With php7.0-fpm: fastcgi_pass unix:/run/php/php7.2-fpm.sock; } 5.)composer cd ~/ curl -sS https://getcomposer.org/installer | php mv composer.phar /usr/bin/composer 6.)Magento ver. 2.3.4 (aws-dv 2.1.9) cd /var/www/ 失敗->composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition magento2(但是keyin了username+password-key) cd /var/www/magento2/ wget 118.163.15.73/magento2.zip unzip magento2.zip composer install -v -> php bin/magento setup:install --backend-frontname="adminmag" \ --key="65b07bf534c102e5ee62f4d7ee8f4b88" \ --base-url="http://qt.wg-1.com" \ --base-url-secure="https://qt.wg-1.com" \ --db-host=localhost \ --db-name=magento2 \ --db-user=magento_user \ --db-password='frevres88' \(20200406改revres88) --admin-firstname=Lee \ --admin-lastname=David \ --admin-email=dv4ml@dacomputing.com \ --admin-user=adminmag \ --admin-password=frevres0907 \ --language=en_US \ --currency=USD \ --timezone=America/Chicago \ --use-rewrites=1 -> [SUCCESS]: Magento installation complete. [SUCCESS]: Magento Admin URI: /adminmag Nothing to import. find . -type f -exec chmod 644 {} \; && find . -type d -exec chmod 755 {} \; && chmod 777 var/ -R && find pub/media -type d -exec chmod 777 {} \; && find pub/static -type d -exec chmod 777 {} \; && chmod 777 app/etc && chmod 644 app/etc/*.xml && chmod u+x bin/magento chown -R www-data:www-data . systemctl restart nginx php bin/magento indexer:reindex php bin/magento cache:flush php bin/magento info:adminuri 改admin-url-> joe app/etc/env.php-> return [ 'backend' => [ 'frontName' => 'admin_lak7t5' 7.)建新權限USER adduser lee passwd aa223344 joe /etc/sudoers-> lee ALL=(ALL:ALL) ALL usermod -a -G www-data lee cd /var/www/magento2 find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \; find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \; find . -type f -exec chmod 644 {} \; find . -type d -exec chmod 755 {} \; find ./var -type d -exec chmod 777 {} \; chmod 777 var/ -R \; find ./pub/media -type d -exec chmod 777 {} \; find ./pub/static -type d -exec chmod 777 {} \; chmod 777 ./app/etc chmod 644 ./app/etc/*.xml chown lee:lee . -hR chmod u+x bin/magento chmod -R g+rwxs . ls -la chown lee:lee /var/www joe /etc/php/7.2/fpm/pool.d/www.conf -> ;user = www-data ;group = www-data user = lee group = lee ;listen.owner = www-data ;listen.group = www-data listen.owner = lee listen.group = lee -> joe /etc/nginx/nginx.conf -> #user www-data; user lee; -> systemctl restart nginx systemctl restart php7.2-fpm 8.)更新magento2->su lee php bin/magento maintenance:enable rm -rf var/di/* && rm -rf var/generation/* && rm -rf var/cache/* && rm -rf var/page_cache/* && rm -rf var/view_preprocessed/* && rm -rf pub/static/* && rm -rf generated/* && mkdir var/di php bin/magento setup:upgrade && php bin/magento setup:di:compile php bin/magento setup:static-content:deploy -f && php bin/magento indexer:reindex && php bin/magento maintenance:disable && php bin/magento cache:clean && php bin/magento cache:flush 失敗->9.)導入Demo Data-> -------------------------------------------------------------------------------------------- wget https://codeload.github.com/magento/magento2-sample-data/zip/2.2.4 mv 2.2.4 2.2.4.zip unzip 2.2.4.zip mv magento2-sample-data-2.2.4 magento2-sample-data rm 2.2.4.zip php -f magento2-sample-data/dev/tools/build-sample-data.php -- --ce-source="/var/www/magento2" php bin/magento setup:upgrade -> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Magento_CatalogSampleData' for key 'PRIMARY', query was: INSERT INTO `setup_module` (`module`, `schema_version`) VALUES (?, ?) php bin/magento indexer:reindex php bin/magento cache:flush php bin/magento sampledata:deploy-> Authentication required (repo.magento.com): Username: 0c2e51e0297016e62e864f5effe625c7 (Public Key) Password: 38410b35ec042696d687ee7c90436d88 (Private Key) Do you want to store credentials for repo.magento.com in /var/www/magento2/var/composer_home/auth.json ? [Yn] ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev) Killed php bin/magento setup:upgrade chown -R www-data:www-data . php bin/magento indexer:reindex php bin/magento cache:flush x->chown -R www-data:www-data . x->chown -R lee:lee . php bin/magento indexer:reindex php bin/magento cache:flush chown -R www-data:www-data . systemctl restart nginx -------------------------------------------------------------------------------------------- --- 20200402-03 AWS-QT 裝新magento2 ========================================================================================================================= 1.)Update field limitation rules from the database Directly in the customer_eav_attribute table, update rows with attribute_id=5 [firstname] and attribute_id=7 [last name] and replace 255 by 25. Change code validate_rules->a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} //before update or by default To validate_rules->a:2:{s:15:"max_text_length";i:25;s:15:"min_text_length";i:1;} // after change ID:9223 Leupoldjrm xwusaymetmbexagGP ID:9224 Holographichwd zvusalmezniuxjsGP (20200324 PM 15:35)改 25->16 ID:9231(20200328刪1人) ID:9237(20200331刪1人) ID:9243(20200402刪1人) 2.)Add Google CAPTCHA https://www.mageplaza.com/blog/how-to-add-google-recaptcha-into-magento-2.html 在你的網站中加進 reCAPTCHA 「purewaterclubmag」已完成註冊。 在向使用者顯示的 HTML 程式碼中使用這串網站金鑰。 6LfIkeMUAAAAAI_FngvUCMAroZ7RizbD3Su6uoDs 用這串密鑰來建立網站和 reCAPTCHA 之間的通訊。 6LfIkeMUAAAAAE6LbLQ2aYQit3coOi3QO3pQSa0a 李生 14:36:28 要仔細研究看看要改哪些檔案 ADA 14:36:44 GMAIL purewaterclubmag@gmail.com ; AA2233zz!! --- 20200324 預防SPAM註冊 ========================================================================================================================= 1.)www.purewaterclub.com + purewaterclub.com 拍向 aws-magento8pm 2.)改STORES->Configuration->Store View:pwc_ro->GENERAL-Web->Base URLs + Base URLs (Secure): http://www.purewaterclub.com/ 3.)cd /etc/apache2/sites-available cp purewaterclub.conf www-purewaterclub.conf(比照mag2.purewaterclub.com) joe www-purewaterclub.conf 4.)修改Mega Menu(不明原因又被改回default,所以再次修改) 共用目錄頁->blank:menu-top(不存在,不會出現) /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml menu-top b4u_home->7pm:menu-top-b4u /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml menu-top-b4u pwc_ro->6pm:menu-top-pwc /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Megamenu/layout/default.xml menu-top-pwc 4-1.)改menu-top-pwc->goto old site -> http://last.pureaterclub.com/ (拼錯字少"w") -> http://last.purewaterclub.com/ 5.)改TAX,GUEST 手工刪除黑客注冊垃圾帳號 舊RO->sale DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 10 record DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address LIKE '%?%' -> 1 record DELETE FROM address_book WHERE entry_country_id='110' -> 1 record (KE Kenya) DELETE FROM address_book WHERE entry_country_id='17' -> 2 record (BH Bahrain) UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 14 record DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 14 record ->http://last.purewaterclub.com/gen-customer-csv.php->q-20200319.csv import Customer -> ro-customer-20200319-last-ok -> Checked rows: 5, checked entities: 10, invalid rows: 0, total errors: 0 新pwc_ro後台 ID:9141,9142,9143,9144,9145,9151 ID:9152-9169(20200320刪18人) ID:9170-9177(20200321刪8人) ID:9178-9184(20200322刪7人) ID:9186-9189(20200323刪4人) ID:9191-9200(20200323刪10人) ID:9201-9207(20200324刪7人) ID:9209-9213(20200324刪5人) ID:9215-9222(20200324刪10人) cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex /usr/bin/php bin/magento cache:flush ->9135 records found --- 20200319 AM 11:30 ML Test OK + ADA Backup OK + New RO Site Ready + 轉最新客戶資料 ========================================================================================================================= 1.)建新Attribute spec_101:11種(尺寸x數量)珠光膜氣泡袋 spec_102:7種(尺寸x數量)牛皮紙氣泡袋 2.)建新Attribute Set b4_bag:加spec_101,spec_102 cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex /usr/bin/php bin/magento cache:flush sudo php -f /var/www/html/magento8pm/bin/magento indexer:reindex --- 20200315 上新item 2 x mailer ========================================================================================================================= 1.)改buck4u shipping ->STORES->Configuration->SALES->Shipping Methods->Flat Rate-> Enabled:Yes Type:Per Item Price:0.2 Handling Fee:3.3 Ship to Applicable Countries:Specific Countries Ship to Specific Countries:United States ->Free Shipping->Enabled:No ->Table Rates->Enabled:No 2.)設free_shipping 舊RO->1元及低價item->b4_free_shipping 舊RO->其他item->free_shipping 3.)設Cart Price Rules 3-1.)Marketing->Cart Price Rules->RO FREE SHIPPING Conditions->Apply the rule only if the following conditions are met (leave blank for all products). If ALL of these conditions are TRUE : If an item is FOUND in the cart with ALL of these conditions true: Free Shipping is Yes Actions-> Free Shipping:For matching items only Apply the rule only to cart items matching the following conditions (leave blank for all items). If ALL of these conditions are TRUE : 3-2.)Marketing->Cart Price Rules->B4 FREE SHIPPING $25 Conditions->Apply the rule only if the following conditions are met (leave blank for all products). If ALL of these conditions are TRUE : If total amount equals or greater than 25 for a subselection of items in cart matching ALL of these conditions: b4 Free Shipping is Yes Actions-> Free Shipping:For matching items only Apply the rule only to cart items matching the following conditions (leave blank for all items). If ALL of these conditions are TRUE : --- 20200314 改buck4u shipping + Cart Price Rules ========================================================================================================================= .)因為刷卡功能報錯,還原系統恢復功能 20200309 ADA 11:52:57 弄回去 0121版本, 前台可刷上但後台掛掉, 把後台重REINDEX, 後台好了, 前台只有 buck4u 可以, buck4all 和 mag2 都掛掉, 而且 buck4u 不能刷卡, 換來換去, 最後又弄回今天的版本 1.)還原mag2目錄改用magento8pm-20200121 rm -Rf magento8pm mv magento8pm-20200121 magento8pm ->Required parameter 'theme_dir' was not passed 添加新theme 6pm cd /var/www/html/magento8pm/app/design/frontend/Venustheme/ cp 8pm 6pm -r cd 6pm joe registration.php joe theme.xml cd /var/www/html/magento8pm/app/design/frontend/ chown -R www-data:www-data . chown www-data:www-data 7pm cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/web/ cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Themesettings/web/ cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Themesettings/web/ chown www-data:www-data css ->前台可刷卡但後台掛掉, 把後台重REINDEX->我reindex 後台仍上不了 cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex /usr/bin/php bin/magento cache:flush 2.)還原資料庫改用magento8pm-20200215-ok ->前後台都會直接跳到buck4all.com 先改conf為demo2,進後台後再改為b4u_home cd /etc/apache2/sites-available joe buck4u.conf -> joe buck4u-ssl.conf -> SetEnv MAGE_RUN_CODE "b4u_home" -> 原為 "demo2" service apache2 restart ->關閉wysiwyg editer STORES->Configuration->General->Content Management->WYSIWYG Options->Enable WYSIWYG Editor->Disabled Completely ->去掉產品頁Short Description,Share,加SKU STORES->Configuration->VES THEMESETTINGS->Product View Page->Other Elements ->去掉產品頁Paypal+Paypal credit icon STORES->Configuration->SALES->Payment Methods->PayPal Express Checkout->Configure->Basic Setting->Display on Product Details Page->No 3.)修改Store View的code,theme(Head,Header,Footer),Base URL,Default page b4u_home->b4u_home + 7pm(buck4u.com) + www.buck4u.com + buck4u.com pwc_ro->pwc_ro + 6pm(purewaterclub.com) + mag2.purewaterclub.com + purewaterclub.com 3-1.)修改Home Page b4u_home->Page:buck4u.com->Ves-Page:buck4u-home-page pwc_ro->Page:purewaterclub.com->Ves-Page:pwc-home-page 3-2.)修改Mega Menu 共用目錄頁->blank:menu-top(不存在,不會出現) /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml menu-top b4u_home->7pm:menu-top-b4u /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml menu-top-b4u pwc_ro->6pm:menu-top-pwc /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Megamenu/layout/default.xml menu-top-pwc 改goto old site -> http://last.pureaterclub.com/ 4.)重新建立圖片根位置連結 cd /var/www/html/magento8pm/pub/media/ mv catalog catalog-0 ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/ mv wysiwyg wysiwyg-0 ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/ mv /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images-0 mv /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images-0 mv /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/images-0 ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/ ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/ ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/ 5.)修改自建目錄頁連結 改pwc-dir-47->Design http://www.buck4all.com/index.php/ro/replacement.html -> ro/replacement.html 改pwc-dir-50->Design 改pwc-dir-65->Design 改pwc-dir-68->Design http://www.buck4all.com/index.php/ro/combo-set.html -> combo-set.html 6.)重新導入Old RO 客戶資料 ->手工刪除Old RO 黑客注冊垃圾帳號 DELETE FROM address_book WHERE entry_country_id='50' -> 1 record (CK Cook Islands) DELETE FROM address_book WHERE entry_country_id='17' -> 2 record (BH Bahrain) DELETE FROM address_book WHERE entry_country_id='88' -> 1 record (GU Guam) DELETE FROM address_book WHERE entry_country_id='232' -> 1 record (VI Virgin Islands (U.S.) UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 5 record DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 5 record ->http://www.purewaterclub.com/gen-customer-csv.php Checked rows: 9126, checked entities: 18252, invalid rows: 0, total errors: 0 ->手工刪除mag2 客戶資料無用帳號 ID=2066->lake757@yahoo.com->VI ID=6462->mm@mm.com ID=6515->mmm@mm.com ID=7536->ugamnut56@hotmail.com->GU Customers 9129 records found 7.)清Catalog + Attribute Set + Product Attributes 刪Catalog A total of 71(disable)+19(qq%)+(Arcadio Gym Short-33-Red) have been deleted. 362 records found + (ADA-TEST-Metal aerator faucet adapter SP-aerator-M->ADA-TEST) ->更新產品出錯Required parameter 'theme_dir' was not passed 刪除theme Zou,6pm,7pm 重新添加新theme 6pm,7pm 刪除表theme中的x-Venustheme - 8pm,Zou/demo 刪Attribute Set Bag,Bottom,Downloadable,Gear,ro-qq-003,Sprite Stasis Ball,Sprite Yoga Strap,Top The attribute set has been removed.(8 record) 增加Product Attributes free_shipping,b4_free_shipping 修改Attribute Set:default 刪Product Attributes 舊的8pm + ro-qq activity,Category Gear,Climate,Collar,eco_collection,erin_recommends,features_bags,format,gender,pattern,performance_fabric,size, sleeve,strap_bags,style_bags,style_bottom,style_general ro_qq_003_size You deleted the product attribute. 53 records found ---------------------- ADA 20200311 AM 10:00 Backup All ----------------------- 8.)改目錄頁footer Manage Elements->pwc-footer cd /var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layout/ mv default.xml default.xml-0 wget http://www.purewaterclub.com/default.xml 9.)install extension disable compare cd /var/www/html/magento8pm/app/code/ mkdir Bss/DisableCompare cd Bss/DisableCompare wget http://www.purewaterclub.com/aws-ext-20200215.zip -> unzip aws-ext-20200215.zip cd /var/www/html/magento8pm /usr/bin/php bin/magento module:enable --clear-static-content Bss_DisableCompare <--- 禁作,疑似可能造成刷卡功能失敗 ---> To make sure that the enabled modules are properly registered, run 'setup:upgrade'. Cache cleared successfully. Generated classes cleared successfully. Please run the 'setup:di:compile' command to generate classes. Generated static view files cleared successfully /usr/bin/php bin/magento setup:upgrade /usr/bin/php bin/magento setup:di:compile <-------------------------------------> --- 20200309-11 恢復刷卡功能->還原目錄magento8pm-20200121+資料庫magento8pm-20200215-ok + 重新補作所有修改 ========================================================================================================================= 改short description tilte為shipping cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Magento_Catalog/templates/product/view joe product_info_main.phtml -> FREE SHIPPING ON ORDERS OVER $35 Shipping and handling Free shipping on orders over $35.00 when you buy ellielantern's other eligible items, and use the cart to make your purchase. $0.25 shipping for each additional eligible item you buy from ellielantern, when you use the cart to make your purchase. Shipping discount will be applied when you add qualifying items from ellielantern to your cart All promotional offers from ellielantern cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/web/ cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Themesettings/web/ cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Themesettings/web/ chown www-data:www-data css The system has an issue when create css file Message: The path "design/frontend/Venustheme/7pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable The system has an issue when create css file Message: The path "design/frontend/Venustheme/7pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable The system has an issue when create css file Message: The path "design/frontend/Venustheme/6pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable tar -czf pwpic-20200223.tar.gz * -rw-r--r-- 1 root root 274210605 Feb 24 01:25 pwpic-20200223.tar.gz zip -r pwpic-20200223.zip ./ -rw-r--r-- 1 root root 285427566 Feb 24 01:29 pwpic-20200223.zip DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 2 record DELETE FROM address_book WHERE entry_lastname LIKE 'dhfh' -> 3 record DELETE FROM address_book WHERE entry_country_id='121' -> 1 record (LY Libyan) UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 5 record DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 5 record Checked rows: 9, checked entities: 18, invalid rows: 0, total errors: 0 Customers 9117 records found 去掉產品頁Paypal+Paypal credit icon STORES->Configuration->SALES->Payment Methods->PayPal Express Checkout->Configure->Basic Setting->Display on Product Details Page->No --- 20200224 打包下載所有圖片 + 建mag2.purewaterclub.com取代www.buck4all.com + 補上傳新增9客戶資料 ========================================================================================================================= 添加新theme 6pm cd /var/www/html/magento8pm/app/design/frontend/Venustheme/ cp 8pm 6pm -r cd 6pm joe registration.php joe theme.xml 直接改不同的default.xml可改變Ves header使用MegaMenu的名稱 blank的menu一定要用,被設為default(menu-top),無法在目錄頁針對不同Theme對應不同menu 1.)blank(關閉menu給pwc+b4共用目錄頁Theme) /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml menu-top 2.)b4u /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml menu-top-b4u 3.)pwc /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Megamenu/layout/default.xml menu-top-pwc --- 20200223 增加新Theme ========================================================================================================================= 1.)合併所有圖片pwpic + /var/www/html/magento8pm/pub/media/ cd /var/www/html/pwpic/catalog/ mkdir category cd category cp -r /var/www/html/magento8pm/pub/media/catalog/category/* ./ mkdir product cd product cp -r /var/www/html/magento8pm/pub/media/catalog/product/* ./ 重新安排圖片位置 mv /var/www/html/pwpic/items /var/www/html/pwpic/webimg/items mv /var/www/html/pwpic/catalog/images/* /var/www/html/pwpic/import/* 圖片根位置: /var/www/html/pwpic/ -> /catalog/category/ (系統目錄圖片位置) -> ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/ /catalog/product/ (系統產品圖片位置) -> ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/ /wysiwyg/ (自建目錄頁圖片位置url media)-> ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/ /themeimg/ (Theme使用logo-背景圖片位置)-> ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/ /import/ (後台import上傳產品csv圖片位置) /webimg/ (pwc產品說明頁img src圖片位置) 修改aws.wg-1.com 指向+對應 AWS /var/www/html/pwpic/webimg cd /etc/apache2/sites-available joe aws-wg-1.conf -> DocumentRoot /var/www/html/pwpic -> DocumentRoot /var/www/html/pwpic/webimg service apache2 restart 測試上傳產品csv圖片成功 sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,additional_attributes,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,related_skus,related_position,crosssell_skus,crosssell_position,upsell_skus,upsell_position,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,bundle_shipment_type,associated_skus ADA-TEST,,b4_bag,simple,"Default Category/PWC,Default Category/PWC/Parts & Tools,Default Category/PWC/Parts & Tools/Feeders,Default Category/PWC/Parts & Tools/Fittings",base,ADA-TEST,,,1,1,0,"Catalog, Search",0.1,,,,ada-test,,,,"/import/22-103.jpg",,"/import/22-08.jpg",,"/import/22-08.jpg",,"/import/22-08.jpg",,"2/3/20, 5:23 PM","2/18/20, 8:08 PM",,,Block after Info Column,,,,No,,,,,,,Use config,,"b4_free_shipping=Yes,featured=Yes,free_shipping=Yes,new=No",999,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,1,0,0,0,,,,,,,,,,,,,,,, 2.)改原系統位置名稱 + 搬離至pwpic-0 mv /var/www/html/magento8pm/pub/media/catalog /var/www/html/magento8pm/pub/media/catalog-0 mv /var/www/html/magento8pm/pub/media/wysiwyg /var/www/html/magento8pm/pub/media/wysiwyg-0 cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/ mv images/ images-0 cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/ mv images/ images-0 mv /var/www/html/magento8pm/pub/media/catalog-0 /var/www/html/pwpic-0/ mv /var/www/html/magento8pm/pub/media/wysiwyg-0 /var/www/html/pwpic-0/ 3.)建catalog,wysiwyg連結 ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/(產品圖片) ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/(系統使用圖片路徑 url media) ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/(Theme使用logo-背景圖片位置) ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/(Theme使用logo-背景圖片位置) --- 20200222-23 整理aws所有圖片 + 新位置連結 -> /var/www/html/pwpic/ ========================================================================================================================= 1.) shipping: 現在新RO站(包括將來的1元店)的shipping有3種 a.) 原本舊RO站的free-shipping->只要是同一order有買正常單價的item,就可以整單都free b.) 新增1元站(b4_free_shippint)->只要買了1元店站b4_free_shipping的item加起來滿$25(金額可隨時修改),就整單都free c.) 如果以上2個條件都沒有,就收$5(金額可隨時修改,也可以改成按zone,重量計算) 2.) ebay: 因為QT2進了很多包裝材料,所以請先從包裝材料開始上架ebay和1元站的銷售 a.) 請把ebay的cutiepetinc帳號改成 buck4u*com b.) 請先參考以下1元站我已經上架的poly bubble mailers(珠光膜氣泡信封), http://www.buck4all.com/index.php/poly-bubble-mailer.html 其中表上的Qty/Set是我用成本價小於等於US$0.3(人民幣2元)倒算出來的1元的數量,是按之前計劃好的(產品成本30%,locat運費30%,利潤30%,其他10%計算), 實際應該出的數量,要請你仔細估算成本運費後,再通知我要如何修正,另外你也可以不用賣1元的方式,直接上架ebay,請你自己決定,以下是ebay的熱門seller和ULINE的參考 https://www.uline.com/BL_1255/Uline-Bubble-Lined-Poly-Mailers https://www.ebay.com/itm/100-50-Poly-Mailer-Bubble-Mailers-Padded-Envelopes-6x9-8-5x11-9x12-5x7-3x5-4x6/272820340492 (這一家在wulnat,可以好好參考一下) https://www.ebay.com/itm/50-000-4x8-Poly-Bubble-Padded-Envelopes-Mailer/321898703486 https://www.ebay.com/itm/Wholesale-10Pcs-Poly-Bubble-Mailers-Padded-Envelopes-Shipping-Bags-Self-Seal/232374230866 https://www.ebay.com/itm/25-0-Glamour-Metallic-Pink-Poly-Bubble-Mailers-Envelopes-Bags-6x10-DVD-Wide-CD/292602069600?epid=5020360655 c.) 請先在試一下在ebay用cutiepetinc和purewaterclub*com帳號分別上架poly bubble mailers(珠光膜氣泡信封), 附件有name(101.c.txt) + 說明(101.c.html) + 產品主圖組 (101.c.jpg.zip) + 原始圖片(101-0.jpg.zip) + 標示文字圖片(101.jpg.zip) + photoshop工作檔案(101.c.psd)請SC教你如何操作 d.) 101.c->代表(101.01-101.11)的configute product (讓客人用來挑選不同尺寸規格的虛擬產品,將來1元站會大量使用), 客人挑選後下單的是(101.01x16~101.11x3)共11種產品組合中的一種 --- 20200221 交接 poly bubble mailer to ebay ========================================================================================================================= 修改Store View buck4u.com home page->b4u_home cd /etc/apache2/sites-available joe buck4u.conf -> joe buck4u-ssl.conf -> SetEnv MAGE_RUN_CODE "b4u_home" -> 原為 "demo2" service apache2 restart find . -name "101.c*" 目錄圖片的位置 /var/www/html/magento8pm/pub/media/catalog/category/100-GDP.png (20200222)改連結到/var/www/html/pwpic/catalog/category/100-GDP.png 產品圖片的位置 /var/www/html/magento8pm/pub/media/catalog/product/1/0/101.c-5.jpg (20200222)改連結到/var/www/html/pwpic/catalog/product/1/0/101.c-5.jpg /1/0/->取圖片名的前2字母 /cache/->分5子目錄->image,small_image,swatch_image,swatch_thumb,thumbnail->其下再分不同尺寸圖片目錄,為cache的圖片最後位置 導入產品圖片的位置 /var/www/html/pwpic/ /catalog/images/->產品主圖 /items/->產品說明插圖片 /wysiwyg/pwc/->子目錄連結用圖片->ln -s /var/www/html/pwpic/wysiwyg/pwc/ /var/www/html/magento8pm/pub/media/wysiwyg/(系統使用圖片路徑) (20200222)刪除pwc連結,改直接連結上一層到/var/www/html/pwpic/wysiwyg /pwpic/->link to /var/www/html/pwpic/(為了導入產品時填Images File Directory用?) (20200222)刪除pwpic連結 成功->(20200222)改連結到/var/www/html/pwpic/ 放棄->改產品圖片的位置->b4pic: cd /var/www/html/b4pic/ mkdir catalog/product cd catalog/product cp -r /var/www/html/magento8pm/pub/media/catalog/product/* ./ apt-get install zip apt-get install unzip zip -r b4pic.zip ./ http://aws.wg-1.com/ -> 指向 /var/www/html/pwpic/ cd /var/www/html/pwpic/ mv /var/www/html/b4pic/catalog/product/b4pic.zip ./ zip -r pwpic.zip ./(x->無限遁環立即占滿所有空間) ---------------------------- --- 20200220 修改 buck4u.com home page + 整理圖片位置 + 下載備份圖片 ========================================================================================================================= 1.)RO free_shipping->如果單內有一件free_shipping item->整單free shipping 2.)B4 free_shipping $25+ ->如果單內所有b4_free_shipping合計金額大於等於$25->整單free shipping 3.)Configued product在Cart Price Rules判斷中會以Configure product的attribute為主,而不是以各別的simple product 改PWC->dollar sale->b4_free_shipping $1->SP-CRT,SP-6044Q,SP-Y,SP-7044Q,SP-7042Q,SP-6044Q,SP-0404Q,SP-4041Q,SP-1044,SP-C clip,SP-aerator-M,SP-aerator-p $1+->SP-132Q,SP-Q34A,SP-FV --- 20200218-20 buck4u shipping ========================================================================================================================= 刪Catalog A total of 72(disable)+19(qq%) have been deleted. 362 records found + ADA-TEST-Metal aerator faucet adapter SP-aerator-M 刪Attribute Set Bag,Bottom,Downloadable,Gear,ro-qq-003,Sprite Stasis Ball,Sprite Yoga Strap,Top The attribute set has been removed.(8 record) 修改Attribute Set:default 增加Product Attributes free_shipping,b4_free_shipping 刪Product Attributes 舊的8pm() + ro-qq activity,Category Gear,Climate,Collar,eco_collection,erin_recommends,features_bags,format,gender,pattern,performance_fabric,size, sleeve,strap_bags,style_bags,style_bottom,style_general ro_qq_003_size You deleted the product attribute. 53 records found 140e8587c46ea4afc679cb70bae56341:70:0->aa223344-osc-v.1 $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0->aa223344-osc-v.2 關閉wysiwyg editer STORES->Configuration->General->Content Management->WYSIWYG Options->Enable WYSIWYG Editor->Disabled Completely --- 20200216 清Catalog + Attribute Set + Product Attributes + 關閉wysiwyg editer ========================================================================================================================= extension disable compare Access Keys Public Key: 0c2e51e0297016e62e864f5effe625c7 Private Key: 38410b35ec042696d687ee7c90436d88 Click install extension Once you redirected to Keys page copy private and public access key Login to your store admin panel Go to System > Configurations Add your public and private key Save & refresh your page Web Setup Wizard->404 registration.php \Magento\Framework\Component\ComponentRegistrar::register( \Magento\Framework\Component\ComponentRegistrar::MODULE, 'Bss_DisableCompare', __DIR__ aws: cd /var/www/html/magento8pm/app/code/ mkdir Bss/DisableCompare cd Bss/DisableCompare wget http://www.purewaterclub.com/aws-ext-20200215.zip -> unzip aws-ext-20200215.zip cd /var/www/html/magento8pm /usr/bin/php bin/magento module:status --> List of enabled modules: Magento_Store Magento_AdvancedPricingImportExport Magento_Directory Magento_Theme Magento_Backend Magento_Backup Magento_Eav Magento_Customer Magento_BundleImportExport Magento_CacheInvalidate Magento_AdminNotification Magento_Indexer Magento_CatalogImportExport Magento_Cms Magento_Rule Magento_Catalog Magento_Search Magento_CatalogUrlRewrite Magento_Widget Magento_Quote Magento_CheckoutAgreements Magento_SalesSequence Magento_CmsUrlRewrite Magento_Config Magento_ConfigurableImportExport Magento_Msrp Magento_Contact Magento_Cookie Magento_Cron Magento_CurrencySymbol Magento_Bundle Magento_CustomerImportExport Magento_Deploy Magento_Developer Magento_Dhl Magento_Authorization Magento_Downloadable Magento_ImportExport Magento_Payment Magento_Email Magento_User Magento_Fedex Magento_Sales Magento_CatalogInventory Magento_GoogleAnalytics Magento_Ui Magento_GroupedImportExport Magento_GroupedProduct Magento_DownloadableImportExport Magento_Checkout Magento_Security Magento_LayeredNavigation Magento_Marketplace Magento_MediaStorage Magento_CatalogRule Magento_Multishipping Magento_ConfigurableProduct Magento_Newsletter Magento_OfflinePayments Magento_SalesRule Magento_PageCache Magento_Captcha Magento_Vault Magento_Persistent Magento_ProductAlert Magento_ProductVideo Magento_Authorizenet Magento_Reports Magento_RequireJs Magento_Review Magento_Rss Magento_CatalogRuleConfigurable Magento_Paypal Magento_SalesInventory Magento_OfflineShipping Magento_GoogleAdwords Magento_SampleData Magento_CatalogSearch Magento_Integration Magento_SendFriend Magento_Shipping Magento_Sitemap Magento_NewRelicReporting Magento_Swagger Magento_Swatches Magento_SwatchesLayeredNavigation Magento_Tax Magento_TaxImportExport Magento_GiftMessage Magento_Translation Magento_GoogleOptimizer Magento_Ups Magento_UrlRewrite Magento_EncryptionKey Magento_Usps Magento_Variable Magento_Braintree Magento_Version Magento_Webapi Magento_WebapiSecurity Magento_Weee Magento_CatalogWidget Magento_Wishlist Ves_All Ves_BaseWidget Ves_Blog Ves_Brand Ves_Megamenu Ves_PageBuilder Ves_Productlist Ves_Setup Ves_Testimonial Ves_Themesettings List of disabled modules: Bss_DisableCompare /usr/bin/php bin/magento module:enable --clear-static-content Bss_DisableCompare /usr/bin/php bin/magento setup:upgrade /usr/bin/php bin/magento setup:di:compile /usr/bin/php bin/magento setup:upgrade->出現error [Exception] Notice: Use of undefined constant MCRYPT_RIJNDAEL_256 - assumed 'MCRYPT_RIJ NDAEL_256' in /var/www/html/magento8pm/vendor/magento/framework/Encryption/ Encryptor.php on line 454 x->裝mcrypt->沒用(而且mcrypt版本錯誤導致舊RO-account login失敗) sudo apt-get install mcrypt php7.0-mcrypt sudo service apache2 restart --------------- 重新安裝mcrypt新版本+改用舊SQL-magento8pm-20200210才解決舊RO-account login成功 sudo apt-get install mcrypt php7.1-mcrypt sudo service apache2 restart --------------- 加直接改Encryptor.php->return null;->不會出現報錯 joe /var/www/html/magento8pm/vendor/magento/framework/Encryption/Encryptor.php protected function getCrypt($key = null, $cipherVersion = null, $initVector = true) { return null; /* return new Crypt($key, $cipher, $mode, $initVector); */ } ----------------- 後台設disable compare STORES->Configuration->BSS COMMERCE->Disable Compare Configuration->YES cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex ----------------- 禁用Ves_Brand /usr/bin/php bin/magento module:disable --clear-static-content Ves_Brand The following modules have been disabled: - Ves_Brand Cache cleared successfully. Generated classes cleared successfully. Please run the 'setup:di:compile' command to generate classes. Generated static view files cleared successfully. ----------------- 496ccbf39792a0aa94cbec4840bee1c526c1c53cbb18445df8692135624fc9cf:ABN45WVliJG7OXcRboPpHhH01usqfRdd:1 df7cde40bc6922f8a885a21ebe8fd4b0:70:0->??+alberto.jany@woodgroup.com 140e8587c46ea4afc679cb70bae56341:70:0->aa223344-osc-v.1 $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0->aa223344-osc-v.2 08ed410c41d46dff63fc73c41aa8df1c3025e0397ece2ae59ebcaaed191c0ae3:kJ17CNzHgKZsKbbmWakPvzEFzFCaWCzw:1->?? --- 20200215 install extension disable compare + 禁用Ves_Brand ========================================================================================================================= 改8pm media url->pwpic: cd /var/www/html/pwpic/ mkdir wysiwyg/pwc cd wysiwyg/pwc cp /var/www/html/magento8pm/pub/media/wysiwyg/pwc/*.jpg ./ ln -s /var/www/html/pwpic/wysiwyg/pwc/ /var/www/html/magento8pm/pub/media/wysiwyg/ pwpic圖片目錄: aws: cd /var/www/html/pwpic/ ls -l drwxr-xr-x 3 root root 4096 Dec 4 13:00 catalog -> /images/ -> 放RO站主圖 drwxr-xr-x 5 root root 4096 Dec 4 13:00 items -> /Driver /PW-Pic /Pic -> 放RO站產品說明連結圖 lrwxrwxrwx 1 root root 19 Jan 30 10:12 pwpic -> /var/www/html/pwpic -> import product csv,填 Images File Directory -> pwpic link指向/var/www/html/pwpic drwxr-xr-x 4 root root 4096 Dec 13 04:23 simplehtmldom -> 分析html結構的PHP Lib drwxr-xr-x 3 root root 4096 Feb 14 04:37 wysiwyg -> /wysiwyg/pwc/ -> 8pm media url -> 子目錄圖片 aws: cd /var/www/html/pwpic/catalog/images/ wget http://www.purewaterclub.com/aws-20200127.zip -> unzip aws-20200127.zip attribute_set_code configurable_variations sku=RO-QQ-003-2cmx100M-Black,ro_qq_003_size=2cmx100M,color=Black| sku=RO-QQ-003-2cmx100M-Blue,ro_qq_003_size=2cmx100M,color=Blue| sku=RO-QQ-003-2cmx100M-Brown,ro_qq_003_size=2cmx100M,color=Brown| sku=RO-QQ-003-2.5cmx100M-Black,ro_qq_003_size=2.5cmx100M,color=Black| sku=RO-QQ-003-2.5cmx100M-Blue,ro_qq_003_size=2.5cmx100M,color=Blue| sku=RO-QQ-003-2.5cmx100M-Brown,ro_qq_003_size=2.5cmx100M,color=Brown| sku=RO-QQ-003-3cmx200M-Black,ro_qq_003_size=3cmx200M,color=Black| sku=RO-QQ-003-3cmx200M-Blue,ro_qq_003_size=3cmx200M,color=Blue| sku=RO-QQ-003-3cmx200M-Brown,ro_qq_003_size=3cmx200M,color=Brown |sku=RO-QQ-003-Brown,ro_qq_003_size=3cmx2000M,color=Brown 新增attribute要加manage tile才會出現在configure product的Select Attributes BUG->新增attribute-option-text swatch(dropdown只能改一次,就改不回去)-要重新copy-paste-否則default空白不會出現 VENUSTHEME->General,Header點進去空白已不可考,除非選pws-xxx page-OK --- 20200214-15 configure product ========================================================================================================================= ADMIN dv4mlmag ; $ML5477ml dv4ml@dacomputing.com 改目錄背景圖:bg_brc.jpg cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/ mv bg_brc.jpg bg_brc-8pm.jpg wget http://www.purewaterclub.com/bg_brc.jpg Everything's $1. What will you find? Sign In or Create an Account Track Orders 0 Home Shop By Business Shop By Business Florists & Gift Shops Weddings, Catering & Events Restaurants, Bars & Hospitality Care Facilities Religious & Nonprofit Organizations Cleaning Services --- 20200212 mag2 開帳號給ML + 改目錄背景圖 ========================================================================================================================= 手工刪除黑客注冊垃圾帳號 DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 29 record DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address LIKE '%?%' -> 1 record DELETE FROM address_book WHERE entry_country_id='147' -> 2 record (NA Navibia) DELETE FROM address_book WHERE entry_country_id='17' -> 4 record (BH Bahrain) DELETE FROM address_book WHERE entry_country_id='1' -> 141 record (AF Afghanistan) DELETE FROM address_book WHERE entry_country_id='14' -> 1 record (AT Austria) DELETE FROM address_book WHERE entry_country_id='193' -> 3 record (ZA South Africa) DELETE FROM address_book WHERE entry_country_id='229' -> 2 record (VE Venezuela) DELETE FROM address_book WHERE entry_country_id='220' -> 3 record (UA Ukiain) DELETE FROM address_book WHERE entry_country_id='184' -> 3 record (SA Saudi Arabia) DELETE FROM address_book WHERE entry_country_id='166' -> 1 record (PY Paraguay) DELETE FROM address_book WHERE entry_country_id='168' -> 4 record (PH Philippines) DELETE FROM address_book WHERE entry_country_id='167' -> 7 record (PE Peru) DELETE FROM address_book WHERE entry_country_id='44' -> 1 record (CN China) DELETE FROM address_book WHERE entry_country_id='21' -> 1 record (BE Belgium) DELETE FROM address_book WHERE entry_country_id='24' -> 1 record (BM Bermuda) DELETE FROM address_book WHERE entry_country_id='32' -> 1 record (BN Brunei Darussalam) DELETE FROM address_book WHERE entry_country_id='83' -> 1 record (GI Gibraltar) DELETE FROM address_book WHERE entry_country_id='84' -> 7 record (GR Greece) DELETE FROM address_book WHERE entry_country_id='96' -> 3 record (HK Hong Kong) DELETE FROM address_book WHERE entry_country_id='53' -> 3 record (HR Croatia) DELETE FROM address_book WHERE entry_country_id='97' -> 5 record (HU Hungary) DELETE FROM address_book WHERE entry_country_id='100' -> 2 record (ID Indonesia) DELETE FROM address_book WHERE entry_country_id='103' -> 3 record (IE Ireland) DELETE FROM address_book WHERE entry_country_id='104' -> 9 record (IL Israel) DELETE FROM address_book WHERE entry_country_id='99' -> 10 record (IN India) DELETE FROM address_book WHERE entry_country_id='101' -> 2 record (IR Iran) DELETE FROM address_book WHERE entry_country_id='105' -> 5 record (IT Italy) DELETE FROM address_book WHERE entry_country_id='113' -> 1 record (KR Korea) DELETE FROM address_book WHERE entry_country_id='114' -> 1 record (KW kuwait) DELETE FROM address_book WHERE entry_country_id='118' -> 1 record (LB Lebanon) DELETE FROM address_book WHERE entry_country_id='126' -> 1 record (MK Macedonia) DELETE FROM address_book WHERE entry_country_id='132' -> 1 record (MT Malta) DELETE FROM address_book WHERE entry_country_id='136' -> 1 record (MU Mauritius) DELETE FROM address_book WHERE entry_country_id='130' -> 1 record (MV Maldives) DELETE FROM address_book WHERE entry_country_id='129' -> 6 record (MY Malaysia) DELETE FROM address_book WHERE entry_country_id='150' -> 1 record (NL Netherlands) DELETE FROM address_book WHERE entry_country_id='55' -> 2 record (CY Cyprus) DELETE FROM address_book WHERE entry_country_id='60' -> 1 record (DO Dominica) DELETE FROM address_book WHERE entry_country_id='195' -> 2 record (ES Spain) DELETE FROM address_book WHERE entry_country_id='203' -> 4 record (SE Sweden) DELETE FROM address_book WHERE entry_country_id='188' -> 9 record (SG Singapore) DELETE FROM address_book WHERE entry_country_id='209' -> 2 record (TH Thailand) DELETE FROM address_book WHERE entry_country_id='215' -> 2 record (TR Turkey) DELETE FROM address_book WHERE customers_id=9100 -> 1 record ->亂填 Last->手工刪除表:customers->無地址address_book UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 129 record DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 129 record _address_fax -> 1-2 -> {fax} -> 放舊RO站"付款" - "未付款"次數 Checked rows: 9108, checked entities: 18216, invalid rows: 0, total errors: 0 COPY SQL magento8pm -> magento8pm20200210: ERROR ALTER TABLE `catalog_eav_attribute` ADD CONSTRAINT `CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE; cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex Design Config Grid index has been rebuilt successfully in 00:00:01 Customer Grid index has been rebuilt successfully in 00:00:09 Category Products index has been rebuilt successfully in 00:00:02 Product Categories index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:01 Product EAV index has been rebuilt successfully in 00:00:00 Stock index has been rebuilt successfully in 00:00:01 Catalog Rule Product index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:11 ->9110 records found last->customers_id9958(Joshua-Peterson)+address_book_id=12859 --- 20200211 old-RO customer 資料 -> mag2 ========================================================================================================================= 1.）請你先檢查一下新的RO站的所有細節, 目前只剩老客人的資料還沒有轉過去, 其他都轉好了, 看看還有有什麼問題或建議, 尤其是手機請多試一下 http://www.buck4all.com/ 2.) 附件的excel表有QT2的裝箱明細和產品編號表, QT2到貨後,因為這一批貨有1千多款,而且都是新貨又非常複雜,所以請一定要按表上的明細拆箱,一一對照後把貨先歸好,不然萬一混在一起後,將來很難分辨 3.) QT2的貨目前發現有以下4個失誤,請你幫忙修改 3-a.)第116箱的地毯膠帶(209.01-209.10)漏了秤單品重量,請幫忙秤 3-b.)第134箱的10,000個(100小包)10絲白邊PE自封袋3cm*4cm編號錯記為107.02,請修改為正確107.20 3-c.)第134箱的500個(5小包) 10絲白邊PE自封袋13cm*18cm編號錯記為107.10,請修改為正確107.19 3-d.)第129箱的5個(1小袋) RJ45接頭-母轉2母編號錯記為322.06,請合併到同一箱的另一小袋相同款式的322.05 4.) QT2和將來一元站的貨號規則如下: 1.) BSKU - Basic SKU: 單品最小實際庫存, 依不同尺寸, 顏色, 款式編不同貨號 編碼規則為 aaa.bb -> aaa為分類編號, bb為分類下的產品號 Ex1: 101為珠光膜氣泡信封, 101.01為11cm*11cm+4cm, 101.09為20cm*25cm+4cm Ex2: 212為美紋紙手撕膠帶, 202.01為6mm*12m-黑色, 212.30為12mm*12m-淺藍色 1-a.) 數量直接可數的->例如: 1個, 1條, 1捲, 1片 1-b.) 需要裁剪長度的->例如: 大捲的魔術貼1米, 大捲熱縮管1米, 大捲反光織帶1米 1-c.) 低單價需要配對使用的合併編號->例如: , 迷你鰐魚夾測試線5色套, 汽車電源端子公母1對, 小鱷魚夾正負1對, 雙絞線傳輸器左右1對, POE分離器左右1對, 香蕉頭插座黑紅1對 1-d.) 高單價需要配對使用的分開編號->例如: 大鱷魚夾正極黑色, 大鱷魚夾負極紅色, 香蕉頭純銅鍍金直針型黑色, 香蕉頭純銅鍍金直針型紅色 1-e.) 超低單價不容易數的預包裝好的整包編號->例如: 金屬紮絲400pcs, 紙紮絲100pcs, 蝴蝶結紮絲20pcs, 尼龍紮帶*100pcs, 背膠圓點魔術貼15mm*30對 1-f.) 客戶不可挑選顏色的編相同貨號->例如: 彩色帶透明蓋彈簧U型剪刀, 彩色長柄洗杯刷, 彩色轉換插座, 彩色RJ45直通接頭, 彩色殼鍍金頭音頻線 2.) SKU - Stock Keeping Unit: 實際銷售單位, 由同一種BSKU數量一個以上或數個BSKU組成 編碼規則為 BSKU + qqq -> aaa.bb + qqq-> aaa.bb 為BSKU+ qqq為數量或附加碼 2-a.) 數量為100個的倍數直接加h,200個加h2->例如: 100個自粘OPP袋為105.01h, 200個水晶頭為321.02h2 2-b.) 數量為不是100個整數先加(x) 再加數量->例如: 10個珠光膜氣泡信封為101.07x10, 25個白快遞袋為104.01x25 2-c.) 不同bsku組成挑主要產品的bsku先加附加碼(s) 再加不重覆流水號(1~99)->例如: 100個水晶頭配100個護套321.01s1 2-d.) 數量為1000個的倍數直接加k,2000個加k2->例如: 目前沒有 --- 20200210 QT2 packing detail + BSKU + SKU 規則 ========================================================================================================================= 增加新Store View 1.)STORES->All Stores->Create Store View->pwc:pwc_buck4aqua 2.)STORES->Configuration->選Store View(pwc:pwc_buck4aqua)->GENERAL:Web->Base URLs + Secure Base URL + CMS Home Page 3.)DNS A buck4aqua.buck4all.com -> 18.218.158.219 4.)cd /etc/apache2/sites-available cp buck4u.conf pwc_buck4aqua.conf -> joe pwc_buck4aqua.conf -> ServerName buck4aqua.buck4all.com SetEnv MAGE_RUN_CODE "pwc_buck4aqua" SetEnv MAGE_RUN_TYPE "store" cd /etc/apache2/sites-available ln -s /etc/apache2/sites-available/pwc_buck4aqua.conf /etc/apache2/sites-enabled/pwc_buck4aqua.conf service apache2 restart (20200209)修改 joe buck4all.conf SetEnv MAGE_RUN_CODE "demo3" -> SetEnv MAGE_RUN_CODE "pwc_ro" --- 20200209 增加 Store View + New Arrival + Feature Product + Our Service ========================================================================================================================= Manage Elements->pwc-footer /var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layout/default.xml wget http://www.purewaterclub.com/default.xml Shipping and Returns pwc-shipping-returns Privacy Notice pwc-privacy-notice RO FAQ pwc-faq My Account customer/account Membrane Rejection Chart membrane-rejection-chart Contact Us pwc-contact-us /var/www/html/magento8pm/vendor/magento/module-newsletter/view/frontend/layout/default.xml /var/www/html/magento8pm/vendor/magento/module-cms/view/frontend/layout/default.xml /var/www/html/magento8pm/vendor/magento/module-search/view/frontend/layout/default.xml /var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/layout/default.xml /var/www/html/magento8pm/vendor/magento/module-sales/view/frontend/layout/default.xml /var/www/html/magento8pm/vendor/magento/module-catalog-search/view/frontend/layout/default.xml Contact表: /var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/layout/contact_index_index.xml /var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/templates/form.phtml --- 20200206-08 Footer + Link + Contact ========================================================================================================================= 設定全站Theme: CONTENT->Design Configuration->選Store Views(pwc English)->Edit->Default Theme->Applied Theme->Magento Blank(x-全站用Blank) (20200208 改用Venustheme - 8pm,因為contact,my account,cart的form 字白色看不到 label:color #000) CONTENT->Design Configuration->選Store Views(pwc English)->Edit->Default Theme->Applied Theme->Venustheme - 8pm(全站用8pm) ->設定首頁Logo: Other Settings->Header->Logo Image Logo Image Width->495 ->設定首頁Footer: Other Settings->Footer->Copyright Copyright (C) 2020 all rights reserved. 加另外改manage element->PWC Footer->Design Elemment 設定首頁Page: 1.)STORES->Configuration->Store Views:選(pwc English)->Web->Default Pages->CMS Home Page->purewaterclub.com 2.)CONTENS->Pages->purewaterclub.com->Content->Widget Type->Ves Page Builder : Generate a page builder profile->Page Id->purewaterclub.com ->改首頁Theme: Custom Design Update->New Theme->Venustheme - 8pm(x-只有首頁用8pm) (20200208 不用改了) 首頁Page加子目錄圖片: VENUSTHEME->Manage Page Profile->挑選page(purewaterclub.com)->Desgin Block->加(pwc-dir-47) 目錄頁設定: PRODUCTS->Categories->Default Category->Design->Theme->Magento Blank(blank手機版可維持2排產品) PRODUCTS->Catagories->挑選目錄(Filtration System)->Content->Add CMS Block->Block(dir_50) CONTENS->Blocks->挑選Block(dir_50)->Widget Type->Ves Page Builder: Generate Element Profile->Element Id->(pwc-dir-50) VENUSTHEME->Manage Element->挑選element(pwc-dir-50)->Design->widget->6 x (single image + heading tag) 子目錄圖片+連結: VENUSTHEME->Manage Element->挑選element(pwc-dir-47)->Design widget->加4 x (single image + heading tag) 1.)Filtration System Image File->wysiwyg/pwc/dir_50.jpg Link->http://www.buck4all.com/index.php/ro/filtration-system.html 2.)Replacement wysiwyg/pwc/dir_65.jpg http://www.buck4all.com/index.php/ro/replacement.html 3.)Parts & Tools wysiwyg/pwc/dir_68.jpg http://www.buck4all.com/index.php/ro/parts-tool.html 4.)Buck4RO wysiwyg/pwc/b4ro.jpg http://www.buck4u.com 1.)Revese Osmosis wysiwyg/pwc/dir_51.jpg http://www.buck4all.com/index.php/ro/filtration-system/revese-osmosis.html 2.)Portable RO wysiwyg/pwc/dir_55.jpg http://www.buck4all.com/index.php/ro/filtration-system/portable-ro.html 3.)Whole House wysiwyg/pwc/dir_59.jpg http://www.buck4all.com/index.php/ro/filtration-system/whole-house.html 4.)Drinking Water wysiwyg/pwc/dir_62.jpg http://www.buck4all.com/index.php/ro/filtration-system/drinking-water.html 5.)Aquarium wysiwyg/pwc/dir_63.jpg http://www.buck4all.com/index.php/ro/filtration-system/aquarium.html 6.)Ultra Violet wysiwyg/pwc/dir_64.jpg http://www.buck4all.com/index.php/ro/filtration-system/ultra-violet.html 1.)Housing wysiwyg/pwc/dir_66.jpg http://www.buck4all.com/index.php/ro/parts-tools/housing.html 2.)Feeders wysiwyg/pwc/dir_67.jpg http://www.buck4all.com/index.php/ro/parts-tools/feeders.html 3.)Fittings wysiwyg/pwc/dir_79.jpg http://www.buck4all.com/index.php/ro/parts-tools/fittings.html 4.)Valves wysiwyg/pwc/dir_80.jpg http://www.buck4all.com/index.php/ro/parts-tools/valves.html 5.)Faucet-Tank-Tubes wysiwyg/pwc/dir_81.jpg http://www.buck4all.com/index.php/ro/parts-tools/faucet-tank-tubes.html 6.)Utilityes wysiwyg/pwc/dir_82jpg http://www.buck4all.com/index.php/ro/parts-tools/utilityes.html cd /var/www/html/magento8pm/pub/media/wysiwyg/pwc/ wget http://www.purewaterclub.com/aws-20200209.zip -> unzip aws-20200209.zip 1.)Combo Set wysiwyg/pwc/dir_70.jpg http://www.buck4all.com/index.php/ro/replacement/combo-set.html 2.)Filters wysiwyg/pwc/dir_71.jpg http://www.buck4all.com/index.php/ro/replacement/filters.html 3.)Menbranes wysiwyg/pwc/dir_72.jpg http://www.buck4all.com/index.php/ro/replacement/menbranes.html 4.)Resin wysiwyg/pwc/dir_73.jpg http://www.buck4all.com/index.php/ro/replacement/resin.html 5.)Ultra Violet wysiwyg/pwc/dir_74.jpg http://www.buck4all.com/index.php/ro/replacement/ultra-violet.html 目錄頁子目錄圖片:dir 47,50,65,68 Catagory->block(dir_50)->element(pwc-dir-50)->widget(6 x pic + 6 x text) 調整圖片為(2x3,3x2,6x1行) Widget:image collect->phone尺寸圖片位置為4+2
Bug->第3-Text如果打Fittings會一直亂碼->改Connecters Fittings Ves Generate->Page Builder Profile->Ves Element->Widget CONTENS->Pages->Ves Generate Page Builder Profile->Ves Element->Widget Ves Generate Page Builder Profile->Ves Element->Widget --- 20200203,05 首頁+目錄頁 ========================================================================================================================= 設定首頁+目錄頁Theme-> CONTENT->Design Configuration->Edit->Default Theme->Applied Theme-> Magento Blank: 首頁第一行自動出現Ves Brand(可全部disable後消失) + Ves Menu在header下方整行 + 手機Ves Menu不會縮小左上角 + 產品列表自動適應成2~4行 Magento Luma: 首頁第一行自動出現Ves Brand(可全部disable後消失) + Ves Menu在header下方整行 + 手機Ves Menu不會縮小左上角 + 中間所有內容消失 Venustheme - 8pm/7pm: 首頁Ves Menu在header 正上方logo右側 + 產品列表PC 3行-手機 1行 關閉首頁(Blank/Luma)的Ves Brand: 1.)將brand中全部都disable or 2.)STORES->Configuration->VENUS - VENUSTHEME.COM->Brand->General Settings->Disabled 設定首頁的Page->STORES->Configuration->Store View:pwc English->GENERAL->Default Pages->CMS Home Page->Home Page(in CONTENTS->Pages) Page Title->Home Page Content->Content Heading->Home Page-dv Design->Layout Update XML block-slideshow-bannertop block-banner-center new-products-carousel banner-mass-bottom product-tabs banner-mass-bottom2 --- 20200202 product-list ========================================================================================================================= Base URL for User Media Files:/var/www/html/magento8pm/pub/media/ 8pm Slider dv
Look Book

Autums
Collection
For

Shop Now
Product2->New Arrival2 Product1->Product Product->Product Product3->Feature Items3 8pm image collection->Collection 2017 --- 20200201 slider ========================================================================================================================= www.buck4all.com->pwc Stores->All Stores->pwc English Stores->Configuration->Store View:>pwc English->Web->Default Pages->CMS Home Page->purewaterclub.com VenusTheme->Page Builder->Block:purewaterclub.com->PAGE INFORMATION->Desgin Block->Elemment:8pm categories->Design Elemment->Widget:Show Categories information and subcategories 目錄頁加子目錄跑馬燈icon: Products->Catagories->目錄->Content->Add CMS Block->dv-block 目錄頁左半列出子目錄 Display Settings->Anchor->No 目錄頁不要出現目錄圖 Configuration->VES THEMESETTINGS->General Settings->Category Image->No 目錄頁下方出現翻頁功能 Configuration->VES THEMESETTINGS->General Settings->Bottom Toolbar->Yes 產品對應目錄list表:catagory-list-20200129-1.csv 產生產品目錄csv->http://www.purewaterclub.com/gen-product-catagory-csv.php ->product-catagory-20200131-4.csv ->Import->Behavior:Add/Update 轉檔URL不可以有+ -> -pl- strtolower(str_replace("+","%20",$tmpurl)) General system exception happened Additional data: URL key for specified store already exists. Checked rows: 362, checked entities: 362, invalid rows: 0, total errors: 0 -> Import successfully done 同步產品說明+名稱->http://aws.wg-1.com/gen-product-desc-name.php-> cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex /usr/bin/php bin/magento cache:flush //--- bug picture (圖片怪,不能用,需要重新抓圖上傳?)--------------- 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 37, 39 FS-5BM150 /catalog/images/FS-5BM150.JPG FS-4M100 /catalog/images/4PM100.jpg 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 25 PT-TANK02UG /catalog/images/tank.jpg 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 69, 72, 75, 98 POQ-5BB-50 /catalog/images/POQ-5BB.JPG POQ-5BB-150 /catalog/images/POQ-5BB.JPG SP-Y /catalog/images/SP-Y.JPG UG-50G No Pic1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 19, 35, 89, 91, 93 General system exception happened Additional data: URL key for specified store already exists. RQ-5-100+4 UG-100-200 SO-002 FT-M200 RQ5-5T-50 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 260, 281, 297, 351, 353, 355 -----------------// 手工添加主圖表:products->products_image 576>>>UG-50G->no pic -> UG-50G.jpg 629>>>UG-100-200->no pic -> UG-100-200.jpg 606>>>RQ-5-100+4->no pic -> RQ-5-100-pl-4.jpg 699>>>SO-002->no pic -> SO-002.jpg 手工上傳 jpg -> aws (DV已上傳-20200131) cd /var/www/html/pwpic/catalog/images/ 576>>>UG-50G->no pic -> wget http://www.purewaterclub.com/UG-50G.jpg 629>>>UG-100-200->no pic -> wget http://www.purewaterclub.com/UG-100-200.jpg 606>>>RQ-5-100+4->no pic -> wget http://www.purewaterclub.com/RQ-5-100-pl-4.jpg 699>>>SO-002->no pic -> wget http://www.purewaterclub.com/SO-002.jpg 701>>>FT-M200->no pic -> wget http://www.purewaterclub.com/FT-M200.jpg 704>>>RQ5-5T-50->no pic -> wget http://www.purewaterclub.com/RQ5-5T-50.jpg wget http://www.purewaterclub.com/4PM100.jpg wget http://www.purewaterclub.com/tank.jpg wget http://www.purewaterclub.com/POQ-5BB.JPG wget http://www.purewaterclub.com/SP-Y.JPG osc 舊RO站後台:(一定要用IE) https://www.purewaterclub.com/catalog/admin/index.php -> admin + admin1234! 更新產品基本資料必要欄位 sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,additional_attributes,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,related_skus,crosssell_skus,upsell_skus,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,configurable_variations,configurable_variation_labels,associated_skus PT-12-1,,,,,,PT-12-1,,,,,,,1.1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,304,0,1,0,0,1,1,0,0,1,1,,1,0,1,1,0,1,0,0,1,,,,,,,,,,,,,, --- 20200130-0201 目錄頁 + import product-catagory ========================================================================================================================= 目錄名稱表:catalog_category_entity_varchar-> attribute_id=42 entity_id=50 value=Filtration System 目錄結構表:catalog_category_entity-> entity_id=50 path=1/2/47/50 level=3 children_count=14 產品查目錄表:catalog_category_product_index-> 目錄查產品表:catalog_category_product->category_id + product_id + position(default 1) 手工修改表:products-> products_id=616 (PT-Qfaucet)->products_status=0 (與617重覆) products_id=592 (PT-3W2)->products_status=0 (與594重覆) 目錄List $catidx=array(0,0,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72,73,74,75,76,77,79,80,81,82,84); 目錄名稱不可以有, / $d[50]="Filtration System"; $d[51]="Filtration System/Revese Osmosis"; $d[52]="Filtration System/Revese Osmosis/Standard Flow 100 GPD"; $d[53]="Filtration System/Revese Osmosis/High Flow 150+ GPD"; $d[54]="Filtration System/Revese Osmosis/Low Flow 50 GPD"; $d[55]="Filtration System/Portable RO"; $d[56]="Filtration System/Portable RO/Standard Flow 100 GPD"; $d[57]="Filtration System/Portable RO/High Flow 150+ GPD"; $d[58]="Filtration System/Portable RO/Low Flow 50 GPD"; $d[59]="Filtration System/Whole House"; $d[60]="Filtration System/Whole House/Standard"; $d[61]="Filtration System/Whole House/Ecnomical"; $d[62]="Filtration System/Drinking Water"; $d[63]="Filtration System/Aquarium"; $d[64]="Filtration System/Ultra Violet"; $d[68]="Replacement"; $d[70]="Replacement/Combo Set"; $d[71]="Replacement/Filters"; $d[72]="Replacement/Menbranes"; $d[73]="Replacement/Resin"; $d[74]="Replacement/Ultra Violet"; $d[65]="Parts & Tools"; $d[66]="Parts & Tools/Housing"; $d[75]="Parts & Tools/Housing/0.25~0.375 inch"; $d[76]="Parts & Tools/Housing/0.75 inch"; $d[77]="Parts & Tools/Housing/0.5 inch"; $d[67]="Parts & Tools/Feeders"; $d[79]="Parts & Tools/Fittings"; $d[80]="Parts & Tools/Valves"; $d[81]="Parts & Tools/Faucet-Tank-Tubes"; $d[82]="Parts & Tools/Utilityes"; $d[84]="Parts & Tools/Shipping"; --- 20200127-29 整理 old-RO product目錄 ========================================================================================================================= gen-product-csv.php $tmppic=$row["products_image"]; $tmppic=str_replace(" ","-sp-",$tmppic,$i); $tmppic=str_replace("+","-pl-",$tmppic,$i2); $tmppic=str_replace("[1]","-1-",$tmppic,$i3); 收集+改產品主圖片名稱(含空格,+,[1]) -> copy to ./tmp/ -> ftp下載整理 -> 手工zip為aws-20200127.zip -> ftp上傳ro站 aws: cd /var/www/html/pwpic/catalog/images/ wget http://www.purewaterclub.com/aws-20200127.zip -> unzip aws-20200127.zip 缺主圖 576>>>UG-50G->no pic 606>>>RQ-5-100+4->no pic 629>>>UG-100-200->no pic 699>>>SO-002->no pic 701>>>FT-M200->no pic 704>>>RQ5-5T-50->no pic mag2->import->product+pwpic->w Checked rows: 364, checked entities: 364, invalid rows: 0, total errors: 0 --- 20200127 整理 old-RO product special file name pic -> mag2 ========================================================================================================================= 53dfeff4e5225395344f4e917893e8ff3762a0e12080f11da0d57b21fdbc97f8:aFtZhhXDAihazGkpXyPFbBWEf32oxHsL:1 dv4ml@dacomputing.com + aa223344 osc 表customers -> customers_id=9660 + 1@aa.com + $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/ alberto.jany@woodgroup.com + (aa223344) $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0 SELECT * FROM customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id LIMIT 100 SELECT countries_id,countries_name,countries_iso_code_3 FROM (customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id) LEFT JOIN countries ON address_book.entry_country_id=countries.countries_id LIMIT 100 SELECT * FROM (customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id) LEFT JOIN countries ON address_book.entry_country_id=countries.countries_id LIMIT 100 手工刪除黑客注冊垃圾帳號 DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 627 record DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address LIKE '%?%' -> 20 record DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address=entry_city -> 23 record DELETE FROM address_book WHERE entry_state like '%?%' -> 1 record DELETE FROM address_book WHERE customers_id=3953 -> 2 record (YU)->南斯拉夫已不存在 DELETE FROM address_book WHERE customers_id=5505 -> 1 record (YU)->南斯拉夫已不存在 DELETE FROM address_book WHERE customers_id=776 -> 1 record (dd@dd.com)->亂碼 ?? if osc的state空白->mag2自動根據地址判斷 手工刪除表:address_book->不常國家 + state/region 錯誤(無法上傳mag2) + 未成交帳號 DELETE FROM address_book WHERE entry_country_id='123' (LT Lithuania) -> 7 record DELETE FROM address_book WHERE entry_country_id='175' (RO Romania) -> 2 record DELETE FROM address_book WHERE entry_country_id='117' (LV Latvia) -> 2 record (含customers_id=2073 -> mike.pelletier@wanadoo.fr) DELETE FROM address_book WHERE entry_country_id='73' (FR France) -> 3 record (含customers_id=3123 -> asd@jp.co.jp) DELETE FROM address_book WHERE entry_country_id='107' AND customers_id<>6476(JP Japan) -> 7 record 手工刪除表:address_book->(BR Brazil)+ 未成交帳號 UPDATE address_book LEFT JOIN orders ON address_book.customers_id=orders.customers_id SET entry_suburb='xxxxx' WHERE orders_id IS NULL AND entry_country_id='30' (BR Brazil) -> 44 record DELETE FROM address_book WHERE entry_suburb='xxxxx' -> 44 record Last->手工刪除表:customers->無地址address_book UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 730 record DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 730 record 手工修改表:address_book->state UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='san juan' (US PR)-> 7 record UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='Comerio' (US PR)-> 2 record UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='aguadilla' (US PR)-> 1 record UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='P.R.' (US PR)-> 3 record UPDATE address_book SET entry_state='Paraíba' WHERE entry_state='paraiba' (BR)-> 3 record UPDATE address_book SET entry_state='S?o Paulo' WHERE entry_state='SAO PAULO' (BR)-> 5 record UPDATE address_book SET entry_state='Goiás' WHERE entry_state='Goias' (BR)-> 3 record 手工修改表:customers->customers_id=8277 (978)?412-6426->去掉中間亂碼 手工修改表:address_book->customers_id=603 2314\->23140 手工修改表:address_book->customers_id=1470 cahoon77@yahoo.com-> 手工修改表:customers->root@localhost->root@localhost.com 手工修改表:customers->richter@ccs.fau.du->richter@ccs.fau.du.com http://www.purewaterclub.com/gen-customer-csv.php 各種拉丁文亂碼Bogotá(例表:customerscustomers_id=1420(alberto.jany@woodgroup.com) $tmps=str_replace("{fname}",iconv("ISO-8859-1","UTF-8",$row["customers_firstname"]),$tmps); $tmps=str_replace("{lname}",iconv("ISO-8859-1","UTF-8",$row["customers_lastname"]),$tmps); $tmps=str_replace("{city}",iconv("ISO-8859-1","UTF-8",$row["entry_city"]),$tmps); $tmps=str_replace("{fname2}",iconv("ISO-8859-1","UTF-8",$row["entry_firstname"]),$tmps); $tmps=str_replace("{lname2}",iconv("ISO-8859-1","UTF-8",$row["entry_lastname"]),$tmps); $tmps=str_replace("{state}",iconv("ISO-8859-1","UTF-8",$row["entry_state"]),$tmps); $tmps=str_replace("{street}",iconv("ISO-8859-1","UTF-8",$row["entry_street_address"]),$tmps); migrate osc to mag2 v.1 -> osc + : + 0 df7cde40bc6922f8a885a21ebe8fd4b0:70 -> df7cde40bc6922f8a885a21ebe8fd4b0:70:0 v.2 -> osc + : + osc去掉首位$ + : + 0 利用mag2的salt位置傳遞存檔hash,新增程式判斷若為osc v.2,則字首加上$後依v.2規則產生hash,比對若正確後回送hash (aa223344) $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/ -> $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0 $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf. -> $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:0 --- 20200124-25-26 整理 old-RO customer 資料 -> mag2 ========================================================================================================================= 添加新theme 7pm cd /var/www/html/magento8pm/app/design/frontend/Venustheme/ cp 8pm 7pm -r joe registration.php joe theme.xml 直接改不同的default.xml可改變Ves header使用MegaMenu的名稱 1.)pwc /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml menu-top 2.)b4u /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml menu-top-b4u 失敗->添加新theme zou-被Ves Extend搶走header cd /var/www/html/magento8pm/app/design/frontend/Zou/demo/ wget http://www.purewaterclub.com/zou-20200121.zip -> unzip zou-20200121.zip DNS A zou.wg-1.com -> 18.218.158.219 cd /etc/apache2/sites-available cp buck4u.conf zou-wg-1.conf joe zou-wg-1.conf -> ServerName zou.wg-1.com SetEnv MAGE_RUN_CODE "zou" cd /etc/apache2/sites-enabled ln -s /etc/apache2/sites-available/zou-wg-1.conf /etc/apache2/sites-enabled/zou-wg-1.conf service apache2 restart 失敗->增加Ves header的layout: copy default.phtml default-b4u.phtml /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml getChildHtml('catalog.topnav_b4u') ?> /var/www/html/magento8pm/app/code/Ves/Megamenu/view/frontend/layout/default.xml 原始默認Ves header使用MegaMenu的名稱 /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml 可改變Ves header使用MegaMenu的名稱 alias menu-top-b4u layout horizontal /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml --- 20200121 mag2 設定不同 store 配不同 Mega Menu ========================================================================================================================= Bug->Ves ->同一頁只會出現第一種MegaMenu MegaMenu從正上方下移至Top Bar下方: /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml Bug->Ves MegaMenu management->必須改第一個 or 只移動位置,只要按了select就save無效 x-SELECT * FROM address_book LEFT JOIN customers ON address_book.customers_id=customers.customers_id WHERE 1 SELECT * FROM customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id WHERE customers.customers_id<>address_book.customers_id 改ves megamenu alias cd /var/www/html/magento8pm app/code/Ves/Megamenu/view/frontend/layout/default.xml menu-top catagary背景圖: /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/bg_brc.jpg /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images/bg_brc.jpg menu背景圖: Add class “menu-bg” to insert background in dropdown, change background in the path: /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/menu-bg.jpg cp /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/bg_brc.jpg /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images/bg_brc.jpg --- 20200119-20 增刪修 Mega Menu ========================================================================================================================= 缺主圖片 x318>>>6BT-150->no pic x332>>>USPS-20->no pic x444>>>SO-003->no pic x477>>>SP-004->no pic 576>>>UG-50G->no pic 606>>>RQ-5-100+4->no pic 629>>>UG-100-200->no pic x681>>>UG-50-150->no pic 699>>>SO-002->no pic x717>>>SO-003->no pic 圖片不存在 701>>>FT-M200.jpg 704>>>RQ5-5T-50.jpg !BkJeFJQB2k~$(KGrHqUH-CkEs+T,q!(EBLWTm-zWz!~~_12.JPG->FT-PP-25.jpg q-2.csv Images File Directory -> pwpic copy sale:desc+name -> magento8pm 上傳 gen-product-desc-name.php -> pwc gen-product-desc-name.phpx cd /var/www/html/pwpic wget http://www.purewaterclub.com/gen-product-desc-name.phpx -O /var/www/html/pwpic/gen-product-desc-name.php http://aws.wg-1.com/gen-product-desc-name.php 產品基本資料->表:catalog_product_entity entity_id=1824 sku='RO-QQ-101' 產品說明->表:catalog_product_entity_text attribute_id=72(Desc) attribute_id=73(short Desc) entity_id=1824 value=Desc-331(原sale product_id) 產品名稱->表:catalog_product_entity_varchar attribute_id=70 entity_id=1824 value=Name-331(原sale product_id) 產品圖片->表:catalog_product_entity_varchar attribute_id=84(base_image) attribute_id=85(small_image) attribute_id=86(thumbnail_image) attribute_id=150(swatch_image) entity_id=1824 value=/2/2/22-28.jpg 產品庫存->表:cataloginventory_stock_item(各種數量max,min..) product_id=1824 qty=919818.0000 ->表:cataloginventory_stock_status product_id=1824 qty=919818.0000 stock_status=1 產品價格->表:catalog_product_entity_decimal entity_id=1824 attribute_id=74 value=123.4500 ->?表:catalog_product_index_price entity_id=1824 gen-product-csv.php 收集產品主圖片->../aws/catalog/images/->ftp下載整理->手工zip aws-20200118.zip->ftp上傳ro站 aws: cd /var/www/html/pwpic/catalog/images/ wget http://www.purewaterclub.com/aws-20200118.zip -> unzip aws-20200118.zip --- 20200118 mag2 product 產品主圖 + 補缺圖 ========================================================================================================================= Marketing->Cart Price Rules->滿$50包郵->Conditions ->Subtotal equals or greater than 50 x->借用屬性 Eco_Collect 成為 Free Shipping(false:可以排除不包郵的item) (20200216 改不借用Eco_Collect,新增Free Shipping屬性 + Attribute Code->free_shipping + Attribute Properties->Scope->Global + Storefront Properties->Use for Promo Rule Conditions->YES) Actions->Apply the rule only to cart items matching the following conditions (leave blank for all items). ->Free Shipping is Yes cart rule->if Free Shipping is TRUE --- 20191225 mag2 shipping rule ========================================================================================================================= Configuration->VES THEMESETTINGS->Product View Page->Tab By Product Attribute Code->Add Attribute Code Configuration->VES THEMESETTINGS->Product View Page->Tab By CMS Block->Add Attribute Code 不可以Add 空白否則產品頁500錯誤 koofficecn 2019/12/20 14:40:25 http://18.218.158.219/magento8pm/ada.php koofficecn 2019/12/20 14:40:33 openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 1.1.1c 28 May 2019 OpenSSL Header Version OpenSSL 1.1.1c 28 May 2019 Openssl default config /usr/lib/ssl/openssl.cnf ADA 22:26:13 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean Cleaned cache types: config layout block_html collections reflection db_ddl eav customer_notification full_page config_integration config_integration_api translate config_webservice 要用 /usr/bin/php 不能只用 php root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento indexer:reindex Design Config Grid index has been rebuilt successfully in 00:00:01 Customer Grid index has been rebuilt successfully in 00:00:01 Category Products index has been rebuilt successfully in 00:00:00 Product Categories index has been rebuilt successfully in 00:00:00 Product Price index has been rebuilt successfully in 00:00:00 Product EAV index has been rebuilt successfully in 00:00:00 Stock index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:03 不過 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean 可以, 但 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:flush 會出錯, 所以我是回後台, 用後台 admin 作 cache management , 然後才去用命令列, 執行 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento indexer:reindex cd /var/www/html/magento8pm /usr/bin/php bin/magento indexer:reindex --- 20191222 mag2 import product + reindex ========================================================================================================================= root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean Cleaned cache types: config layout block_html collections reflection db_ddl eav customer_notification full_page config_integration config_integration_api translate config_webservi cd /var/www/html/magento8pm find . -type f -exec chmod 644 {} /; && find . -type d -exec chmod 755 {} /; && chmod 777 var/ -R && find pub/media -type d -exec chmod 777 {} /; && find pub/static -type d -exec chmod 777 {} /; && chmod 777 app/etc && chmod 644 app/etc/*.xml && chmod u+x bin/magento adduser zou passwd zou joe /etc/sudoers -> zou ALL=(ALL:ALL) ALL usermod -a -G www-data zou groups www-data cd /var/www/html/magento8pm chown -R www-data:www-data . cd /var/www/html/magento8pm find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} /; find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} /; find . -type f -exec chmod 644 {} /; find . -type d -exec chmod 755 {} /; find ./var -type d -exec chmod 777 {} /; chmod 777 var/ -R find ./pub/media -type d -exec chmod 777 {} /; find ./pub/static -type d -exec chmod 777 {} /; chmod 777 ./app/etc chmod 644 ./app/etc/*.xml xxxx-> chown zou:zou . -hR <--- xxx chmod u+x bin/magento chmod -R g+rwxs . ls -la joe /etc/php/7.0/fpm/pool.d/www.conf chmod u+x qq cd /var/www/html/magento8pm sudo php bin/magento indexer:reindex php /var/www/html/magento8pm/bin/magento indexer:reindex The openssl extension is required for SSL/TLS protection but is not available. If you can not enable the openssl extension, you can disable this error, at your own risk, by setting the 'disable-tls' option to true. #0 /var/www/html/magento8pm/vendor/composer/composer/src/Composer/Factory.php(306): Composer/Factory::createRemoteFilesystem(Object(Composer/IO/BufferIO), Object(Composer/Config)) #1 /var/www/html/magento8pm/vendor/composer/composer/src/Composer/Factory.php(532): Composer/Factory->createComposer(Object(Composer/IO/BufferIO), Array, false) #2 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerFactory.php(47): Composer/Factory::create(Object(Composer/IO/BufferIO), '/var/www/html/m...') #3 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(362): Magento/Framework/Composer/ComposerFactory->create() #4 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(375): Magento/Framework/Composer/ComposerInformation->getComposer() #5 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(242): Magento/Framework/Composer/ComposerInformation->getLocker() #6 /var/www/html/magento8pm/vendor/magento/framework/App/ProductMetadata.php(104): Magento/Framework/Composer/ComposerInformation->getSystemPackages() #7 /var/www/html/magento8pm/vendor/magento/framework/App/ProductMetadata.php(65): Magento/Framework/App/ProductMetadata->getSystemPackageVersion() #8 /var/www/html/magento8pm/vendor/magento/framework/Console/Cli.php(81): Magento/Framework/App/ProductMetadata->getVersion() #9 /var/www/html/magento8pm/bin/magento(22): Magento/Framework/Console/Cli->__construct('Magento CLI') #10 {main} Fatal error: Uncaught Error: Class 'Cli' not found in /var/www/html/magento8pm/bin/magento:31 Stack trace: #0 {main} thrown in /var/www/html/magento8pm/bin/magento on line 31 不可用sudo composer config -g -- disable-tls true service apache2 restart ln -s /var/www/html/pwpic /var/www/html/magento8pm/pwpic Images File Directory -> pwpic catalog_product_20191216_044905 /catalog/images/22-28.jpg url -> atomic-endurance-running-tee-v-neck-s-blue 35138564 cd /var/www/html/magento8pm php bin/magento indexer:reindex php bin/magento cache:clean && php bin/magento cache:flush Table eav_entity_type.entity_type_id=4(catalog_product) ->Table eav_attribute.attribute_id=72(catalog_product-description-text) ->Table catalog_product_entity.entity_id=1792(sku=RQ-6B2W-100) ->Table catalog_product_entity_text.attribute_id=72 + .entity_id=1792(value=description html) sale.products.products_model->sku --- 20191213 AWS mySQL Table ========================================================================================================================= cd /var/www/html/pwpic wget http://www.purewaterclub.com/pid.phpx -O /var/www/html/pwpic/pid.php http://www.purewaterclub.com/pid.php?p=264 -> http://aws.wg-1.com/pid.php?p=264 2434 72 0 1792 ->去掉height UPDATE catalog_product_entity_text SET value='$tmphtm' WHERE value_id='2434' AND attribute_id='72' AND entity_id='1792' STORES->Configuration->VES THEMESETTINGS->Profuct View Page->Tab --- 20191213 AWS PHP + mySQL ========================================================================================================================= cd /var/www/html/pwpic wget http://www.purewaterclub.com/aws-20191205.zip -> 解壓zip ro.wg-1.com 指向+對應 59.124.16.10 /home/httpd/www/aws aws.wg-1.com 指向+對應 AWS /var/www/html/pwpic 更新所有連結 59.124.16.10 -> aws.wg-1.com www.purewaterclub.com -> aws.wg-1.com products_description_wk copy to products_description %20 -> / http://aws.wg-1.com/items/Pic/PO/2way%20switch.jpg -> 2way/ switch.jpg http://aws.wg-1.com/items/Pic/SP/Collet%20release%20tool.JPG -> Collet/ release/ tool.JPG http://aws.wg-1.com/items/Pic/SP/Collet%20release%20tool-1.JPG -> Collet/ release/ tool-1.JPG http://aws.wg-1.com/items/Pic/SP/SP-Collet%20release%20tool.JPG -> SP-Collet/ release/ tool.JPG http://aws.wg-1.com/items/Pic/SP/SP-Collet%20release%20tool-1.JPG -> SP-Collet/ release/ tool-1.JPG http://aws.wg-1.com/items/Pic/000/install/tube%20remove.jpg -> tube/ remove.jpg http://aws.wg-1.com/items/Pic/000/First-Class%20Mail.jpg -> First-Class/ Mail.jpg http://aws.wg-1.com/items/Pic/PT/bracket%20-size.JPG -> bracket -size.JPG http://aws.wg-1.com/items/Pic/000/FS/FS20-PPx25-2.JPG ->換圖 wget http://www.purewaterclub.com/items/Pic/000/parts/B38.jpg -O /var/www/html/pwpic/items/Pic/000/parts/B38.jpg wget http://www.purewaterclub.com/items/Pic/000/parts/B38-1.JPG -O /var/www/html/pwpic/items/Pic/000/parts/B38-1.JPG wget http://www.purewaterclub.com/items/Pic/000/parts/B38-2.JPG -O /var/www/html/pwpic/items/Pic/000/parts/B38-2.JPG wget http://www.purewaterclub.com/items/Pic/000/parts/B38-3.jpg -O /var/www/html/pwpic/items/Pic/000/parts/B38-3.jpg --- 20191205 舊RO站所有pic -> AWS ========================================================================================================================= www.purewaterclub.com -> /home/httpd/www/sale copy -> /home/httpd/www/aws 59.124.16.10 -> /home/httpd/www/ksoffice copy -> /home/httpd/www/aws 通知 ML http://www.purewaterclub.com/catalog/product_info.php?products_id=709 -> 5破圖 取消所有超連結 未來新產品儘量使用全圖片 --- 20191204 集中舊RO站所有產品說明的pic ========================================================================================================================= 1.) copy products_description-20191128 -> products_description_20191203_0 2.) products_description_20191203_0 新增 products_description_0 3.) UPDATE products_description_20191203_0 SET products_description_0=products_description 4.) copy products_description_20191203_0 -> products_description_wk 5.) php 去除所有 href + 修正所有 img 後同時寫回 mySQL language_id=1,2 6.) 手工改/加圖檔 --- 20191203 修改舊RO站產品說明 去除所有href + 修正 img ========================================================================================================================= www.purewaterclub.com -> /home/httpd/www/sale , 59.124.16.10 -> /home/httpd/www/ksoffice 1.) 去除 (112 + 128 + 104 + 130 + 46 + 44 records) UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 2.) 去除 .. (92 + 90 + 86 + 76 + 22 + 42 records) UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 3.) 去除 .. (18 + 60 + 60 + 56 + 20 + 20 records) UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 4.) 去除 .. (4 + 98 + 58 + 46 + 10 + 8 records) UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 5.) 去除 (4 + 2 + 8 + 4 + 20 + 20 records) UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 6.) 去除 Instructions menu (6 records) SELECT * FROM products_description WHERE products_description LIKE '%Instructions menu%' UPDATE products_description SET products_description=REPLACE(products_description,'Instructions menu','') WHERE products_description LIKE '%Instructions menu%'; 7.) 去除 Instructions menu (2 records) UPDATE products_description SET products_description=REPLACE(products_description,'Instructions menu','') WHERE products_description LIKE '%Instructions menu%'; 8.) 去除 Instructions menu (2 records) UPDATE products_description SET products_description=REPLACE(products_description,'Instructions menu','') WHERE products_description LIKE '%Instructions menu%'; 9.) 去除 nstructions menu (2 records) UPDATE products_description SET products_description=REPLACE(products_description,'nstructions menu','') WHERE products_description LIKE '%nstructions menu%'; 11.) 手工去除 增加 (products_id=305,307,308,312,355) 12.) 手工去除 .. 13.) remove whole --- 20191202 修改舊RO站產品說明 去除href ========================================================================================================================= 1.) 去除 ? ? (76 records) SELECT * FROM products_description WHERE products_description LIKE '%?%' UPDATE products_description SET products_description=REPLACE(products_description,'?','') WHERE products_description LIKE '%?%' 2.) 去除 (Please Click Picture to enlarge the picture) (324 + 94 + 52 records) SELECT * FROM products_description WHERE products_description LIKE '%(Please Click Picture to enlarge the picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'(Please Click Picture to enlarge the picture)','') WHERE products_description LIKE '%(Please Click Picture to enlarge the picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'(Please Click ','') WHERE products_description LIKE '%(Please Click %' UPDATE products_description SET products_description=REPLACE(products_description,'Picture to enlarge the','') WHERE products_description LIKE '%Picture to enlarge the%' UPDATE products_description SET products_description=REPLACE(products_description,'picture)','') WHERE products_description LIKE '%picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'Picture to','') WHERE products_description LIKE '%Picture to%' UPDATE products_description SET products_description=REPLACE(products_description,'enlarge the picture)','') WHERE products_description LIKE '%enlarge the picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'the picture)','') WHERE products_description LIKE '%the picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'enlarge','') WHERE products_description LIKE '%enlarge%' UPDATE products_description SET products_description=REPLACE(products_description,'PW- PW-Picture)','') WHERE products_description LIKE '%PW- PW-Picture)%' UPDATE products_description SET products_description=REPLACE(products_description,'Picture)','') WHERE products_description LIKE '%Picture)%' 10.) 去除

 

(82 + 128 records) SELECT * FROM products_description WHERE products_description LIKE '%

 

%' UPDATE products_description SET products_description=REPLACE(products_description,'

 

','') WHERE products_description LIKE '%

 

%'; UPDATE products_description SET products_description=REPLACE(products_description,'

 

','') WHERE products_description LIKE '%

 

%'; 11.) 去除


 

(38 + 48 records) SELECT * FROM products_description WHERE products_description LIKE '%


 

%' UPDATE products_description SET products_description=REPLACE(products_description,'


 

','') WHERE products_description LIKE '%


 

%'; UPDATE products_description SET products_description=REPLACE(products_description,'


 

','') WHERE products_description LIKE '%


 

%'; 12.) 去除 (102 + 98 records) SELECT * FROM products_description WHERE products_description LIKE '%%' UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%'; 13.) 去除

(180 + 102 records) SELECT * FROM products_description WHERE products_description LIKE '%

%' UPDATE products_description SET products_description=REPLACE(products_description,'

','') WHERE products_description LIKE '%

%'; UPDATE products_description SET products_description=REPLACE(products_description,'

','') WHERE products_description LIKE '%

%'; 14.) 去除 (150 records) SELECT * FROM products_description WHERE products_description LIKE '% %' UPDATE products_description SET products_description=REPLACE(products_description,' ','') WHERE products_description LIKE '% %'; SELECT * FROM products_description WHERE products_description LIKE '%



%'
--- 20191201 修改舊RO站產品說明內容 + href ========================================================================================================================= 1.) http://61.220.188.82/items/Pic/Public/US-I.bmp -> http://59.124.16.10/items/Pic/Public/US-I.jpg SELECT * FROM products_description WHERE products_description LIKE '%http://61.220.188.82/items/Pic/Public/US-I.bmp%' UPDATE products_description SET products_description=REPLACE(products_description,'http://61.220.188.82/items/Pic/Public/US-I.bmp','http://59.124.16.10/items/Pic/Public/US-I.jpg') WHERE products_description LIKE '%http://61.220.188.82/items/Pic/Public/US-I.bmp%' 2.) http://59.124.16.10/items/Pic/FT/DIQ-1.JPG -> http://59.124.16.10/items/Pic/FT/DIQ-2.JPG SELECT * FROM products_description WHERE products_description LIKE '%http://59.124.16.10/items/Pic/FT/DIQ-1.JPG%' UPDATE products_description SET products_description=REPLACE(products_description,'http://59.124.16.10/items/Pic/FT/DIQ-1.JPG','http://59.124.16.10/items/Pic/FT/DIQ-2.JPG') WHERE products_description LIKE '%http://59.124.16.10/items/Pic/FT/DIQ-1.JPG%' 3.) http://59.124.16.10/items/Pic/22-4114/22-4 /r 114.jpg -> http://59.124.16.10/items/Pic/22-4114/22-4114.jpg (products_id=191) 4.) hhttp://59.124.16.10/items/Pic/000/FT/FT-PH.jpg -> hhttp://59.124.16.10/items/Pic/000/FT/FT-PH.jpg (products_id=308) 5.) http://59.124.16.10/items/Pic/000/1042Q-1.jpg -> IMG rmoved (products_id=340) 6.) http://sm7.sitemeter.com/meter.asp?site=sm7purewaterclub -> IMG rmoved (products_id=414) 7.) (products_id=490) http://59.124.16.10/items/Pic/22-10/22-10- /r F5-I-1.jpg -> http://59.124.16.10/items/Pic/22-10/22-10-F5-I-1.jpg http://59.124.16.10/items/PW-Pic/PW-22- /r 82/PW-22-82-F5-I.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82-F5-I.jpg http://59.124.16.10/items/PW- /r Pic/PW-22-82/PW-22-82-F1.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82- F6.jpg http://59.124.16.10/items/PW-Pic/PW-22- 82/PW-22-82- /r F6.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82- F6.jpg 8.) -> IMG rmoved (products_id=542) SELECT * FROM `products_description` WHERE `products_description` like '%%' UPDATE products_description SET products_description=REPLACE(products_description,'','') WHERE products_description LIKE '%%' 9.) http://59.124.16.10/items/Pic/000/FT/FT-PP05_2.JPG -> http://59.124.16.10/items/Pic/000/FT/FT-PP05_2.JPG (products_id=595,597,637) SELECT * FROM `products_description` WHERE products_description LIKE '% %' AND (products_id='595' OR products_id='597' OR products_id='637') UPDATE products_description SET products_description=REPLACE(products_description,' ','') WHERE products_description LIKE '% %' AND (products_id='595' OR products_id='597' OR products_id='637') 10.) (products_id=632,633,658,661) http://59.124.16.10/items/Pic/22-309/22-115-F1.jpg -> http://59.124.16.10/items/Pic/22-309/22-115-F1.jpg http://59.124.16.10/items/Pic/22-309/22-115-F3.jpg -> http://59.124.16.10/items/Pic/22-309/22-115-F3.jpg http://59.124.16.10/items/Pic/FT/T33.JPG -> http://59.124.16.10/items/Pic/FT/T33.JPG http://59.124.16.10/items/Pic/22-36/22-36-F3.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-F3.jpg http://59.124.16.10/items/Pic/22-36/22-36-P4.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-P4.jpg http://59.124.16.10/items/Pic/22-36/22-36-P6.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-P6.jpg SELECT * FROM `products_description` WHERE products_description LIKE '% %' AND (products_id='632' OR products_id='633' OR products_id='658' OR products_id='661') UPDATE products_description SET products_description=REPLACE(products_description,' ','') WHERE products_description LIKE '% %' AND (products_id='632' OR products_id='633' OR products_id='658' OR products_id='661') 11.) http://59.124.16.10/items/Pic/000/FS/FS20-PPx25-1.JPG -> http://59.124.16.10/items/Pic/000/FS/FS20-PPx24-1.JPG (products_id=675) 12.) https: -> http: (products_id=709,716) SELECT * FROM `products_description` WHERE products_description LIKE '%https:%' AND (products_id='709' OR products_id='716') UPDATE products_description SET products_description=REPLACE(products_description,'https:','http:') WHERE products_description LIKE '%https:%' AND (products_id='709' OR products_id='716') ?? http://www.purewaterclub.com/catalog/images/Psi-1.jpg -> http://59.124.16.10/catalog/images/Psi-1.jpg 不顯現 30 pic ?? http://i.ebayimg.com/00/s/NDgwWDY0MA==/z/29MAAMXQ3kNTiBiu/$_12.JPG -> href ? 15 pic http://www.purewaterclub.com/catalog/product_info.php?products_id=709 -> Miss 5 Pic http://www.purewaterclub.com/catalog/product_info.php?products_id=711 -> Miss 1 Pic http://www.purewaterclub.com/catalog/product_info.php?products_id=712 -> Miss 1 Pic ----------------> total 52 pic --- 20191130 修改舊RO站產品圖片連結 ========================================================================================================================= UPDATE products_description SET products_description_0=REPLACE(products_description_0,'?','') WHERE products_id='169' AND language_id='1' http://www.purewaterclub.com/catalog/product_info.php?cPath=88_87&products_id=158 舊RO站table products_description->products_description 1114 records Logo Max 218 x 70 1.)改圖片 IP->?? AWS domain + 去掉目錄? http://59.124.16.10/items/Pic/22-57/22-57-F5-2.jpg 2.)改file:// 244 records file:///E:/Documents%20and%20Settings/Administrator/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/pvwA.htm#RO-P1 3.)去掉亂碼 76 records ? 4.)去掉ebay hyper link 656 records http://cgi5.ebay.com/ws/eBayISAPI.dll?SimilarListing&itemid=110389038550#RO-P1 http://stores.ebay.com/purewaterclub_Water-Filter-System_W0QQcolZ4QQdirZ1QQfclZ4QQfsubZ231976010QQftidZ2QQtZkmQQ_trksidZp1742.m154.l1264 5.)去掉無效說明 a.) (Please Click Picture to enlarge the picture) -> 324 records b.)Great Gift! We Could Ship This Item To Your Friend Within US Continatal! Good For Your Family And Friends! -> 328 records 6.)去掉破圖 ?? http://59.124.16.10/items/Driver/driver.jpg 7.)去掉下載Download Manual hyper link 32 records http://59.124.16.10/items/Driver/Protable%20RO%20instruction.doc 8.)去掉Buy It Now價格 194 records Buy It Now is Just US$108.99 and 2-7 days* you will GET IT at HOME within US!! 9.)去掉Retail Price價格 256 records (Retail Price:US$320) SELECT * FROM `products_description` WHERE `products_description` LIKE '%file:%' --- 20191110 修改舊RO站產品說明 ========================================================================================================================= magento2 table customer_entity->password_hash: format -> hash(md5/sha256) : salt (max 32digit) : version (0/1) (md5/sha256) ?->: convet to version (1/2?) b7de469740dc4f7edf08fe26c4e3ee5a53bf03c5467ff2f02a831c94b707d455:mCIgmxGBoZBGKgL6vkc7xIcZcKUwYQvd:1 v.0登入成功後將主動升級v.1用sha256重寫password_hash osCommerce 2.4.3.1 table customers->customers_password: format v.1 -> hash(md5) : salt (2digit) df7cde40bc6922f8a885a21ebe8fd4b0:70 format v.2 -> $P$ + D(重複作md5次數 D=2^13=8192次) + salt (64進位 8digit) + hash (64進位 21+1digit 最後1位2bit=21*6+2=128=32*4=16進位 32digit) $P$ D NVAIbn8k ZQQop6d3QAg2lFVkSG2o2 / ./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz (64進位) -> 0123456789abcdef (16進位) migrate osc to mag2 v.1 -> osc + : + 0 df7cde40bc6922f8a885a21ebe8fd4b0:70 -> df7cde40bc6922f8a885a21ebe8fd4b0:70:0 v.2 -> osc + : + osc去掉首位$ + : + 0 利用mag2的salt位置傳遞存檔hash,新增程式判斷若為osc v.2,則字首加上$後依v.2規則產生hash,比對若正確後回送hash $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/ -> $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0 $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf. -> $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:0 joe /var/www/html/magento8pm/vendor/magento/framework/Encryption/Encryptor.php 1.)新增產生osc v.2的password hash public function GenPasswordHash($password,$setting){ $itoa64='./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'; $count_log2 = strpos($itoa64,$setting[3]); if ($count_log2 < 7 || $count_log2 > 30)return $output; $count = 1 << $count_log2; $salt = substr($setting, 4, 8); if (strlen($salt) != 8)return $output; if (PHP_VERSION >= '5') { $hash = md5($salt . $password, TRUE); do { $hash = md5($hash . $password, TRUE); } while (--$count); } else { $hash = pack('H*', md5($salt . $password)); do { $hash = pack('H*', md5($hash . $password)); } while (--$count); } $output = substr($setting, 0, 12); $tmpout = ''; $count=16; $i = 0; do { $value = ord($hash[$i++]); $tmpout .= $itoa64[$value & 0x3f]; if ($i < $count)$value |= ord($hash[$i]) << 8; $tmpout .= $itoa64[($value >> 6) & 0x3f]; if ($i++ >= $count)break; if ($i < $count)$value |= ord($hash[$i]) << 16; $tmpout .= $itoa64[($value >> 12) & 0x3f]; if ($i++ >= $count)break; $tmpout .= $itoa64[($value >> 18) & 0x3f]; }while ($i < $count); $output .= $tmpout; return $output; } 2.)修改原有的isValidHash(),加入判斷利用salt位置傳遞的hash值是否為osc v.2,並比對由GenPasswordHash()產生的v.2 hash是否正確 public function isValidHash($password, $hash) { $this->explodePasswordHash($hash); foreach ($this->getPasswordVersion() as $hashVersion) { // $password = $this->hash($this->getPasswordSalt() . $password, $hashVersion); //----- 20191109 DV ------- //--- check if RO Site 2nd password hash ($P$D... 33 digit)->(P$D... 32 digit) $tmpsalt=$this->getPasswordSalt(); if($hashVersion==0 && substr($tmpsalt,0,3)=='P$D'){ //--- make hash by salt $tmpsalt="$".$tmpsalt; //--- check if password OK with SQL hash($ + P$D..) if($this->GenPasswordHash($password,$tmpsalt)==$tmpsalt){ //--- set password -> generated hash $password=$tmpsalt; } } else{ $password=$this->hash($tmpsalt.$password,$hashVersion); } //----- } return Security::compareStrings( $password, $this->getPasswordHash() ); } magento2 核心密碼比對程式 01.)D:/Temp-Downloads/AWS/8pm-zip/vendor/zendframework/zend-crypt/src/Utils.php -> public static function compareStrings($expected, $actual) -> 逐ord()比對產生Hash vs SQLHash -> return true 02.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Helper/Security.php -> public static function compareStrings($expected, $actual) -> by pass call (01) -> return true 03.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Encryptor.php -> public function isValidHash($password, $hash) ->展開SQLHash成passwordHashMap array,根據不同$hashVersion()+getPasswordSalt()+password產生Hash -> 比對SQLHash+getPasswordHash() call (02) -> return true 03-1.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/zendframework1/library/Zend/Crypt.php -> public static function hash($algorithm, $data, $binaryOutput = false)實際產生Hash for (03) 研究用only /var/www/html/magento8pm/vendor/magento/module-customer/Model/AccountManagement.php cd /var/www/html/magento8pm/vendor/magento/module-customer/Model/ mv AccountManagement.php-x AccountManagement.php wget http://61.220.188.84/dv-2019-tmp/AccountManagement.php wget http://61.220.188.84/dv-2019-tmp/PasswordHash.x ---------------- https://blog.csdn.net/chengfei112233/article/details/6939144/ 密码生成方式 > 随机产生一个salt 并将salt和password相加 > 进行了count次md5 然后和encode64的hash数值累加 > 最后得到一个以$P$开头的密码，这个密码每次产生的结果都不一样C:/Users/dv-10/Desktop/catalog/includes/classes/passwordhash.php 系统：MD5(WordPress) 例子：$P$B123456780BhGFYSlUqGyE6ErKErL01 说明：WordPress使用的md5 长度：34个字符 描述：$P$表示加密类型，然后跟着一位字符，经常是字符‘B’，后面是8位salt，后面是就是hash 加密算法：8192次md5循环加密 -> 2的(8+5=13)次方=8192 --- 20191107 遷移舊RO站客戶資料 -> 一元站 ========================================================================================================================= /var/www/html/magento8pm/app/design/frontend/Zou/demo/ x->joe /usr/local/apache/conf/httpd.conf x->joe /etc/apache2/apache2.conf ServerName www.buck4u.com DocumentRoot /var/www/html/magento8pm/pub/ SetEnv MAGE_MODE "developer" ServerName www.buck4all.com DocumentRoot /var/www/html/magento8pm/pub/ SetEnv MAGE_MODE "developer" SetEnv MAGE_RUN_CODE "demo3" SetEnv MAGE_RUN_TYPE "website" service apache2 restart /etc/apache2/sites-enabled/mag-wg-1.conf /etc/apache2/sites-available/mag-wg-1.conf /etc/apache2/sites-enabled/000-default.conf /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/buck4u.conf /etc/apache2/sites-enabled/buck4u.conf ls -al /etc/apache2/sites-enabled/ 是 /etc/apache2/sites-available / buck4u.conf 這個, documentroot 對應 magento8pm/pub , 那個 setenv 才有效 在 magneto8pm 和 magneto8pm/pub 下 都各有一個 .htaccess 裡面有指定 index.php RO站後台入口 https://www.purewaterclub.com/catalog/admin/ admin + admin1234! D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-downloadable/view/frontend/layout/downloadable_customer_products.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/Customer/Attribute/Backend/Password.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Exception/InvalidEmailOrPasswordException.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/AuthenticationInterface.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Observer/CheckUserLoginObserver.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Test/Unit/Observer/CheckUserEditObserverTest.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Test/Unit/Observer/CheckUserLoginObserverTest.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Controller/Account/EditPost.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/Authentication.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Observer/CustomerLoginSuccessObserver.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Encryptor.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/PasswordHash.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/CheckOscPswHash.php ---------------------------------------------------------------------------------------------------------- D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/layout/default.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/page_layout/1column.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/base/page_layout/empty.xml D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml D:/Temp-Downloads/AWS/8pm-zip/app/code/Ves/Themesettings/Block/Html/Header.php D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml D:/Temp-Downloads/AWS/8pm-zip/app/code/Ves/Themesettings/Block/Html/Links.php D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/Html/Links.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/Template.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/AbstractBlock.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/layout/default.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/Block/Html/Header.php D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/templates/html/header.phtml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/view/frontend/layout/default.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/layout/default.xml D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/templates/link.phtml table: catalog_product_entity_text entity_id: item id -> attribute_id, value table: eav_attribute attribute_id: 72 -> attribute_code: description attribute_id: 73 -> attribute_code: short_description attribute_id: 82 -> attribute_code: meta_keyword Atomic Endurance Running Tee (V-neck)-S-Blue 修改footer2 背景顏色: 8pm Footer 2 -> Design Elemment -> Prefix Class -> 去掉footer2(黑變白) 修改shipping: STORES -> Configuration -> SALES -> Shipping Methods 修改payment: STORES -> Configuration -> SALES -> Payment Methods 修改注冊設定: Configuration -> CUSTOMERS -> Customer Configuration -> Password Options -> Number of Required Character Classes: 3 -> 2 (20191026) Element Builder -> 8pm categories -> Design -> (Widget) Categories Info And Subcategories -> Edit 首頁目錄element改長寬: (Toggle Code) limit_subcategory=/"3/" limit=/"3/" columns=/"3/" 首頁目錄element改目錄類別: (Toggle Code) catsid=/"20,11,13,3/" /var/www/html/magento8pm/pub/media/catalog/category/cat6.jpg ----------------------- Ref ----------------------------------------------- app/code/Magento/Xxx/ vendor/magento/module-xxx/ app/design/frontend/Venustheme/8pm/ vendor/magento/theme-frontend-blank/ Base layouts: /view/frontend/layout /view/frontend/page_layout Theme layouts: /_/layout /_/page_layout All layouts: /var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layouts.xml ----------------------- OK Used ----------------------------------------- /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/theme.xml A.) Base Page configuration: /var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layout/default.xml A-1.) Base Page layout: -> container page-header /var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/page_layout/3columns.xml A-2.) -> 2columns-right -> 1column -> -> container page-wrapper /var/www/html/magento8pm/vendor/magento/module- theme/view/base/page_layout/empty.xml B.) Main Customer (Ves) Theme Page configuration: /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml B-1.) -> header.container :: block ves_header -> /var/www/html/magento8pm/app/code/Ves/Themesettings/Block/Html/ Header.php B-1-1.) protected $_template = 'header/default.phtml' -> /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml B-2.) -> header.container -> block ves_header -> block top.links -> /var/www/html/magento8pm/app/code/Ves/Themesettings/Block/Html/Links.php B-2-1.) $this->setTemplate("Ves_Themesettings::html/links.phtml"); -> /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml B-2-2.) class Links extends /Magento/Framework/View/Element/Html/Links -> class Links extends /Magento/Framework/View/Element/Template -> class Template extends AbstractBlock C.) Sub Customer (Ves) Theme Page configuration: -> 自動搜vendor/magento下的所有module-XXX/view/frontend/layout/default.xml -> module-catalog , module-customer, module-wishlist C-1.) module-catalog -> -> /var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/layout/default.xml C-2.) module-theme (原本為"-",被C-1 也是"-",插隊變第二) -> -> /var/www/html/magento8pm/vendor/magento/module-customer/view/frontend/layout/default.xml C-3.) module-customer -> -> /var/www/html/magento8pm/vendor/magento/module-customer/view/frontend/layout/default.xml C-4.) module- wishlist -> -> /var/www/html/magento8pm/vendor/magento/module-wishlist/view/frontend/layout/default.xml C-5.) register-link -> module- wishlist -> C-6.) authorization-link -> module- wishlist -> -> /var/www/html/magento8pm/vendor/magento/framework/View/Element/Html/Links.php /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml ------------------------- X-- No Used --------------------------------------------------- /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Magento_Theme/page_layout/1column.xml -> /var/www/html/magento8pm/vendor/magento/module-theme/view/base/page_layout/empty.xml ----------------------------------------------------- (20190914) 社区 https://magento.stackexchange.com https://stackoverflow.com/ https://community.magento.com/ cd /var/www/html/magento8pm/ home page -> app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml -> vendor/magento/framework/View/Element/Html/Links.php index.php -> app/bootstrap.php -> app/autoload.php -> vender/autoload.php -> vender/composer/autoloadreal.php 首頁: class Links extends /Magento/Framework/View/Element/Html/Links -> /var/www/html/magento8pm/vendor/magento/framework/View/Element/Html/Links.php class Links extends /Magento/Framework/View/Element/Template -> class Template extends AbstractBlock -> abstract class AbstractBlock extends /Magento/Framework/DataObject implements BlockInterface -> /var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/layout/default.xml /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml getChildHtml('top_links') ?> --> D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend 首頁右上角人頭下拉選單: 選項 catalog.compare.link 定義頁 -> D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/layout/default.xml -> D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml 去掉 Compare Products -> mv /var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml 選項 wish-list-link 定義頁 -> D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/layout/default.xml -> D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/templates/link.phtml 去掉My Wish List -> mv /var/www/html/magento8pm/vendor/magento/module-wishlist/view/frontend/templates/link.phtml 改LOGO: http://www.buck4u.com/magento8pm/pub/media/logo/default/logo.png ls /var/www/html/magento8pm/pub/media/logo/default/logo.png cd /var/www/html/magento8pm/pub/media/logo/default/ wget http://61.220.188.84/dv-2019-tmp/logo.png 去掉首頁 panel tool: VES THEMESETTINGS -> General Settings -> Panel Tool -> Enable -> No 去掉 element->8pm-product 彈出 compare, review, price, addtocart: show_compare=/"1/" -> show_compare=/"0/" show_review=/"1/" -> show_review=/"0/" show_price=/"1/" -> show_price=/"0/" show_addtocart=/"1/" -> show_addtocart=/"0/" /Magento/Framework/Exception/LocalizedException cd /var/www/html/magento8pm/ (20191026) AWS 啟動實例 IP-> 3.17.62.14 -> 18.218.158.219 phpmyadmin: http://18.218.158.219/awsadmin/ root + revres88 (20190909) puttygen.exe + dv-1.pem -> dv-1.ppk ssh: putty + IP + dv-1.ppk -> sudo su phpmyadmin: http://3.17.62.14/awsadmin/ root + revres88 手工改mysql data base: magento8pm megamenu -> table ves_megamenu_item 首頁header -> Main Website -> Search Box, Language, Currency(取消) /etc/apache2/sites-enabled/mag-wg-1.conf <- 網址 mag.wg-1.com 的設定檔, 實際設定檔在 /etc/apache2/sites-abvilable/mag-wg-1.conf /etc/apache2/sites-enabled/000-default.conf <- 預設網址 www.buck4u.com 的設定檔, 指向到 /var/www/html 目錄 之前給的STORE網址, 直接連就已經是錯誤, mag.wg-1.com 我改指向到 /var/www/html/mag-wg-1/ 目錄, 再由 index.html 去指向到 測試網址 /etc/apache2/apache2.conf 和 /var/www/html/magento8pm/.htaccess 都已經復原 apache 的 conf /etc/apache2/apache2.conf DocumentRoot /home/httpd/www/magento8pm ServerName www.buck4u.com AllowOverride all Order allow,deny Allow from all ErrorLog /var/log/httpd/error_log CustomLog /var/log/httpd/access_log common DocumentRoot /home/httpd/www/magento8pm ServerName mag.wg-1.com AllowOverride all Order allow,deny Allow from all ErrorLog /var/log/httpd/error_log CustomLog /var/log/httpd/access_log common 兩個網址都對應到同一個目錄 joe /var/www/html/magento8pm/.htaccess RewriteEngine On RewriteCond %{HTTP_HOST} ^www/.buck4u/.com$ RewriteRule ^(.*)$ dn1.html [L] RewriteCond %{HTTP_HOST} ^mag/.wg-1/.com$ RewriteRule ^(.*)$ dn2.html [L] dn1.html 改 www.buck4u.com 要對應的PHP網頁 dn2.html 改 mag.wg-1.com 要對應的PHP網頁, 或直接整個完整網址, 例 http://www.buck4u.com/magento8pm/stores/store/switch/___store/demo2