The admin panel hangs in the opencart at the entrance.

5/51 rating

Recently, very often the situation is that when you try to enter the admin panel of the online store on the opencart page freezes and then issues a variety of errors, for example, you may receive a 500 or 504 error, that is, the timeout has worked and the connection has been reset.

What is the reason for the error in logging in to the admin panel of Opencart?

It's simple, if you have several types of currencies in the store, then you want the exchange rate to be updated automatically, there is a special function that updates the exchange rate from the Yahoo service at every login to the store admin area. You can either enable automatic updating or turn it off.

If you have automatic updating of currencies in opencart is turned on then your store tries to update the exchange rate when entering the admin panel and refers to the above service, which just causes this error.

If you do not need to automatically update the exchange rate, you change the exchange rate yourself, the simplest solution is to turn off currency updates in the admin panel of opencart. But since you can not enter the admin panel to disable it, just go to any other section, and after you go to the settings and turn off the update, for example, you can go to the category page like this:

http://vach-domen.ru/admin/index.php?route=catalog/category&token=9dd715885c7c3d38fac8e4ada1bf4039

1	http://vach-domen.ru/admin/index.php?route=catalog/category&token=9dd715885c7c3d38fac8e4ada1bf4039

Since the example specifies a completely different token, you will be asked to authorize again, after authorization, you will immediately go to the category section, after you go to the settings and in the localization section turn off the Automatic currency update, the page will probably hang again, but you will not be affected by the settings you can already log in as usual.

But what if automatic currency updates are important to you?

In this case, there are several options for fixing this situation, and now we will look at each of the methods how to fix the error in entering the admin panel in opencart.

1. And so, we will consider the first variant of the decision of problems with an input in the admin panel:

Our task is to make changes to the file /admin/model/localisation/currency.php, we need to add return to the call request. (PS: return returns the result of the function's operation to the place where it was called.)

And so we opened the above file and find in it about 104 lines:

public function updateCurrencies($force = false) {

1	public function updateCurrencies($force = false) {

and immediately under this line we insert:

return;

return;

That is, we completely disable automatic currency updates. (For those to whom the automatic update still needs this method is not suitable).

Please note - that in some versions the code may differ slightly, for example the above function updateCurrencies can be without $force = false, but it's not important and return is still inserted under this function.

2. Now let's look at the second option for solving the problems of entering the admin panel of the store.

In this example, we specify the time when, in the case of a freeze, the update from Yahoo breaks and skips the update attempt and immediately proceeds to the administrative panel of the store. For this method, open the same file /admin/model/localisation/currency.php and in it we find the line:

curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

1	curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

And immediately after it we insert:

curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 4); //We are waiting for 4 seconds, after we go to the admin area
curl_setopt($curl, CURLOPT_TIMEOUT,4);

1 2	curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 4); //We are waiting for 4 seconds, after we go to the admin area curl_setopt($curl, CURLOPT_TIMEOUT,4);

3. Well, the most recent third option will not be editing and adjusting for the Yahoo service, but completely changing the automatic updating of the opencart exchange rates from Yahoo to the CBRF. That is now Opencart will be updated from the courses of the Central Bank of Russia.

This method was kindly provided by one of the users of the Russian-language forum Opencart.

And so, in order to update the currency exchange rates with the CBRF in opencart, you will need all the same /admin/model/localisation/currency.php, only we will not change some parts of the code in it but delete everything completely and replace it with it all the contents of the code below:

<?php
class ModelLocalisationCurrency extends Model {
	public function addCurrency($data) {
		$this->db->query("INSERT INTO " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW()");

		$this->cache->delete('currency');
	}
	
	public function editCurrency($currency_id, $data) {
		$this->db->query("UPDATE " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW() WHERE currency_id = '" . (int)$currency_id . "'");

		$this->cache->delete('currency');
	}
	
	public function deleteCurrency($currency_id) {
		$this->db->query("DELETE FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'");
	
		$this->cache->delete('currency');
	}

	public function getCurrency($currency_id) {
		$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'");
		return $query->row;
	}
	
	public function getCurrencyByCode($currency) {
		$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($currency) . "'");
		return $query->row;
	}
		
	public function getCurrencies($data = array()) {
		if ($data) {
			$sql = "SELECT * FROM " . DB_PREFIX . "currency";

			$sort_data = array(
				'title',
				'code',
				'value',
				'date_modified'
			);	
			
			if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
				$sql .= " ORDER BY " . $data['sort'];	
			} else {
				$sql .= " ORDER BY title";	
			}
			
			if (isset($data['order']) && ($data['order'] == 'DESC')) {
				$sql .= " DESC";
			} else {
				$sql .= " ASC";
			}
			
			if (isset($data['start']) || isset($data['limit'])) {
				if ($data['start'] < 0) {
					$data['start'] = 0;
				}				

				if ($data['limit'] < 1) {
					$data['limit'] = 20;
				}	
			
				$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
			}
			
			$query = $this->db->query($sql);
	
			return $query->rows;
		} else {
			$currency_data = $this->cache->get('currency');

			if (!$currency_data) {
				$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency ORDER BY title ASC");
	
				foreach ($query->rows as $result) {
      				$currency_data[$result['code']] = array(
        				'currency_id'   => $result['currency_id'],
        				'title'         => $result['title'],
        				'code'          => $result['code'],
						'symbol_left'   => $result['symbol_left'],
						'symbol_right'  => $result['symbol_right'],
						'decimal_place' => $result['decimal_place'],
						'value'         => $result['value'],
						'status'        => $result['status'],
						'date_modified' => $result['date_modified']
      				);
    			}	
			
				$this->cache->set('currency', $currency_data);
			}
			
			return $currency_data;			
		}
	}

	public function updateCurrencies() {
	
	$query = $this->db->query("SELECT date_modified FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'");
	$cc_value = $this->db->query("SELECT value FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'");
	$i = 0;
	foreach ($query->rows as $mdate) {
		if($this->db->escape(date('Y-m-d',strtotime($mdate['date_modified']))) < $this->db->escape(date('Y-m-d', strtotime('now')))) $i++;
	}
	$manual_update = isset($this->request->post['manual_update']) ? $this->request->post['manual_update'] : false;
	if ($i || $cc_value->row['value'] != 1.00000 || $manual_update)	{
	$url = 'http://www.cbr.ru/scripts/XML_daily.asp';
	$answer = $this->CheckHttpStatus($url);
	$this->log->write('Обновление валют: ');
	if ($answer != 200) {
		$this->log->write(" > не удалось загрузить курсы валют, ответ сервера:" . $answer);
	} else {
	
		if (extension_loaded('curl')) {
			$data = array();
						
			$ch = curl_init();
			curl_setopt($ch, CURLOPT_URL, 'http://www.cbr.ru/scripts/XML_daily.asp');
			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
			$content = curl_exec($ch);
			curl_close($ch);

			$doc = new DOMDocument();
			$doc->loadXML($content);
			
			$root = $doc->documentElement;
			$curs_date = $root->getAttribute('Date');
			$this->log->write(" > успешно загружены курсы валют на: ". $curs_date);
			
			$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'");

			$valutes = $doc->getElementsByTagName("Valute");
			$ret = array();

			foreach( $valutes as $valute )
			{
				$icn = $valute->childNodes;
				$code = $icn->item(1)->nodeValue;
				$nom = intval($icn->item(2)->nodeValue);
				$value = floatval(str_replace(",", "." , $icn->item(4)->nodeValue));
				$ret[$code] = ($value/$nom);
			}
			
			$cur_val = $this->config->get('config_currency');
			
			if ($cur_val == 'RUB') {
			foreach ($query->rows as $result) {
			 if($ret[$result['code']]){
				$value = 1 / $ret[$result['code']];

				if ((float)$value) {
					$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = NOW() WHERE code = '" . $this->db->escape($result['code']) . "'");
				}
			 }
			}
			
			} else {
			
			foreach ($query->rows as $result) {
			    if($result['code'] == 'RUB') {
				$value = $ret[$cur_val];
				if ((float)$value) {
				    $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = NOW() WHERE code = 'RUB'");
				}
				} else {
				    $value = $ret[$result['code']];
				    if ((float)$value) {
					$val = (float)$ret[$cur_val] / (float)$value;
				        $this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . $val . "', date_modified = NOW() WHERE code = '" . $this->db->escape($result['code']) . "'");
				    }
				}
			}
			}
			
			$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '1.00000', date_modified = NOW() WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'");
			
			$this->cache->delete('currency');

		}
	} }
	
	}

public function CheckHttpStatus($url) {
  $user_agent = 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)';
  $ch = curl_init();
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_USERAGENT, $user_agent);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_VERBOSE, false);
  curl_setopt($ch, CURLOPT_TIMEOUT, 10);
  curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  curl_setopt($ch, CURLOPT_SSLVERSION, 3);
  curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  $page = curl_exec($ch);

  $err = curl_error($ch);
  if (!empty($err)) return $err;
  
  $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
  curl_close($ch);
  return $httpcode;
  }	
	
	public function getTotalCurrencies() {
		$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "currency");
		
		return $query->row['total'];
	}
}
?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

<?php

class ModelLocalisationCurrency extends Model {

public function addCurrency($data) {

$this->db->query("INSERT INTO " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW()");

$this->cache->delete('currency');

}

public function editCurrency($currency_id, $data) {

$this->db->query("UPDATE " . DB_PREFIX . "currency SET title = '" . $this->db->escape($data['title']) . "', code = '" . $this->db->escape($data['code']) . "', symbol_left = '" . $this->db->escape($data['symbol_left']) . "', symbol_right = '" . $this->db->escape($data['symbol_right']) . "', decimal_place = '" . $this->db->escape($data['decimal_place']) . "', value = '" . $this->db->escape($data['value']) . "', status = '" . (int)$data['status'] . "', date_modified = NOW() WHERE currency_id = '" . (int)$currency_id . "'");

$this->cache->delete('currency');

}

public function deleteCurrency($currency_id) {

$this->db->query("DELETE FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'");

$this->cache->delete('currency');

}

public function getCurrency($currency_id) {

$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE currency_id = '" . (int)$currency_id . "'");

return $query->row;

}

public function getCurrencyByCode($currency) {

$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($currency) . "'");

return $query->row;

}

public function getCurrencies($data = array()) {

if ($data) {

$sql = "SELECT * FROM " . DB_PREFIX . "currency";

$sort_data = array(

'title',

'code',

'value',

'date_modified'

);

if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {

$sql .= " ORDER BY " . $data['sort'];

} else {

$sql .= " ORDER BY title";

}

if (isset($data['order']) && ($data['order'] == 'DESC')) {

$sql .= " DESC";

} else {

$sql .= " ASC";

}

if (isset($data['start']) || isset($data['limit'])) {

if ($data['start'] < 0) {

$data['start'] = 0;

}

if ($data['limit'] < 1) {

$data['limit'] = 20;

}

$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];

}

$query = $this->db->query($sql);

return $query->rows;

} else {

$currency_data = $this->cache->get('currency');

if (!$currency_data) {

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency ORDER BY title ASC");

foreach ($query->rows as $result) {

$currency_data[$result['code']] = array(

'currency_id' => $result['currency_id'],

'title' => $result['title'],

'code' => $result['code'],

'symbol_left' => $result['symbol_left'],

'symbol_right' => $result['symbol_right'],

'decimal_place' => $result['decimal_place'],

'value' => $result['value'],

'status' => $result['status'],

'date_modified' => $result['date_modified']

);

}

$this->cache->set('currency', $currency_data);

}

return $currency_data;

}

public function updateCurrencies() {

$query = $this->db->query("SELECT date_modified FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'");

$cc_value = $this->db->query("SELECT value FROM " . DB_PREFIX . "currency WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'");

$i = 0;

foreach ($query->rows as $mdate) {

if($this->db->escape(date('Y-m-d',strtotime($mdate['date_modified']))) < $this->db->escape(date('Y-m-d', strtotime('now')))) $i++;

}

$manual_update = isset($this->request->post['manual_update']) ? $this->request->post['manual_update'] : false;

if ($i || $cc_value->row['value'] != 1.00000 || $manual_update) {

$url = 'http://www.cbr.ru/scripts/XML_daily.asp';

$answer = $this->CheckHttpStatus($url);

$this->log->write('Обновление валют: ');

if ($answer != 200) {

$this->log->write(" > не удалось загрузить курсы валют, ответ сервера:" . $answer);

} else {

if (extension_loaded('curl')) {

$data = array();

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, 'http://www.cbr.ru/scripts/XML_daily.asp');

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$content = curl_exec($ch);

curl_close($ch);

$doc = new DOMDocument();

$doc->loadXML($content);

$root = $doc->documentElement;

$curs_date = $root->getAttribute('Date');

$this->log->write(" > успешно загружены курсы валют на: ". $curs_date);

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "currency WHERE code != '" . $this->db->escape($this->config->get('config_currency')) . "'");

$valutes = $doc->getElementsByTagName("Valute");

$ret = array();

foreach( $valutes as $valute )

{

$icn = $valute->childNodes;

$code = $icn->item(1)->nodeValue;

$nom = intval($icn->item(2)->nodeValue);

$value = floatval(str_replace(",", "." , $icn->item(4)->nodeValue));

$ret[$code] = ($value/$nom);

}

$cur_val = $this->config->get('config_currency');

if ($cur_val == 'RUB') {

foreach ($query->rows as $result) {

if($ret[$result['code']]){

$value = 1 / $ret[$result['code']];

if ((float)$value) {

$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = NOW() WHERE code = '" . $this->db->escape($result['code']) . "'");

}

} else {

foreach ($query->rows as $result) {

if($result['code'] == 'RUB') {

$value = $ret[$cur_val];

if ((float)$value) {

$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . (float)$value . "', date_modified = NOW() WHERE code = 'RUB'");

}

} else {

$value = $ret[$result['code']];

if ((float)$value) {

$val = (float)$ret[$cur_val] / (float)$value;

$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '" . $val . "', date_modified = NOW() WHERE code = '" . $this->db->escape($result['code']) . "'");

}

$this->db->query("UPDATE " . DB_PREFIX . "currency SET value = '1.00000', date_modified = NOW() WHERE code = '" . $this->db->escape($this->config->get('config_currency')) . "'");

$this->cache->delete('currency');

}

} }

}

public function CheckHttpStatus($url) {

$user_agent = 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)';

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);

curl_setopt($ch, CURLOPT_USERAGENT, $user_agent);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($ch, CURLOPT_VERBOSE, false);

curl_setopt($ch, CURLOPT_TIMEOUT, 10);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

curl_setopt($ch, CURLOPT_SSLVERSION, 3);

curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);

$page = curl_exec($ch);

$err = curl_error($ch);

if (!empty($err)) return $err;

$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

curl_close($ch);

return $httpcode;

}

public function getTotalCurrencies() {

$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "currency");

return $query->row['total'];

}

Now every time you enter the administrative panel of the store, the site will update the exchange rate from the XML file that is generated by the central bank of Russia.

PS: Note, to use this method, you must have PHP modules such as curl and simplexml on your hosting.

Well, that's all, now you know how to overcome the error in entering the admin panel associated with updating the exchange rate. Good luck to you.