You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1142
error message: Invalid SQL: INSERT INTO wcf1_session
(sessionID, packageID, userID, ipAddress, userAgent,
lastActivityTime, requestURI, requestMethod, userData, sessionVariables,
username)
VALUES ('3d72e3ce4a4eee851031ffc3e32b4bf11215e9f8',
38,
0,
'18.204.55.168',
'CCBot/2.0 (https://commoncrawl.org/faq/)',
1597243216,
'/forum1/index.php?page=Tagging&tag=shoot',
'GET',
'O:15:\"WBBGuestSession\":12:{s:14:\"\0*\0boardVisits\";N;s:15:\"\0*\0threadVisits\";N;s:15:\"\0*\0hiddenBoards\";N;s:16:\"\0*\0lastVisitTime\";N;s:19:\"\0*\0boardPermissions\";a:4:{i:3;a:16:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";s:14:\"canStartThread\";s:1:\"0\";s:14:\"canReplyThread\";s:1:\"1\";s:17:\"canReplyOwnThread\";s:1:\"1\";s:31:\"canStartThreadWithoutModeration\";s:1:\"1\";s:31:\"canReplyThreadWithoutModeration\";s:1:\"1\";s:12:\"canStartPoll\";s:1:\"0\";s:11:\"canVotePoll\";s:1:\"1\";s:13:\"canRateThread\";s:1:\"1\";s:12:\"canUsePrefix\";s:1:\"1\";s:19:\"canUploadAttachment\";s:1:\"0\";s:21:\"canDownloadAttachment\";s:1:\"1\";s:16:\"canDeleteOwnPost\";s:1:\"1\";s:14:\"canEditOwnPost\";s:1:\"1\";}i:4;a:16:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";s:14:\"canStartThread\";s:1:\"0\";s:14:\"canReplyThread\";s:1:\"1\";s:17:\"canReplyOwnThread\";s:1:\"1\";s:31:\"canStartThreadWithoutModeration\";s:1:\"1\";s:31:\"canReplyThreadWithoutModeration\";s:1:\"1\";s:12:\"canStartPoll\";s:1:\"0\";s:11:\"canVotePoll\";s:1:\"1\";s:13:\"canRateThread\";s:1:\"1\";s:12:\"canUsePrefix\";s:1:\"1\";s:19:\"canUploadAttachment\";s:1:\"0\";s:21:\"canDownloadAttachment\";s:1:\"1\";s:16:\"canDeleteOwnPost\";s:1:\"1\";s:14:\"canEditOwnPost\";s:1:\"1\";}i:5;a:16:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";s:14:\"canStartThread\";s:1:\"0\";s:14:\"canReplyThread\";s:1:\"1\";s:17:\"canReplyOwnThread\";s:1:\"1\";s:31:\"canStartThreadWithoutModeration\";s:1:\"1\";s:31:\"canReplyThreadWithoutModeration\";s:1:\"1\";s:12:\"canStartPoll\";s:1:\"0\";s:11:\"canVotePoll\";s:1:\"1\";s:13:\"canRateThread\";s:1:\"1\";s:12:\"canUsePrefix\";s:1:\"1\";s:19:\"canUploadAttachment\";s:1:\"0\";s:21:\"canDownloadAttachment\";s:1:\"1\";s:16:\"canDeleteOwnPost\";s:1:\"1\";s:14:\"canEditOwnPost\";s:1:\"1\";}s:8:\"groupIDs\";s:3:\"1,2\";}s:28:\"\0*\0boardModeratorPermissions\";a:0:{}s:12:\"\0*\0groupData\";a:98:{s:27:\"admin.user.accessibleGroups\";s:0:\"\";s:27:\"user.profile.canChangeEmail\";b:1;s:22:\"user.profile.canRename\";b:1;s:25:\"user.profile.renamePeriod\";s:3:\"182\";s:26:\"user.message.canUseSmilies\";b:1;s:26:\"user.message.canUseBBCodes\";b:1;s:29:\"user.message.floodControlTime\";s:1:\"0\";s:36:\"user.profile.signature.canUseSmilies\";b:1;s:36:\"user.profile.signature.canUseBBCodes\";b:1;s:32:\"user.profile.signature.maxImages\";s:1:\"1\";s:36:\"user.profile.signature.maxImageWidth\";s:3:\"530\";s:37:\"user.profile.signature.maxImageHeight\";s:3:\"200\";s:35:\"user.profile.signature.maxImageSize\";s:5:\"20000\";s:32:\"user.profile.signature.maxLength\";s:3:\"500\";s:20:\"user.profile.canView\";b:1;s:39:\"user.profile.avatar.canUseDefaultAvatar\";b:1;s:35:\"user.profile.avatar.canUploadAvatar\";b:1;s:28:\"user.profile.avatar.maxWidth\";s:3:\"150\";s:29:\"user.profile.avatar.maxHeight\";s:3:\"150\";s:27:\"user.profile.avatar.maxSize\";s:5:\"20000\";s:24:\"user.membersList.canView\";b:1;s:16:\"user.pm.canUsePm\";b:1;s:21:\"user.pm.maxRecipients\";s:2:\"10\";s:13:\"user.pm.maxPm\";s:3:\"100\";s:18:\"user.pm.maxFolders\";s:1:\"5\";s:27:\"user.pm.canUploadAttachment\";b:1;s:25:\"user.pm.maxAttachmentSize\";s:5:\"20000\";s:35:\"user.pm.allowedAttachmentExtensions\";s:79:\"gif\r\njpg\r\njpeg\r\npng\r\nbmp\r\nzip\r\ntxt\r\npdf\ngif\r\njpg\r\njpeg\r\npng\r\nbmp\r\nzip\r\ntxt\r\npdf\";s:26:\"user.pm.maxAttachmentCount\";s:1:\"5\";s:17:\"user.pm.maxLength\";s:5:\"10000\";s:23:\"user.board.canViewBoard\";b:1;s:24:\"user.board.canEnterBoard\";b:1;s:24:\"user.board.canReadThread\";b:1;s:25:\"user.board.canStartThread\";b:1;s:25:\"user.board.canReplyThread\";b:1;s:28:\"user.board.canReplyOwnThread\";b:1;s:24:\"user.board.canRateThread\";b:1;s:25:\"user.board.canEditOwnPost\";b:1;s:26:\"user.board.postEditTimeout\";i:-1;s:42:\"user.board.canStartThreadWithoutModeration\";b:1;s:42:\"user.board.canReplyThreadWithoutModeration\";b:1;s:23:\"user.board.canUsePrefix\";b:1;s:24:\"user.board.maxPostLength\";s:5:\"10000\";s:32:\"user.board.canDownloadAttachment\";b:1;s:28:\"user.board.maxAttachmentSize\";s:1:\"0\";s:38:\"user.board.allowedAttachmentExtensions\";s:0:\"\";s:29:\"user.board.maxAttachmentCount\";s:1:\"0\";s:22:\"user.board.canVotePoll\";b:1;s:23:\"user.board.canStartPoll\";b:1;s:15:\"user.map.canUse\";b:1;s:15:\"user.map.canAdd\";b:1;s:20:\"user.map.canAddCount\";s:1:\"0\";s:24:\"user.map.canViewPersonal\";b:1;s:16:\"user.map.canView\";b:1;s:15:\"user.map.header\";b:1;s:23:\"user.board.canViewStats\";b:1;s:45:\"user.advertisement.thread.canSeeAdvertisement\";b:1;s:26:\"user.shoutbox.messageDelay\";s:1:\"0\";s:22:\"user.shoutbox.canWrite\";b:1;s:21:\"user.shoutbox.canRead\";b:1;s:29:\"user.calendar.canSignupEvents\";b:1;s:28:\"user.calendar.canAddComments\";b:1;s:29:\"user.calendar.canCreateEvents\";b:1;s:27:\"user.calendar.canViewEvents\";b:1;s:22:\"user.calendar.canEnter\";b:1;s:20:\"user.board.canSeeWWO\";b:1;s:20:\"user.message.tagging\";b:1;s:21:\"user.dldb.maxFileSize\";s:5:\"50000\";s:26:\"user.dldb.canDeleteOwnFile\";b:1;s:24:\"user.dldb.canEditOwnFile\";b:1;s:23:\"user.dldb.canUploadFile\";b:1;s:21:\"user.dldb.canLinkFile\";b:1;s:25:\"user.dldb.canDownloadFile\";b:1;s:26:\"user.dldb.canUseDownloadDB\";b:1;s:18:\"user.faq.canSeeFaq\";b:1;s:21:\"user.rgallery.canView\";b:1;s:19:\"user.rgallery.quota\";s:1:\"0\";s:28:\"user.rgallery.uploadsPerWeek\";s:1:\"0\";s:28:\"user.message.canUseWoWSearch\";b:1;s:36:\"user.message.canUseThreadQuickSearch\";b:1;s:22:\"user.guestbook.canRead\";b:1;s:26:\"user.guestbook.canViewList\";b:1;s:36:\"user.guestbook.canViewListMenuButton\";b:1;s:36:\"user.guestbook.canViewMembersListTab\";b:1;s:23:\"user.guestbook.canWrite\";b:1;s:32:\"user.guestbook.canEditOwnEntries\";i:-1;s:34:\"user.guestbook.listView.showAvatar\";b:1;s:41:\"user.guestbook.listView.showUserLastVisit\";b:1;s:43:\"user.guestbook.listView.showUserLastComment\";b:1;s:41:\"user.guestbook.listView.showLastEntryUser\";b:1;s:41:\"user.guestbook.listView.showLastEntryDate\";b:1;s:40:\"user.guestbook.listView.showNumOfEntries\";b:1;s:43:\"user.guestbook.listView.showNumOfNewEntries\";b:1;s:38:\"user.guestbook.listView.showNumOfViews\";b:1;s:39:\"user.guestbook.listView.showLastVisitor\";b:1;s:41:\"user.guestbook.listView.showLastVisitDate\";b:1;s:33:\"user.profile.canViewUserAgentData\";b:1;s:8:\"groupIDs\";s:3:\"1,2\";}s:11:\"\0*\0sqlJoins\";N;s:13:\"\0*\0sqlSelects\";N;s:13:\"\0*\0sqlGroupBy\";N;s:11:\"\0*\0groupIDs\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"2\";}s:7:\"\0*\0data\";a:1:{s:6:\"userID\";i:0;}}',
'',
''
)
error code: 1142
sql type: MySQLDatabase
sql error: INSERT command denied to user 'woltlab_demo'@'10.21.20.8' for table 'wcf1_session'
sql error number: 1142
sql version:
file: /home/woltlab/demo/forum1/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.2.17
wcf version: 1.0.10 (Horizon)
date: Wed, 12 Aug 2020 14:40:16 +0000
request: /forum1/index.php?page=Tagging&tag=shoot
referer:
#0 /home/woltlab/demo/forum1/wcf/lib/system/session/CookieSessionFactory.class.php(74): MySQLDatabase->sendQuery('INSERT INTO ?wc...')
#1 /home/woltlab/demo/forum1/wcf/lib/system/session/SessionFactory.class.php(71): CookieSessionFactory->create()
#2 /home/woltlab/demo/forum1/lib/system/WBBCore.class.php(201): SessionFactory->get()
#3 /home/woltlab/demo/forum1/wcf/lib/system/WCF.class.php(91): WBBCore->initSession()
#4 /home/woltlab/demo/forum1/global.php(18): WCF->__construct()
#5 /home/woltlab/demo/forum1/index.php(7): require_once('/home/woltlab/d...')
#6 {main}