Jump to content

cheap gaming pcs

Members
  • Posts

    112
  • Joined

  • Last visited

2 Followers

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

cheap gaming pcs's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. 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]
  2. 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]
  3. 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
  4. Hi All How can i move all products in one category to another at the same time There must be any easy way Many Thanks
  5. Hi Can anyone help my website has gone and its just showing a blank white screen Any help would be great Many Thanks Gary
  6. Hi Thanks for your help im going to read through that now im useing ps.1.3.1 is that the same one ? Thanks again
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. Hi Thanks do much both of you for your fast reply I have fixed it now . The ssl was switch on in the back office I turned it off and it working again now Many Thanks to you both Gary
  13. 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
×
×
  • Create New...