[BUG]Soft-delete errors in list

[hubdesk[bot]]

From: Andrea Romero andrearomerov@gmail.com

Am trying to create a list, it says the list (perpetradores) already exists but it is nowhere to be found. I change the name, I progress beyond the name and then I get the error screen

A

--

Attachments

• [SQLSTATE[42000]_Syntax error or access violation 1103 Incorrect table name 'perp' (SQL_ create table list_perpetrador_c_o_s (id char(36) not null, created_at timestamp null, updated_at timestamp null, deleted_at timestamp null, perp._c_.pdf](https://hubdesk.io/dashboard/b9a709ec-2a28-440a-8984-c029f3d6bc60/inboxes/253d6580-14b1-41a0-a587-fae4bb82eb56/threads/fd5f1703-fcf4-46da-bf90-1baf7d537a10/messages/06c4a2b0-7472-4aa6-a747-a18b5aadcf11/attachments/SQLSTATE[42000]__Syntax error or access violation_ 1103 Incorrect table name 'perp' (SQL_ create tablelist_perpetrador_c_o_s(idchar(36) not null,created_attimestamp null,updated_attimestamp null,deleted_attimestamp null,perp.c.pdf)

[lduf]

We should review the soft-delete process in the application

[github-actions[bot]]

AI-Assisted Response:

Issue Summary: List Creation Causes Errors

Summary: Andrea Romero is experiencing problems while attempting to create a list named "perpetradores" in a system. Despite receiving a notification that the list name "perpetradores" already exists, Andrea cannot locate the list. When attempting to create the list with a different name, Andrea advances past the naming step but then encounters an error screen.

Context: The error pertains to an SQL syntax error suggesting an incorrect table name 'perp' encountered during the creation of a table named list_perpetrador_c_o_s. The error message is an SQLSTATE[42000] referring to a syntax or access violation.

Issue Type:

• Bug Report

@hubdesk[bot] Tagged User:

• You're being tagged to indicate your notification regarding the resolution status and to request further information if necessary.

Clarifying Questions:

1. What software or platform are you using where you are trying to create the "perpetradores" list? Is it a custom application, web interface, or a framework?
2. Can you provide the exact steps you are following to create the list prior to encountering the error?
3. Has the list "perpetradores" ever been created successfully before in the system, or is this the first time you're attempting to create it?
4. After renaming the list, are you able to see the newly named list anywhere in the system or does it also disappear?
5. Can you share a screenshot of the error you encounter after renaming and attempting to create the list?
6. Is there a log file or additional error details we could examine to understand what's causing the syntax error for the table name 'perp'?
7. Are you able to manually access the database to check if the list/table exists through a query?

It's important to provide any additional context or logs to aid in the troubleshooting of this issue.

[github-actions[bot]]

AI-Assisted Response:

Issue Summary: List Creation Error and SQL Syntax Violation

Context and Rephrasing:

Andrea Romero is attempting to create a list internally referred to as perpetradores. She is experiencing an issue where the system is indicating that the list perpetradores already exists, but she cannot locate it in the system. Andrea attempted to resolve this by renaming the list, which allowed her to proceed past the naming stage. However, upon proceeding, an error screen appeared.

Accompanying this message, Andrea has attached an error related to an SQL syntax issue. The error mentions an "Incorrect table name 'perp'", which appears during an attempt to create a table named list_perpetrador_c_o_s.

Issue Type:

• Bug Report

Questions for Clarification:

• @hubdesk[bot], could you please confirm the steps you took leading up to the point where the message stated that the list already exists?
• Can you provide a screenshot of the error screen you encountered after renaming the list?
• Is the SQL error shown in the attachment a result of a manual SQL query you executed or is it generated by a tool or script you are using within the application? If it's from an application, can you share which application and its version?
• Are there any system logs or additional error messages that might give more context to the 'Incorrect table name' SQL error?
• Have you tried looking for the list perpetradores directly in the database, through a query, to ensure it does not exist?
• Could you specify if your environment has any unique configurations that might affect the creation of database tables or the list within the application?

Request for Additional Information:

• To better diagnose the issue, it would be helpful to know the exact operating system and database version you are working with, as well as any special characters or settings that might affect the system behavior.