Current PHP version: 5.6.31, I following from here http://docs.opencart.com/upgrading/ for upgrade version
What i did :
1. Set backup current mysql/OC
2. Turn off the module (actually I not use any single module)
3. Upload the file to website (front & back end).
4. Set the admin/config & config.
I got 4 Error in my front end website :
1. Notice: Use of undefined constant DIR_STORAGE - assumed 'DIR_STORAGE' in /home/website/website.com/system/startup.php on line 70
2. (This loop 7 - 10) Notice: Use of undefined constant DIR_MODIFICATION - assumed 'DIR_MODIFICATION' in bla bla bla
3. Notice: Use of undefined constant DB_PORT - assumed 'DB_PORT' in /home/website/website.com/system/config/catalog.php on line 16
4. Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load database adaptor mmysqli!' in /home/website/website.com/system/library/db.php .bla bla bla
To fix it :
1-4. Change both config, follow this link https://github.com/opencart/opencart/issues/5688 (Same Case)
Note :
1. Actually this //DIR DIR_DATABASE is gone(in 3.0.1.2)(Both config) ? should i keep it(old version)/remove it from (Both Config ?)
,2. Front-end Config : Change the the url 'DIR_CATALOG'
3. It's okay for change (old) define('DB_DRIVER', 'mmysqli'); to (new) define('DB_DRIVER', 'mysqli');
4. Both Config : I still keep the define('DB_PREFIX', ''); since change to define('DB_PREFIX', 'oc_'); got error
like this : Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'website.oc_session' doesn't exist bla bla blaNext the new error :
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'website_db.session' doesn't exist<br />Error No: 1146<br />SELECT `data` FROM `session` WHERE session_id = bla bla bla
I Add new table in my DB :
Code: Select all
CREATE TABLE `session` (
`session_id` varchar(32) NOT NULL,
`data` text NOT NULL,
`expire` datetime NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;1. Warning: require_once(/system/startup.php): failed to open stream: No such file or directory in /home/website/website.com/admin/index.php on line 17
2. Fatal error: require_once(): Failed opening required '/system/startup.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/website/website.com/admin/index.php on line 17
Current Error Website :
1. Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'website.translation' doesn't exist<br />Error No: 1146<br />SELECT * FROM translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')' in /home/website/website.com/system/library/db/mysqli.php:40 Stack trace: #0 /home/website/website.com/system/library/db.php(16): DB\MySQLi->query('SELECT * FROM t...', Array) #1 /home/website/website.com/catalog/model/design/translation.php(6): DB->query('SELECT * FROM t...') #2 [internal function]: ModelDesignTranslation->getTranslations('engb') #3 /home/website/website.com/system/engine/loader.php(185): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /home/website/website.com/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #6 /home/website/website.com/catalog/controller/event/translation.php(6): Proxy->__call('getTranslations', Array) #7 /home/website/website.com/catalo in /home/website/website.com/system/library/db/mysqli.php on line 40
I need to build table for translation, but idk the structure table.
Now I stuck with this error, did I make mistake from the upgrade?
, This is my Both Config :
Code: Select all
<?php
//Front-End /Website
// HTTP
define('HTTP_SERVER', 'http://website.com/');
define('HTTP_IMAGE', 'http://website.com/image/');
define('HTTP_ADMIN', 'http://website.com/admin/');
define('HTTP_TEMPLATE', 'http://website.com/catalog/view/theme/');
// HTTPS
define('HTTPS_SERVER', 'http://website.com/');
define('HTTPS_IMAGE', 'http://website.com/image/');
// DIR
define('DIR_DATABASE', '/home/website/website.com/system/database/');
define('DIR_APPLICATION', str_replace('\\', '/', realpath(dirname(__FILE__))) . '/catalog/');
define('DIR_SYSTEM', str_replace('\\', '/', realpath(dirname(__FILE__))) . '/system/');
define('DIR_IMAGE', str_replace('\\', '/', realpath(dirname(__FILE__))) . '/image/');
define('DIR_STORAGE', DIR_SYSTEM . 'storage/');
define('DIR_LANGUAGE', DIR_APPLICATION . 'language/');
define('DIR_TEMPLATE', DIR_APPLICATION . 'view/theme/');
define('DIR_CONFIG', DIR_SYSTEM . 'config/');
define('DIR_CACHE', DIR_STORAGE . 'cache/');
define('DIR_DOWNLOAD', DIR_STORAGE . 'download/');
define('DIR_LOGS', DIR_STORAGE . 'logs/');
define('DIR_MODIFICATION', DIR_STORAGE . 'modification/');
define('DIR_SESSION', DIR_STORAGE . 'session/');
define('DIR_UPLOAD', DIR_STORAGE . 'upload/');
// DB
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', 'mysql.website.com');
define('DB_USERNAME', 'website16');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'website');
define('DB_PORT', '3306');
define('DB_PREFIX', '');
// Config Admin/Back-end
// HTTP
define('HTTP_SERVER', 'http://website.com/website/');
define('HTTP_CATALOG', 'http://website.com/');
// HTTPS
define('HTTPS_SERVER', 'http://website.com/website/');
define('HTTPS_CATALOG', 'http://website.com/');
// DIR
define('DIR_DATABASE', '/home/website/website.com/system/database/');
define('DIR_APPLICATION', str_replace('\\', '/', realpath(dirname(__FILE__))) . '/');
define('DIR_SYSTEM', str_replace('\\', '/', realpath(dirname(__FILE__) . '../')) . '/system/');
define('DIR_IMAGE', str_replace('\\', '/', realpath(dirname(__FILE__) . '../')) . '/image/');
define('DIR_STORAGE', DIR_SYSTEM . 'storage/');
define('DIR_CATALOG', '/home/website/website.com/upload/catalog/');
define('DIR_LANGUAGE', DIR_APPLICATION . 'language/');
define('DIR_TEMPLATE', DIR_APPLICATION . 'view/template/');
define('DIR_CONFIG', DIR_SYSTEM . 'config/');
define('DIR_CACHE', DIR_STORAGE . 'cache/');
define('DIR_DOWNLOAD', DIR_STORAGE . 'download/');
define('DIR_LOGS', DIR_STORAGE . 'logs/');
define('DIR_MODIFICATION', DIR_STORAGE . 'modification/');
define('DIR_SESSION', DIR_STORAGE . 'session/');
define('DIR_UPLOAD', DIR_STORAGE . 'upload/');
// DB
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', 'mysql.website.com');
define('DB_USERNAME', 'website16');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'website');
define('DB_PREFIX', '');
define('DB_PORT', '3306');
// OpenCart API
define('OPENCART_SERVER', 'https://www.opencart.com/');
?>
