(solucionado)Error en mi pagina, fuera de juego. (winetheme- 1.5.4.1)

[xatanax]

Hola,

 

tras intentar realizar un pedido de prueba se ha roto mi página.

 

Adjunto mensaje cuando accedo http://tedorado.com/index.php

 

Fatal error: Uncaught 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 ')) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`' at line 6

SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN ())
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
thrown in /customers/9/c/b/tedorado.com/httpd.www/classes/db/Db.php on line 607

Edited November 29, 2013 by xatanax (see edit history)

[xatanax]

[PrestaShopDatabaseException]

Table 'tedorado_com.ps_loyalty' doesn't exist
 

                SELECT l.id_loyalty, l.id_order
                FROM ps_loyalty AS l
                WHERE NOT EXISTS (
                    SELECT o.id_order
                    FROM ps_orders AS o
                    WHERE l.id_order = o.id_order)
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]
  Argument [0]
  
                  SELECT l.id_loyalty, l.id_order
                  FROM ps_loyalty AS l
                  WHERE NOT EXISTS (
                      SELECT o.id_order
                      FROM ps_orders AS o
                      WHERE l.id_order = o.id_order)
• DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]
  Argument [0]
  
                  SELECT l.id_loyalty, l.id_order
                  FROM ps_loyalty AS l
                  WHERE NOT EXISTS (
                      SELECT o.id_order
                      FROM ps_orders AS o
                      WHERE l.id_order = o.id_order)
• DbCore->executeS - [line 76 - modules/pscleanerpro/pscleanerpro.php] - [1 Arguments]
  Argument [0]
  
                  SELECT l.id_loyalty, l.id_order
                  FROM ps_loyalty AS l
                  WHERE NOT EXISTS (
                      SELECT o.id_order
                      FROM ps_orders AS o
                      WHERE l.id_order = o.id_order)
• psCleanerPro->postProcess - [line 173 - modules/pscleanerpro/pscleanerpro.php] - [0 Argument]
• psCleanerPro->getContent - [line 675 - controllers/admin/AdminModulesController.php] - [0 Argument]
• AdminModulesControllerCore->postProcessCallback - [line 795 - controllers/admin/AdminModulesController.php] - [0 Argument]
• AdminModulesControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 50 - xatanax/index.php] - [0 Argument]

Edited November 29, 2013 by xatanax (see edit history)

[xatanax]

He desactivado y activado el modulo lofcamera y ya me carga, pero me da este error:

 

Warning: Function addCSS() is deprecated in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php on line 74
in /customers/9/c/b/tedorado.com/httpd.www/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php on line 75
in /customers/9/c/b/tedorado.com/httpd.www/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php on line 76
in /customers/9/c/b/tedorado.com/httpd.www/classes/Tools.php on line 1845 Warning: Function addJS() is deprecated in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php on line 77
in /customers/9/c/b/tedorado.com/httpd.www/classes/Tools.php on line 1845 Warning: is_dir(): open_basedir restriction in effect. File(..) is not within the allowed path(s): (/customers/9/c/b/tedorado.com/httpd.www:/customers/9/c/b/tedorado.com/httpd.private:/customers/9/c/b/tedorado.com/tmp:/customers/tedorado.com/tedorado.com:/var/www/diagnostics:/usr/share/php) in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/config/lofcamera.php on line 51 Warning: file_exists(): open_basedir restriction in effect. File(/customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php/themes/default/default.tpl) is not within the allowed path(s): (/customers/9/c/b/tedorado.com/httpd.www:/customers/9/c/b/tedorado.com/httpd.private:/customers/9/c/b/tedorado.com/tmp:/customers/tedorado.com/tedorado.com:/var/www/diagnostics:/usr/share/php) in /customers/9/c/b/tedorado.com/httpd.www/modules/lofcamera/lofcamera.php on line 143 

 

tiene solucion?

[xatanax]

Conseguí solucionar el problema, pero no se si tendre problemas en el futuro por este error, lo doy por resuelto ya que nadie me comenta de que va el tema. Un saludo.

[xatanax]

En este tema no me deja editar el asunto, no se el motivo. jeje