#CW Racing App Issue - Console error when creating race

1 messages · Page 1 of 1 (latest)

tardy belfry
#

Not sure if I'm creating a race properly but when I Create With Race Editor, it does not allow me to create a race. I receive this error in console. No errors in F8.

Framework: Qbox

cosmic bloom
#

You seem to have alot of other errors aswell

#

The error from racingapp seems to indicate something might be wrong in your database setup

tardy belfry
#

I installed the cw-racingapp sql in HeidiSQL but im not sure what else could be wrong.

cosmic bloom
#

There's a guide in the stickied to help you debug

#

however, with that amount of other bugs I'd expect something else is wrong elsewhere 😅

tardy belfry
#

Those are not related to the script but ok

cosmic bloom
#

Yeah but they could indicate that something in your core is broken for example

grave cairn
#

I'm having this same error but it is the only issue

#

im getting the error when i try to create a track

grave cairn
#

01:38:10 AM [ script:cw-racingapp] SCRIPT ERROR: @cw-racingapp/server/main.lua:1367: cw-racingapp was unable to execute a query!
01:38:10 AM [ script:cw-racingapp] Query: SELECT name FROM race_tracks WHERE creatorid = ?
01:38:10 AM [ script:cw-racingapp] ["char1:9f3da6472c1fd1b09195a42db7988096f1393811"]
01:38:10 AM [ script:cw-racingapp] Unknown column 'creatorid' in 'where clause'
01:38:10 AM [ script:cw-racingapp] > ? (@cw-racingapp/server/main.lua:1367)
01:38:10 AM [ script:cw-racingapp] > handler (@cw-racingapp/server/functions.lua:11)
01:38:10 AM [ script:cw-racingapp] > logError (@oxmysql/dist/build.js:26284)
01:38:10 AM [ script:cw-racingapp] > rawQuery (@oxmysql/dist/build.js:26476)
01:38:10 AM [ script:cw-racingapp] > processTicksAndRejections (node:internal/process/task_queues:96)

cosmic bloom
#

When in the create a track flow is this happening?

#

What core?

#

Fresh install or update from older version?

grave cairn
#

Fresh install esx with ox inv and ox everything lol

#

It does is as I name the track and click confirm

cosmic bloom
#

Unless you messed up the database creations I don't really know whats up honestly 😅

Code:

#

The error says the colum doesnt exist

#

Do you have it in your database?

#

Could maybe be that esx (or some other script you had) had a table with the same name, hence why there's a warning in the sql file for this 🤔

grave cairn
#

I dropped the table and reinstalled it was an old table i believe