[COMMUNITY] Syntax error or access violation on creation #97

New Issue

rooty · 2022-01-19T16:29:41+01:00

rooty commented

2022-01-19 16:29:41 +01:00

When tried to create a community that contains a quote, the platform returns an error :

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 in [...]/lib/system/system_data_source/database/mypdo.php:187\nStack trace:\n#0 [...]/lib/system/system_data_source/database/mypdo.php(187): PDOStatement->execute()\n#1 [...]/lib/system/system_coordination/ressource/coordinationobjmanagerdb.php(191): mypdo->sql_query()\n#2 [...]lib/system/system_coordination/coordinationobjmanager.php(225): CoordinationObjManagerDb->doLoadFromId()\n#3 [...]/lib/system/system_coordination/coordinationobjmanager.php(550): CoordinationObjManager->sourceLoadFromId()\n#4 [...]/lib/object_plugin/navigation/navigation.php(115): CoordinationObjManager->createInstance()\n#5 [...]/lib/object_plugin/navigation/navigation.php(301): Navigation::idToSessionCoordinationObject()\n#6 [...]/lib/object_printing/navigationprint/navigationprint.php(140): Navigation::formatUrl()\n#7 [...]/lib/system/system_printing/printingmanager.php(185): NavigationPrint->__print()\n#8 [...]/lib/system/system_control/systemcontrol.php(368): PrintingManager->execPrinting()\n#9 [...]/lib/system/system_control/systemcontrol.php(310): SystemControl->outputExecutionPage()\n#10 [...]/index.php(78): SystemControl->execute()\n#11 {main}\n  thrown in [...]/lib/system/system_data_source/database/mypdo.php on line 187

When tried to create a community that contains a quote, the platform returns an error : ``` PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 in [...]/lib/system/system_data_source/database/mypdo.php:187\nStack trace:\n#0 [...]/lib/system/system_data_source/database/mypdo.php(187): PDOStatement->execute()\n#1 [...]/lib/system/system_coordination/ressource/coordinationobjmanagerdb.php(191): mypdo->sql_query()\n#2 [...]lib/system/system_coordination/coordinationobjmanager.php(225): CoordinationObjManagerDb->doLoadFromId()\n#3 [...]/lib/system/system_coordination/coordinationobjmanager.php(550): CoordinationObjManager->sourceLoadFromId()\n#4 [...]/lib/object_plugin/navigation/navigation.php(115): CoordinationObjManager->createInstance()\n#5 [...]/lib/object_plugin/navigation/navigation.php(301): Navigation::idToSessionCoordinationObject()\n#6 [...]/lib/object_printing/navigationprint/navigationprint.php(140): Navigation::formatUrl()\n#7 [...]/lib/system/system_printing/printingmanager.php(185): NavigationPrint->__print()\n#8 [...]/lib/system/system_control/systemcontrol.php(368): PrintingManager->execPrinting()\n#9 [...]/lib/system/system_control/systemcontrol.php(310): SystemControl->outputExecutionPage()\n#10 [...]/index.php(78): SystemControl->execute()\n#11 {main}\n thrown in [...]/lib/system/system_data_source/database/mypdo.php on line 187 ```

rooty added the

bug

live

master

labels 2022-01-19 16:29:41 +01:00

rooty self-assigned this 2022-01-19 16:29:41 +01:00

Sign in to join this conversation.