Database problem

Hello, i’ve just a problem with my database

I need one user per row.

I use the CITYRP base.

Instead of creating a new row for a player each time they join, check if they have one first and update it, instead. You should check by SteamID since that will be unique to every player – UniqueID may have collisions and I would stop using it all together.

not exactly sure what the issue is here but it looks pretty normal to me. is there any error in the server consol related to the database itself happening?

Make SteamID a unique column and then use ON DUPLICATE KEY UPDATE in your MySQL query to update the table with any new relevant information instead of inserting a new row.


And after a time passed on the server the DB should like this: