Car Dealer and DB error [i solved]


#1

Hi,
i need BIG help.
When i want buy some car it’s everything okey but DB can’t set me owner.
I don’t know how to fix this.
Pls help.

error from console:
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM owned_vehicles WHERE @plate = plate {@plate=RJE 002}”: Unknown column ‘plate’ in ‘where clause’

Solution: Import ur owned_vehicle folder from MySql then delete.
Open ur downloaded file and paste and replace:

CREATE TABLE owned_vehicles (
id int(11) NOT NULL,
vehicle longtext COLLATE utf8mb4_bin NOT NULL,
owner varchar(60) COLLATE utf8mb4_bin NOT NULL,
plate varchar(12) COLLATE utf8mb4_bin NOT NULL,
state tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘Etat de la voiture’
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

DELETE GREEN TEXT !


#2

Could you share us a screenshot of your database structure? Seems that you’re missing a section.


#3

If u need english menu just say.