PrestashopDatabaseException Page d'erreur

JoeDev1 · October 30, 2015

Bonjour, surprise ce matin en voulant me connecter pour continuer mes travaux sur mon site...

Une page d'erreur s'affiche:

[PrestaShopDatabaseException]

Failed to read auto-increment value from storage engine

INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('2', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')

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

617. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);618. 		}619. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))620. 		{621. 			if ($sql)622. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');623. 			throw new PrestaShopDatabaseException($this->getMsgError());624. 		}625. 	}626. 627. 	/**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 597 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 378 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 455 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 417 - classes/ObjectModel.php] - [2 Arguments]
ObjectModelCore->save - [line 189 - classes/Guest.php]
GuestCore::setNewGuest - [line 73 - modules/statsdata/statsdata.php] - [1 Arguments]
StatsData->hookFooter - [line 500 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 811 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initFooter - [line 185 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Je suis perdu...

Je viens de vouloir me connecter a mon back office, je ne peux pas aller sur la partie "module"... je ne peux donc rien faire de ce coter là...

voiçi le message dans le back office quand je clique sur "Module" :

[PrestaShopDatabaseException]

Got error -1 from storage engine

		UPDATE `ps_module` m		SET m.version = '1.3.0'		WHERE m.name = 'statslive'

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

617. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);618. 		}619. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))620. 		{621. 			if ($sql)622. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');623. 			throw new PrestaShopDatabaseException($this->getMsgError());624. 		}625. 	}626. 627. 	/**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 453 - classes/db/Db.php] - [1 Arguments]
DbCore->execute - [line 469 - classes/module/Module.php] - [1 Arguments]
ModuleCore::upgradeModuleVersion - [line 541 - classes/module/Module.php] - [2 Arguments]
ModuleCore::loadUpgradeVersionList - [line 490 - classes/module/Module.php] - [3 Arguments]
ModuleCore::needUpgrade - [line 402 - classes/module/Module.php] - [1 Arguments]
ModuleCore::initUpgradeModule - [line 1271 - controllers/admin/AdminModulesController.php] - [1 Arguments]
AdminModulesControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

Edited October 30, 2015 by JoeDev1 (see edit history)

tuk66 · October 30, 2015

The ps_guest table has wrong schema. Compare it with this:

CREATE TABLE IF NOT EXISTS `ps_guest` (
  `id_guest` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_operating_system` int(10) unsigned DEFAULT NULL,
  `id_web_browser` int(10) unsigned DEFAULT NULL,
  `id_customer` int(10) unsigned DEFAULT NULL,
  `javascript` tinyint(1) DEFAULT '0',
  `screen_resolution_x` smallint(5) unsigned DEFAULT NULL,
  `screen_resolution_y` smallint(5) unsigned DEFAULT NULL,
  `screen_color` tinyint(3) unsigned DEFAULT NULL,
  `sun_java` tinyint(1) DEFAULT NULL,
  `adobe_flash` tinyint(1) DEFAULT NULL,
  `adobe_director` tinyint(1) DEFAULT NULL,
  `apple_quicktime` tinyint(1) DEFAULT NULL,
  `real_player` tinyint(1) DEFAULT NULL,
  `windows_media` tinyint(1) DEFAULT NULL,
  `accept_language` varchar(8) DEFAULT NULL,
  `mobile_theme` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_guest`),
  KEY `id_customer` (`id_customer`),
  KEY `id_operating_system` (`id_operating_system`),
  KEY `id_web_browser` (`id_web_browser`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

JoeDev1 · October 30, 2015

Thank you for the reponse Tuk66, but i not understand..

What should I compare ? The problem is to where? on ps_guest? Thank's

tuk66 · October 30, 2015

The error is

Failed to read auto-increment value from storage engine

so I think the table schema for the ps_guest table is corrupted. Check it in phpMyAdmin.

JoeDev1 · October 30, 2015

Thank you for your help, I never go on phpmyadmin , I found the ps -guest table you advise me to change what is his ?

JoeDev1 · October 30, 2015

I just found the ps -guest table, but I do not know how to fix it ?

tuk66 · October 30, 2015

Check it first. Export the schema for the ps_guest table in SQL format.

JoeDev1 · October 30, 2015

I click on ps-guest and then export ?

JoeDev1 · October 30, 2015

I clik Quick or Custom ?

Exporting rows from "ps_guest" table

Export Method:

Quick - display only the minimal options
Custom - display all possible options

I will not make stupidity

Edited October 30, 2015 by JoeDev1 (see edit history)

JoeDev1 · October 30, 2015

I just checked

CREATE TABLE IF NOT EXISTS `ps_guest` (
`id_guest` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_operating_system` int(10) unsigned DEFAULT NULL,
`id_web_browser` int(10) unsigned DEFAULT NULL,
`id_customer` int(10) unsigned DEFAULT NULL,
`javascript` tinyint(1) DEFAULT '0',
`screen_resolution_x` smallint(5) unsigned DEFAULT NULL,
`screen_resolution_y` smallint(5) unsigned DEFAULT NULL,
`screen_color` tinyint(3) unsigned DEFAULT NULL,
`sun_java` tinyint(1) DEFAULT NULL,
`adobe_flash` tinyint(1) DEFAULT NULL,
`adobe_director` tinyint(1) DEFAULT NULL,
`apple_quicktime` tinyint(1) DEFAULT NULL,
`real_player` tinyint(1) DEFAULT NULL,
`windows_media` tinyint(1) DEFAULT NULL,
`accept_language` varchar(8) DEFAULT NULL,
`mobile_theme` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_guest`),
KEY `id_customer` (`id_customer`),
KEY `id_operating_system` (`id_operating_system`),
KEY `id_web_browser` (`id_web_browser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

JoeDev1 · October 30, 2015

Only difference

with the table that you have shown me is this: is missing on mine : AUTO_INCREMENT = 4

tuk66 · October 30, 2015

Open the SQL tab, insert this query to the window and then click the Go button (tested):

SELECT (MAX(id_guest) + 1) INTO @counter FROM ps_guest;
SET @sql = CONCAT('ALTER TABLE ps_guest AUTO_INCREMENT=',@counter);
PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;

Edited October 30, 2015 by tuk66 (see edit history)

JoeDev1 · October 30, 2015

when I click then SQL INSERT :

INSERT INTO `ps_guest`(`id_guest`, `id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16])

JoeDev1 · October 30, 2015

I do not know how to execute the request

JoeDev1 · October 30, 2015

is what I have to put it like this ?

SELECT (MAX(id_guest) + 1) INTO @counter FROM ps_guest;

SET @sql = CONCAT('ALTER TABLE ps_guest AUTO_INCREMENT=',@counter);

PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;INSERT INTO `ps_guest`(`id_guest`, `id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16])

tuk66 · October 30, 2015

I improved my description at https://www.prestashop.com/forums/topic/479676-prestashopdatabaseexception-page-derreur/?do=findComment&comment=2178102

JoeDev1 · October 30, 2015

is what I need to delete and only what you wrote me?

SELECT * FROM `ps_guest` WHERE 1 SELECT (MAX(id_guest) + 1) INTO @counter FROM ps_guest;

SET @sql = CONCAT('ALTER TABLE ps_guest AUTO_INCREMENT=',@counter);

PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;

Or only :

SELECT (MAX(id_guest) + 1) INTO @counter FROM ps_guest;

SET @sql = CONCAT('ALTER TABLE ps_guest AUTO_INCREMENT=',@counter);

PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;

thank you

tuk66 · October 30, 2015

The last one.

JoeDev1 · October 30, 2015

#1030 - Got error -1 from storage engine

tuk66 · October 30, 2015

This explains the previous problem. Please ask your server administrator. It seems your database recently crashed. It can need a repair. We can't do it at the forum.

JoeDev1 · October 30, 2015

I do not understand what's the problem ? this is my web host ?

tuk66 · October 30, 2015

Perhaps.

JoeDev1 · October 30, 2015

Last night everything was working correctly and this morning it is my problem ... hebergeur poses problem for you?

Thank you for all

JoeDev1 · October 30, 2015

Je n'ai pas de bonnes nouvelles... rien a faire sa ne fonctionne toujours pas.. et je n'ai aucune idée d'ou sa peut venir... je suis déprimé!

JoeDev1 · October 30, 2015

J'ai mis 300 articles en ventes sur mon site, avec 3 photos par article, est ce qu'il ce pourrait que ce soit la cause du probleme ?

Mais je pense pas la base de donnée n'a pas l'air pleine.

Mon hebergeur me dit que tout est ok...

Je rappel que hier soir tout fonctionnait nickel! et là ce matin :

[PrestaShopDatabaseException]

Failed to read auto-increment value from storage engine

Le site aurait du etre mis en ligne la semaine prochaine

PrestashopDatabaseException Page d'erreur

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in