Page 6 of 13

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Fri Apr 29, 2016 6:55 pm
by pm-netti
discoverytdi wrote:Just ran your upgrade script and am getting the following error/blank page on the shop page A theme has not been assigned to this store admin works fine ::)
Are you removed expired 3 party extensions, also old vqmod/xml files and emptied vqmod cache?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Fri Apr 29, 2016 8:59 pm
by discoverytdi
pm-netti wrote:
discoverytdi wrote:Just ran your upgrade script and am getting the following error/blank page on the shop page A theme has not been assigned to this store admin works fine ::)
Are you removed expired 3 party extensions, also old vqmod/xml files and emptied vqmod cache?
:-[ well that sorted it thanks.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Fri Apr 29, 2016 9:55 pm
by pm-netti
discoverytdi wrote:
pm-netti wrote:
discoverytdi wrote:Just ran your upgrade script and am getting the following error/blank page on the shop page A theme has not been assigned to this store admin works fine ::)
Are you removed expired 3 party extensions, also old vqmod/xml files and emptied vqmod cache?
:-[ well that sorted it thanks.
You can add this to index.php top:

Code: Select all

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Tue May 03, 2016 12:39 pm
by Qphoria
dmsims wrote:Q - When will v7 go into the core?

People are still coming on here (virtually every day) with a failed upgrade
It's in the core but 2.2.0.0 is already released. So not until 2.2.0.1 or whatever release version is next.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Tue May 03, 2016 6:56 pm
by daniel2008
pm-netti wrote:
daniel2008 wrote:the last question?
You can do as you please. Support is found this forum in necessary.
Hi pm-netti,

I've imported the upgraded database to the fresh installed OC V2.200
several times but got the error message on both the store front and admin page.
Even I dropped all tables of the fresh OC V2.200, the problem is the same: both
pages cannot opened with the following errors:
Store Front:
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'v220.oc_extension' doesn't exist<br />Error No: 1146<br />SELECT * FROM oc_extension WHERE `type` = 'openbay'' in E:\xampp\htdocs\v220\system\library\db\mysqli.php:40 Stack trace: #0 E:\xampp\htdocs\v220\system\library\db.php(16): DB\MySQLi->query('SELECT * FROM o...', Array) #1 E:\xampp\htdocs\v220\system\library\openbay.php(117): DB->query('SELECT * FROM o...') #2 E:\xampp\htdocs\v220\system\library\openbay.php(10): Openbay->getInstalled() #3 E:\xampp\htdocs\v220\system\engine\loader.php(94): Openbay->__construct(Object(Registry)) #4 E:\xampp\htdocs\v220\system\framework.php(77): Loader->library('openbay') #5 E:\xampp\htdocs\v220\index.php(22): require_once('E:\xampp\htdocs...') #6 {main} thrown in E:\xampp\htdocs\v220\system\library\db\mysqli.php on line 40

Admin:
Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'v220.oc_setting' doesn't exist<br />Error No: 1146<br />SELECT * FROM oc_setting WHERE store_id = '0'' in E:\xampp\htdocs\v220\system\library\db\mysqli.php:40 Stack trace: #0 E:\xampp\htdocs\v220\system\library\db.php(16): DB\MySQLi->query('SELECT * FROM o...', Array) #1 E:\xampp\htdocs\v220\admin\controller\startup\startup.php(5): DB->query('SELECT * FROM o...') #2 [internal function]: ControllerStartupStartup->index() #3 E:\xampp\htdocs\v220\system\engine\action.php(44): call_user_func_array(Array, Array) #4 E:\xampp\htdocs\v220\system\engine\front.php(34): Action->execute(Object(Registry)) #5 E:\xampp\htdocs\v220\system\engine\front.php(19): Front->execute(Object(Action)) #6 E:\xampp\htdocs\v220\system\framework.php(99): Front->dispatch(Object(Action), Object(Action)) #7 E:\xampp\htdocs\v220\admin\index.php(22): require_once('E:\xampp\htdocs...') #8 {main} thrown in E:\xampp\htdocs\v220\system\library\db\mysqli.php on line 40

I have used OC function for the multi-stores. Maybe that's where the setting errors come from. But I don't know
how to correct it. Can you help me out of this?

Thanks,

Daniel

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Tue May 03, 2016 7:06 pm
by pm-netti
@daniel2008
I do not mean, that I am only to give support :)
Is your DB_PREFIX changed from 'oc_'?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Tue May 03, 2016 7:17 pm
by daniel2008
pm-netti wrote:@daniel2008
I do not mean, that I am only to give support :)
Is your DB_PREFIX changed from 'oc_'?
Hi pm-netti,

Thank you for your quick reply.

I found oc-tables were still there if I only imported the upgraded DB to
the fresh OC V2.200. As a result, the store front and admin page can displays
without errors but only the demo products not mine even I can find my
data in DB. So I dropped all DB tables in the fresh OC V2.200 and imported
my DB. The DB cannot find any oc-tables now but the store front and admin
page can't be opened (with the errors mentioned before).

Thanks,

Daniel

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Thu May 05, 2016 12:00 am
by Qphoria
When you imported your db did you change the prefix at all?
Do you maybe have a prefix defined in the config.php but not in the admin/config.php?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Thu May 05, 2016 6:56 am
by daniel2008
Qphoria wrote:When you imported your db did you change the prefix at all?
Do you maybe have a prefix defined in the config.php but not in the admin/config.php?
Hi Qphoria,

Thank you so much. You're absolute right.
I didn't realize the hint from pm-netti, thanks pm-netti again.

After making a small change of both config.php files (deleting prefix of oc), the store front and
admin pages are back again.

Now I'm going to revise my css to meet V2.200.

Daniel

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Thu May 05, 2016 12:51 pm
by spirit
Qphoria wrote:
dmsims wrote:Q - When will v7 go into the core?

People are still coming on here (virtually every day) with a failed upgrade
It's in the core but 2.2.0.0 is already released. So not until 2.2.0.1 or whatever release version is next.
Great! :)

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Fri May 06, 2016 6:43 pm
by doho
I have tried to upgrade from OC1.5.6.4. to OC 2.2. and didn't worked
This is what I've found in the error_log file>:
[06-May-2016 10:22:45 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load cache adaptor file cache!' in /home/cosmet91/public_html/test/system/library/cache.php:11
Stack trace:
#0 /home/cosmet91/public_html/test/system/framework.php(36): Cache->__construct('file', 3600)
#1 /home/cosmet91/public_html/test/install/index.php(34): require_once('/home/cosmet91/...')
#2 {main}
thrown in /home/cosmet91/public_html/test/system/library/cache.php on line 11
[06-May-2016 10:22:51 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load cache adaptor file cache!' in /home/cosmet91/public_html/test/system/library/cache.php:11
Stack trace:
#0 /home/cosmet91/public_html/test/system/framework.php(36): Cache->__construct('file', 3600)
#1 /home/cosmet91/public_html/test/install/index.php(34): require_once('/home/cosmet91/...')
#2 {main}
thrown in /home/cosmet91/public_html/test/system/library/cache.php on line 11
[06-May-2016 10:25:10 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load cache adaptor file cache!' in /home/cosmet91/public_html/test/system/library/cache.php:11
Stack trace:
#0 /home/cosmet91/public_html/test/system/framework.php(36): Cache->__construct('file', 3600)
#1 /home/cosmet91/public_html/test/install/index.php(34): require_once('/home/cosmet91/...')
#2 {main}
thrown in /home/cosmet91/public_html/test/system/library/cache.php on line 11
Does anyone have any ideea how to solve the problem?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Fri May 06, 2016 11:29 pm
by Qphoria
I've never seen that before. what version were you coming from?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Sat May 07, 2016 2:01 am
by doho
1.5.6.4

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Sat May 07, 2016 10:29 pm
by doho
Any ideea of how to solve the problem?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Sun May 08, 2016 2:07 am
by pm-netti
doho wrote:Any ideea of how to solve the problem?
Are you updated file system/startup.php?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Sun May 08, 2016 3:15 am
by doho
no, I didn't

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Sun May 08, 2016 4:04 pm
by pm-netti
doho wrote:no, I didn't
Uhh, can you upload file system/startup.php to your store?

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Mon May 09, 2016 3:12 am
by doho
Yes, I can. Where i can get the file?

My current startup.php file has the folowing content:

Code: Select all

<?php
// Error Reporting
error_reporting(E_ALL);

// Check Version
if (version_compare(phpversion(), '5.1.0', '<') == true) {
	exit('PHP5.1+ Required');
}

// Register Globals
if (ini_get('register_globals')) {
	ini_set('session.use_cookies', 'On');
	ini_set('session.use_trans_sid', 'Off');

	session_set_cookie_params(0, '/');
	session_start();

	$globals = array($_REQUEST, $_SESSION, $_SERVER, $_FILES);

	foreach ($globals as $global) {
		foreach(array_keys($global) as $key) {
			unset(${$key}); 
		}
	}
}

// Magic Quotes Fix
if (ini_get('magic_quotes_gpc')) {
	function clean($data) {
		if (is_array($data)) {
			foreach ($data as $key => $value) {
				$data[clean($key)] = clean($value);
			}
		} else {
			$data = stripslashes($data);
		}

		return $data;
	}			

	$_GET = clean($_GET);
	$_POST = clean($_POST);
	$_REQUEST = clean($_REQUEST);
	$_COOKIE = clean($_COOKIE);
}

if (!ini_get('date.timezone')) {
	date_default_timezone_set('UTC');
}

// Windows IIS Compatibility  
if (!isset($_SERVER['DOCUMENT_ROOT'])) { 
	if (isset($_SERVER['SCRIPT_FILENAME'])) {
		$_SERVER['DOCUMENT_ROOT'] = str_replace('\\', '/', substr($_SERVER['SCRIPT_FILENAME'], 0, 0 - strlen($_SERVER['PHP_SELF'])));
	}
}

if (!isset($_SERVER['DOCUMENT_ROOT'])) {
	if (isset($_SERVER['PATH_TRANSLATED'])) {
		$_SERVER['DOCUMENT_ROOT'] = str_replace('\\', '/', substr(str_replace('\\\\', '\\', $_SERVER['PATH_TRANSLATED']), 0, 0 - strlen($_SERVER['PHP_SELF'])));
	}
}

if (!isset($_SERVER['REQUEST_URI'])) { 
	$_SERVER['REQUEST_URI'] = substr($_SERVER['PHP_SELF'], 1); 

	if (isset($_SERVER['QUERY_STRING'])) { 
		$_SERVER['REQUEST_URI'] .= '?' . $_SERVER['QUERY_STRING']; 
	} 
}

if (!isset($_SERVER['HTTP_HOST'])) {
	$_SERVER['HTTP_HOST'] = getenv('HTTP_HOST');
}

// Helper
require_once(DIR_SYSTEM . 'helper/json.php'); 
require_once(DIR_SYSTEM . 'helper/utf8.php'); 

// Engine
require_once(DIR_SYSTEM . 'engine/action.php'); 
require_once(DIR_SYSTEM . 'engine/controller.php');
require_once(DIR_SYSTEM . 'engine/front.php');
require_once(DIR_SYSTEM . 'engine/loader.php'); 
require_once(DIR_SYSTEM . 'engine/model.php');
require_once(DIR_SYSTEM . 'engine/registry.php');

// Common
require_once(DIR_SYSTEM . 'library/cache.php');
require_once(DIR_SYSTEM . 'library/url.php');
require_once(DIR_SYSTEM . 'library/config.php');
require_once(DIR_SYSTEM . 'library/db.php');
require_once(DIR_SYSTEM . 'library/document.php');
require_once(DIR_SYSTEM . 'library/encryption.php');
require_once(DIR_SYSTEM . 'library/image.php');
require_once(DIR_SYSTEM . 'library/language.php');
require_once(DIR_SYSTEM . 'library/log.php');
require_once(DIR_SYSTEM . 'library/mail.php');
require_once(DIR_SYSTEM . 'library/pagination.php');
require_once(DIR_SYSTEM . 'library/request.php');
require_once(DIR_SYSTEM . 'library/response.php');
require_once(DIR_SYSTEM . 'library/session.php');
require_once(DIR_SYSTEM . 'library/template.php');
require_once(DIR_SYSTEM . 'library/openbay.php');
require_once(DIR_SYSTEM . 'library/ebay.php');
require_once(DIR_SYSTEM . 'library/amazon.php');
require_once(DIR_SYSTEM . 'library/amazonus.php');
?>

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Mon May 09, 2016 3:52 am
by pm-netti
doho wrote:Yes, I can. Where i can get the file?

My current startup.php file has the folowing content
That is Opencart 1.5.6.4 file. Your need upload startup.php of Oc 2.2.0.0.

Re: 2.2.0.0 Upgrade Script Improvements by Qphoria - TEST PL

Posted: Wed May 11, 2016 3:59 pm
by doho
I did that and after upgrade my browser shows me this error messageȘ
Warning: Missing argument 1 for Cache::__construct(), called in /home/cosmet91/public_html/upgrade/admin/index.php on line 108 and defined in /home/cosmet91/public_html/upgrade/system/library/cache.php on line 5Notice: Undefined variable: adaptor in /home/cosmet91/public_html/upgrade/system/library/cache.php on line 6Notice: Undefined variable: adaptor in /home/cosmet91/public_html/upgrade/system/library/cache.php on line 11
What shoul I do to fix this?