Database

[mano79]

Can anyone help with a database problem?

[KickMayer]

Would be good if you described the issue you've got..

[mano79]

Fault

Static analysis:

We found 3 errors in the analysis.

A symbol name is waiting! (near "'itemType'" at position 127)
Unexpected start of instruction. (near "11" at position 142)
Unrecognized instruction type. (near "NOT NULL" at position 146)

SQL query: Copy

CREATE TABLE auction ( auctionID int (11) NOT NULL, designID int (11) NOT NULL, baseShipID int (11) NOT NULL, 'itemType' int (11) NOT NULL, CATEGORY ('' ammunition '', '' weapon '', '' extra '', '' drone '', '' generator '', '' design ''), 10minutes int (11) NOT NULL DEFAULT AVAILABLE 1, 30minutes int (11) NOT NULL DEFAULT AVAILABLE 1, 60minutes int (11) NOT NULL DEFAULT AVAILABLE 1, 24hours int (11) NOT NULL DEFAULT AVAILABLE 1, currently bidder int (11) NOT NULL DEFAULT 1, winner int (11) NOT NULL DEFAULT 1, winnerID tinyint (1) NOT NULL DEFAULT 0, itemID int (11) NOT NULL DEFAULT 0, amount varchar (2048) COLLATE utf8_bin NOT NULL DEFAULT, isdesign int (11) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE, UNIQUE KEY baseShipID (baseShipID) USING BTREE) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC

MySQL said: Documentation
# 1064 - Syntax Error for '' itemType 'int (11) NOT NULL, CATEGORY (' 'ammunition' ',' 'weapon' ',' 'extra' ',' 'd ...' approach 5 in a row

[S7K Yuuki]

1. The query you posted is completely wrong in a lot of ways
2. The query you posted is not the same to the one from your picture with the error message
3. This has nothing to do with DarkOrbit. Will be better to ask in StackOverflow.

Regards.-

[mano79]

I do not understand

[kipseke]

Originally Posted by mano79

I do not understand

We know you don't


#closerequest

[mano79]

?