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

extonjaez
Topic Author
Offline

9 months 4 days ago - 9 months 4 days ago #370219 by extonjaez

500 A database error has occurred. Please enable debug mode for more information was created by extonjaez

-- 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

Code:

'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
       $this->connection   = $connection;
       $this->query        = $query;

       $query = $this->prepareParameterKeyMapping($query);

       $this->statement  = $connection->prepare($query);

       if (!$this->statement) {
           throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
       }
   }
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
       $this->connection   = $connection;
       $this->query        = $query;

       $query = $this->prepareParameterKeyMapping($query);

       $this->statement  = $connection->prepare($query);

       if (!$this->statement) {
           throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
       }
   }
Joomla\Database\Mysqli\MysqliStatement->__construct()
.../libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972
    * @since   2.0.0
    * @throws  PrepareStatementFailureException
    */
   protected function prepareStatement(string $query): StatementInterface
   {
       return new MysqliStatement($this->connection, $query);
   }

   /**
    * Unlocks tables in the database.
    *
Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
.../libraries/vendor/joomla/database/src/DatabaseDriver.php:1780

       $query->setLimit($limit, $offset);

       $sql = $this->replacePrefix((string) $query);

       $this->statement = $this->prepareStatement($sql);

       $this->sql    = $query;
       $this->limit  = (int) max(0, $limit);
       $this->offset = (int) max(0, $offset);

Joomla\Database\DatabaseDriver->setQuery()
.../administrator/components/com_hikashop/helpers/update.php:937
		$query = $c;
	}

	$query = trim($query);
	if(!empty($query) && $this->checkSQLquery($query)) {
		$this->db->setQuery($query);
		try {
			 $this->db->execute();
		} catch(Exception $e) {}
	}
	unset($query);
hikashopUpdateHelper->processSQLfile()
.../administrator/components/com_hikashop/helpers/update.php:866
(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');
EOD;
	$this->db->setQuery($query);
	$this->db->execute();

	$this->processSQLfile('currencies.sql');

	$this->db->setQuery($query);
	$this->db->execute();

	$config = hikashop_config();
hikashopUpdateHelper->addDefaultData()
.../administrator/components/com_hikashop/controllers/update.php:30
	$newConfig->installcomplete = 1;
	$config = hikashop_config();
	$config->save($newConfig);
	$updateHelper = hikashop_get('helper.update');
	$updateHelper->addJoomfishElements();
	$updateHelper->addDefaultData();
	$updateHelper->createUploadFolders();
	$lang = JFactory::getLanguage();
	$code = $lang->getTag();
	$updateHelper->installMenu($code);
	if($code != 'en-GB') {
updateController->install()
.../libraries/src/MVC/Controller/BaseController.php:730
       }

       // Record the actual task being fired
       $this->doTask = $doTask;

       return $this->$doTask();
   }

   /**
    * Method to get a model object, loading it if required.
    *
Joomla\CMS\MVC\Controller\BaseController->execute()
.../administrator/components/com_hikashop/hikashop.php:75
$app->enqueueMessage('Page not found : '.$taskGroup, 'warning');
return;
}

hikaInput::get()->set('view', $classGroup->getName() );
$classGroup->execute( hikaInput::get()->get('task','listing'));
$classGroup->redirect();
if(hikaInput::get()->getString('tmpl') !== 'component'){
echo hikashop_footer();
}

require_once()
.../libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
       // Load common and local language files.
       $lang->load($this->app->scope, JPATH_BASE) || $lang->load($this->app->scope, JPATH_BASE . '/components/' . $this->app->scope);

       // Execute the component
       $loader = static function ($path) {
           require_once $path;
       };
       $loader($path);
   }
}
Arguments

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

       // Execute the component
       $loader = static function ($path) {
           require_once $path;
       };
       $loader($path);
   }
}
Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
.../libraries/src/Component/ComponentHelper.php:361
       if (!static::isEnabled($option)) {
           throw new MissingComponentException(Text::_('JLIB_APPLICATION_ERROR_COMPONENT_NOT_FOUND'), 404);
       }

       ob_start();
       $app->bootComponent($option)->getDispatcher($app)->dispatch();
       $contents = ob_get_clean();

       // Revert the scope
       $app->scope = $scope;

Joomla\CMS\Component\ComponentHelper::renderComponent()
.../libraries/src/Application/AdministratorApplication.php:150
       $this->dispatchEvent(
           'onAfterInitialiseDocument',
           new AfterInitialiseDocumentEvent('onAfterInitialiseDocument', ['subject' => $this, 'document' => $document])
       );

       $contents = ComponentHelper::renderComponent($component);
       $document->setBuffer($contents, ['type' => 'component']);

       // Trigger the onAfterDispatch event.
       $this->dispatchEvent(
           'onAfterDispatch',
Joomla\CMS\Application\AdministratorApplication->dispatch()
.../libraries/src/Application/AdministratorApplication.php:206
           ['option' => 'com_users', 'task' => 'method.add'],
           ['option' => 'com_users', 'task' => 'method.save'],
       ]);

       // Dispatch the application
       $this->dispatch();

       // Mark afterDispatch in the profiler.
       JDEBUG ? $this->profiler->mark('afterDispatch') : null;
   }

Joomla\CMS\Application\AdministratorApplication->doExecute()
.../libraries/src/Application/CMSApplication.php:304
           $this->sanityCheckSystemVariables();
           $this->setupLogging();
           $this->createExtensionNamespaceMap();

           // Perform application routines.
           $this->doExecute();

           // If we have an application document object, render it.
           if ($this->document instanceof \Joomla\CMS\Document\Document) {
               // Render the application output.
               $this->render();
Joomla\CMS\Application\CMSApplication->execute()
.../administrator/includes/app.php:58

// Set the application as global app
\Joomla\CMS\Factory::$application = $app;

// Execute the application.
$app->execute();
require_once()
.../administrator/index.php:32
* define() is used rather than "const" to not error for PHP 5.2 and lower
*/
\define('_JEXEC', 1);

// Run the application - All executable code should be triggered through this file
require_once __DIR__ . '/includes/app.php';
Arguments

string(62) "/homepages/3/d4298756585/htdocs/administrator/includes/app.php"

Last edit: 9 months 4 days ago by nicolas.

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

nicolas
Offline

9 months 4 days ago #370220 by nicolas

Replied by nicolas on topic 500 A database error has occurred. Please enable debug mode for more information

Hi,

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

The following user(s) said Thank You: oxido

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

extonjaez
Topic Author
Offline

9 months 4 days ago #370221 by extonjaez

Replied by extonjaez on topic 500 A database error has occurred. Please enable debug mode for more information

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.103 seconds