Code Monkey home page Code Monkey logo

Comments (3)

MaDHouSe79 avatar MaDHouSe79 commented on July 29, 2024

is the script the same script from your test server or did you just download it? cause i had add something but that did not work well, so i remove it, so maby you have that one?

from mh-parking.

Cynist3r avatar Cynist3r commented on July 29, 2024

Yes i drag and dropped the working one from the test server into my main server. Making sure anything i have modified was also moved. It was working fine in my test server. I woke up the next day and i received the error in both the test and the live

from mh-parking.

MaDHouSe79 avatar MaDHouSe79 commented on July 29, 2024

you need to go in the server file at the buttom you see a dataabse MySql execute if you have that at the bottom than you have a the bad one, or you download a new one cause i already fix that issue.

Remove:

Citizen.CreateThread(function()
    Wait(5000)
    MySQL.Async.execute([[
        CREATE TABLE IF NOT EXISTS `player_parking` (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `citizenid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `citizenname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `modelname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `plate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `steerangle` int(15) NOT NULL DEFAULT 0,
            `fuel` int(15) NOT NULL DEFAULT 0,
            `engine` int(15) NOT NULL DEFAULT 0,
            `body` int(15) NOT NULL DEFAULT 0,
            `oil` int(15) NOT NULL DEFAULT 0,
            `data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            `coords` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            `time` bigint(20) NOT NULL,
            `cost` int(10) NOT NULL DEFAULT 0,
            `parktime` int(10) NOT NULL DEFAULT 0,
            `parking` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            PRIMARY KEY (`id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
        
        CREATE TABLE IF NOT EXISTS `player_parking_vips` (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `citizenid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `citizenname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
            `maxparking` int(10) NOT NULL DEFAULT 0,
            `hasparked` int(10) NOT NULL DEFAULT 0,
            PRIMARY KEY (`id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
	]])
end)

from mh-parking.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.