-
Type: Bug
-
Status: Closed (View Workflow)
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: 1.1 Swallows
-
Fix Version/s: 1.2 Swallows, 1.5 Swallows, 1.4 Swallows
-
Labels:None
-
Sprint:1.2 Swallows
Steps to reproduce
Table "Users" has to contain user with username \ (i.e. backslash,single character)
1. Go to Poulpe, select in side menu Components -> Components, right mouse button click on "Admin panel", select "Backup Database", save backup
2. Import saved in previous step DB to the server
Actual result
Receiving error:
SQL-запрос: INSERT INTO `USERS` (ID,UUID,FIRST_NAME,LAST_NAME,USERNAME,ENCODED_USERNAME,EMAIL,PASSWORD,ROLE,LAST_LOGIN,AVATAR,BAN_REASON,SALT,REGISTRATION_DATE) VALUES (113,'e237ed3f-d7f4-4af5-92b7-e5382ebc95a9',NULL,NULL,'\','%5C','a2674974@rmqkr.net','1e891e6e45b18577279154da2ba37472',NULL,'2012-12-18 19:48:33.0','[B@3eaf805e',NULL,'','2012-12-18 19:47:50.0'); INSERT INTO `USERS` (ID,UUID,FIRST_NAME,LAST_NAME,USERNAME,ENCODED_USERNAME,EMAIL,PASSWORD,ROLE,LAST_LOGIN,AVATAR,BAN_REASON,SALT,REGISTRATION_DATE) VALUES (114,'1726877e-beec-4fc1-9136-c1d2f66da575',NULL,NULL,'Input/output','Input%2Foutput','a2676165@rmqkr.net','1e891e6e45b18577279154da2ba37472',NULL,'2012-12-18 20:09:24.0','[B@7414bb78',NULL,'','2012-12-18 20:07:10.0'); INSERT INTO `USERS` (ID,UUID,FIRST_NAME,LAST_NAME,USERNAME,ENCODED_USERNAME,EMAIL,PASSWORD,ROLE,LAST_LOGIN,AVATAR,BAN_REASON,SALT,REGISTRATION_DATE) VALUES (115,'8da1f3e4-ebcc-4c18-b277-aa8fed1c55f6',NULL,NULL,'Flashed1','Flashed1','fl1@m.ru','81dc9bdb52d04dc20036dbd8313[...] Ответ MySQL: Документация #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','a2674974@rmqkr.net','1e891e6e45b18577279154da2ba37472',NULL,'2012-12-18 19:48' at line 1
Expected result
Succesfully import of DB.
Example of DB see in attachment.
- relates to
-
POULPE-477 Error "Foreign key constraint is incorrectly formed" when trying to restore backup created using Poulpe UI
- Closed