Eintrag hinzufügen spuckt Fehler aus

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}

-- 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 */;