[LemonPunch]

what is these errors? lol

Код:

Error
SQL query: 




--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `Online`, `UpdateDate`, `RegiDate`, `LastLogin`, `Username`, `Key`, `Email`, `IP`, `SecureIP`, `Registered`, `ConnectedTime`, `Sex`, `Age`, `BirthDate`, `Band`, `PermBand`, `Warnings`, `Disabled`, `Level`, `AdminLevel`, `SeniorModerator`, `DonateRank`, `Respect`, `XP`, `Money`, `Bank`, `pHealth`, `pArmor`, `pSHealth`, `Int`, `VirtualWorld`, `Model`, `SPos_x`, `SPos_y`, `SPos_z`, `SPos_r`, `BanAppealer`, `PR`, `HR`, `AP`, `Security`, `ShopTech`, `FactionModerator`, `GangModerator`, `Undercover`, `TogReports`, `Radio`, `RadioFreq`, `UpgradePoints`, `Origin`, `Muted`, `Crimes`, `Accent`, `CHits`, `FHits`, `Arrested`, `Phonebook`, `LottoNr`, `Fishes`, `BiggestFish`, `Job`, `Job2`, `Paycheck`, `HeadValue`, `Jailed`, `JailTime`, `WRestricted`, `Materials`, `CasinoChips`, `Crates`, `Pot`, `Crack`, `Nation`, `Leader`, `Member`, `Division`, `FMember`, `Rank`, `DetSkill`, `SexSkill`, `BoxSkill`, `LawSkill`, `MechSkill`, [...]

MySQL said:  

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

:P

[Sithis]

It means you are trying to put data in your table, but the column LastLogin (which is in your query), was not found in the table 'accounts'.

[LemonPunch]

which means?

[Konstantinos]

The error is self-explanatory and so Sithis' post is. The field "LastLogin" doesn't exist in that table. Check the spelling of the table's fields or if you forgot to add it when you created the table, just do it now.

[LemonPunch]

Код:

SQL-frеga:




--
-- Database: `sampsrv`
--

-- --------------------------------------------------------

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Online` int(11) NOT NULL DEFAULT '0',
  `UpdateDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `RegiDate` datetime DEFAULT NULL,
  `LastLogin` datetime DEFAULT NULL,
  `Username` varchar(32) NOT NULL DEFAULT '',
  `Key` varchar(256) NOT NULL DEFAULT '',
  `Email` varchar(256) NOT NULL DEFAULT '',
  `IP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `SecureIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `Registered` int(11) NOT NULL DEFAULT '0',
  `ConnectedTime` int(11) NOT NULL DEFAULT '0',
  `Sex` int(11) NOT NULL DEFAULT '1',
  `Age` int(11) NOT NULL DEFAULT '18',
  `BirthDate` date NOT NULL DEFAULT '0000-00-00',
  `Band` int(11) NOT NULL DEFAULT '0',
  `PermBand` int(11) NOT NULL DEFAULT '0',
  `Warnings` int(11) NOT NULL DEFAULT '0',
  `Disabled` int([...]
MySQL sa: Dokumentation

#1046 - No database selected

[LemonPunch]

fixed