exception 'RuntimeException' with message '[Microsoft][SQL Server Native Client 11.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert au√üerhalb des g√ľltigen Bereichs.SQL=SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.slogande, a.authorde, a.bgimg, a.colortheme, a.textintro, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '1900-01-01 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM znet_content AS a LEFT JOIN znet_categories AS c on c.id = a.catid LEFT JOIN znet_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM znet_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN znet_categories as parent ON parent.id = c.parent_id LEFT JOIN znet_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM znet_categories AS cat JOIN znet_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 55 AND (a.publish_up = '1900-01-01 00:00:00' OR a.publish_up <= '2019-07-19 02:31:17') AND (a.publish_down = '1900-01-01 00:00:00' OR a.publish_down >= '2019-07-19 02:31:17') AND (a.state = 1 OR a.state =2)' in C:\inetpub\htdocs\charmeandcharity.de\libraries\joomla\database\driver\sqlsrv.php:634 Stack trace: #0 C:\inetpub\htdocs\charmeandcharity.de\libraries\joomla\database\driver.php(1179): JDatabaseDriverSqlsrv->execute() #1 C:\inetpub\htdocs\charmeandcharity.de\components\com_content\models\article.php(151): JDatabaseDriver->loadObject() #2 C:\inetpub\htdocs\charmeandcharity.de\libraries\legacy\view\legacy.php(394): ContentModelArticle->getItem() #3 C:\inetpub\htdocs\charmeandcharity.de\components\com_content\views\article\view.html.php(38): JViewLegacy->get('Item') #4 C:\inetpub\htdocs\charmeandcharity.de\libraries\legacy\controller\legacy.php(685): ContentViewArticle->display() #5 C:\inetpub\htdocs\charmeandcharity.de\components\com_content\controller.php(79): JControllerLegacy->display(true, Array) #6 C:\inetpub\htdocs\charmeandcharity.de\libraries\legacy\controller\legacy.php(722): ContentController->display() #7 C:\inetpub\htdocs\charmeandcharity.de\components\com_content\content.php(16): JControllerLegacy->execute(NULL) #8 C:\inetpub\htdocs\charmeandcharity.de\libraries\legacy\component\helper.php(359): require_once('C:\inetpub\htdo...') #9 C:\inetpub\htdocs\charmeandcharity.de\libraries\legacy\component\helper.php(339): JComponentHelper::executeComponent('C:\inetpub\htdo...') #10 C:\inetpub\htdocs\charmeandcharity.de\includes\application.php(218): JComponentHelper::renderComponent('com_content') #11 C:\inetpub\htdocs\charmeandcharity.de\index.php(61): JSite->dispatch() #12 {main}



Fehler beim Laden des Moduls: [Microsoft][SQL Server Native Client 11.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert au√üerhalb des g√ľltigen Bereichs.SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM znet_modules AS m LEFT JOIN znet_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN znet_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '1900-01-01 00:00:00' OR m.publish_up <= '2019-07-19 02:31:17') AND (m.publish_down = '1900-01-01 00:00:00' OR m.publish_down >= '2019-07-19 02:31:17') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 187 OR mm.menuid <= 0) AND m.language IN ('de-DE','*') ORDER BY m.position, m.ordering