Hello, friends. As I mentioned to a lot of people earlier and promised to leak this uniquely fantastic phone, qs-smartphone and to be fixed without bugs or errors, well here it is, the version of the phone is 1.2.2, it's not the latest but it will work for a lot of people, for a lot of servers.
Phone is only been fully tested on ESX and I don't know if it will work the same in QBCore.

The error message indicates that the DELETE query is failing because there is no phone column in the phone_messages table of your database.
Here’s the part of the error that’s most important:
This suggests that your code is trying to delete records from phone_messages where a number or phone matches the given parameters, but the phone_messages table does not have a column named phone.To fix this, you have to do one of the following:
Phone is only been fully tested on ESX and I don't know if it will work the same in QBCore.

The error message indicates that the DELETE query is failing because there is no phone column in the phone_messages table of your database.
Here’s the part of the error that’s most important:
Code:
SCRIPT ERROR: @qs-smartphone/server/main.lua:9943: qs-smartphone was unable to execute a query!
Query: DELETE FROM phone_messages WHERE number = ? OR phone = ?
["police","police"]
Unknown column 'phone' in 'where clause'
This suggests that your code is trying to delete records from phone_messages where a number or phone matches the given parameters, but the phone_messages table does not have a column named phone.To fix this, you have to do one of the following:
- Correct the Column Name: If the column should be something else (like perhaps phone_number), update the query to use the correct column name.
- Update the Database Schema: If the phone column should exist, you'll need to update your database schema to include it. This would typically be done with an ALTER TABLE statement to add the new column.
- Update the Logic: If the phone column was removed intentionally and you don't need to filter by this column anymore, just remove the OR phone = ? from the query.
Last edited by a moderator: