發表回覆建立主題發起投票

> Twe 3.03 匯入 3.01 的資料後無法進入管理者介面
dab_tw
發表於: 2014-05-12, 05:32 PM
引用文章


新進會員
*

所屬群組: 註冊會員
發表總數: 4
會員編號: 14718
註冊日期: --



老爹您好:

最近我將購物車的系統由3.01版更換為3.03版,並將原本3.01版時期的資料匯入,

但匯入後要進入管理者介面時卻發生左邊選單整排消失的情況,如下圖所示:

http://i.imgur.com/1YvN2zl.jpg


由於在匯入之前的3.03版前有測試過介面,都能正常顯示以及使用,

所以應該是匯入資料後某個參數影響了選單顯示.

但如果此時直接輸入該項功能的網址時,卻又可以正常使用該項功能

(例如 http://www.autors.tw/shop/admin/content_manager.php)

請問這樣的話是否有其他方法可以解決這個問題呢,煩請老爹解惑,謝謝:)
傳送簡訊Email
Top
dab_tw
發表於: 2014-05-12, 05:36 PM
引用文章


新進會員
*

所屬群組: 註冊會員
發表總數: 4
會員編號: 14718
註冊日期: --



虛擬主機及系統相關資訊

●虛擬主機作業系統:Apache/2.0.63 (Unix)
●PHP:4.4.9 (Zend: 1.3.0)
●phpMyAdmin - 2.11.11.3
●MySQL 客戶端版本:4.1.21
●TWE連結網址:http://www.autors.tw/shop
傳送簡訊Email
Top
oldpa
發表於: 2014-05-12, 06:43 PM
引用文章


超級會員
*****

所屬群組: 管理群組
發表總數: 5402
會員編號: 1
註冊日期: --



將以下資料再導入MYSQL試試

CODE

INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CATEGORIES', 'true', 18, 1, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('NEW_ATTRIBUTES', 'true', 18, 2, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('PRODUCTS_ATTRIBUTES', 'true', 18, 3, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MANUFACTURERS', 'true', 18, 4, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('REVIEWS', 'true', 18, 5, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SPECIALS', 'true', 18, 6, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('PRODUCTS_EXPECTED', 'true', 18, 7, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('NEWS_CATEGORIES', 'true', 18, 8, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID1', 'true', 18, 9, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID2', 'true', 18, 10, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID3', 'true', 18, 11, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID4', 'true', 18, 12, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID5', 'true', 18, 13, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID7', 'true', 18, 14, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID8', 'true', 18, 15, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID9', 'true', 18, 16, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID10', 'true', 18, 17, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID11', 'true', 18, 18, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID12', 'true', 18, 19, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID13', 'true', 18, 20, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID14', 'true', 18, 21, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID15', 'true', 18, 22, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID16', 'true', 18, 23, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATIONGID17', 'true', 18, 24, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('ORDERS_STATUS', 'true', 18, 25, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SHIPPING_STATUS', 'true', 18, 26, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CUSTOMERS', 'true', 18, 27, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CUSTOMERS_STATUS', 'true', 18, 28, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('ORDERS', 'true', 18, 29, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('COUPON_ADMIN', 'true', 18, 30, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('GV_QUEUE', 'true', 18, 31, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('GV_MAIL', 'true', 18, 32, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('GV_SENT', 'true', 18, 33, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('LANGUAGES', 'true', 18, 34, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('COUNTRIES', 'true', 18, 35, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CURRENCIES', 'true', 18, 36, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('ZONES', 'true', 18, 37, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('GEO_ZONES', 'true', 18, 38, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('TAX_CLASSES', 'true', 18, 39, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('TAX_RATES', 'true', 18, 40, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('PAYMENT', 'true', 18, 41, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SHIPPING', 'true', 18, 42, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('ORDER_TOTAL', 'true', 18, 43, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MODULE_EXPORT', 'true', 18, 44, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('STATS_PRODUCTS_VIEWED', 'true', 18, 45, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('STATS_PRODUCTS_PURCHASED', 'true', 18, 46, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('STATS_CUSTOMERS', 'true', 18, 47, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SALES_REPORT', 'true', 18, 48, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MODULE_NEWSLETTER', 'true', 18, 49, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONTENT_MANAGER', 'true', 18, 50, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('BACKUP', 'true', 18, 51, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('BANNER_MANAGER', 'true', 18, 52, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('SERVER_INFO', 'true', 18, 53, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('WHOS_ONLINE', 'true', 18, 54, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('FILE_MANAGER', 'true', 18, 55, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CATEGORIES_NOTE', 'true', 18, 56, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CONFIGURATION_NOTE', 'true', 18, 57, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('CUSTOMERS_NOTE', 'true', 18, 58, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('GV_ADMIN_NOTE', 'true', 18, 59, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('LOCALIZATION_NOTE', 'true', 18, 60, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MODULES_NOTE', 'true', 18, 61, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('REPORTS_NOTE', 'true', 18, 62, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('TOOLS_NOTE', 'true', 18, 63, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('STATS_STOCK_WARNING', 'true', 18, 64, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('LAYOUT_CONTROLLER', 'true', 18, 64, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MYSQL', 'true', 18, 65, NULL, now(), NULL, 'twe_cfg_select_option(array(\'true\', \'false\'),');


--------------------

傳送簡訊個人網站
Top
dab_tw
發表於: 2014-05-19, 12:03 PM
引用文章


新進會員
*

所屬群組: 註冊會員
發表總數: 4
會員編號: 14718
註冊日期: --



老爹您好,感謝您的回覆,我這幾天有嘗試用PHPMyAdmin導入,也有出現導入成功畫面:

http://i.imgur.com/9n2gIYa.jpg

不過管理介面還是沒有出現,我是否還有漏掉哪些步驟或是設定呢?
傳送簡訊Email
Top
oldpa
發表於: 2014-05-21, 04:55 PM
引用文章


超級會員
*****

所屬群組: 管理群組
發表總數: 5402
會員編號: 1
註冊日期: --



CODE

INSERT INTO configuration (configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('MENU_TYPE', 'accordion', 1, 28, NULL, now(), NULL, 'twe_cfg_select_option(array(\'tabs\', \'accordion\'),');


再將此CODE導入資料庫

原則上開啟新版TWE3.03的twe_installer/twecommerce.sql
裡面有標註# twe303新增數據開始
比對一下看看缺哪些尚未導入


--------------------

傳送簡訊個人網站
Top
dab_tw
發表於: 2014-05-23, 12:28 PM
引用文章


新進會員
*

所屬群組: 註冊會員
發表總數: 4
會員編號: 14718
註冊日期: --



喔喔喔這次就可以了~

目前測試過大部分管理者頁面的功能都有正常運作,如有檢查出其他BUG的話會再盡速回報,感謝老爹的幫忙~:)
傳送簡訊Email
Top
1 位使用者正在閱讀本主題 (1 位訪客及 0 位匿名使用者)
0 位會員:

主題選項 發表回覆建立主題發起投票