*

rejja

  • ***
  • 26 posts
How the title says i switched from Zara theme to Veronika and now the phone numbers doesn't display. It says no phone number.
Can you help me please?

*

Ivanko

  • *****
  • 391 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #1 on: May 04, 2017, 06:21:44 AM »
In veronika phones are storing in user profile.
If your phones in custom fields you need to transfer them in sql from custom fields into users profile.
« Last Edit: May 04, 2017, 06:28:51 AM by Ivanko »

*

rejja

  • ***
  • 26 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #2 on: May 04, 2017, 06:36:47 AM »
Hi, can you help me with a tutorial. Thank you very much

*

Ivanko

  • *****
  • 391 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #3 on: May 04, 2017, 06:51:51 AM »
If your phones in custom fields you can try update table in sql and grab phones from other table.

https://www.w3schools.com/sql/sql_update.asp
« Last Edit: May 04, 2017, 08:50:07 AM by Ivanko »

*

rejja

  • ***
  • 26 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #4 on: May 04, 2017, 07:58:36 AM »
Hi, did you received my pm message?

*

MB Themes

Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #5 on: May 04, 2017, 09:43:04 AM »
Phones in user profile are ok and will not change, only phones on items will disappear, as veronika use own table for storing phones.

Best way to migrate is to:
1) Export fk_i_item_id, s_city_area columns from table t_item_location
2) In exported .sql modify naming of column s_city_area to s_phone and table name from t_item_location to t_item_veronika
3) Import this file back to table t_item_veronika
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

apibio

  • ***
  • 68 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #6 on: September 01, 2017, 12:34:33 PM »
Be clearer ..... I can not understand exactly how and how to change and after all I should not be able to modify these things myself. :(

*

apibio

  • ***
  • 68 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #7 on: September 02, 2017, 04:56:51 PM »
Please help me.

*

MB Themes

Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #8 on: September 02, 2017, 05:05:18 PM »
@apibio
Above mentioned procedure must be done in MySQL.


You can do it in different way as well.

Go to file:
oc-content/themes/veronika/item.php

Find line:
Code: [Select]
    if($mobile == '' && osc_item_user_id() <> 0) { $mobile = $item_user['s_phone_mobile']; }     

Replace it with:
Code: [Select]
    if($mobile == '') { $mobile = osc_item_city_area(); }     
    if($mobile == '' && osc_item_user_id() <> 0) { $mobile = $item_user['s_phone_mobile']; }     
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

apibio

  • ***
  • 68 posts
Re: Switched from Zara to Veronika - Phone numbers doesn't display
« Reply #9 on: September 02, 2017, 05:35:45 PM »
It was very easy, thank you very much :)