Beiträge von ZeroGravity im Thema „Eintrag hinzufügen spuckt Fehler aus“

ZeroGravity · 4. Dezember 2016

Hey Cyperghost,

hab vielen lieben Dank, es geht wieder.

Konnte den Eintrag jetzt ohne Probleme abspeichern.

Danke!!!!

Liebe Grüße,
Zero

ZeroGravity · 3. Dezember 2016

Was kann ich denn gegen den Fehler machen @Cyperghost?

ZeroGravity · 2. Dezember 2016

Ich versuche es mal, habe ich es richtig gemacht?

Code

-- phpMyAdmin SQL Dump
-- version 4.6.5.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 02, 2016 at 11:06 AM
-- Server version: 5.5.52-0+deb8u1-log
-- PHP Version: 5.6.27-0+deb8u1


SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";




/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


--
-- Database: `zerogravity_borderline`
--


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


--
-- Table structure for table `wcf1_moderation_book`
--


CREATE TABLE `wcf1_moderation_book` (
  `bookID` int(10) NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  `userID` int(10) NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `moderatorID` int(10) DEFAULT '0',
  `moderatorUsername` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` mediumtext COLLATE utf8_unicode_ci,
  `enableSmilies` tinyint(1) NOT NULL DEFAULT '0',
  `enableHtml` tinyint(1) NOT NULL DEFAULT '0',
  `editCount` mediumint(7) NOT NULL DEFAULT '0',
  `lastEditTime` int(10) NOT NULL DEFAULT '0',
  `deleteTime` int(10) NOT NULL DEFAULT '0',
  `editorID` int(10) DEFAULT NULL,
  `deleteReason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0',
  `editor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachments` mediumint(5) NOT NULL DEFAULT '0',
  `enableBBCodes` tinyint(1) NOT NULL DEFAULT '0',
  `hasEmbeddedObjects` tinyint(1) NOT NULL DEFAULT '0',
  `isOriginal` tinyint(1) NOT NULL DEFAULT '0',
  `userWarningID` int(10) DEFAULT '0',
  `comments` mediumint(7) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


--
-- Indexes for dumped tables
--


--
-- Indexes for table `wcf1_moderation_book`
--
ALTER TABLE `wcf1_moderation_book`
  ADD PRIMARY KEY (`bookID`),
  ADD UNIQUE KEY `bookID` (`bookID`),
  ADD KEY `34d6febfbfd5a28551dc59ceec04024f_fk` (`userID`),
  ADD KEY `466b1921b676bd6ba3967933a19a2dcf_fk` (`moderatorID`),
  ADD KEY `f3a132bd194a433373d2a210e77d2560_fk` (`editorID`),
  ADD KEY `0aabe5ee0c5d6fc0575cb0db6da93ba2_fk` (`userWarningID`);


--
-- AUTO_INCREMENT for dumped tables
--


--
-- AUTO_INCREMENT for table `wcf1_moderation_book`
--
ALTER TABLE `wcf1_moderation_book`
  MODIFY `bookID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--


--
-- Constraints for table `wcf1_moderation_book`
--
ALTER TABLE `wcf1_moderation_book`
  ADD CONSTRAINT `0aabe5ee0c5d6fc0575cb0db6da93ba2_fk` FOREIGN KEY (`userWarningID`) REFERENCES `wcf1_user_infraction_warning` (`userWarningID`) ON DELETE SET NULL,
  ADD CONSTRAINT `34d6febfbfd5a28551dc59ceec04024f_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE CASCADE,
  ADD CONSTRAINT `466b1921b676bd6ba3967933a19a2dcf_fk` FOREIGN KEY (`moderatorID`) REFERENCES `wcf1_user` (`userID`) ON DELETE SET NULL,
  ADD CONSTRAINT `f3a132bd194a433373d2a210e77d2560_fk` FOREIGN KEY (`editorID`) REFERENCES `wcf1_user` (`userID`) ON DELETE SET NULL;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Alles anzeigen

ZeroGravity · 2. Dezember 2016

Hallo Cyperghost,

ich habe mir eben das Moderations Buch neu installiert.
Jetzt wollte ich einen Eintrag hinzufügen und bekomme eine Fehlermeldung.

Code

Fri, 02 Dec 2016 04:20:19 +0000
Message: Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("zerogravity_borderline"."wcf1_moderation_book", CONSTRAINT "0aabe5ee0c5d6fc0575cb0db6da93ba2_fk" FOREIGN KEY ("userWarningID") REFERENCES "wcf1_user_infraction_warning" ("userWarningID") ON D)
File: /home/jail/zerogravity/home/borderline-forum/wcf/lib/system/database/statement/PreparedStatement.class.php (97)
PHP version: 5.6.27-0+deb8u1
WCF version: 2.1.12 (Typhoon)
Request URI: /index.php?ajax-proxy/&
Referrer: https://www.borderline-forum.net/user/2369-veru/
User-Agent: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
Information: ""
Stacktrace: 
  #0 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
  #1 [internal function]: wcf\data\DatabaseObjectEditor::create(Array)
  #2 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/AbstractDatabaseObjectAction.class.php(328): call_user_func(Array, Array)
  #3 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/moderation/book/ModerationBookEntryAction.class.php(177): wcf\data\AbstractDatabaseObjectAction->create()
  #4 [internal function]: wcf\data\moderation\book\ModerationBookEntryAction->create()
  #5 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/AbstractDatabaseObjectAction.class.php(196): call_user_func(Array)
  #6 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/moderation/book/ModerationBookEntryAction.class.php(393): wcf\data\AbstractDatabaseObjectAction->executeAction()
  #7 [internal function]: wcf\data\moderation\book\ModerationBookEntryAction->saveAdd()
  #8 /home/jail/zerogravity/home/borderline-forum/wcf/lib/data/AbstractDatabaseObjectAction.class.php(196): call_user_func(Array)
  #9 /home/jail/zerogravity/home/borderline-forum/wcf/lib/action/AJAXProxyAction.class.php(77): wcf\data\AbstractDatabaseObjectAction->executeAction()
  #10 /home/jail/zerogravity/home/borderline-forum/wcf/lib/action/AJAXInvokeAction.class.php(96): wcf\action\AJAXProxyAction->invoke()
  #11 /home/jail/zerogravity/home/borderline-forum/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AJAXInvokeAction->execute()
  #12 /home/jail/zerogravity/home/borderline-forum/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
  #13 /home/jail/zerogravity/home/borderline-forum/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
  #14 /home/jail/zerogravity/home/borderline-forum/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
  #15 /home/jail/zerogravity/home/borderline-forum/index.php(10): wcf\system\request\RequestHandler->handle('wbb')
  #16 {main}

Alles anzeigen

Beiträge von ZeroGravity im Thema „Eintrag hinzufügen spuckt Fehler aus“

Eintrag hinzufügen spuckt Fehler aus

Eintrag hinzufügen spuckt Fehler aus

Eintrag hinzufügen spuckt Fehler aus

Eintrag hinzufügen spuckt Fehler aus

Informationen

Support

Über uns