Brauche einen Scripter der sich mit Mysql auskennt

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hey ich hab ein problem wenn ich ingame gehe und mich registrieren will (auf meinem server) und dannach das passwort eingeben muss ist das passwort angeblich falsch.
    Dann habe ich in der Mysql Datenbank gekuckt und er wurde keine tabelle erstellt nichts... mache ich was falsch oder so?
    Und bei dem mysql log kommt das An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value)


    Falls ihr mir über teamviewer helfen wollt oder so bitte mich skype adden : jumper8reventon
    oder PM


    Kann mir bitte einer helfen?, Danke im voraus! ;(

  • @Music4You Sry tut mir leid, nein keinen syntax error gefunden...



    @TheBester Ja bitte gib mir deine skypeaddy oder adde du mich pls...


    Maximilian Heisst das, das ich mit Mysql nicht verbunden bin oder so ?? bin planlos sry...



    [20:23:02] CMySQLHandler::Query(UPDATE `onlines` SET `Name` = 'Awesome', `Legend` = '0' WHERE SQLid = '4') - Successfully executed.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `bannedplayers` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:02] >> mysql_free_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::FreeResult() - Result was successfully free'd.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `users` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:06] >> mysql_ping( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Ping() - Connection is still alive.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(INSERT INTO `users` (`Name`, `Key`) VALUES ('Awesome', 'test123')) - An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value)


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `RegisterDatum`='1379622186' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Key`='der123123', `Level`='0', `AdminLevel`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='0', `Sex`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Money`='0', `Bank`='0', `Allowed`='0', `bankfach1`='0', `bankfach2`='0', `bankfach3`='0', `bankfach4`='0', `wgs`='0', `facherlaubis`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `Paycheck`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='101', `Vertragszeit`='5', `DetSkill`='0', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `CarSkill`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='50.0', `PhoneNr`='0', `House`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='1', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Warnings`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `SaveCodes`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='60', `CarLicPoints`='0', `BikeLicPoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='0', `OldName`='Niemand', `ClientIP`='91.60.69.67', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:09] >> mysql_real_escape_string( Connection handle: 1 )


    [20:23:09] CMySQLHandler::EscapeString(test123); - Escaped 9 characters to test123.


    [20:23:09] >> mysql_query( Connection handle: 1 )


    [20:23:09] CMySQLHandler::Query(SELECT `Key` FROM `users` WHERE `Name` = 'Awesome' AND `Key` = 'test123') - Successfully executed.


    [20:23:09] >> mysql_store_result( Connection handle: 1 )


    [20:23:09] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:09] >> mysql_num_rows( Connection handle: 1 )


    [20:23:09] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:09] >> mysql_free_result( Connection handle: 1 )



    Das kommt bei mysql log

    3 Mal editiert, zuletzt von ReVenTon ()