Copying a value in the DB (oc_tb_setting)

ThemeBurn SupportForumsOpenCart ThemesPavilion OpenCart ThemeCopying a value in the DB (oc_tb_setting)

This topic has been marked as not resolved.

Hej ThemBurn-Team,

I created a page using the PageBuilder that I would like to copy to my main store (id=0). Thus, my idea was to take the value for the key “area_content_page_21″ and store_id=1 (in my case it has the setting_id 1326) and copy it to the same key for store=0 (setting_id=1424). Alls this with phpmyadmin. Unfortunately, this doesn’t work. Any idea why?

I can’t use the “Copy to” function in the PageBuilder as it seems that one could just copy things from the main store to other stores, not the other way around. Also I had to insert a backup of my DB as fiddling with the values gave me trouble. So really now after 10 hours of work I only have a txt file on my computer that contains the value for the DB field. But inserting it doesn’t work… :/

Attached you may find the value.

Thanks & best,
Torge

February 4, 2016 at 12:07 am #44676

Hello,

this issue is resolved with the next version of Pavilion, which is due to be released within this month. There you can save pages as templates and load them in any store.

Currently its a little hard to achieve it manually with db editing, because there are internal settings that need to me modified, not just copying rows around. You are free to try the beta or just wait 1-2 weeks for the final release.

Regards,
ThemeBurn team

February 8, 2016 at 11:04 am #44757

Hi ThemeBurn team,

thanks for your feedback. I already read about the Beta in the forum and am looking forward to it. However, as I have lots of custom things in my shop by now I guess switching will be a long and painful process for me :)

Anyway, I got it to work actually. If you copy settings via SQL from one page to another it works:

UPDATE `oc_tb_setting` SET value = (SELECT value FROM oc_tb_setting as c WHERE c.setting_id =1326)
WHERE setting_id = 1424

Only ‘importing’ the setting from the rtf file doesn’t work of course. That one is gone for good.

Thanks & best,
Torge

February 10, 2016 at 10:43 am #44807

Glad that you have resolved the issue. We will leave this post to reference for all that have the same problem prior to upgrading to Pavilion 2.0

Regards,
ThemeBurn team

February 12, 2016 at 5:54 pm #44869
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.