In case you had the previous okokBilling version (both ESX & QBCore) execute the code below in your database, otherwise ignore it.
DROP TABLE okokbilling;
Execute the following SQL code in your database:
CREATE TABLE `okokbilling` (
`id` int NOT NULL AUTO_INCREMENT,
`ref_id` varchar(10) NOT NULL,
`receiver_identifier` varchar(255) NOT NULL,
`receiver_name` varchar(255) NOT NULL,
`author_identifier` varchar(255) NOT NULL,
`author_name` varchar(255) NOT NULL,
`society` varchar(255) NOT NULL,
`society_name` varchar(255) NOT NULL,
`item` varchar(255) NOT NULL,
`invoice_value` int NOT NULL,
`fees_amount` int NOT NULL,
`status` varchar(50) NOT NULL,
`notes` LONGTEXT DEFAULT ' ',
`sent_date` varchar(255) NOT NULL,
`limit_pay_date` varchar(255) NOT NULL,
`paid_date` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
);
Server artifacts
Make sure your server artifacts version is above the 5181.
