When I add these SQL it will cause this problem
How can I fix it?
INSERT INTO addon_account
(name, label, shared) VALUES
(‘society_taxi’, ‘Taxi’, 1)
#1062 - Duplicate entry ‘society_taxi’ for key ‘PRIMARY’
and
INSERT INTO items
(name
, label
, limit
, rare
, can_remove
) VALUES
(‘cannabis’, ‘Cannabis’, 40, 0, 1),
(‘marijuana’, ‘Marijuana’, 14, 0, 1)
#1062 - Duplicate entry ‘cannabis’ for key ‘PRIMARY’
Pr0n3
2
Its already in your table, remove those lines from the sql file
Thanks, I didn’t expect it to exist
i removed the lines but now im getting a error of 3 errors were found during analysis.
- Unexpected token. (near “(” at position 97)
- Unexpected beginning of statement. (near “‘chemicalslisence’” at position 98)
- Unexpected beginning of statement. (near “‘Chemicals license’” at position 118)
SQL query: Copy
INSERT INTO licenses
(type
, label
) VALUES (‘weed_processing’, ‘Weed Processing License’) (‘chemicalslisence’, ‘Chemicals license’)
cant figure this out either, and removing lines only brings more issues.
someone said try deleting the SQL from your database but i cant find it.
I tried a lot of things but nothing has worked.
if anyone knows how to fix it please say.