MYSQL

[mApY.]

Salut,

cand pun baza de date pe host imi da eroare.

Comanda SQL:

-- -- Dumping data for table `houses` -- INSERT INTO `houses` (`hID`, `PosX`, `PosY`, `PosZ`, `PosX1`, `PosY1`, `PosZ1`, `Name`, `Owner`, `Password`, `Value`, `Storage`, `World`, `Interior`, `Dog`, `Privacy`, `UpgradeLock`, `ForSale`, `Price`, `Lock`, `Level`, `Alarma`, `Camera`, `Caine`) VALUES (1, 2266.97, 1633.61, 1084.23, 2283, -1139.76, 1050.9, 'No name', 'Unbought', 'None', 500, 0, 1, 11, 0, 0, 13, 1, 0, 1, 1, 0, 0, 0), (2, 2270.76, 1633.4, 1084.23, 2283, -1139.76, 1050.9, 'No name', 'Unbought', 'None', 500, 0, 1, 11, 1, 0, 13, 1, 0, 1, 1, 0, 0, 0), (3, 2270.61, 1642.01, 1084.23, 2283, -1139.76, 1050.9, 'No name', 'Unbought', 'None', 500, 0, 1, 11, 1, 2000, 13, 1, 0, 1, 1, 0, 0, 0), (4, 2271.07, 1652.57, 1084.23, 2283, -1139.76, 1050.9, 'No name', 'Unbought', 'None', 500, 0, 1, 11, 0, 0, 13, 1, 0, 1, 1, 0, 0, 0), (5, 2266.33, 1642.18, 1084.23, 2283, -1139.76, 1050.9, 'No name', 'Unbought', 'None', 500, 0, 1, 11, 0, 0, 13, 1, 0, 1, 1, 0, 0, 0), (6, 2270.75, 1662.7, 1084.23, 228[...]

MySQL zice: 

#1054 - Unknown column 'hID' in 'field list' 

Daca ma puteti ajuta va multumesc mult

Baza de date: http://www.girlshare.ro/32118255.4

PUPICI din mica mea venetie,

Alba-Iulia.

[Fallen0329]

in baza ta de date hID nu exista verifica cum e trecut primul camp in baza ta de date, posibil e doar ID

[mApY.]

Daca e cineva care chiar mi-o poate rezolva nu sa dea cu presupusul, rasplatesc cu credite. Baza e la primul post link girlshare.

[Fallen0329]

eroarea iti apare cand pui baza aia de date in phpMyAdmin?

[BuBu]

Ai facut macar tabelul 'houses' in PHPMYADMIN cu acele date?