#__hikashop_contact doesn't exists

  • Posts: 8
  • Thank you received: 0
10 years 2 months ago #169382

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.4.29
-- Error-message(debug-mod must be tuned on) -- : Table 'xxx_yyyyy.mrz29_hikashop_contact' doesn't exist SQL=SELECT COUNT(`services_contact`) as total,`services_contact` as name FROM mrz29_hikashop_contact WHERE `services_contact` IS NOT NULL AND `services_contact` != '' GROUP BY `services_contact` ORDER BY total DESC LIMIT 20

All the time that I try edit a field of type singledropdown on the contact, I get this issues. Because the table #__hikashop_contact doesn't exists. There's any sugestion to the corretion for this issues?

Thanks

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169384

Hi,

Please edit the file "administrator/components/com_hikashop/classes/field.php" and replace

		$namekey = hikashop_secureField($field->field_namekey);
		if(empty($order_status)){
			if($table=='item') $table ='order_product';
By
		if($table == 'contact')
			return;
		$namekey = hikashop_secureField($field->field_namekey);
		if(empty($order_status)){
			if($table=='item') $table ='order_product';
It will fix the display of the chart when looking at a contact custom field.
The next HikaShop release will contain the fix and other fixes for the contact custom fields.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: uaigo

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

  • Posts: 8
  • Thank you received: 0
10 years 2 months ago #169394

Jerome,
I added the line at the position you suggested me, and now the edition of the fields works well.

Thanks

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

  • Posts: 8
  • Thank you received: 0
10 years 2 months ago #169395

Jerome,
I have another one problem with the custom field on contact. All the time that I attempt delete a custom field on contact, the Hika tries to alter a table of contact that not exists and causing a error on mysql. Do you have another suggestion of alteration to work around this problem?

Thanks

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169399

Hi,

Yes, that is the other fix I was talking about.
In the same file, replace :

		foreach($fieldsToDelete as $oneField){
			if($oneField->field_type!='customtext'){
				if($oneField->field_table=='item'){
					$namekeys['cart_product'][] = $oneField->field_namekey;
					$namekeys['order_product'][] = $oneField->field_namekey;
				}else{
					$namekeys[$oneField->field_table][] = $oneField->field_namekey;
				}
By
		foreach($fieldsToDelete as $oneField){
			if($oneField->field_type!='customtext'){
				if($oneField->field_table=='item'){
					$namekeys['cart_product'][] = $oneField->field_namekey;
					$namekeys['order_product'][] = $oneField->field_namekey;
				}elseif($oneField->field_table != 'contact'){
					$namekeys[$oneField->field_table][] = $oneField->field_namekey;
				}

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: uaigo

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

  • Posts: 8
  • Thank you received: 0
10 years 2 months ago #169635

Hi Jerome,
Now works well!!

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

Time to create page: 0.059 seconds
Powered by Kunena Forum