• Priority: 0
  • Status: Closed
  • Theme: Alysum
  • Assigned To: Alex
  • Private: No
  • Open Date: 22.11.15, 13:49
  • Opened by: Jules Piccotti
  • Closed by: Alex
  • Closed on: 17.12.15, 10:14
  • Reason: Closed
  • Comment: Glad to help!

Ticket #8870 - Database error when saving theme settings

We just experience a very alarming error with alysum on our staging server, while trying to save the theme settings (after modifying the custom css).
Everything else is working, so I can’t imagine what could possibly be the cause.

Development website:
FO: http://staging.modicabeauty.co.uk/ BO: http://staging.modicabeauty.co.uk/administration login: support@promokit.eu
password: promokit!!
we have multistore enabled, the right store is “Modica staging”

Here is the full error, also available as screenshot:

[PrestaShopDatabaseException]

BIGINT UNSIGNED value is out of range in ‘(`bitnami_prestashop`.`ps_hook_module`.`position` - 1)’

UPDATE `ps_hook_module`

			SET `position`= position -1
			WHERE position between 0 AND 5
			AND `id_hook` = 164 AND `id_shop` = 1

at line 639 in file classes/db/Db.php
634. WebserviceRequest::getInstance()→setError(500, ‘[SQL Error] ‘.$this→getMsgError().’. From ‘.(isset($dbg[3][’class’]) ? $dbg[3][’class’] : ‘‘).’→‘.$dbg[3][’function’].’() Query was : ‘.$sql, 97);
635. }
636. elseif (_PS_DEBUG_SQL_ && $errno && !defined(’PS_INSTALLATION_IN_PROGRESS’))
637. {
638. if ($sql)
639. throw new PrestaShopDatabaseException($this→getMsgError().’<br /><br /><pre>’.$sql.’</pre>’);
640. throw new PrestaShopDatabaseException($this→getMsgError());
641. }
642. }
643.
644. /**
DbCore→displayError - [line 333 - classes/db/Db.php] - [1 Arguments]
DbCore→query - [line 473 - classes/db/Db.php] - [1 Arguments]
DbCore→execute - [line 1846 - classes/module/Module.php] - [1 Arguments]
ModuleCore→updatePosition - [line 546 - modules/pk_themesettings/pk_themesettings.php] - [3 Arguments]
pk_themesettings→updateModulesState - [line 445 - modules/pk_themesettings/pk_themesettings.php]
pk_themesettings→getContent - [line 828 - controllers/admin/AdminModulesController.php]
AdminModulesControllerCore→postProcessCallback - [line 1071 - controllers/admin/AdminModulesController.php]
AdminModulesControllerCore→postProcess - [line 171 - classes/controller/Controller.php]
ControllerCore→run - [line 374 - classes/Dispatcher.php]
DispatcherCore→dispatch - [line 54 - admin/index.php]

Comments

Alex 23 Nov 2015, 22:24

Hi. Disable the DEBUG mode

your_site/config/defines.inc.php

/* Debug only */
define('_PS_MODE_DEV_', true);

change “true” to “false”