cheap gaming pcs
Members-
Posts
112 -
Joined
-
Last visited
cheap gaming pcs's Achievements
Newbie (1/14)
1
Reputation
-
Hi Everyone Thanks for your inadvance, Im using ps 1.5.4 I turn on dev mode to shows any errors and i get the message below I have a fresh install of prestashop, I added a few products and category's, then i deleted 2 catgegorys and the error message come up when i tried to view the products Thanks so much for your help [PrestaShopDatabaseException] Unknown column 'cp.position' in 'field list' SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,a.active as active,cp.position as position , MAX(i.id_image) id_image,cl.name `name_category` , i.`id_image`, a.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, a.`active` FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product` AND i.cover=1)LEFT JOIN `ps_category_lang` cl ON (a.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 ) WHERE 1 GROUP BY a.id_product ORDER BY cp.`position` ASC LIMIT 0,50 at line 607 in file classes/db/Db.php 601. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. } 603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 604. { 605. if ($sql) 606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 607. throw new PrestaShopDatabaseException($this->getMsgError()); 608. } 609. } 610. 611. /** DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2198 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->getList - [line 337 - controllers/admin/AdminProductsController.php] - [6 Arguments] AdminProductsControllerCore->getList - [line 1531 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->renderList - [line 2260 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->renderList - [line 1440 - classes/controller/AdminController.php] - [0 Argument] AdminControllerCore->initContent - [line 2252 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 50 - admin123/index.php] - [0 Argument]
-
Hi Tommerg3 Thanks for your help and sorry for not stating what ps i am using Im using ps 1.5.4 I turn on dev mode as you said above and it shows the following error message below</p> I have a fresh install of prestashop, I added a few products and category's, then i deleted 2 catgegorys and the error message come up when i tried to view the products Thanks so much for your help [PrestaShopDatabaseException] Unknown column 'cp.position' in 'field list' SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,a.active as active,cp.position as position , MAX(i.id_image) id_image,cl.name `name_category` , i.`id_image`, a.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, a.`active` FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product` AND i.cover=1)LEFT JOIN `ps_category_lang` cl ON (a.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 ) WHERE 1 GROUP BY a.id_product ORDER BY cp.`position` ASC LIMIT 0,50 at line 607 in file classes/db/Db.php 601. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. } 603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 604. { 605. if ($sql) 606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 607. throw new PrestaShopDatabaseException($this->getMsgError()); 608. } 609. } 610. 611. /** DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2198 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->getList - [line 337 - controllers/admin/AdminProductsController.php] - [6 Arguments] AdminProductsControllerCore->getList - [line 1531 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->renderList - [line 2260 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->renderList - [line 1440 - classes/controller/AdminController.php] - [0 Argument] AdminControllerCore->initContent - [line 2252 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 50 - admin123/index.php] - [0 Argument]
- 19 replies
-
Hi Everyone When i go to veiw the product page in the back office its shows this error below Bad SQL query Unknown column 'cp.position' in 'field list' Would anyone know how to fit it please Many Thanks
- 19 replies
-
[SOLVED] Module ERROR in BO
cheap gaming pcs replied to cyrusvsdarius's topic in Configuring and using PrestaShop
Hi I have the same problem. The link you supplyed above dose not work it say The page you were trying to reach could not be found Can you please redo the link Many Thanks -
Hi Everyone Can anyone help me with these error on the module page in the back office. Im worried the back office will stop working please help anyone Many Thanks Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//blockcategories.tpl/blockcategories.tpl.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//blockcategoriesaccordion.php/blockcategoriesaccordion.php.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//blockcategoriesaccordion.tpl/blockcategoriesaccordion.tpl.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//category-tree-branch.tpl/category-tree-branch.tpl.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//ddsmoothmenu.css/ddsmoothmenu.css.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//ddsmoothmenu.js/ddsmoothmenu.js.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//down.gif/down.gif.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//en.php/en.php.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//index.php/index.php.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//logo.gif/logo.gif.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//right.gif/right.gif.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956
-
Hi Can anyone help please i have this error showing 11 times on the modual page in the backoffice Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//blockcategoriesaccordion.php/blockcategoriesaccordion.php.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 Any help would be very greatfull Many Thanks
-
- error
- backoffice
-
(and 1 more)
Tagged with:
-
Hi Can any one help please ive got this error going down my modual page 11 different lines it shows the same error Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/ukgaming/public_html/modules//blockcategories.tpl/blockcategories.tpl.php) is not within the allowed path(s): (/home/ukgaming:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/ukgaming/public_html/classes/Tools.php on line 956 How can i fix the please Many Thanks Gary
-
Hi Everyone Im just seeing if someone can help my site gone down and not sure why The front end is fine but get a 404 error on all page link and the same for the back office login Ive checked the db and that looks ok , the site is calling the right db Many thanks for your help im really stuck Thanks Gary
- 2 replies
-
- 404
- page error
-
(and 1 more)
Tagged with:
-
Hi Everyone Can anyone help please . A customer has just message me saying they can not order from my site That they get the error message below . It was all working fine . Dont know what happened I have checked it and i get the same error . What you put something into the barskit and press checkout . It ring you to the page below The requested URL /order.php was not found on this server. I cant take order till this is fix . Any Help would be great Man many Thanks Gary