Need a little help please site has gone completly and im unsure what to do

[puffdade]

Guys I decided to make a landing page for my site  thinking I could drop an index.html  file in the main folder  thinking that the server would pick out the index.html file first then my customers would read the over 18 part  and click to enter the site

 

well that fell flat on its face and never worked so I deleted the index.html file  and www.puffdade.com now reverts to the old index.html code

 

im using 1.5.4.1

 

anyone have any idea what's gone belly up  and how I can address this issue.

 

we have a really busy site  and this is a tad worrying

[stottycabanas]

You have a blank screen at present, so first step would be to switch error reporting on and post the error here.

Cheers, Dave

[puffdade]

ok thanks  will do that now

[puffdade]

Hope I have done this correctly  first time I have had to do this 

 

 

[PrestaShopDatabaseException]

Unknown column 'a.start_day' in 'where clause'

SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`FROM `ps_advice` a			LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`			LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice` WHERE (			a.`validated` = 1 AND 			a.`hide` = 0 AND 			al.`id_lang` = 2 AND 			at.`id_tab` = 93 AND 			((a.`start_day` = 0 AND a.`stop_day` = 0) OR (24 >= a.`start_day` AND 24 <= a.`stop_day`)))

at line 607 in file classes/db/Db.php

 

601. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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]

  301. 		if ($sql instanceof DbQuery)302. 			$sql = $sql->build();303. 304. 		$this->result = $this->_query($sql);305. 		if (_PS_DEBUG_SQL_)306. 			$this->displayError($sql);307. 		return $this->result;308. 	}309. 310. 	/**311. 	 * Execute an INSERT query

  Argument [0]SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`FROM `ps_advice` a			LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`			LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice` WHERE (			a.`validated` = 1 AND 			a.`hide` = 0 AND 			al.`id_lang` = 2 AND 			at.`id_tab` = 93 AND 			((a.`start_day` = 0 AND a.`stop_day` = 0) OR (24 >= a.`start_day` AND 24 <= a.`stop_day`)))

• DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]

  476. 		{477. 			$this->last_cached = true;478. 			return $result;479. 		}480. 481. 		$this->result = $this->query($sql);482. 		if (!$this->result)483. 			return false;484. 485. 		$this->last_cached = false;486. 		if (!$array)

  Argument [0]SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`FROM `ps_advice` a			LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`			LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice` WHERE (			a.`validated` = 1 AND 			a.`hide` = 0 AND 			al.`id_lang` = 2 AND 			at.`id_tab` = 93 AND 			((a.`start_day` = 0 AND a.`stop_day` = 0) OR (24 >= a.`start_day` AND 24 <= a.`stop_day`)))

• DbCore->executeS - [line 96 - modules/gamification/classes/Advice.php] - [1 Arguments]

  90. 			a.`hide` = 0 AND 91. 			al.`id_lang` = '.(int)Context::getContext()->language->id.' AND 92. 			at.`id_tab` = '.(int)$id_tab.' AND 93. 			((a.`start_day` = 0 AND a.`stop_day` = 0) OR ('.date('d').' >= a.`start_day` AND '.date('d').' <= a.`stop_day`))');94. 		95. 		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);96. 		97. 		$advices = array();98. 		foreach ($result as $res)99. 			$advices[] = array(100. 				'selector' => $res['selector'],

  Argument [0]DbQuery Object(    [query:protected] => Array        (            [select] => Array                (                    [0] => a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`                )            [from] => Array                (                    [0] => `ps_advice` a                )            [join] => Array                (                    [0] => 			LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`			LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice`                 )            [where] => Array                (                    [0] => 			a.`validated` = 1 AND 			a.`hide` = 0 AND 			al.`id_lang` = 2 AND 			at.`id_tab` = 93 AND 			((a.`start_day` = 0 AND a.`stop_day` = 0) OR (24 >= a.`start_day` AND 24 <= a.`stop_day`))                )            [group] => Array                (                )            [having] => Array                (                )            [order] => Array                (                )            [limit] => Array                (                    [offset] => 0                    [limit] => 0                )        ))

• Advice::getValidatedByIdTab - [line 145 - modules/gamification/gamification.php] - [1 Arguments]

  139. 		{140. 			$this->context->controller->addJquery();141. 			$this->context->controller->addCss($this->_path.'views/css/gamification.css');142. 			143. 			//add css for advices144. 			$advices = Advice::getValidatedByIdTab($this->context->controller->id);145. 			$css_str = '';146. 			foreach ($advices as $advice)147. 				$css_str .= '<link href="http://gamification.prestashop.com/css/advices/advice-'._PS_VERSION_.'_'.$advice['id_ps_advice'].'.css" rel="stylesheet" type="text/css" media="all" />';148. 			149. 			if (version_compare(_PS_VERSION_, '1.6.0', '>=') === TRUE)

  Argument [0]93

• Gamification->hookDisplayBackOfficeHeader - [line 421 - classes/Hook.php] - [1 Arguments]

  415. 			{416. 				$hook_args['altern'] = ++$altern;417. 418. 				// Call hook method419. 				if ($hook_callable)420. 					$display = $moduleInstance->{'hook'.$hook_name}($hook_args);421. 				else if ($hook_retro_callable)422. 					$display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);423. 				// Live edit424. 				if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))425. 				{

  Argument [0]Array(    [cookie] => Cookie Object        (            [_content:protected] => Array                (                    [date_add] => 2014-01-03 20:31:43                    [id_lang] => 2                    [id_employee] => 1                    [email] => [email protected]                    [profile] => 1                    [passwd] => cf4bcc4c0533f1bd4c542020b19390f8                    [remote_addr] => 1376080489                    [shopContext] => s-1                    [stats_granularity] => 10                    [id_currency] => 2                    [order_pagination] => 300                    [product_pagination] => 50                    [category_pagination] => 50                    [manufacturer_pagination] => 50                    [address_pagination] => 50                    [id_category_products_filter] => 6                    [customer_pagination] => 50                    [cart_pagination] => 50                    [cartscartOrderby] => date_add                    [cartscartOrderway] => desc                    [customer_thread_pagination] => 50                    [customerthreadscustomer_threadOrderby] => date_upd                    [customerthreadscustomer_threadOrderway] => desc                    [customer_threadFilter_cl!id_contact] => 2                    [cart_rule_pagination] => 50                    [submitFilterorder] => 0                    [ordersorderFilter_id_order] =>                     [ordersorderFilter_reference] =>                     [ordersorderFilter_new] =>                     [ordersorderFilter_customer] =>                     [ordersorderFilter_total_paid_tax_incl] =>                     [ordersorderFilter_payment] =>                     [ordersorderFilter_os!id_order_state] =>                     [ordersorderFilter_a!date_add] => a:2:{i:0;s:0:"";i:1;s:0:"";}                    [zone_pagination] => 50                    [country_pagination] => 50                    [range_price_pagination] => 50                    [carrier_pagination] => 50                    [attribute_group_pagination] => 50                    [log_pagination] => 50                    [eBaySession] =>                     [eBayUsername] =>                     [range_weight_pagination] => 50                    [quick_access_pagination] => 50                    [checksum] => 1243624157                )            [_name:protected] => 44c621219e3f66a7d4725c437c8fb0f8            [_expire:protected] => 1392250089            [_domain:protected] => www.puffdade.com            [_path:protected] => /shop/            [_cipherTool:protected] => Rijndael Object                (                    [_key:protected] => hD6OEIaLMzNvTgyLcJGKxpcw1OGisuHX                    [_iv:protected] => I; .7r+7i                )            [_key:protected] => 9pffparw5nclnxmcuorbch9a3u60tawsiqgdjtkkqd8bxitt1kvb9nes            [_iv:protected] => bykeebuh            [_modified:protected] =>             [_allow_writing:protected] => 1        )    [cart] =>     [altern] => 1)

• HookCore::exec - [line 1791 - classes/controller/AdminController.php] - [2 Arguments]

  1785. 			'token' => $this->token,1786. 			'stock_management' => (int)Configuration::get('PS_STOCK_MANAGEMENT')1787. 		));1788. 		1789. 		if ($this->display_header)1790. 			$this->context->smarty->assign('displayBackOfficeHeader', Hook::exec('displayBackOfficeHeader', array()));1791. 		1792. 		$this->context->smarty->assign(1793. 			array(1794. 				'displayBackOfficeTop' => Hook::exec('displayBackOfficeTop', array()),1795. 				'submit_form_ajax' => (int)Tools::getValue('submitFormAjax')

  Argument [0]displayBackOfficeHeaderArgument [1]Array()

• AdminControllerCore->init - [line 31 - controllers/admin/AdminStatsTabController.php] - [0 Argument]

  25. 26. abstract class AdminStatsTabControllerCore extends AdminPreferencesControllerCore27. {28. 	public function init()29. 	{30. 		parent::init();31. 32. 		$this->action = 'view';33. 		$this->display = 'view';34. 	}35. 

• AdminStatsTabControllerCore->init - [line 150 - classes/controller/Controller.php] - [0 Argument]

  144. 	/**145. 	 * Start controller process (this method shouldn't be overriden !)146. 	 */147. 	public function run()148. 	{149. 		$this->init();150. 		if ($this->checkAccess())151. 		{152. 			// setMedia MUST be called before postProcess153. 			if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))154. 				$this->setMedia();

• ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]

  343. 			// Execute hook dispatcher344. 			if (isset($params_hook_action_dispatcher))345. 				Hook::exec('actionDispatcher', $params_hook_action_dispatcher);346. 347. 			// Running controller348. 			$controller->run();349. 		}350. 		catch (PrestaShopException $e)351. 		{352. 			$e->displayMessage();353. 		}

• DispatcherCore->dispatch - [line 50 - admin123/index.php] - [0 Argument]

  44. 	$_POST['controller'] = strtolower($_POST['tab']);45. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab']))46. 	$_REQUEST['controller'] = strtolower($_REQUEST['tab']);47. 48. // Prepare and trigger admin dispatcher49. Dispatcher::getInstance()->dispatch();

[stottycabanas]

Hi, looks like @aun4some1 had the same error in this thread:

http://www.prestashop.com/forums/topic/302137-solved-prestashopdatabaseexception-backoffice-orders/

Maybe what worked for him/her will work for you too.

Cheers, Dave

[stottycabanas]

And similar ones here:

http://www.prestashop.com/forums/topic/302960-solved-problem-unknown-column-ahide-in-where-clause

http://www.prestashop.com/forums/topic/303146-solved-problem-modules-tab-not-working/

Issue with updating gamification module, so it would seem.

Cheers, Dave

[puffdade]

Thanks Dave

 

 

time to get digging 

[puffdade]

lots of my modules have vanished from the modules tag in the back office  how can that happen

[puffdade]

it would seem homefeatured is messed up,  my host tech support tell me this is where the error is and to reinstall this module but when I try to reinstall  I just get  internet explorer error,  anyone have a clue?

 

Parse error: syntax error, unexpected T_STRING in /home/puffdade/public_html/shop/modules/homefeatured/homefeatured.php on line 107

 

when I checked homefeatured.php  line 107  doesn't even exist

see below

 

<?php
/*
* 2007-2013 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 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/afl-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-2013 PrestaShop SA
*  @license    http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

if (!defined('_PS_VERSION_'))
 exit;

class HomeFeatured extends Module
{
 private $_html = '';
 private $_postErrors = array();

 function __construct()
 {
  $this->name = 'homefeatured';
  $this->tab = 'front_office_features';
  $this->version = '0.9';
  $this->author = 'PrestaShop';
  $this->need_instance = 0;

  parent::__construct();

  $this->displayName = $this->l('Featured products on the homepage.');
  $this->description = $this->l('Displays featured products in the middle of your homepage.');
 }

 function install()
 {
  if (!Configuration::updateValue('HOME_FEATURED_NBR', 8) || !parent::install() || !$this->registerHook('displayHome') || !$this->registerHook('header'))
   return false;
  return true;
 }

 public function getContent()
 {
  $output = '<h2>'.$this->displayName.'</h2>';
  if (Tools::isSubmit('submitHomeFeatured'))
  {
   $nbr = (int)(Tools::getValue('nbr'));
   if (!$nbr OR $nbr <= 0 OR !Validate::isInt($nbr))
    $errors[] = $this->l('An invalid number of products has been specified.');
   else
    Configuration::updateValue('HOME_FEATURED_NBR', (int)($nbr));
   if (isset($errors) AND sizeof($errors))
    $output .= $this->displayError(implode('<br />', $errors));
   else
    $output .= $this->displayConfirmation($this->l('Your settings have been updated.'));
  }
  return $output.$this->displayForm();
 }

 public function displayForm()
 {
  $output = '
  <form action="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'" method="post">
   <fieldset><legend><img src="'.$this->_path.'logo.gif" alt="" title="" />'.$this->l('Settings').'</legend>
    <p>'.$this->l('To add products to your homepage, simply add them to the "home" category.').'</p><br />
    <label>'.$this->l('Define the number of products to be displayed.').'</label>
    <div class="margin-form">
     <input type="text" size="5" name="nbr" value="'.Tools::safeOutput(Tools::getValue('nbr', (int)(Configuration::get('HOME_FEATURED_NBR')))).'" />
     <p class="clear">'.$this->l('Define the number of products that you would like to display on homepage (default: 8).').'</p>

    </div>
    <center><input type="submit" name="submitHomeFeatured" value="'.$this->l('Save').'" class="button" /></center>
   </fieldset>
  </form>';
  return $output;
 }

 public function hookDisplayHeader($params)
 {
  $this->hookHeader($params);
 }

 public function hookHeader($params)
 {
  $this->context->controller->addCSS(($this->_path).'homefeatured.css', 'all');
 }

 public function hookDisplayHome($params){
 $category = new Category(Context::getContext()->shop->getCategory(), (int)Context::getContext()->language->id);
 $nb = (int)(Configuration::get('HOME_FEATURED_NBR'));
 $products = $category->getProducts((int)Context::getContext()->language->id, 1, ($nb ? $nb : 10));

 

The last line of code is 106

 

Edited January 24, 2014 by puffdade (see edit history)