[Skip to main content](#vessel-content) # user control panel - view account is broken. ## - **[malicula](/forum/user/2837-malicula "View malicula's Profile")** - [![malicula's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2837-malicula "View malicula's Profile") Topic Author - [ Offline](/forum/user/2837-malicula) Less More - Posts: 8 - Thank you received: 0 - - 15 years 4 months ago [\#19321](#19321) by [malicula](/forum/user/2837-malicula "View malicula's Profile") *[user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#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.")* was created by *[malicula](/forum/user/2837-malicula "View malicula's Profile")* 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. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_06_19_at_2.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_06_19_at_2.png "[img") - [ ![Screen_shot_2011_06_19_at_2.png](/forum/attachment/1316) ](/forum/attachment/1316 "...06_19_at_2.png") [ ](/forum/attachment/1316?download=1 "...06_19_at_2.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 4 months ago [\#19322](#19322) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19322 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[malicula](/forum/user/2837-malicula "View malicula's Profile")** - [![malicula's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2837-malicula "View malicula's Profile") Topic Author - [ Offline](/forum/user/2837-malicula) Less More - Posts: 8 - Thank you received: 0 - - 15 years 4 months ago [\#19323](#19323) by [malicula](/forum/user/2837-malicula "View malicula's Profile") Replied by *[malicula](/forum/user/2837-malicula "View malicula's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19323 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 4 months ago [\#19324](#19324) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19324 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[malicula](/forum/user/2837-malicula "View malicula's Profile")** - [![malicula's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2837-malicula "View malicula's Profile") Topic Author - [ Offline](/forum/user/2837-malicula) Less More - Posts: 8 - Thank you received: 0 - - 15 years 4 months ago [\#19325](#19325) by [malicula](/forum/user/2837-malicula "View malicula's Profile") Replied by *[malicula](/forum/user/2837-malicula "View malicula's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19325 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 4 months ago - 15 years 4 months ago [\#19326](#19326) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19326 "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.")* 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: 15 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Reason: wrong file path... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[malicula](/forum/user/2837-malicula "View malicula's Profile")** - [![malicula's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2837-malicula "View malicula's Profile") Topic Author - [ Offline](/forum/user/2837-malicula) Less More - Posts: 8 - Thank you received: 0 - - 15 years 4 months ago [\#19333](#19333) by [malicula](/forum/user/2837-malicula "View malicula's Profile") Replied by *[malicula](/forum/user/2837-malicula "View malicula's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19333 "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.")* 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](http://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 = "window.addEvent('domready', 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 4 months ago [\#19338](#19338) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: user control panel - view account is broken.](/forum/3-bug-report/19321-user-control-panel-view-account-is-broken#19338 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTMyMS11c2VyLWNvbnRyb2wtcGFuZWwtdmlldy1hY2NvdW50LWlzLWJyb2tlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.055 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)