Do you have any other mods insalled that have modified the core files?
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
All that I did, was upload, installl, enable, go to a product listing and added text in the new tab. Saved changes and when I went view it I got this error .
Error No: 1064
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM product_to_category p2c WHERE ) in /home/content/13/6473013/html/gemoc/system/database/mysql.php on line 49
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
I had that strange premonition, this was the cause....bull5-i wrote:Then why are using a mod for 1.5.1.1 which is different from 1.5.1.3.1 in many ways and would brake the OC. Please get the correct version.
OC version 1.5.4.1
How would I locate that ?
Notice: Error: Duplicate column name 'specs'
Error No: 1060
ALTER TABLE product_description ADD specs TEXT NOT NULL in /home/content/13/6473013/html/gemoc/system/database/mysql.php on line 49
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
bull5-i wrote:In catalog/controller/product/product.php is the evaluation of
$this->data['cpt_show'] = ....
This is (probably for your case) the only variable that is checked to display or not to display the tabs. You would have to make a separate variable for each tab if you want individual control for the tabs.
Hi Mate,
Below you can find my code in catalog/controller/product/product.php. I added these line 2 weeks ago or so.
Can to tell me what to do to hide the tab titled "specs6"? This tab is empy yet, but i might need it in future,
Code: Select all
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs'] = html_entity_decode($product_info['specs'], ENT_QUOTES, 'UTF-8');
}
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs2']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs2'] = html_entity_decode($product_info['specs2'], ENT_QUOTES, 'UTF-8');
}
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs3']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs3'] = html_entity_decode($product_info['specs3'], ENT_QUOTES, 'UTF-8');
}
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs4']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs4'] = html_entity_decode($product_info['specs4'], ENT_QUOTES, 'UTF-8');
}
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs5']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs5'] = html_entity_decode($product_info['specs5'], ENT_QUOTES, 'UTF-8');
}
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs6']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs6'] = html_entity_decode($product_info['specs6'], ENT_QUOTES, 'UTF-8');
OC version 1.5.4.1
Try the following:
Code: Select all
$this->data['cpt_show'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs']));
$this->data['cpt_show2'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs2']));
$this->data['cpt_show3'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs3']));
$this->data['cpt_show4'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs4']));
$this->data['cpt_show5'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs5']));
$this->data['cpt_show6'] = $this->config->get('custom_product_tab_status') && ($this->config->get('cpt_always_show') || !empty($product_info['specs6']));
if ($this->config->get('custom_product_tab_status')) {
$this->data['specs'] = html_entity_decode($product_info['specs'], ENT_QUOTES, 'UTF-8');
$this->data['specs2'] = html_entity_decode($product_info['specs2'], ENT_QUOTES, 'UTF-8');
$this->data['specs3'] = html_entity_decode($product_info['specs3'], ENT_QUOTES, 'UTF-8');
$this->data['specs4'] = html_entity_decode($product_info['specs4'], ENT_QUOTES, 'UTF-8');
$this->data['specs5'] = html_entity_decode($product_info['specs5'], ENT_QUOTES, 'UTF-8');
$this->data['specs6'] = html_entity_decode($product_info['specs6'], ENT_QUOTES, 'UTF-8');
}
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
Yesterday I posted a message in this OC upgrade topic:
http://forum.opencart.com/viewtopic.php ... 41#p205841
This was my question:
I'm using the commercial extension : "Custom Product TAB".
This extension enabled me to add 5 extra pages for each product. On these extra pages customers can find detailed productinfo. What will happen with the information (mostly text) on these pages when I uninstall and reinstall this extension? Lost????
This is the answer I received today given by user "uksitebuilder":
Depends on how the extension stores the data in the database. If stored in the settings table, the data will be gone when the extension is uninstalled. You should check with the extension developer
Can you tell me please what will happen with the data on the extra TAB pages I created, when I uninstall and reinstall your extension? These steps have to be taken when I want to update to OC version 1.5.1.3.
OC version 1.5.4.1
If you uninstall the mod, the database changes are reverted, meaning that the spec column is removed and all data will be lost.
You can avoid this if you uncomment the uninstall/install functions from admin/controller/module/custom_product_tab.php
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
Code: Select all
public function install() {
$this->db->query("ALTER TABLE " . DB_PREFIX . "product_description ADD specs TEXT NOT NULL");
$this->load->model('setting/setting');
$settings = array("cpt_show_always" => 0);
$this->model_setting_setting->editSetting('custom_product_tab', $settings);
}
public function uninstall() {
$this->db->query("ALTER TABLE " . DB_PREFIX . "product_description DROP COLUMN specs");
$this->load->model('setting/setting');
$this->model_setting_setting->deleteSetting('custom_product_tab');
}
By uncommenting this part of the code, I can upgrade OC in future safely?
OC version 1.5.4.1
I do not know what the future holds, but assuming the OC upgrades to not modify the table you should be on the safe side.
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
bull5-i wrote:A // before every line or /* at the beginning and */ at the end of the block.
I do not know what the future holds, but assuming the OC upgrades to not modify the table you should be on the safe side.
Thanx mate. I'm not php skilled and used to quotes like "uncommenting". Used Google for it's meaning.
Thanx for confirming it.
OC version 1.5.4.1
Thanx mate!
OC version 1.5.4.1
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
Users browsing this forum: Amazon [Bot] and 51 guests