Perl 5.32.1.1 Released #64

Strawberry perl 5.32.1.1 is released

Our Supporters

Bear
AM Graphix
Simplify your web
OCH
Tassos gr
codium

Sorry, this website uses features that your browser doesn't support. Upgrade to a newer version of Firefox, Chrome, Safari, or Edge and you'll be all set.

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 ' UTC_TIMESTAMP()), DATEDIFF(UTC_TIMESTAMP(), to_date)) AS number_days FROM rh...' at line 1 (500 Whoops, looks like something went wrong.)

mysqli_sql_exception

HTTP 500 Whoops, looks like something went wrong.

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 ' UTC_TIMESTAMP()), DATEDIFF(UTC_TIMESTAMP(), to_date)) AS number_days
FROM rh...' at line 1

Exception

mysqli_sql_exception

Show exception properties 
mysqli_sql_exception {#4381
  #sqlstate: "42000"
}
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 138)
  1. $this->connection = $connection;
  2. $this->query = $query;
  4. $query = $this->prepareParameterKeyMapping($query);
  6. $this->statement = $connection->prepare($query);
  8. if (!$this->statement) {
  9. throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
  10. }
  11. }
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php -> prepare (line 138)
  1. $this->connection = $connection;
  2. $this->query = $query;
  4. $query = $this->prepareParameterKeyMapping($query);
  6. $this->statement = $connection->prepare($query);
  8. if (!$this->statement) {
  9. throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
  10. }
  11. }
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> __construct (line 972)
  1. * @since 2.0.0
  2. * @throws PrepareStatementFailureException
  3. */
  4. protected function prepareStatement(string $query): StatementInterface
  5. {
  6. return new MysqliStatement($this->connection, $query);
  7. }
  9. /**
  10. * Unlocks tables in the database.
  11. *
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php -> prepareStatement (line 1780)
  2. $query->setLimit($limit, $offset);
  4. $sql = $this->replacePrefix((string) $query);
  6. $this->statement = $this->prepareStatement($sql);
  8. $this->sql = $query;
  9. $this->limit = (int) max(0, $limit);
  10. $this->offset = (int) max(0, $offset);
DatabaseDriver->setQuery() in /var/www/vhosts/bearsampp.com/public_html/plugins/system/osmembershipreminder/src/Extension/Reminder.php (line 358)
  1. if (!$this->params->get('send_to_group_members'))
  2. {
  3. $query->where('a.group_admin_id = 0');
  4. }
  6. $db->setQuery($query, 0, $numberEmailSendEachTime);
  8. try
  9. {
  10. return $db->loadObjectList();
  11. }
Reminder->getSubscriptionsToSendReminder() in /var/www/vhosts/bearsampp.com/public_html/plugins/system/osmembershipreminder/src/Extension/Reminder.php (line 143)
  1. PluginHelper::importPlugin('osmembership');
  3. $app = $this->getApplication();
  5. // Send first reminder
  6. $rows = $this->getSubscriptionsToSendReminder(1, $numberEmailSendEachTime);
  8. if (count($rows) > 0)
  9. {
  10. $reminderType = 'first_reminder';
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 454)
  1. foreach ($this->listeners[$event->getName()] as $listener) {
  2. if ($event->isStopped()) {
  3. return $event;
  4. }
  6. $listener($event);
  7. }
  8. }
  10. return $event;
  11. }
in /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/application/src/AbstractApplication.php -> dispatch (line 99)
  1. $dispatcher = $this->getDispatcher();
  2. } catch (\UnexpectedValueException $exception) {
  3. return null;
  4. }
  6. return $dispatcher->dispatch($eventName, $event ?: new ApplicationEvent($eventName, $this));
  7. }
  9. /**
  10. * Method to run the application routines.
  11. *
AbstractApplication->dispatchEvent() in /var/www/vhosts/bearsampp.com/public_html/libraries/src/Application/CMSApplication.php (line 347)
  2. // Send the application response.
  3. $this->respond();
  5. // Trigger the onAfterRespond event.
  6. $this->dispatchEvent(
  7. 'onAfterRespond',
  8. new AfterRespondEvent('onAfterRespond', ['subject' => $this])
  9. );
  10. }
CMSApplication->execute() in /var/www/vhosts/bearsampp.com/public_html/includes/app.php (line 58)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/var/www/vhosts/bearsampp.com/public_html/includes/app.php') in /var/www/vhosts/bearsampp.com/public_html/index.php (line 51)
  1. // ... die
  2. die();
  3. }
  5. // Run the application - All executable code should be triggered through this file
  6. require_once __DIR__ . '/includes/app.php';

Stack Trace

mysqli_sql_exception 
mysqli_sql_exception:
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 ' UTC_TIMESTAMP()), DATEDIFF(UTC_TIMESTAMP(), to_date)) AS number_days
FROM rh...' at line 1

  at /var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
  at mysqli->prepare()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138)
  at Joomla\Database\Mysqli\MysqliStatement->__construct()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972)
  at Joomla\Database\Mysqli\MysqliDriver->prepareStatement()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1780)
  at Joomla\Database\DatabaseDriver->setQuery()
     (/var/www/vhosts/bearsampp.com/public_html/plugins/system/osmembershipreminder/src/Extension/Reminder.php:358)
  at JoomDonation\MembershipPro\Plugin\System\Reminder\Extension\Reminder->getSubscriptionsToSendReminder()
     (/var/www/vhosts/bearsampp.com/public_html/plugins/system/osmembershipreminder/src/Extension/Reminder.php:143)
  at JoomDonation\MembershipPro\Plugin\System\Reminder\Extension\Reminder->onAfterRespond()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/event/src/Dispatcher.php:454)
  at Joomla\Event\Dispatcher->dispatch()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/vendor/joomla/application/src/AbstractApplication.php:99)
  at Joomla\Application\AbstractApplication->dispatchEvent()
     (/var/www/vhosts/bearsampp.com/public_html/libraries/src/Application/CMSApplication.php:347)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/var/www/vhosts/bearsampp.com/public_html/includes/app.php:58)
  at require_once('/var/www/vhosts/bearsampp.com/public_html/includes/app.php')
     (/var/www/vhosts/bearsampp.com/public_html/index.php:51)