user control panel - view account is broken.

  • Posts: 8
  • Thank you received: 0
12 years 9 months ago #19321

Hi,


I activated the user account. When I click on "view orders" I get an error :

Fatal error: Class '' not found in /home/content/25/7962825/html/home/libraries/joomla/database/database/mysql.php on line 434

Any ideas?

Thank you.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 9 months ago #19322

Hi,

Mmm, looking at the code on that file, I suppose that you're on joomla 1.6, right ?
It also seems that you have something related to joomfish installed on your website although joomfish is not compatible with joomla 1.6. Maybe the joomfish database tables, or a joomfish plugin ? Is that the case ? Could you try to remove what you have related to joomfish if that's the case ?

I might be completely wrong but that's what I see with the small amount of details you gave. If I'm wrong, please give more details on your setup.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
12 years 9 months ago #19323

Correct, i am using joomla 1.6.
I do not have joomfish installed, as you mentioned it is not compatible with this version. I am using M17 instead for multilingual support.

What other details would you like to know? Is there away to just disable the View Orders for now?

Thanks again,
M

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 9 months ago #19324

Please check that you don't have the jos_jf_content table in your database. That's a joomfish table. If you tried to install it once on your website, you should still have that table, and hikashop bases itself on that table to know whether it can use joomfish or not.
If you have it, you can change its name (you could delete it but let's play it safe for know) and that sould solve the problem.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
12 years 9 months ago #19325

I don't feel comfortable to do that... is there a different way to maybe just disable the vie orders option for now?

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 9 months ago #19326

You can remove the line:
$buttons[] = array('link'=>hikashop::completeLink('order'.$url_itemid),'level'=>0,'image'=>'order','text'=>JText::_('ORDERS'),'description'=>'<ul><li>'.JText::_('VIEW_ORDERS').'</li></ul>');
in the file components/com_hikashop/views/user/view.html.php
But you will loose your modification when you update so you will have to reapply it.

Last edit: 12 years 9 months ago by nicolas. Reason: wrong file path...

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
12 years 9 months ago #19333

I can't find this line in the file you mention. This is what's in this fole:

<?php
/**
* @package HikaShop for Joomla!
* @version 1.5.1
* @author hikashop.com
* @copyright (C) 2010-2011 HIKARI SOFTWARE. All rights reserved.
* @license www.hikashop.com/commercial_license.php
*/
defined('_JEXEC') or die('Restricted access');
?>
<?php
class OrderViewOrder extends JView{
var $ctrl= 'order';
var $nameListing = 'ORDERS';
var $nameForm = 'HIKASHOP_ORDER';
var $icon = 'order';
function display($tpl = null,$params=array()){
$this->paramBase = HIKASHOP_COMPONENT.'.'.$this->getName();
$function = $this->getLayout();
$this->params = $params;
if(method_exists($this,$function)) $this->$function();
parent::display($tpl);
}
function listing(){
$app =& JFactory::getApplication();
$pageInfo = null;
$pageInfo->filter->order->value = $app->getUserStateFromRequest( $this->paramBase.".filter_order", 'filter_order', 'a.order_created','cmd' );
$pageInfo->filter->order->dir = $app->getUserStateFromRequest( $this->paramBase.".filter_order_Dir", 'filter_order_Dir', 'desc', 'word' );
$pageInfo->search = $app->getUserStateFromRequest( $this->paramBase.".search", 'search', '', 'string' );
$pageInfo->search = JString::strtolower( $pageInfo->search );
$pageInfo->limit->value = $app->getUserStateFromRequest( $this->paramBase.'.list_limit', 'limit', $app->getCfg('list_limit'), 'int' );
$pageInfo->limit->start = $app->getUserStateFromRequest( $this->paramBase.'.limitstart', 'limitstart', 0, 'int' );
$database =& JFactory::getDBO();
$searchMap = array('a.order_id','a.order_status');
$filters = array('a.order_user_id='.(int)hikashop::loadUser());
$order = '';
if(!empty($pageInfo->filter->order->value)){
$order = ' ORDER BY '.$pageInfo->filter->order->value.' '.$pageInfo->filter->order->dir;
}
if(!empty($pageInfo->search)){
$searchVal = '\'%'.$database->getEscaped(JString::strtolower( $pageInfo->search ),true).'%\'';
$id = hikashop::decode($pageInfo->search);
$filter = implode(" LIKE $searchVal OR ",$searchMap)." LIKE $searchVal";
if(!empty($id)){
$filter .= " OR a.order_id LIKE '%".$database->getEscaped($id,true).'%\'';
}
$filters[] = $filter;
}
$query = 'FROM '.hikashop::table('order').' AS a WHERE '.implode(' AND ',$filters).$order;
$database->setQuery('SELECT a.* '.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value);
$rows = $database->loadObjectList();
if(!empty($pageInfo->search)){
$rows = hikashop::search($pageInfo->search,$rows,'order_id');
}
$database->setQuery('SELECT COUNT(*) '.$query);
$pageInfo->elements->total = $database->loadResult();
$pageInfo->elements->page = count($rows);
$currencyClass = hikashop::get('class.currency');
$this->assignRef('currencyHelper',$currencyClass);
if($pageInfo->elements->page){
}else{
$app =& JFactory::getApplication();
$app->enqueueMessage(JText::_('NO_ORDERS_FOUND'));
}
jimport('joomla.html.pagination');
$pagination = new JPagination( $pageInfo->elements->total, $pageInfo->limit->start, $pageInfo->limit->value );
$this->assignRef('pagination',$pagination);
$this->assignRef('pageInfo',$pageInfo);
$string='';
jimport('joomla.html.parameter');
$params = new JParameter($string);
$params->set('show_quantity_field',0);
$config =& hikashop::config();
if(hikashop::level(1) && $config->get('allow_payment_button',1)){
$default_status = $config->get('order_created_status','created');
foreach($rows as $k => $order){
if($order->order_status==$default_status){
$rows[$k]->show_payment_button = true;
}
}
$payment_change = $config->get('allow_payment_change',1);
$this->assignRef('payment_change',$payment_change);
$pluginsPayment = hikashop::get('type.plugins');
$pluginsPayment->type='payment';
$this->assignRef('payment',$pluginsPayment);
}
$this->assignRef('params',$params);
$this->assignRef('rows',$rows);
$cart = hikashop::get('helper.cart');
$this->assignRef('cart',$cart);
$category = hikashop::get('type.categorysub');
$category->type = 'status';
$category->load(true);
$this->assignRef('order_statuses',$category);
}
function show(){
$type = 'order';
$order =& $this->_order($type);
$config =& hikashop::config();
$download_time_limit = $config->get('download_time_limit',0);
$this->assignRef('download_time_limit',$download_time_limit);
$download_number_limit = $config->get('download_number_limit',0);
$this->assignRef('download_number_limit',$download_number_limit);
$order_status_download_ok=false;
$order_status_for_download = $config->get('order_status_for_download','confirmed,shipped');
if(in_array($order->order_status,explode(',',$order_status_for_download))){
$order_status_download_ok=true;
}
$this->assignRef('order_status_download_ok',$order_status_download_ok);
$this->assignRef('config',$config);
JHTML::_('behavior.modal');
}
function invoice(){
$type = 'invoice';
$this->setLayout('show');
$order =& $this->_order($type);
$js = "do_nothing( function() {window.print();setTimeout(function(){try{ window.top.document.getElementById('sbox-window').close(); }catch(err){ window.top.SqueezeBox.close(); }}, 50);});";
$doc =& JFactory::getDocument();
$doc->addScriptDeclaration("<!--\n".$js."\n//-->");
JHTML::_('behavior.mootools');
}
function &_order($type){
$order_id = hikashop::getCID('order_id');
if(!empty($order_id)){
$class = hikashop::get('class.order');
$order = $class->loadFullOrder($order_id,($type=='order'?true:false));
}
if(empty($order)){
$app =& JFactory::getApplication();
$app->redirect(hikashop::completeLink('order&task=listing',false,true));
}
$config =& hikashop::config();
$store = str_replace(array("\r\n","\n","\r"),array('<br/>','<br/>','<br/>'),$config->get('store_address',''));
$this->assignRef('store_address',$store);
$this->assignRef('element',$order);
$this->assignRef('order',$order);
$this->assignRef('invoice_type',$type);
$display_type = 'frontcomp';
$this->assignRef('display_type',$display_type);
$currencyClass = hikashop::get('class.currency');
$this->assignRef('currencyHelper',$currencyClass);
$fieldsClass = hikashop::get('class.field');
$this->assignRef('fieldsClass',$fieldsClass);
$fields = array();
if(hikashop::level(2)){
$null = null;
$fields = $fieldsClass->getData('frontcomp',$null,'entry');
$fields = $fieldsClass->getFields('frontcomp',$null,'item');
$fields = $fieldsClass->getFields('',$null,'order');
}
$this->assignRef('fields',$fields);
return $order;
}
}

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 9 months ago #19338

Indeed. It was not the correct path I gave you. It should have been:
components/com_hikashop/views/user/view.html.php

Please Log in or Create an account to join the conversation.

Time to create page: 0.071 seconds
Powered by Kunena Forum