[Opgelost] Debug probleem

[Frits van Leeuwen]

Hallo allemaal,

 

Ik heb in config/defines.inc.php de debug op true gezet.

Als ik dan naar de back office ga, zie ik de volgende tekst:

 

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
 

SELECT versionFROM `vgzr_module`WHERE (id_module = )

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

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 803 - modules/mobassistantconnector/mobassistantconnector.php] - [1 Arguments]
• Mobassistantconnector->getDatabaseVersion - [line 74 - modules/mobassistantconnector/mobassistantconnector.php]
• Mobassistantconnector->__construct - [line - ]
• ReflectionClass->newInstance - [line 124 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php]
• Core_Foundation_IoC_Container->makeInstanceFromClassName - [line 157 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php] - [2 Arguments]
• Core_Foundation_IoC_Container->doMake - [line 170 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php] - [2 Arguments]
• Core_Foundation_IoC_Container->make - [line 52 - Adapter/Adapter_ServiceLocator.php] - [1 Arguments]
• Adapter_ServiceLocator::get - [line 1371 - classes/module/Module.php] - [1 Arguments]
• ModuleCore::getModulesOnDisk - [line 2059 - classes/controller/AdminController.php]
• AdminControllerCore->initTabModuleList - [line 2003 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 189 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]

 

Wie kan mij hierbij helpen?

 

Alvast bedankt.

Frits

Edited October 6, 2015 by frits1969 (see edit history)

[Frits van Leeuwen]

Is dit wat je bedoelt met de LOG? En opengeklapte links?

 

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
 

SELECT versionFROM `vgzr_module`WHERE (id_module = )

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

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

  420.                 $this->result = $this->_query($sql);421.             }422.         }423. 424.         if (_PS_DEBUG_SQL_) {425.             $this->displayError($sql);426.         }427. 428.         return $this->result;429.     }430. 

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

  638.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');639.             }640.             return $this->execute($sql, $use_cache);641.         }642. 643.         $this->result = $this->query($sql);644. 645.         if (!$this->result) {646.             $result = false;647.         } else {648.             if (!$array) {

• DbCore->executeS - [line 803 - modules/mobassistantconnector/mobassistantconnector.php] - [1 Arguments]

  798. 		$db_version_obj = new DbQuery();799. 		$db_version_obj->select('version');800. 		$db_version_obj->from('module');801. 		$db_version_obj->where('id_module = '.$this->id);802. 		$db_version_sql = $db_version_obj->build();803. 		$db_version = Db::getInstance()->executeS($db_version_sql);804. 		$db_version = array_shift($db_version);805. 806. 		return $db_version['version'];807. 	}808. 

• Mobassistantconnector->getDatabaseVersion - [line 74 - modules/mobassistantconnector/mobassistantconnector.php]

  69. 			Are you carrying laptop everywhere you go, repeatedly searching the answer for bothering question in your mind - 'What’s going on at my store?'70. 			With Prestashop Mobile Assistant on you can be on the move and have access to the real-time store data reports at your fingertips.71. 			Using it you can monitor key details on your products, customers and orders from your Android device wherever you are.");72. 73. 		// Update module version in database74. 		$this->database_version_cur = $this->getDatabaseVersion();75. 		if ($this->database_version_cur !== null && version_compare($this->database_version_cur, $this->version, '<' ))76. 		{77. 			self::upgradeModuleVersion($this->name, $this->version);78. 			$this->_generateConfigXml();79. 		}

• Mobassistantconnector->__construct - [line - ]
• ReflectionClass->newInstance - [line 124 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php]

  119.         if (count($args) > 0) {120.             return $refl->newInstanceArgs($args);121.         } else {122.             // newInstanceArgs with empty array fails in PHP 5.3 when the class123.             // doesn't have an explicitly defined constructor124.             return $refl->newInstance();125.         }126.     }127. 128.     private function doMake($serviceName, array $alreadySeen = array())129.     {

• Core_Foundation_IoC_Container->makeInstanceFromClassName - [line 157 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php] - [2 Arguments]

  152.             } elseif (!is_string($constructor)) {153.                 // user already provided the value, no need to construct it.154.                 $service = $constructor;155.             } else {156.                 // assume the $constructor is a class name157.                 $service = $this->makeInstanceFromClassName($constructor, $alreadySeen);158.             }159. 160.             if ($binding['shared']) {161.                 $this->instances[$serviceName] = $service;162.             }

• Core_Foundation_IoC_Container->doMake - [line 170 - Core/Foundation/IoC/Core_Foundation_IoC_Container.php] - [2 Arguments]

  165.         }166.     }167. 168.     public function make($serviceName)169.     {170.         return $this->doMake($serviceName, array());171.     }172. }

• Core_Foundation_IoC_Container->make - [line 52 - Adapter/Adapter_ServiceLocator.php] - [1 Arguments]

  47.     {48.         if (empty(self::$service_container) || is_null(self::$service_container)) {49.             throw new Adapter_Exception('Service container is not set.');50.         }51. 52.         return self::$service_container->make($serviceName);53.     }54. }

• Adapter_ServiceLocator::get - [line 1371 - classes/module/Module.php] - [1 Arguments]

  1366.                     }1367.                 }1368. 1369.                 // If class exists, we just instanciate it1370.                 if (class_exists($module, false)) {1371.                     $tmp_module = Adapter_ServiceLocator::get($module);1372. 1373.                     $item = new stdClass();1374.                     $item->id = $tmp_module->id;1375.                     $item->warning = $tmp_module->warning;1376.                     $item->name = $tmp_module->name;

• ModuleCore::getModulesOnDisk - [line 2059 - classes/controller/AdminController.php]

  2054.             $this->refresh(Module::CACHE_FILE_TAB_MODULES_LIST, _PS_TAB_MODULE_LIST_URL_);2055.         }2056. 2057.         $this->tab_modules_list = Tab::getTabModulesList($this->id);2058. 2059.         $modules = Module::getModulesOnDisk();2060. 2061.         $tmp = array();2062.         foreach ($modules as $module) {2063.             $tmp[] = $module->name;2064.         }

• AdminControllerCore->initTabModuleList - [line 2003 - classes/controller/AdminController.php]

  1998.             return;1999.         }2000. 2001.         $this->getLanguages();2002.         $this->initToolbar();2003.         $this->initTabModuleList();2004.         $this->initPageHeaderToolbar();2005. 2006.         if ($this->display == 'edit' || $this->display == 'add') {2007.             if (!$this->loadObject(true)) {2008.                 return;

• AdminControllerCore->initContent - [line 189 - classes/controller/Controller.php]

  184.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {185.                 $this->initHeader();186.             }187. 188.             if ($this->viewAccess()) {189.                 $this->initContent();190.             } else {191.                 $this->errors[] = Tools::displayError('Access denied.');192.             }193. 194.             if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {

• ControllerCore->run - [line 367 - classes/Dispatcher.php]

  362.             if (isset($params_hook_action_dispatcher)) {363.                 Hook::exec('actionDispatcher', $params_hook_action_dispatcher);364.             }365. 366.             // Running controller367.             $controller->run();368.         } catch (PrestaShopException $e) {369.             $e->displayMessage();370.         }371.     }372. 

• DispatcherCore->dispatch - [line 58 - admin/index.php]

  53. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) {54.     $_REQUEST['controller'] = strtolower($_REQUEST['tab']);55. }56. 57. // Prepare and trigger admin dispatcher58. Dispatcher::getInstance()->dispatch();

[Frits van Leeuwen]

Ik had een module om de B.O. ook op mijn mobiel te zien. Die is nu weer terug.

Bedankt voor de tip PrestaShop Apprentice om de boel door te sturen naar de techneuten van Prestashop..