rooty/Qware_core
0
0
Fork 0
Code Issues 6 Pull Requests 1 Actions Packages Projects Releases Wiki Activity

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

New Issue
Open
opened 2022-01-19 16:29:41 +01:00 by rooty · 0 comments
rooty commented 2022-01-19 16:29:41 +01:00
Owner
Copy Link
Copy Source

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 buglivemaster 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.
master
Branches Tags
Labels
Clear labels
bug
Something is not working
 duplicate
This issue or pull request already exists
 enhancement
New feature
 fixed
Issue/request fixed
 help wanted
Need some help
 invalid
Something is wrong
 live
Dépôt de la version de production
 live pull
Source code has been pulled on live
 local commit
Source code has been added and committed on local rpository
 master
Dépôt de la version de développement
 php7_migration
Php7 migration related
 php8_migration
Php8 migration related
 question
More information is needed
 remote push
Source code has been pushed to remote repository
 template
Templates related
 wontfix
This won't be fixed
No labels bug live master
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
Luc Zjarr rooty (Rooty)
No Assignees rooty
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: rooty/Qware_core#97