Post by IP_CAM » Wed Jan 27, 2016 4:07 am

just try one from here, you cannot ruin anything, it either works, or then not.
http://www.opencart.com/index.php?route ... rch=Mysqli

Ernie
openshop.li

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by UVAPE » Mon Feb 01, 2016 7:15 am

Hello

A week or so ago my page stopped working. I would really appreciate any insight or help as to how to fix it. I will try to include as many details as possible. Here we go.

1. I went to my site and noticed the header had an error code in it and some of the shopping cart features seemed a bit buggy as well. Here is the error that was showing in the header

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/uvapeca/public_html/system/database/mysql.php on line 6
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/uvapeca/public_html/system/database/mysql.php:6) in /home/uvapeca/public_html/system/library/session.php on line 11Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/uvapeca/public_html/system/database/mysql.php:6) in /home/uvapeca/public_html/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/uvapeca/public_html/system/database/mysql.php:6) in /home/uvapeca/public_html/index.php on line 179Warning: Cannot modify header information - headers already sent by (output started at /home/uvapeca/public_html/system/database/mysql.php:6) in /home/uvapeca/public_html/system/library/currency.php on line 45Warning: Cannot modify header information - headers already sent by (output started at /home/uvapeca/public_html/system/database/mysql.php:6) in /home/uvapeca/public_html/catalog/controller/journal2/product_tabs.php on line 28 - See more at: http://uvape.ca/ejuice/jc-classic-tobac ... T2j0N.dpuf

2. They sent me here for help viewtopic.php?t=110180#p438507 -- I then tried playing around with the mysqli.php and keep getting different errors now.

3. Seems there is something with the code at the end it does not like. Here is the error that is currently being display on my webpage www.uvape.ca

Parse error: syntax error, unexpected end of file in /home/uvapeca/public_html/system/database/mysqli.php on line 75

4. The CRA are looking for me to file my taxes and I cant get to my reports in my admin panel either because of this error. I would seriously appreciate any help I could get on this. I have tried to fix the error by myself and I fear I am making it worse.

5. Here is what my current mysqli.php file reads.

<?php
if (!class_exists('MySQLi')) {
final class MySQLi{
private $mysqli;

public function __construct($hostname, $username, $password, $database) {
$this->mysqli = new mysqli($hostname, $username, $password, $database);

if ($this->mysqli->connect_error) {
trigger_error('Error: Could not make a database link (' . $this->mysqli->connect_errno . ') ' . $this->mysqli->connect_error);
}

$this->mysqli->query("SET NAMES 'utf8'");
$this->mysqli->query("SET CHARACTER SET utf8");
$this->mysqli->query("SET CHARACTER_SET_CONNECTION=utf8");
$this->mysqli->query("SET SQL_MODE = ''");
}

public function query($sql) {
$result = $this->mysqli->query($sql);



if ($this->mysqli->errno) {
//$mysqli->errno

if (is_resource($resource)) {
$i = 0;

$data = array();

while ($row = $result->fetch_object()) {
$data[$i] = $row;

$i++;
}

$result->close();

$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $result->num_rows;

unset($data);




return $query;
} else {
return true;
}
} {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit();
} }

public function escape($value) {
return $this->mysqli->real_escape_string($value);
}

public function countAffected() {
return $this->mysqli->affected_rows;
}

public function getLastId() {
return $this->mysqli->insert_id;
}

public function __destruct() {
$this->mysqli->close();
}
}
?>

Newbie

Posts

Joined
Mon Feb 01, 2016 4:57 am

Post by IP_CAM » Tue Feb 02, 2016 12:00 am

This is my working v.1.5.6.5_rc File, why not just trying it out ?

Code: Select all

<?php
final class DBMySQLi {
	private $link;

	public function __construct($hostname, $username, $password, $database) {
		$this->link = new mysqli($hostname, $username, $password, $database);

		if (mysqli_connect_error()) {
			trigger_error('Error: Could not make a database link (' . $this->link->connect_errno . ') ' . $this->link->connect_error);
			exit();
		}

		$this->link->set_charset("utf8");
		$this->link->query("SET SQL_MODE = ''");
	}

	public function query($sql) {
		$query = $this->link->query($sql);

		if (!$this->link->errno){
			if (isset($query->num_rows)) {
				$data = array();

				while ($row = $query->fetch_assoc()) {
					$data[] = $row;
				}

				$result = new stdClass();
				$result->num_rows = $query->num_rows;
				$result->row = isset($data[0]) ? $data[0] : array();
				$result->rows = $data;

				unset($data);

				$query->close();

				return $result;
			} else{
				return true;
			}
		} else {
			trigger_error('Error: ' . $this->link->error . '<br />Error No: ' . $this->link->errno . '<br />' . $sql);
			exit();
		}
	}

	public function escape($value) {
		return $this->link->real_escape_string($value);
	}

	public function countAffected() {
		return $this->link->affected_rows;
	}

	public function getLastId() {
		return $this->link->insert_id;
	}

	public function __destruct() {
		$this->link->close();
	}
}
?>
there seem to be something missing, or then at least much different, in yours...

Code: Select all

unset($data);
...
...
...
...
return $query; 
Good Luck
Ernie
openshop.li

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Mon Apr 25, 2016 9:13 pm

I'm running 1.5.4.1 and did all of mysqli upgrade as instructed but I'm still getting the error...

"PHP Unknown: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead"

...on my vqcache files. I deleted the vqcache but they are still occurring. Did I miss a step somewhere?

Thanks
Matt

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Tue Apr 26, 2016 3:06 am

This has actually nothing to do with your Cache Files. You just seem to have the error noted there...
But just download the 3 files below, and try them out, if you have not already done this before:
---
mysqli for opencart V5.5.x (should mean V1.5.5.x, I guess!)
if using this, you have to rename your config.php DB File Name Line from
define('DB_DRIVER', 'mysqli');
to
define('DB_DRIVER', 'mysqliz');
http://www.opencart.com/index.php?route ... n_id=24413
----
MySQLiz - MySQLi support
if using this, you have to rename your config.php DB File Name Line from
define('DB_DRIVER', 'mysqli');
to
define('DB_DRIVER', 'mysqliz');
http://www.opencart.com/index.php?route ... n_id=13041
----
if using this modified russian File, you have to rename your config.php DB File Name Line from
define('DB_DRIVER', 'mysqli');
back to
define('DB_DRIVER', 'mysql');
----
On the Page, press the Buttom on the TOP, called Скачать
after clicking this Link:
https://opencartforum.com/files/file/83 ... B0-mysqli/

Good Luck!
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Tue Apr 26, 2016 6:00 am

Thanks for the reply, Ernie.

I updated to mysqli and am still getting that error.

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Tue Apr 26, 2016 6:49 am

did you try all of those different files and settings?
show me your BOTH config.php entries (exept for passwords!)
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Wed May 04, 2016 4:27 am

Hi Ernie,

Here's my config.php

Code: Select all

<?php
// HTTP
define('HTTP_SERVER', 'http://www.site.com/');
define('HTTP_IMAGE', 'http://www.site.com/image/');
define('HTTP_ADMIN', 'http://www.site.com/admin/');

// HTTPS
define('HTTPS_SERVER', 'https://www.site.com/');
define('HTTPS_IMAGE', 'https://www.site.com/image/');

// DIR
define('DIR_APPLICATION', '/home/site/domains/site.com/public_html/catalog/');
define('DIR_SYSTEM', '/home/site/domains/site.com/public_html/system/');
define('DIR_DATABASE', '/home/site/domains/site.com/public_html/system/database/');
define('DIR_LANGUAGE', '/home/site/domains/site.com/public_html/catalog/language/');
define('DIR_TEMPLATE', '/home/site/domains/site.com/public_html/catalog/view/theme/');
define('DIR_CONFIG', '/home/site/domains/site.com/public_html/system/config/');
define('DIR_IMAGE', '/home/site/domains/site.com/public_html/image/');
define('DIR_CACHE', '/home/site/domains/site.com/public_html/system/cache/');
define('DIR_DOWNLOAD', '/home/site/domains/site.com/public_html/download/');
define('DIR_LOGS', '/home/site/domains/site.com/public_html/system/logs/');

// DB
define('DB_DRIVER', 'mysqliz');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'xxxxxxxx');
define('DB_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxx');
define('DB_PREFIX', 'oc');
?>
Here's my /admin.config.php

Code: Select all

<?php
// HTTP
define('HTTP_SERVER', 'http://www.site.com/admin/');
define('HTTP_CATALOG', 'http://www.site.com/');
define('HTTP_IMAGE', 'http://www.site.com/image/');

// HTTPS
define('HTTPS_SERVER', 'https://www.site.com/admin/');
define('HTTPS_CATALOG', 'https://www.site.com/');
define('HTTPS_IMAGE', 'https://www.site.com/image/');

// DIR
define('DIR_APPLICATION', '/home/site/domains/site.com/public_html/admin/');
define('DIR_SYSTEM', '/home/site/domains/site.com/public_html/system/');
define('DIR_DATABASE', '/home/site/domains/site.com/public_html/system/database/');
define('DIR_LANGUAGE', '/home/site/domains/site.com/public_html/admin/language/');
define('DIR_TEMPLATE', '/home/site/domains/site.com/public_html/admin/view/template/');
define('DIR_CONFIG', '/home/site/domains/site.com/public_html/system/config/');
define('DIR_IMAGE', '/home/site/domains/site.com/public_html/image/');
define('DIR_CACHE', '/home/site/domains/site.com/public_html/system/cache/');
define('DIR_DOWNLOAD', '/home/site/domains/site.com/public_html/download/');
define('DIR_LOGS', '/home/site/domains/site.com/public_html/system/logs/');
define('DIR_CATALOG', '/home/site/domains/site.com/public_html/catalog/');

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'xxxxxxxxxx');
define('DB_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxx');
define('DB_PREFIX', 'oc');
?>
One thing I just noticed...and corrected, was that the admin config file was using "mysql" and not "mysqliz". So I just changed that. Is that correct?

Thanks for taking a look.

Matt

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Wed May 04, 2016 6:42 am

yes, both values have to be the same, in your ROOT + Admin Section config.php.
Other than that, I don't see any other errors.
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Thu May 05, 2016 1:42 am

Still getting this error

Code: Select all

2016-05-04 7:43:02 - PHP Unknown:  mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /usr/home/site/domains/site.com/public_html/vqmod/vqcache/vq2-catalog_controller_common_footer.php on line 29
2016-05-04 7:43:02 - PHP Warning:  mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /usr/home/site/domains/site.com/public_html/vqmod/vqcache/vq2-catalog_controller_common_footer.php on line 29
Not sure what else I can try.

Matt

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Thu May 05, 2016 1:50 am

let us see this file please!
shop/vqmod/vqcache/vq2-catalog_controller_common_footer.php
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Thu May 05, 2016 1:53 am

Code: Select all

<?php   class ControllerCommonFooter extends Controller { 	protected function index() { 		$this->language->load('common/footer'); 
                        $this->load->model('catalog/creator');
			$this->data['forms'] = $this->model_catalog_creator->getActiveForms();
			
		 		$this->data['text_information'] = $this->language->get('text_information'); 		$this->data['text_service'] = $this->language->get('text_service'); 		$this->data['text_extra'] = $this->language->get('text_extra'); 		$this->data['text_contact'] = $this->language->get('text_contact'); 		$this->data['text_return'] = $this->language->get('text_return');     	$this->data['text_sitemap'] = $this->language->get('text_sitemap'); 		$this->data['text_manufacturer'] = $this->language->get('text_manufacturer'); 		$this->data['text_voucher'] = $this->language->get('text_voucher'); 		$this->data['text_affiliate'] = $this->language->get('text_affiliate'); 		$this->data['text_special'] = $this->language->get('text_special'); 		$this->data['text_account'] = $this->language->get('text_account'); 		$this->data['text_order'] = $this->language->get('text_order'); 		$this->data['text_wishlist'] = $this->language->get('text_wishlist'); 		$this->data['text_newsletter'] = $this->language->get('text_newsletter'); 		 		$this->load->model('catalog/information'); 
		 error_reporting(0);	
		 
         if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . DB_PREFIX . "company_details' "))==1){
		 
			//richsnippets code start
	    $this->load->model('richsnippets/richsnippets');  
        $result[]= $this->model_richsnippets_richsnippets->ShowCompanyDetails(); 
         
        if(!empty($result[0])){
			foreach ($result as $results) {
				 
			    $this->data['detail'][] = array(
				        'id'          => $results['id'],
						'company_name'       => $results['company_name'],  
				        'company_country'       => $results['company_country'],  
				    	'company_region'       => $results['company_region'],  
				        'company_locality'       => $results['company_locality'],
				      	'company_postal_code'       => $results['company_postal_code'],
					    'company_address'       => $results['company_address'],
					    'company_tel'       => $results['company_tel'],
					    'company_logo'       => $results['company_logo'],
					    'company_email'       => $results['company_email'],
					    'company_duns'       => $results['company_duns'],
					    'company_gln'       => $results['company_gln'],
					    'company_isicv4'       => $results['company_isicv4'],
					    'company_naics'       => $results['company_naics'],
					    'company_language'       => $results['company_language'],
					    'company_lati'       => $results['company_lati'],
					    'company_long'       => $results['company_long'],
					    'position'       => $results['position']  
			        
				); 
				
			} 
        }
       
        }
     
        
        //richsnippets code end
			
		 		$this->data['informations'] = array();  		foreach ($this->model_catalog_information->getInformations() as $result) { 			if ($result['bottom']) { 
			if (($result['sort_order'] < 0) || ($result['sort_order'] >= 1000)) { continue; }
		    
				$this->data['informations'][] = array( 					'title' => $result['title'], 					'href'  => $this->url->link('information/information', 'information_id=' . $result['information_id']) 				); 			}     	}  		$this->data['contact'] = $this->url->link('information/contact'); 		$this->data['return'] = $this->url->link('account/return/insert', '', 'SSL');     	$this->data['sitemap'] = $this->url->link('information/sitemap'); 		$this->data['manufacturer'] = $this->url->link('product/manufacturer'); 		$this->data['voucher'] = $this->url->link('account/voucher', '', 'SSL'); 		$this->data['affiliate'] = $this->url->link('affiliate/account', '', 'SSL'); 		$this->data['special'] = $this->url->link('product/special'); 		$this->data['account'] = $this->url->link('account/account', '', 'SSL'); 		$this->data['order'] = $this->url->link('account/order', '', 'SSL'); 		$this->data['wishlist'] = $this->url->link('account/wishlist', '', 'SSL'); 		$this->data['newsletter'] = $this->url->link('account/newsletter', '', 'SSL');		  		$this->data['powered'] = sprintf($this->language->get('text_powered'), $this->config->get('config_name'), date('Y', time())); 		 		if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/common/footer.tpl')) { 			$this->template = $this->config->get('config_template') . '/template/common/footer.tpl'; 		} else { 			$this->template = 'default/template/common/footer.tpl'; 		} 		 		$this->render(); 	} } ?>

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Thu May 05, 2016 2:17 am

well, if you clean out this richsnippets Crab, or get it's DB-Access Routine fixed, then, it would function! :D
I figured... DB Access in the footer section ;)
Ernie
PS, I could not help you, when it comes to such DB Stuff, it's just not my thing, :( sorry.

Code: Select all

if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . DB_PREFIX . "company_details' "))==1){
//richsnippets code start
$this->load->model('richsnippets/richsnippets'); 
$result[]= $this->model_richsnippets_richsnippets->ShowCompanyDetails();
---      
---
---
}
//richsnippets code end

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Thu May 05, 2016 3:02 am

This is a file created by the vqmod cache. I can literally delete the file and it comes right back.

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

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

don't JUST delete the cached Vqcache File, remove the VqMod, enabling it!
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by matt71 » Thu May 05, 2016 7:26 am

I'm not really sure what you are telling me. Sorry.

New member

Posts

Joined
Sat Jan 19, 2013 4:13 am

Post by IP_CAM » Thu May 05, 2016 8:57 am

I am just telling you, to simply remove the (possibly) VqMod, or then Module, adding that RICH SNIPPETS Routine to your footer section, as long as you not have the extension fixed, to work with mysqli !
That's all I can tell you on this...
Good Luck!
Ernie

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by blackarch » Fri Jun 03, 2016 10:44 am

I got same issue but, it's happen in admin(back end) & website(front end), after follow some instruction, it's just solved for admin, for front end still error like this :

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/website/website.com/system/database/mysql.php on line 6.

Any one know how to solved this?

This my config (front) :

Code: Select all

<?php
// 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_APPLICATION', '/home/website/website.com/catalog/');
define('DIR_SYSTEM', '/home/website/website.com/system/');
define('DIR_DATABASE', '/home/website/website.com/system/database/');
define('DIR_LANGUAGE', '/home/website/website.com/catalog/language/');
define('DIR_TEMPLATE', '/home/website/website.com/catalog/view/theme/');
define('DIR_CONFIG', '/home/website/website.com/system/config/');
define('DIR_IMAGE', '/home/website/website.com/image/');
define('DIR_CACHE', '/home/website/website.com/system/cache/');
define('DIR_DOWNLOAD', '/home/website/website.com/download/');
define('DIR_LOGS', '/home/website/website.com/system/logs/');

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'xxxxxxxxxx');
define('DB_USERNAME', 'xxxxxxxxxx');
define('DB_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxxx');
define('DB_PREFIX', '');
?>
And this is for config admin :

Code: Select all

<?php
// HTTP
define('HTTP_SERVER', 'http://website.com/bkmanagement/');
define('HTTP_CATALOG', 'http://website.com/');

// HTTPS
define('HTTPS_SERVER', 'http://website.com/bkmanagement/');
define('HTTPS_CATALOG', 'http://website.com/');

// DIR
define('DIR_APPLICATION', '/home/website/website.com/bkmanagement/');
define('DIR_SYSTEM', '/home/website/website.com/system/');
define('DIR_DATABASE', '/home/website/website.com/system/database/');
define('DIR_LANGUAGE', '/home/website/website.com/bkmanagement/language/');
define('DIR_TEMPLATE', '/home/website/website.com/bkmanagement/view/template/');
define('DIR_CONFIG', '/home/website/website.com/system/config/');
define('DIR_IMAGE', '/home/website/website.com/image/');
define('DIR_CACHE', '/home/website/website.com/system/cache/');
define('DIR_DOWNLOAD', '/home/website/website.com/download/');
define('DIR_LOGS', '/home/website/website.com/system/logs/');
define('DIR_CATALOG', '/home/website/website.com/catalog/');

// DB
define('DB_DRIVER', 'mmysqli');
define('DB_HOSTNAME', 'xxxxxxxxxx');
define('DB_USERNAME', 'xxxxxxxxxx');
define('DB_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxxx');
define('DB_PREFIX', '');
?>   

New member

Posts

Joined
Thu Jan 07, 2016 6:00 pm

Post by IP_CAM » Fri Jun 03, 2016 10:52 am

Great ! You use two db-drivers, one for the Admin, and one for the Pack, I guess ! :D

Code: Select all

// DB
define('DB_DRIVER', 'mysql');
// DB
define('DB_DRIVER', 'mmysqli');
what a way, to make a living ! :laugh:

I'm rarely active at the OC Forum lately. To reach me, contact: jti@jacob.ch
A Demoversion of my free OpenCart LIGHT v.1.5.6.5 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
---
1'300+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
---
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by blackarch » Fri Jun 03, 2016 11:06 am

OMG You right, I continue to follow the instructions to change the config, and forget another 1 config, OMG that so embarrassing, but Thx for fast reply ^-^

New member

Posts

Joined
Thu Jan 07, 2016 6:00 pm
Who is online

Users browsing this forum: No registered users and 10 guests