Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by climaticmoments

  1. Hello, I love your module. It installed perfect on local and also allowed me to paste the code. I've tried every method to install it live, but when I paste the code in, it automatically sends me to my 404 page and does not save the code. I uninstalled and deleted it and tried to install it via add new module through the back end, but just like the first time I tried this method, the module does not show in the list of modules. I even double checked to show all modules installed not installed. I hope you might be able to help me because I am really anxious to try it. Thank you again. Athena D
  2. 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 Thank you Athena
  3. 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
  4. Hi Ron, I am going to send you my steps in a message. Thank you again. Tina www.climaticmoments.com
  5. Sorry never attached to a post before. After the problem. Tina www.climaticmoments.com
  6. 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, however I am a victim of the problems and as a result I am missing all the tables and fields added since 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
  7. 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
  8. 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 or 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 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
  9. 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
  10. 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 [email protected]_CHARACTER_SET_CLIENT */; /*!40101 SET [email protected]_CHARACTER_SET_RESULTS */; /*!40101 SET [email protected]_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
  11. 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 to my current 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
  12. 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 Thank you again for any help anyone can offer. Tina www.climaticmoments.com
  13. Hello Nemo, Thank you so much for taking the time to help me. I pasted controllers/admin/AdminCmsContentController.php below with line 43 in red. /* * 2007-2015 PrestaShop * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to [email protected] so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author PrestaShop SA <[email protected]> * @copyright 2007-2015 PrestaShop SA * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * International Registered Trademark & Property of PrestaShop SA */ class AdminCmsContentControllerCore extends AdminController { /** @var object adminCMSCategories() instance */ protected $admin_cms_categories; /** @var object adminCMS() instance */ protected $admin_cms; /** @var object Category() instance for navigation*/ protected static $category = null; public function __construct() { $this->bootstrap = true; /* Get current category */ $id_cms_category = (int)Tools::getValue('id_cms_category', Tools::getValue('id_cms_category_parent', 1)); self::$category = new CMSCategory($id_cms_category); if (!Validate::isLoadedObject(self::$category)) die('Category cannot be loaded'); $this->table = 'cms'; $this->className = 'CMS'; $this->bulk_actions = array( 'delete' => array( 'text' => $this->l('Delete selected'), 'confirm' => $this->l('Delete selected items?'), 'icon' => 'icon-trash' ) ); $this->admin_cms_categories = new AdminCmsCategoriesController(); $this->admin_cms_categories->init(); $this->admin_cms = new AdminCmsController(); $this->admin_cms->init(); parent::__construct(); } /** * Return current category * * @return object */ public static function getCurrentCMSCategory() { return self::$category; } public function viewAccess($disable = false) { $result = parent::viewAccess($disable); $this->admin_cms_categories->tabAccess = $this->tabAccess; $this->admin_cms->tabAccess = $this->tabAccess; return $result; } public function initContent() { $this->initTabModuleList(); $this->renderPageHeaderToolbar(); $this->admin_cms_categories->token = $this->token; $this->admin_cms->token = $this->token; if ($this->display == 'edit_category') $this->content .= $this->admin_cms_categories->renderForm(); elseif ($this->display == 'edit_page') $this->content .= $this->admin_cms->renderForm(); elseif ($this->display == 'view_page') $fixme = 'fixme';// @FIXME else { $id_cms_category = (int)Tools::getValue('id_cms_category'); if (!$id_cms_category) $id_cms_category = 1; // CMS categories breadcrumb $cms_tabs = array('cms_category', 'cms'); // Cleaning links $cat_bar_index = self::$currentIndex; foreach ($cms_tabs as $tab) if (Tools::getValue($tab.'Orderby') && Tools::getValue($tab.'Orderway')) $cat_bar_index = preg_replace('/&'.$tab.'Orderby=([a-z _]*)&'.$tab.'Orderway=([a-z]*)/i', '', self::$currentIndex); $this->context->smarty->assign(array( 'cms_breadcrumb' => getPath($cat_bar_index, $id_cms_category, '', '', 'cms'), 'page_header_toolbar_btn' => $this->page_header_toolbar_btn, 'page_header_toolbar_title' => $this->toolbar_title, )); $this->content .= $this->admin_cms_categories->renderList(); $this->admin_cms->id_cms_category = $id_cms_category; $this->content .= $this->admin_cms->renderList(); } $this->context->smarty->assign(array( 'content' => $this->content )); } public function renderPageHeaderToolbar() { $id_cms_category = (int)Tools::getValue('id_cms_category'); $id_cms_page = Tools::getValue('id_cms'); if (!$id_cms_category) $id_cms_category = 1; $cms_category = new CMSCategory($id_cms_category); if ($this->display == 'edit_category') { if (Tools::getValue('addcms_category') !== false) $this->toolbar_title[] = $this->l('Add new'); else $this->toolbar_title[] = sprintf($this->l('Edit: %s'), $cms_category->name[$this->context->employee->id_lang]); } elseif ($this->display == 'edit_page') { $this->toolbar_title[] = $cms_category->name[$this->context->employee->id_lang]; if (Tools::getValue('addcms') !== false) $this->toolbar_title[] = $this->l('Add new'); elseif ($id_cms_page) { $cms_page = new CMS($id_cms_page); $this->toolbar_title[] = sprintf($this->l('Edit: %s'), $cms_page->meta_title[$this->context->employee->id_lang]); } } else $this->toolbar_title[] = $this->l('CMS'); if ($this->display == 'list') { $this->page_header_toolbar_btn['new_cms_category'] = array( 'href' => self::$currentIndex.'&addcms_category&token='.$this->token, 'desc' => $this->l('Add new CMS category', null, null, false), 'icon' => 'process-icon-new' ); $this->page_header_toolbar_btn['new_cms_page'] = array( 'href' => self::$currentIndex.'&addcms&id_cms_category='.(int)$id_cms_category.'&token='.$this->token, 'desc' => $this->l('Add new CMS page', null, null, false), 'icon' => 'process-icon-new' ); } $this->page_header_toolbar_title = implode(' '.Configuration::get('PS_NAVIGATION_PIPE').' ', $this->toolbar_title); if (is_array($this->page_header_toolbar_btn) && $this->page_header_toolbar_btn instanceof Traversable || trim($this->page_header_toolbar_title) != '') $this->show_page_header_toolbar = true; $template = $this->context->smarty->createTemplate( $this->context->smarty->getTemplateDir(0).DIRECTORY_SEPARATOR .'page_header_toolbar.tpl', $this->context->smarty); $this->context->smarty->assign(array( 'show_page_header_toolbar' => $this->show_page_header_toolbar, 'title' => $this->page_header_toolbar_title, 'toolbar_btn' => $this->page_header_toolbar_btn, 'page_header_toolbar_btn' => $this->page_header_toolbar_btn, 'page_header_toolbar_title' => $this->toolbar_title, )); } public function postProcess() { /*if (Tools::isSubmit('submitDelcms') || Tools::isSubmit('previewSubmitAddcmsAndPreview') || Tools::isSubmit('submitAddcms') || Tools::isSubmit('submitBulkdeletecms') || Tools::isSubmit('deletecms') || Tools::isSubmit('viewcms') || (Tools::isSubmit('statuscms') && Tools::isSubmit('id_cms')) || (Tools::isSubmit('way') && Tools::isSubmit('id_cms')) && (Tools::isSubmit('position')) || Tools::isSubmit('submitFiltercms') || $this->context->cookie->{'submitFiltercms'} !== false || Tools::getValue('cmsOrderby') || Tools::getValue('cmsOrderway'))*/ $this->admin_cms->postProcess(); /*elseif (Tools::isSubmit('submitDelcms_category') || Tools::isSubmit('submitAddcms_categoryAndBackToParent') || Tools::isSubmit('submitBulkdeletecms_category') || Tools::isSubmit('submitAddcms_category') || Tools::isSubmit('deletecms_category') || (Tools::isSubmit('statuscms_category') && Tools::isSubmit('id_cms_category')) || (Tools::isSubmit('position') && Tools::isSubmit('id_cms_category_to_move')) || Tools::isSubmit('submitFiltercms_category') || $this->context->cookie->{'submitFiltercms_category'} !== false || Tools::getValue('cms_categoryOrderby') || Tools::getValue('cms_categoryOrderway'))*/ $this->admin_cms_categories->postProcess(); //else parent::postProcess(); if (((Tools::isSubmit('submitAddcms_category') || Tools::isSubmit('submitAddcms_categoryAndStay')) && count($this->admin_cms_categories->errors)) || Tools::isSubmit('updatecms_category') || Tools::isSubmit('addcms_category')) $this->display = 'edit_category'; elseif (((Tools::isSubmit('submitAddcms') || Tools::isSubmit('submitAddcmsAndStay')) && count($this->admin_cms->errors)) || Tools::isSubmit('updatecms') || Tools::isSubmit('addcms')) $this->display = 'edit_page'; else { $this->display = 'list'; $this->id_cms_category = (int)Tools::getValue('id_cms_category'); } if (isset($this->admin_cms->errors)) $this->errors = array_merge($this->errors, $this->admin_cms->errors); if (isset($this->admin_cms_categories->errors)) $this->errors = array_merge($this->errors, $this->admin_cms_categories->errors); } public function setMedia() { parent::setMedia(); $this->addJqueryUi('ui.widget'); $this->addJqueryPlugin('tagify'); } public function ajaxProcessUpdateCmsPositions() { if ($this->tabAccess['edit'] === '1') { $id_cms = (int)Tools::getValue('id_cms'); $id_category = (int)Tools::getValue('id_cms_category'); $way = (int)Tools::getValue('way'); $positions = Tools::getValue('cms'); if (is_array($positions)) foreach ($positions as $key => $value) { $pos = explode('_', $value); if ((isset($pos[1]) && isset($pos[2])) && ($pos[1] == $id_category && $pos[2] == $id_cms)) { $position = $key; break; } } $cms = new CMS($id_cms); if (Validate::isLoadedObject($cms)) { if (isset($position) && $cms->updatePosition($way, $position)) die(true); else die('{"hasError" : true, "errors" : "Can not update cms position"}'); } else die('{"hasError" : true, "errors" : "This cms can not be loaded"}'); } } public function ajaxProcessUpdateCmsCategoriesPositions() { if ($this->tabAccess['edit'] === '1') { $id_cms_category_to_move = (int)Tools::getValue('id_cms_category_to_move'); $id_cms_category_parent = (int)Tools::getValue('id_cms_category_parent'); $way = (int)Tools::getValue('way'); $positions = Tools::getValue('cms_category'); if (is_array($positions)) foreach ($positions as $key => $value) { $pos = explode('_', $value); if ((isset($pos[1]) && isset($pos[2])) && ($pos[1] == $id_cms_category_parent && $pos[2] == $id_cms_category_to_move)) { $position = $key; break; } } $cms_category = new CMSCategory($id_cms_category_to_move); if (Validate::isLoadedObject($cms_category)) { if (isset($position) && $cms_category->updatePosition($way, $position)) die(true); else die('{"hasError" : true, "errors" : "Can not update cms categories position"}'); } else die('{"hasError" : true, "errors" : "This cms category can not be loaded"}'); } } public function ajaxProcessPublishCMS() { if ($this->tabAccess['edit'] === '1') { if ($id_cms = (int)Tools::getValue('id_cms')) { $bo_cms_url = _PS_BASE_URL_.__PS_BASE_URI__.basename(_PS_ADMIN_DIR_).'/index.php?tab=AdminCmsContent&id_cms='.(int)$id_cms.'&updatecms&token='.$this->token; if (Tools::getValue('redirect')) die($bo_cms_url); $cms = new CMS((int)(Tools::getValue('id_cms'))); if (!Validate::isLoadedObject($cms)) die('error: invalid id'); $cms->active = 1; if ($cms->save()) die($bo_cms_url); else die('error: saving'); } else die ('error: parameters'); } } } Thank you again Tina www.climaticmoments.com
  14. Hello, I am not new to Prestashop, but new to posting in the forumn. I am usually pretty good about finding answers to all my problems by reading all the amazing people's solutions posted to help others out. I started the upgrade with the 1 click upgrade module and didn't realize I was so tired and nodded off. When I woke up it said the upgrade was complete. Everything worked as far as I can see except the top menu which I just uninstalled and reinstalled and works now and all my CMS pages are empty and everytime I retype all the information in I get the following error. [PrestaShopDatabaseException] Unknown column 'id_shop' in 'where clause' SELECT * FROM `ps_cms_category_lang` WHERE `id_cms_category` = 1 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] DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 240 - classes/ObjectModel.php] - [1 Arguments] ObjectModelCore->__construct - [line 43 - controllers/admin/AdminCmsContentController.php] - [1 Arguments] AdminCmsContentControllerCore->__construct - [line 135 - classes/controller/Controller.php] - [2 Arguments] ControllerCore::getController - [line 366 - classes/Dispatcher.php] - [1 Arguments] DispatcherCore->dispatch - [line 54 - admin/index.php] and can not save it. I rolled back the database from both my perfect backup from phpadmin and also the one that prestashop does when you upgrade. It rolled back everything but this issue. A couple days later 14 came out and I upgraded to that crossing my fingers it would fix it, but unfortuneately I didn't. So now I am desperate!! I am praying there is an easy solution to my problem because it takes me way to long to do everything all over again, plus I already lost all my customers and orders from the 1.5 to the 1.6 upgrade and can't afford to lose all the new informaton again. I thank anyone in advance for any help you can offer. Tina www.climaticmoments.com
  15. I had the same problem and it was the block search. using your FTP client, go to your web server’s FTP, and open the file defines.inc.php, which is in the /config folder. There's a bunch of text, then this appears: /* Debug only */ define('_PS_MODE_DEV_', false); if (_PS_MODE_DEV_) change that second line: replace "false" with "true" (without quotes). It should now read: /* Debug only */ define('_PS_MODE_DEV_', true); if (_PS_MODE_DEV_) I'm sure you already know to change it back as soon as you fix the error. I disabled the blocksearch until I can figure out where the error is. Sorry if you already received an answer.
  16. Hello, I did love the theme maker until I couldn't get an update. When I purchased the theme maker the way I understood it was I paid for 1 domain and after the 15 days my membership ended. I was hesistant purchasing the 15 days, but did after I searched your entire site for your policy when there is a new update and didn't see anything that said every update requires me to renew my account. I was tossing between purchasing a template that receives free updates once you purchase the theme or theme maker. Does this mean everytime you do an update, I have to pay another 19.99 or 39.99? This could be an extremely expensive theme if this is the case. With it being so new I'm sure you will have to continuely update it. I have already had to update it twice. Could you please explain how updates work and if we have to pay for them everytime there is one? Thank you ClimaticMoments
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More