- 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
Hi. Disable the DEBUG mode
your_site/config/defines.inc.php
change “true” to “false”