sql vehicle ownership system - data not saving
#8

Because you don't create that table, it has errors
Код:
Static analysis:

1 errors were found during analysis.

A comma or a closing bracket was expected. (near "AUTOINCREMENT" at position 99)
SQL query:

CREATE TABLE IF NOT EXISTS vehicles (owner VARCHAR(24) COLLATE NOCASE, ownerid INTEGER PRIMARY KEY AUTOINCREMENT, forsale INTEGER DEFAULT 1 NOT NULL, model INTEGER DEFAULT 0 NOT NULL, color1 INTEGER DEFAULT 0 NOT NULL, color2 INTEGER DEFAULT 0 NOT NULL, price INTEGER DEFAULT 0 NOT NULL, posx FLOAT, posy FLOAT, posz FLOAT, posa FLOAT)

MySQL said: Documentation

#1273 - Unknown collation: 'NOCASE'
AUTO_INCREMENT

and COLLATE NOCASE is suppose to be used in a select query.
You don't need case sensitivity on table creation/insert value, it is saved as is, you use it when you want to select.

EDIT:
Quote:

'%s', '%d', '%d', '%d', '%d','%f', '%f', '%f', '%f'

You don't need ' for integers (i.e. %d)
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)