500 A database error has occurred. Please enable debug mode for more information

  • Posts: 53
  • Thank you received: 3
  • Hikaauction Standard Hikaserial Subscription Hikashop Business
11 hours 53 minutes ago #370219

-- HikaShop version -- : 6.3
-- Joomla version -- : 5.42
-- PHP version -- : 8.3x
-- Browser(s) name and version -- : Chrome à jour Version 144.0.7559.110 (Build officiel) (64 bits)
-- Error-message(debug-mod must be tuned on) -- : 500 A database error has occurred. Please enable debug mode for more information.during update from 6.2 to 6.3

Hello

I have this error during update from 6.2 to 6.3

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near

'mon_grouping";s:1:"3";s:13:"positive_sign";s:0:"";s:13:"negative_sign";s:1:"-...' at line 152
.../libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
133         $this->connection   = $connection;
134         $this->query        = $query;
135 
136         $query = $this->prepareParameterKeyMapping($query);
137 
138         $this->statement  = $connection->prepare($query);
139 
140         if (!$this->statement) {
141             throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
142         }
143     }
mysqli->prepare()
Joomla\Database\Mysqli\MysqliStatement->__construct()
Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
Joomla\Database\DatabaseDriver->setQuery()
hikashopUpdateHelper->processSQLfile()
hikashopUpdateHelper->addDefaultData()
updateController->install()
Joomla\CMS\MVC\Controller\BaseController->execute()
require_once()
Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()
Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
Joomla\CMS\Component\ComponentHelper::renderComponent()
Joomla\CMS\Application\AdministratorApplication->dispatch()
Joomla\CMS\Application\AdministratorApplication->doExecute()
Joomla\CMS\Application\CMSApplication->execute()
require_once()
mysqli->prepare()
.../libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
133         $this->connection   = $connection;
134         $this->query        = $query;
135 
136         $query = $this->prepareParameterKeyMapping($query);
137 
138         $this->statement  = $connection->prepare($query);
139 
140         if (!$this->statement) {
141             throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
142         }
143     }
Joomla\Database\Mysqli\MysqliStatement->__construct()
.../libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972
967      * @since   2.0.0
968      * @throws  PrepareStatementFailureException
969      */
970     protected function prepareStatement(string $query): StatementInterface
971     {
972         return new MysqliStatement($this->connection, $query);
973     }
974 
975     /**
976      * Unlocks tables in the database.
977      *
Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
.../libraries/vendor/joomla/database/src/DatabaseDriver.php:1780
1775 
1776         $query->setLimit($limit, $offset);
1777 
1778         $sql = $this->replacePrefix((string) $query);
1779 
1780         $this->statement = $this->prepareStatement($sql);
1781 
1782         $this->sql    = $query;
1783         $this->limit  = (int) max(0, $limit);
1784         $this->offset = (int) max(0, $offset);
1785 
Joomla\Database\DatabaseDriver->setQuery()
.../administrator/components/com_hikashop/helpers/update.php:937
932 			$query = $c;
933 		}
934 
935 		$query = trim($query);
936 		if(!empty($query) && $this->checkSQLquery($query)) {
937 			$this->db->setQuery($query);
938 			try {
939 				 $this->db->execute();
940 			} catch(Exception $e) {}
941 		}
942 		unset($query);
hikashopUpdateHelper->processSQLfile()
.../administrator/components/com_hikashop/helpers/update.php:866
861 (11, 'Order to ship', 'O:8:"stdClass":27:{s:7:"display";s:7:"listing";s:9:"date_type";s:7:"created";s:10:"date_group";s:5:"%j %Y";s:10:"periodType";s:14:"proposedPeriod";s:14:"proposedPeriod";s:3:"all";s:6:"period";s:1:"0";s:7:"content";s:6:"orders";s:7:"filters";s:54:"a:1:{s:14:"a.order_status";a:1:{i:0;s:9:"confirmed";}}";s:15:"category_childs";s:1:"0";s:9:"customers";s:14:"last_customers";s:15:"customers_order";s:5:"sales";s:8:"partners";s:14:"last_customers";s:14:"partners_order";s:5:"sales";s:12:"compare_with";s:7:"periods";s:14:"period_compare";s:4:"none";s:5:"limit";s:0:"";s:6:"region";s:5:"world";s:6:"format";s:5:"UTF-8";s:10:"map_source";s:8:"shipping";s:12:"product_data";s:5:"sales";s:16:"product_order_by";s:4:"best";s:15:"orders_order_by";s:4:"last";s:8:"compares";N;s:10:"categories";s:3:"all";s:8:"products";s:6:"a:0:{}";s:7:"coupons";s:6:"a:0:{}";s:6:"status";s:0:"";}', 0, 11, 'all');
862 EOD;
863 		$this->db->setQuery($query);
864 		$this->db->execute();
865 
866 		$this->processSQLfile('currencies.sql');
867 
868 		$this->db->setQuery($query);
869 		$this->db->execute();
870 
871 		$config = hikashop_config();
hikashopUpdateHelper->addDefaultData()
.../administrator/components/com_hikashop/controllers/update.php:30
25 		$newConfig->installcomplete = 1;
26 		$config = hikashop_config();
27 		$config->save($newConfig);
28 		$updateHelper = hikashop_get('helper.update');
29 		$updateHelper->addJoomfishElements();
30 		$updateHelper->addDefaultData();
31 		$updateHelper->createUploadFolders();
32 		$lang = JFactory::getLanguage();
33 		$code = $lang->getTag();
34 		$updateHelper->installMenu($code);
35 		if($code != 'en-GB') {
updateController->install()
.../libraries/src/MVC/Controller/BaseController.php:730
725         }
726 
727         // Record the actual task being fired
728         $this->doTask = $doTask;
729 
730         return $this->$doTask();
731     }
732 
733     /**
734      * Method to get a model object, loading it if required.
735      *
Joomla\CMS\MVC\Controller\BaseController->execute()
.../administrator/components/com_hikashop/hikashop.php:75
70 	$app->enqueueMessage('Page not found : '.$taskGroup, 'warning');
71 	return;
72 }
73 
74 hikaInput::get()->set('view', $classGroup->getName() );
75 $classGroup->execute( hikaInput::get()->get('task','listing'));
76 $classGroup->redirect();
77 if(hikaInput::get()->getString('tmpl') !== 'component'){
78 	echo hikashop_footer();
79 }
80 
require_once()
.../libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
66         // Load common and local language files.
67         $lang->load($this->app->scope, JPATH_BASE) || $lang->load($this->app->scope, JPATH_BASE . '/components/' . $this->app->scope);
68 
69         // Execute the component
70         $loader = static function ($path) {
71             require_once $path;
72         };
73         $loader($path);
74     }
75 }
Arguments
0	
string(82) "/homepages/3/d4298756585/htdocs/administrator/components/com_hikashop/hikashop.php"
Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()
.../libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
68 
69         // Execute the component
70         $loader = static function ($path) {
71             require_once $path;
72         };
73         $loader($path);
74     }
75 }
Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
.../libraries/src/Component/ComponentHelper.php:361
356         if (!static::isEnabled($option)) {
357             throw new MissingComponentException(Text::_('JLIB_APPLICATION_ERROR_COMPONENT_NOT_FOUND'), 404);
358         }
359 
360         ob_start();
361         $app->bootComponent($option)->getDispatcher($app)->dispatch();
362         $contents = ob_get_clean();
363 
364         // Revert the scope
365         $app->scope = $scope;
366 
Joomla\CMS\Component\ComponentHelper::renderComponent()
.../libraries/src/Application/AdministratorApplication.php:150
145         $this->dispatchEvent(
146             'onAfterInitialiseDocument',
147             new AfterInitialiseDocumentEvent('onAfterInitialiseDocument', ['subject' => $this, 'document' => $document])
148         );
149 
150         $contents = ComponentHelper::renderComponent($component);
151         $document->setBuffer($contents, ['type' => 'component']);
152 
153         // Trigger the onAfterDispatch event.
154         $this->dispatchEvent(
155             'onAfterDispatch',
Joomla\CMS\Application\AdministratorApplication->dispatch()
.../libraries/src/Application/AdministratorApplication.php:206
201             ['option' => 'com_users', 'task' => 'method.add'],
202             ['option' => 'com_users', 'task' => 'method.save'],
203         ]);
204 
205         // Dispatch the application
206         $this->dispatch();
207 
208         // Mark afterDispatch in the profiler.
209         JDEBUG ? $this->profiler->mark('afterDispatch') : null;
210     }
211 
Joomla\CMS\Application\AdministratorApplication->doExecute()
.../libraries/src/Application/CMSApplication.php:304
299             $this->sanityCheckSystemVariables();
300             $this->setupLogging();
301             $this->createExtensionNamespaceMap();
302 
303             // Perform application routines.
304             $this->doExecute();
305 
306             // If we have an application document object, render it.
307             if ($this->document instanceof \Joomla\CMS\Document\Document) {
308                 // Render the application output.
309                 $this->render();
Joomla\CMS\Application\CMSApplication->execute()
.../administrator/includes/app.php:58
53 
54 // Set the application as global app
55 \Joomla\CMS\Factory::$application = $app;
56 
57 // Execute the application.
58 $app->execute();
require_once()
.../administrator/index.php:32
27  * define() is used rather than "const" to not error for PHP 5.2 and lower
28  */
29 \define('_JEXEC', 1);
30 
31 // Run the application - All executable code should be triggered through this file
32 require_once __DIR__ . '/includes/app.php';
Arguments
0	
string(62) "/homepages/3/d4298756585/htdocs/administrator/includes/app.php"

Last edit: 9 hours 36 minutes ago by nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 85030
  • Thank you received: 13861
  • MODERATOR
9 hours 23 minutes ago #370220

Hi,

Thank you for your feedback. I've made a patch for this. Please try again.

Please Log in or Create an account to join the conversation.

  • Posts: 53
  • Thank you received: 3
  • Hikaauction Standard Hikaserial Subscription Hikashop Business
8 hours 55 minutes ago #370221

Works!
Merci ;-)

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum