Post by pm-netti » Fri Apr 29, 2016 6:55 pm

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?

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by discoverytdi » Fri Apr 29, 2016 8:59 pm

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.

https://www.rvsolar.co.uk/


User avatar
New member

Posts

Joined
Fri Feb 17, 2012 6:43 am
Location - sunny lancashire UK

Post by pm-netti » Fri Apr 29, 2016 9:55 pm

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);

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by Qphoria » Tue May 03, 2016 12:39 pm

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.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by daniel2008 » Tue May 03, 2016 6:56 pm

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

http://www.smartebuy.com.au/ http://www.myleathers.com.au/ http://www.cctv4oz.com.au/ http://www.origreen.com.au/


Active Member

Posts

Joined
Wed Jul 07, 2010 8:54 pm

Post by pm-netti » Tue May 03, 2016 7:06 pm

@daniel2008
I do not mean, that I am only to give support :)
Is your DB_PREFIX changed from 'oc_'?

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by daniel2008 » Tue May 03, 2016 7:17 pm

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

http://www.smartebuy.com.au/ http://www.myleathers.com.au/ http://www.cctv4oz.com.au/ http://www.origreen.com.au/


Active Member

Posts

Joined
Wed Jul 07, 2010 8:54 pm

Post by Qphoria » Thu May 05, 2016 12:00 am

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?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by daniel2008 » Thu May 05, 2016 6:56 am

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

http://www.smartebuy.com.au/ http://www.myleathers.com.au/ http://www.cctv4oz.com.au/ http://www.origreen.com.au/


Active Member

Posts

Joined
Wed Jul 07, 2010 8:54 pm

Post by spirit » Thu May 05, 2016 12:51 pm

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! :)

Active Member

Posts

Joined
Sat Oct 02, 2010 7:40 am

Post by doho » Fri May 06, 2016 6:43 pm

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?

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm

Post by Qphoria » Fri May 06, 2016 11:29 pm

I've never seen that before. what version were you coming from?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by doho » Sat May 07, 2016 2:01 am

1.5.6.4

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm

Post by doho » Sat May 07, 2016 10:29 pm

Any ideea of how to solve the problem?

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm

Post by pm-netti » Sun May 08, 2016 2:07 am

doho wrote:Any ideea of how to solve the problem?
Are you updated file system/startup.php?

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by doho » Sun May 08, 2016 3:15 am

no, I didn't

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm

Post by pm-netti » Sun May 08, 2016 4:04 pm

doho wrote:no, I didn't
Uhh, can you upload file system/startup.php to your store?

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by doho » Mon May 09, 2016 3:12 am

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');
?>

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm

Post by pm-netti » Mon May 09, 2016 3:52 am

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.

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by doho » Wed May 11, 2016 3:59 pm

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?

Newbie

Posts

Joined
Fri May 06, 2016 6:39 pm
Who is online

Users browsing this forum: No registered users and 19 guests