1B0Y
commented
9 months ago Hey @Chromentos,
Based on that insert as mentioned above, property_id should be auto incrementing inside the database as specified in the properties.sql file.
To confirm that property_id is incrementing as intended, please check the table structure of properties and ensure AUTO_INCREMENT is present as shown below:
If it doesn't, you can either toggle this within the structure, or drop the properties table and reinsert properties.sql to fix
[ script:ps-housing] SCRIPT ERROR: @ps-housing/server/server.lua:57: ps-housing was unable to execute a query! [ script:ps-housing] Query: INSERT INTO properties (owner_citizenid, street, region, description, has_access, extra_imgs, furnitures, for_sale, price, shell, apartment, door_data, garage_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [ script:ps-housing] ["IFY33604",null,null,"This is Michael Wise's apartment in Fantastic Plaza","[]","[]","[]",0,0,"Apartment Furnished","Fantastic Plaza","[]","[]"] [ script:ps-housing] Field 'property_id' doesn't have a default value
Get this in my server logs, This happens when i start the game and go to load in. I click apartments, then click one of the apartments and this happens. It seems as if it doesnt define what the property ID is suppose to be when loading in. So this then creates a issue where you dont even spawn in at the apartment.