climaticmoments

Hello, One of my suppliers is going to be adjusting their wholesale prices on 4000 plus products over the next couple weeks. I am trying to prepare by adding a wholesale price column to the back office product list so I can see it without having to click the product every time. I don't know if this what I should edit on the AdminProductsController.php. $this->_select .= 'shop.name as shopname, a.id_shop_default, '; $this->_select .= 'MAX('.$alias_image.'.id_image) id_image, cl.name `name_category`, '.$alias.'.`price`,'.$alias.'.`wholesale_price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, '.$alias.'.`active`, IF(sav.`quantity`<=0, 1, 0) badge_danger'; And.. $this->fields_list['wholesale_price'] = array( 'title' => $this->l('Wholesale price'), 'width' => 90, 'type' => 'price', 'align' => 'right', 'filter_key' => 'wholesale_price' <--------- How do I get the filter key? ); Would something like this work? Or am I way off? I am so confused and would really appreciate if someone could help me add a wholesale price column to the back office product list. I currently have version 1.6.0.14 Thank you Athena

Hi, I am not a tech by any means, but I guess I am following this topic and saw your dilemma and think I can help you a little bit. I read through and if I read it correctly you are able to see the CMS pages you created, but they are empty and or missing when you try to load them. My solution was fixed by doing the following.. If you are able to access PhpMyAdmin.. Check to make sure your ps_cms_lang has the field id_shop Check to make sure your ps_cms_category_language has the field id_shop If one or both don't have those fields you will need to add them. As far as if you need help adding those fields, it wouldn't be a good idea for me to help. I just barely make it by when it comes to queries and those sort of things. I hope I was able to help you. Tina www.climaticmoments.com

Hi Ron, I am going to send you my steps in a message. Thank you again. Tina www.climaticmoments.com

Before the problem.

Sorry never attached to a post before. After the problem. Tina www.climaticmoments.com

Hello Ron, The problem is.. I have over 4000 products with a very fast turn around so I have to update everyday. When I export the products and open them in excel the columns and rows are a mess. I took a screen shot of before and after this started showing up. Before I had just over 4000 lines to edit and now I have 11926 lines because of this, plus it wraps text in excel so I have to delete those lines, unwrap the text, take spaces out, etc. it takes forever. I also took a screen shot of the first product I opened and showed source. I didn't code the extra <br /><br /> or the the <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> That is in both long description and short. I have version 1.6.0.14, however I am a victim of the 1.6.0.12 problems and as a result I am missing all the tables and fields added since 1.6.0.9 with no way to roll back using perfect backups from 3 different sources. I can't update products, add products, edit products, put products on sale, etc so I guess 1 thing at a time. I also don't want to start fresh because image mapping was depreciated as of 1.5. Thank you for any help you can offer Ron. Have a nice night. Tina www,climaticmoments.com

Am I the only one with this problem?

Hellppp I am praying someone knows!

Hello, I have been pulling my hair out trying to find how, why, or where my pasted text below is coming from. My products export no problem, but it is really messing everything up when I try to open the csv export in excel. It is not visible to customers, but it is messing up my descriptions both short and long and other areas. I am praying someone knows what is producing this and how to get rid of it. This is from one description. <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> <div class=""notifyIcon""></div> <div class=""copyIcon copy0""></div> <div class=""pasteIcon paste0""></div> I appreciate any import or help. Thank you Athena www.climaticmoments.com

Hi, I don't usually answer technical questions in forums because by NO MEANS am I as qualified as the amazing techs on here, but I thought my post might help you with the CMS part at least. https://www.prestashop.com/forums/topic/430259-please-help-errors-with-cms-after-upgrading-from-16011-to-16013/ This might help you if you are using Prestashop 1.6.0.13 or 1.6.0.14 and if your CMS pages are still showing in your database, but not displaying on your website or back office. Nemo was a lot of help and now I am able to at least edit my cms and top horizontal menu. I did find the main problem, but I am still working on fixing the rest of the issues. The upgrade 1.6.0.12 I guess in short failed, but I didn't realize it. That upgrade included the needed query to add id_shop to a couple tables, it also didn't run the query that affected the pack table which affects specific pricing plus a few other things. I tried rolling back my working database as well from 3 different sources, but it didn't change anything. I hope I was a little help as far as the CMS portion is concerned. Have a great day. Athena www.climaticmoments.com

Nemo, You are AMAZING!!!!!! If you are ever in Massachusetts let me know and I will buy you drinks!!! You are the BEST!!! Thank you again you fixed everything I needed. Tina www.climaticmoments.com

Hi again, I can't express how much I appreciate your help. I added an id_shop column with int(12) to cms_category_lang like you asked with this -- -- Table structure for table `ps_cms_category_lang` -- DROP TABLE IF EXISTS `ps_cms_category_lang`; CREATE TABLE IF NOT EXISTS `ps_cms_category_lang` ( `id_cms_category` int(10) unsigned NOT NULL, `id_shop` int(12) unsigned NOT NULL DEFAULT '1', `id_lang` int(10) unsigned NOT NULL, `name` varchar(128) NOT NULL, `description` text, `link_rewrite` varchar(128) NOT NULL, `meta_title` varchar(128) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_description` varchar(255) DEFAULT NULL, PRIMARY KEY (`id_cms_category`,`id_lang`), KEY `category_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ps_cms_category_lang` -- INSERT INTO `ps_cms_category_lang` (`id_cms_category`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (1, 1, 'Home', NULL, 'home', NULL, NULL, NULL), (3, 1, 'Customer Service', 'Resources links to help you find important information faster.', 'customer-service', 'Customer Service', NULL, 'Customer Service at Climatic Moments'), (5, 1, 'How to Sex Toy Guides', 'Bondage and Sex Toy Product Guides\r\n\r\nFinding the right adult products for yourself or partner can be a daunting task. Even as you browse through our site, you''ll find over 3,000 BDSM products and sex toys. Don''t worry our product guides are designed to help you learn more about these products and how they can be used to improve your sexual pleasure. Enjoy reading through our sex toy and bondage guides and we hope you''ll learn more about the many different ways you can bring your sex life to a whole new satisfying level. \r\n', 'how-to-sex-toy-guides', 'How to Sex Toy Guides | Climatic Moments | How to BDSM Guides', 'how to sex toy guides,how to bdsm guides,what sex toys should I buy,how to buy bondage gear', ' Finding the right sex toys and bdsm products for yourself or partner can be a daunting task. Browse our Free how to sex toy guides at Climatic Moments to help you find the perfect sex toys to enhance your sex life.'), (6, 1, 'Sexual Education', 'Discovering what can heighten, enhance, and renew your sexual needs and your relationships can be overwhelming and expensive without the right resources. This Sexual Education section includes information and links to help you explore, educate, and learn about these topics.', 'sexual-education', 'Sexual Education | Climatic Moments | How to Sex Guides', 'free sexual guides, how to sex guides', 'Discover Free Sexual Guides and Help at Climatic Moments.'), (8, 1, 'More Info', NULL, 'more-info', 'More Info | Climatic Moments', NULL, NULL); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; It shows the new column now id_shop now. I then deleted the smarty compile cache, the template cache, browser cache, temp files etc. I deleted the .htaccess and regenerated one. I clicked on cms with error reporting on and this is what I am getting now [PrestaShopDatabaseException] Unknown column 'id_shop' in 'where clause' SELECT * FROM `ps_cms_lang` WHERE `id_cms` = 16 AND `id_shop` = 1 at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 642. } 643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 644. { 645. if ($sql) 646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 647. throw new PrestaShopDatabaseException($this->getMsgError()); 648. } 649. } 650. 651. /** DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments] 335. if ($this->connect()) 336. $this->result = $this->_query($sql); 337. } 338. 339. if (_PS_DEBUG_SQL_) 340. $this->displayError($sql); 341. return $this->result; 342. } 343. 344. /** 345. * Execute an INSERT query DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments] 511. { 512. $this->last_cached = true; 513. return $result; 514. } 515. 516. $this->result = $this->query($sql); 517. 518. if (!$this->result) 519. $result = false; 520. else 521. { DbCore->executeS - [line 240 - classes/ObjectModel.php] - [1 Arguments] 235. if (!$id_lang && isset($this->def['multilang']) && $this->def['multilang']) 236. { 237. $sql = 'SELECT * FROM `'.pSQL(_DB_PREFIX_.$this->def['table']).'_lang` 238. WHERE `'.bqSQL($this->def['primary']).'` = '.(int)$id 239. .(($this->id_shop && $this->isLangMultishop()) ? ' AND `id_shop` = '.$this->id_shop : ''); 240. if ($object_datas_lang = ObjectModel::$db->executeS($sql)) 241. foreach ($object_datas_lang as $row) 242. foreach ($row as $key => $value) 243. { 244. if ($key != $this->def['primary'] && array_key_exists($key, $this)) 245. { ObjectModelCore->__construct - [line 151 - controllers/admin/AdminCmsContentController.php] - [1 Arguments] 146. 147. if (Tools::getValue('addcms') !== false) 148. $this->toolbar_title[] = $this->l('Add new'); 149. elseif ($id_cms_page) 150. { 151. $cms_page = new CMS($id_cms_page); 152. $this->toolbar_title[] = sprintf($this->l('Edit: %s'), $cms_page->meta_title[$this->context->employee->id_lang]); 153. } 154. } 155. else 156. $this->toolbar_title[] = $this->l('CMS'); AdminCmsContentControllerCore->renderPageHeaderToolbar - [line 85 - controllers/admin/AdminCmsContentController.php] 80. } 81. 82. public function initContent() 83. { 84. $this->initTabModuleList(); 85. $this->renderPageHeaderToolbar(); 86. 87. $this->admin_cms_categories->token = $this->token; 88. $this->admin_cms->token = $this->token; 89. 90. if ($this->display == 'edit_category') AdminCmsContentControllerCore->initContent - [line 180 - classes/controller/Controller.php] 175. 176. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) 177. $this->initHeader(); 178. 179. if ($this->viewAccess()) 180. $this->initContent(); 181. else 182. $this->errors[] = Tools::displayError('Access denied.'); 183. 184. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) 185. $this->initFooter(); ControllerCore->run - [line 373 - classes/Dispatcher.php] 368. // Execute hook dispatcher 369. if (isset($params_hook_action_dispatcher)) 370. Hook::exec('actionDispatcher', $params_hook_action_dispatcher); 371. 372. // Running controller 373. $controller->run(); 374. } 375. catch (PrestaShopException $e) 376. { 377. $e->displayMessage(); 378. } DispatcherCore->dispatch - [line 54 - admin/index.php] 49. $_POST['controller'] = strtolower($_POST['tab']); 50. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) 51. $_REQUEST['controller'] = strtolower($_REQUEST['tab']); 52. 53. // Prepare and trigger admin dispatcher 54. Dispatcher::getInstance()->dispatch(); I am really sorry to be such a pain in the behind. Thank you again. Tina www.climaticmoments.com

I really hope someone can help me soon because my website does not have any cms pages for customer service reasons or in the top menu. I compared my current data bases to my 1.6..0.9 and 1.6.0.11 to my current 1.6.0.14 and nothing really stood out. All the Cms pages are showing in my current database when I goto phpmyadmin, but when I open them in prestashop they are blank and I can not edit, add, or change them. Everytime I add links to the top menu it links completey wrong. Please please please can someone help me. Thank you again Tina www.climaticmoments.com

I guess that wasn't my only issue I thought when I uninstalled and reinstalled the top horizontal menu it fixed the issue with all the links and weird empty transparent box in the middle of it, but it didn't. When I add the categories and a home link, it gives a 404 error for home. So if I was on a category the home would come up as www.climaticmoments.com/herbals/climaticmoments.com. I am not sure if the two are related issues the cms and the top horizontal menu. Is there a way to rerun just these two issues from the update 1.6.0.13? Thank you again for any help anyone can offer. Tina www.climaticmoments.com