Jump to content

[RESOLU] Problème de page blanche page catégorie

Miryam68
 Share

Recommended Posts

Miryam68 Newbie

Miryam68

Posted
Posted (edited)

Bonjour

 

Suite à des problèmes de bases de données sql , au niveau des catégories , j'arrive pas à règler un problème de page blanche : nour-al-akhawates.com

 

 

RESOLU ; en supprimant encore les catégories par le back office

 

puis finalement : 

 

Pas résolu : Problème de page blanche page catégorie : 

 

 

Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/homez.744/nouralak/www/themes/PRS020038/product-list.tpl" on line 63 "<a class="button ajax_add_to_cart_button exclusive" rel="ajax_id_product_{$product.id_product|intval}" href="{$link->getPageLink('cart',false, NULL, "add=1&amp;id_product={$product.id_product|intval}&amp;token={$static_token}", false)}" title="{l s='Add to cart'}"><span></span>{l s='Add to cart'}</a>" - Unexpected "<"' in /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:667 Stack trace: #0 /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templateparser.php(3144): Smarty_Internal_TemplateCompilerBase->trigger_template_error() #1 /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templateparser.php(3209): Smarty_Internal_Templateparser->yy_syntax_error(69, '<') #2 /homez.74 in/homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 667

Edited by Miryam68 (see edit history)
Link to comment
Share on other sites
Miryam68 Newbie

Miryam68

Posted
  • Author
Posted

merci pour votre réponse,

 

Oui jlavais déjà fais , mais rien ne s'affiche : 

 

/* Debug only */
define('_PS_MODE_DEV_', true);
if (_PS_MODE_DEV_)
{
@ini_set('display_errors', 'on');
@error_reporting(E_ALL | E_STRICT);
define('_PS_DEBUG_SQL_', true);
/* Compatibility warning */
define('_PS_DISPLAY_COMPATIBILITY_WARNING_', true);
}
else
{
@ini_set('display_errors', 'off');
define('_PS_DEBUG_SQL_', false);
/* Compatibility warning */
define('_PS_DISPLAY_COMPATIBILITY_WARNING_', false);
}
 
define('_PS_DEBUG_PROFILING_', true);
define('_PS_MODE_DEMO_', false);
Link to comment
Share on other sites
Miryam68 Newbie

Miryam68

Posted
  • Author
Posted

:) Non 

 

Le problème que je voulais règler à la base c'était des pag quand on clique sur les catégories , 

 

Ensuite j'ai fait truncate catégorie dans le serveur sql , ce qui a fait planter le site et on pouvait mm plus toucher au catégorie dans l'admin, impossible d'en créer 

 

Puis j'ai essayer de réparer la partie catégorie dans sql en me basant sur une autre base de donnée et la on peut recréer des catégories mais le site erreur  500 maintenant

Link to comment
Share on other sites
Miryam68 Newbie

Miryam68

Posted
  • Author
Posted

le 14.11

 

*ERROR* 2013/11/14 - 10:17:44: Parent category does not exist at line 377 in file classes/Category.php
*ERROR* 2013/11/14 - 10:18:05: Parent category does not exist at line 377 in file classes/Category.php
 
 
Javais du coup recharger les classes propres de la même version presta 

*ERROR* 2013/08/14 - 17:48:33: MySQL server has gone away<br /><br /><pre>
SELECT `id_zone`, `name`
FROM `pss_zone`
WHERE `active` = 1
</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/14 - 17:50:27: MySQL server has gone away<br /><br /><pre>
SELECT `id_zone`, `name`
FROM `pss_zone`
WHERE `active` = 1
</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/14 - 17:50:57: MySQL server has gone away<br /><br /><pre>
SELECT `id_zone`, `name`
FROM `pss_zone`
WHERE `active` = 1
</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/14 - 17:52:59: MySQL server has gone away<br /><br /><pre>
SELECT `id_zone`, `name`
FROM `pss_zone`
WHERE `active` = 1
</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/14 - 17:53:01: MySQL server has gone away<br /><br /><pre>
SELECT `id_zone`, `name`
FROM `pss_zone`
WHERE `active` = 1
</pre> at line 607 in file classes/db/Db.php
 
Link to comment
Share on other sites
Miryam68 Newbie

Miryam68

Posted
  • Author
Posted

et aussi :
 

*ERROR* 2013/08/15 - 10:46:21: Table 'pss_blocklink_shop' already exists<br /><br /><pre>
CREATE TABLE pss_blocklink_shop (
`id_blocklink` int(2) NOT NULL AUTO_INCREMENT, 
`id_shop` int(2) NOT NULL,
PRIMARY KEY(`id_blocklink`, `id_shop`))
ENGINE=MyISAM default CHARSET=utf8</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:11: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>INSERT INTO pss_blocklink_lang VALUES (1, 1, 'Facebook')</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:19: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>INSERT INTO pss_blocklink_lang VALUES (2, 1, 'Facebook')</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:26: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>INSERT INTO pss_blocklink_lang VALUES (3, 1, 'Facebook')</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:38: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>INSERT INTO pss_blocklink_lang VALUES (4, 1, 'Facebook')</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:51: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>SELECT `id_lang`, `text` 
FROM pss_blocklink_lang 
WHERE `id_blocklink`=1</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:51: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>SELECT `id_lang`, `text` 
FROM pss_blocklink_lang 
WHERE `id_blocklink`=1</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:47:57: Table 'nouralakmod1.pss_blocklink_lang' doesn't exist<br /><br /><pre>SELECT `id_lang`, `text` 
FROM pss_blocklink_lang 
WHERE `id_blocklink`=1</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:48:15: Unknown table 'pss_blocklink_lang'<br /><br /><pre>DROP TABLE pss_blocklink_lang</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:57:41: Db->executeS() must be used only with select, show, explain or describe queries at line 470 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:58:16: Table 'nouralakmod1.pss_CrCom_social' doesn't exist<br /><br /><pre>select * from pss_CrCom_social</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:58:25: Table 'nouralakmod1.pss_CrCom_social' doesn't exist<br /><br /><pre>select * from pss_CrCom_social</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:58:29: Table 'nouralakmod1.pss_CrCom_social' doesn't exist<br /><br /><pre>select * from pss_CrCom_social</pre> at line 607 in file classes/db/Db.php
*ERROR* 2013/08/15 - 10:58:42: Db->executeS() must be used only with select, show, explain or describe queries at line 470 in file classes/db/Db.php
Link to comment
Share on other sites
2FR3 Newbie

2FR3

Posted
Posted (edited)

Hum, c'est la misère ...

Pour la premiere partie, il faut regardé les logs MySQL pour savoir pourquoi il dit merde !

Pour la seconde, creez les tables (ou les champs) manuellement.

 

Toujours faire une sauvegarde avant toutes modifications !

 

Regardez aussi si votre class n'est pas surchargée (override)!

Si c'est le cas, renomez le fichier, ne l'effacez pas.

Edited by 2FR3 (see edit history)
Link to comment
Share on other sites
Gregory Roussac Newbie

Gregory Roussac

Posted
Posted

Bonjour,

 

Je ne vois pas comment sans back up de la base vous pourriez recuperer le fonctionnement.

 

Le truncate est fatal, en plus cela a du supprimer les root categories. Je ne vois pas d'issue a votre problème. D'autant plus que les identifiants des catégories sont dans toutes les autres tables qui ont pour clé externe id_category.

 

Ce sera insolvable comme souci je pense, ne jamais au grand jamais faire de manipulation en base sans back up.

 

Cordialement

Link to comment
Share on other sites
Miryam68 Newbie

Miryam68

Posted
  • Author
Posted

Retour de la page blanche sur catégorie ..................

 

avec erreur cette fois : 

Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/homez.744/nouralak/www/themes/PRS020038/product-list.tpl" on line 63 "<a class="button ajax_add_to_cart_button exclusive" rel="ajax_id_product_{$product.id_product|intval}" href="{$link->getPageLink('cart',false, NULL, "add=1&amp;id_product={$product.id_product|intval}&amp;token={$static_token}", false)}" title="{l s='Add to cart'}"><span></span>{l s='Add to cart'}</a>" - Unexpected "<"' in /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:667 Stack trace: #0 /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templateparser.php(3144): Smarty_Internal_TemplateCompilerBase->trigger_template_error() #1 /homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templateparser.php(3209): Smarty_Internal_Templateparser->yy_syntax_error(69, '<') #2 /homez.74 in/homez.744/nouralak/www/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 667
Link to comment
Share on other sites
Gregory Roussac Newbie

Gregory Roussac

Posted
Posted

Re,

 

Le message me semble déjà pourtant compréhensible  :

Error in template "/homez.744/nouralak/www/themes/PRS020038/product-list.tpl" on line 63

A priori vous avez un souci ligne 63 de product-list.tpl dans votre thème. Le fichier du theme par defaut est ici https://github.com/PrestaShop/PrestaShop/blob/development/themes/default/product-list.tpl

 

Cordialement

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...