MYSQL :P - Printable Version

MYSQL :P - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MYSQL :P (/showthread.php?tid=513533)

MYSQL :P - LemonPunch - 16.05.2014

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'

Re: MYSQL :P - Sithis - 16.05.2014

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'.

Re : MYSQL :P - LemonPunch - 16.05.2014

which means?

Re: MYSQL :P - Konstantinos - 16.05.2014

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.

Re : MYSQL :P - LemonPunch - 16.05.2014

Код:

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

Re : MYSQL :P - LemonPunch - 16.05.2014

fixed