Bekomme immer diese fehler meldung

Fischii · Jun 9th 2016

Hallo Community,

seid ein paar tagen komme ich nicht mehr ins forum rein. Es ich habe nichts an die Tabellen geändert, nur vor kurzen bei Hosteurope die php Version 5.3 abstellt und jetzt läuft die php Version 5.6, kann es damit vielleicht zusammen hängen?

Habe auch kein update mehr von der Datenbak, wie kann man es reparieren?

Code

Fatal error: Invalid SQL: SELECT * FROM wbb1_1_board_moderator WHERE groupID IN (1,2) ORDER BY userID DESC




You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146
Information:




error message: Invalid SQL: SELECT * FROM wbb1_1_board_moderator WHERE groupID IN (1,2) ORDER BY userID DESC
error code: 1146
sql type: MySQLDatabase
sql error: Table 'db1066521-RTM.wbb1_1_board_moderator' doesn't exist
sql error number: 1146
sql version:
file: /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.5.36-1~he.squeeze0
wcf version: 1.1.8 (Tempest)
date: Thu, 09 Jun 2016 08:00:50 +0000
request: /
referer: http://www.rtm-base.de/include.php?path=start.php
Stacktrace:




#0 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/data/user/AbstractWBBUserSession.class.php(73): MySQLDatabase->sendQuery('SELECT\t\t*\n\t\t\tFR...')
#1 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/UserSession.class.php(66): AbstractWBBUserSession->getGroupData()
#2 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/data/DatabaseObject.class.php(24): UserSession->handleData(NULL)
#3 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/data/user/User.class.php(67): DatabaseObject->__construct(NULL)
#4 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/UserSession.class.php(33): User->__construct(NULL, NULL, NULL, NULL)
#5 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/CookieSessionFactory.class.php(51): UserSession->__construct()
#6 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/SessionFactory.class.php(73): CookieSessionFactory->create()
#7 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/system/WBBCore.class.php(200): SessionFactory->get()
#8 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/WCF.class.php(98): WBBCore->initSession()
#9 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/global.php(18): WCF->__construct()
#10 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/index.php(7): require_once('/is/htdocs/wp10...')
#11 {main}

Display More

Danke schon mal!

norse · Jun 9th 2016

Lege die Tabelle neu an:

SQL

DROP TABLE IF EXISTS wbb1_1_board_moderator;
CREATE TABLE wbb1_1_board_moderator (
	boardID INT(10) NOT NULL DEFAULT 0,
	userID INT(10) NOT NULL DEFAULT 0,
	groupID INT(10) NOT NULL DEFAULT 0,
	canDeleteThread TINYINT(1) NOT NULL DEFAULT -1,
	canReadDeletedThread TINYINT(1) NOT NULL DEFAULT -1,
	canDeleteThreadCompletely TINYINT(1) NOT NULL DEFAULT -1,
	canCloseThread TINYINT(1) NOT NULL DEFAULT -1,
	canEnableThread TINYINT(1) NOT NULL DEFAULT -1,
	canMoveThread TINYINT(1) NOT NULL DEFAULT -1,
	canCopyThread TINYINT(1) NOT NULL DEFAULT -1,
	canMergeThread TINYINT(1) NOT NULL DEFAULT -1,
	canEditPost TINYINT(1) NOT NULL DEFAULT -1,
	canDeletePost TINYINT(1) NOT NULL DEFAULT -1,
	canReadDeletedPost TINYINT(1) NOT NULL DEFAULT -1,
	canDeletePostCompletely TINYINT(1) NOT NULL DEFAULT -1,
	canClosePost TINYINT(1) NOT NULL DEFAULT -1,
	canEnablePost TINYINT(1) NOT NULL DEFAULT -1,
	canMovePost TINYINT(1) NOT NULL DEFAULT -1,
	canCopyPost TINYINT(1) NOT NULL DEFAULT -1,
	canMergePost TINYINT(1) NOT NULL DEFAULT -1,
	canReplyClosedThread TINYINT(1) NOT NULL DEFAULT -1,
	canPinThread TINYINT(1) NOT NULL DEFAULT -1,
	canStartAnnouncement TINYINT(1) NOT NULL DEFAULT -1,
	canMarkAsDoneThread TINYINT(1) NOT NULL DEFAULT -1,
	KEY (userID),
	KEY (groupID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Display More

Gruß norse

Fischii · Jun 9th 2016

Hallo Norse,

danke erstmal!

Habe so es so aus geführt, nur jetzt kommt diese fehler meldung

Code

Fatal error: Invalid SQL: INSERT INTO wcf1_session (sessionID, packageID, userID, ipAddress, userAgent, lastActivityTime, requestURI, requestMethod, username) VALUES ('d0e2c5ec345701c49fe19fe0e291199863b119c6', 48, 0, '79.238.216.154', 'Mozilla/5.0 (Windows NT 6.1; rv:46.0) Gecko/20100101 Firefox/46.0', 1465461559, '/index.php', 'GET', '' )




You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146
Information:




error message: Invalid SQL: INSERT INTO wcf1_session (sessionID, packageID, userID, ipAddress, userAgent, lastActivityTime, requestURI, requestMethod, username) VALUES ('d0e2c5ec345701c49fe19fe0e291199863b119c6', 48, 0, '79.238.216.154', 'Mozilla/5.0 (Windows NT 6.1; rv:46.0) Gecko/20100101 Firefox/46.0', 1465461559, '/index.php', 'GET', '' )
error code: 1146
sql type: MySQLDatabase
sql error: Table 'db1066521-RTM.wcf1_session' doesn't exist
sql error number: 1146
sql version:
file: /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.5.36-1~he.squeeze0
wcf version: 1.1.8 (Tempest)
date: Thu, 09 Jun 2016 08:39:19 +0000
request: /
referer: http://www.rtm-base.de/include.php?path=start.php
Stacktrace:




#0 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/CookieSessionFactory.class.php(78): MySQLDatabase->sendQuery('INSERT INTO \twc...')
#1 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/SessionFactory.class.php(73): CookieSessionFactory->create()
#2 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/system/WBBCore.class.php(200): SessionFactory->get()
#3 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/WCF.class.php(98): WBBCore->initSession()
#4 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/global.php(18): WCF->__construct()
#5 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/index.php(7): require_once('/is/htdocs/wp10...')
#6 {main}

Display More

Danke schon mal!

norse · Jun 9th 2016

Da hat es Dir wohl die halbe DB oder mehr zerschossen. Schau mal nach, wieviele Tabellen in der DB existieren.

Gruß norse

Fischii · Jun 9th 2016

In wbb1 habe ich 53 Tabellen und in WCF3 habe ich 101

norse · Jun 9th 2016

Das sieht ja schon mal garnicht so schlecht aus. Hier die Abfrage für die Sessiontabelle:

SQL

DROP TABLE IF EXISTS wcf1_session;
CREATE TABLE wcf1_session (
	sessionID char(40) NOT NULL default '',
	packageID int(10) unsigned NOT NULL default 0,
	userID int(10) unsigned NOT NULL default 0,
	ipAddress varchar(39) NOT NULL default '',
	userAgent varchar(255) NOT NULL default '',
	lastActivityTime int(10) unsigned NOT NULL default 0,
	requestURI varchar(255) NOT NULL default '',
	requestMethod varchar(4) NOT NULL default '',
	username varchar(255) NOT NULL default '',
	spiderID int(10) unsigned NOT NULL default 0,
	PRIMARY KEY (sessionID),
	KEY (packageID, lastActivityTime, spiderID),
	KEY (userID)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

Display More

Gruß norse

Fischii · Jun 9th 2016

Es wird immer schlimmer, jetzt kommt diese fehler meldung.

Code

You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1054
Information:




error message: Invalid SQL: UPDATE wcf1_session SET userData = 'O:15:\"WBBGuestSession\":12:{s:14:\"\0*\0boardVisits\";N;s:15:\"\0*\0threadVisits\";N;s:19:\"\0*\0closedCategories\";N;s:16:\"\0*\0lastVisitTime\";N;s:19:\"\0*\0boardPermissions\";a:122:{i:1;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:2;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:3;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:4;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:5;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:6;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:7;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:8;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:9;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:10;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:11;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:12;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:13;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:14;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:15;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:16;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:17;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:18;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:20;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:21;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:22;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:23;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:24;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:25;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:26;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:27;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:28;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:29;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:30;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:31;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:32;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:33;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:34;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:35;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:36;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:37;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:38;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:39;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:40;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:41;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:42;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:43;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:44;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:45;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:46;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:47;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:48;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:49;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:50;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:51;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:52;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:53;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:54;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:55;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:56;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:57;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:58;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:59;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:60;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:61;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:62;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:63;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:64;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:65;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:66;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:67;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:68;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:69;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:70;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:71;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:72;a:15:{s:12:\"canViewBoard\";s:1:\"0\";s:13:\"canEnterBoard\";s:1:\"0\";s:13:\"canReadThread\";s:1:\"0\";s:14:\"canStartThread\";s:1:\"0\";s:14:\"canReplyThread\";s:1:\"0\";s:31:\"canStartThreadWithoutModeration\";s:1:\"0\";s:31:\"canReplyThreadWithoutModeration\";s:1:\"0\";s:12:\"canStartPoll\";s:1:\"0\";s:11:\"canVotePoll\";s:1:\"0\";s:13:\"canRateThread\";s:1:\"0\";s:12:\"canUsePrefix\";s:1:\"0\";s:19:\"canUploadAttachment\";s:1:\"0\";s:21:\"canDownloadAttachment\";s:1:\"0\";s:16:\"canDeleteOwnPost\";s:1:\"0\";s:14:\"canEditOwnPost\";s:1:\"0\";}i:73;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:74;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:75;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:76;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:77;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:78;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:79;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:80;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:81;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:82;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:83;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:84;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:85;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:86;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:87;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:88;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:89;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:90;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:91;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:92;a:3:{s:12:\"canViewBoard\";s:1:\"0\";s:13:\"canEnterBoard\";s:1:\"0\";s:13:\"canReadThread\";s:1:\"0\";}i:128;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:129;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:130;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:104;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:113;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:112;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:105;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:106;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:107;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:94;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:103;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:108;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:96;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:97;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:98;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:120;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:121;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:122;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:123;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:126;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:127;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:99;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:100;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:101;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:102;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:111;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:93;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:109;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:110;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}i:95;a:3:{s:12:\"canViewBoard\";s:1:\"1\";s:13:\"canEnterBoard\";s:1:\"1\";s:13:\"canReadThread\";s:1:\"1\";}s:8:\"groupIDs\";s:3:\"1,2\";}s:28:\"\0*\0boardModeratorPermissions\";a:0:{}s:12:\"\0*\0groupData\";a:62:{s:27:\"admin.user.accessibleGroups\";s:0:\"\";s:27:\"user.profile.canChangeEmail\";b:1;s:25:\"user.profile.renamePeriod\";s:3:\"182\";s:20:\"user.profile.canView\";b:1;s:17:\"user.mail.canMail\";b:1;s:33:\"user.profile.avatar.canViewAvatar\";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:\"40000\";s:41:\"user.profile.avatar.allowedFileExtensions\";s:39:\"gif\r\njpg\r\njpeg\r\npng\ngif\r\njpg\r\njpeg\r\npng\";s:24:\"user.membersList.canView\";b:1;s:26:\"user.message.canUseSmilies\";b:1;s:26:\"user.message.canUseBBCodes\";b:1;s:29:\"user.message.floodControlTime\";s:2:\"30\";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: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:17:\"user.pm.maxLength\";s:5:\"10000\";s:27:\"user.pm.canUploadAttachment\";b:1;s:25:\"user.pm.maxAttachmentSize\";s:6:\"150000\";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:24:\"user.usersOnline.canView\";b:1;s:30:\"user.usersOnline.canViewRobots\";b:1;s:23:\"user.board.canViewBoard\";b:1;s:24:\"user.board.canEnterBoard\";b:1;s:24:\"user.board.canReadThread\";b:1;s:27:\"user.board.canReadOwnThread\";b:1;s:26:\"user.board.postEditTimeout\";i:-1;s:25:\"user.board.doublePostLock\";s:1:\"0\";s:27:\"user.profile.canSeeTeamPage\";b:1;s:24:\"user.board.maxPostLength\";s:5:\"10000\";s:21:\"user.board.canSetTags\";b:1;s:33:\"user.board.canMarkAsDoneOwnThread\";b:1;s:32:\"user.board.canDownloadAttachment\";b:1;s:35:\"user.board.canViewAttachmentPreview\";b:1;s:28:\"user.board.maxAttachmentSize\";s:6:\"150000\";s:38:\"user.board.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:29:\"user.board.maxAttachmentCount\";s:1:\"5\";s:26:\"user.board.canViewVisitors\";b:1;s:22:\"user.board.canVotePoll\";b:1;s:38:\"user.profile.birthdays.canUseBirthdays\";b:1;s:23:\"user.board.canViewStats\";b:1;s:27:\"user.guestbook.canReadEntry\";b:1;s:28:\"user.guestbook.canWriteEntry\";b:1;s:29:\"user.guestbook.maxEntryLength\";s:5:\"10000\";s:30:\"user.guestbook.canEditOwnEntry\";b:1;s:28:\"user.chat.room.canEnterRoom1\";b:1;s:30:\"user.guestbook.canUseGuestbook\";b:1;s:30:\"user.guestbook.canCommentEntry\";b:1;s:18:\"user.chat.canEnter\";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;}}' WHERE sessionID = 'dcc62705738f85a8020c0f35ae881d4dfe54d65d'
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'userData' in 'field list'
sql error number: 1054
sql version:
file: /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.5.36-1~he.squeeze0
wcf version: 1.1.8 (Tempest)
date: Thu, 09 Jun 2016 13:44:27 +0000
request: /
referer: http://www.rtm-base.de/include.php?path=start.php
Stacktrace:




#0 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/CookieSessionFactory.class.php(100): MySQLDatabase->sendQuery('UPDATE \twcf1_se...')
#1 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/session/SessionFactory.class.php(73): CookieSessionFactory->create()
#2 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/system/WBBCore.class.php(200): SessionFactory->get()
#3 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/WCF.class.php(98): WBBCore->initSession()
#4 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/global.php(18): WCF->__construct()
#5 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/index.php(7): require_once('/is/htdocs/wp10...')
#6 {main}

Display More

Black Rider · Jun 9th 2016

Führe noch folgende Abfrage aus:

SQL

DROP TABLE IF EXISTS `wcf1_session_data`;
CREATE TABLE IF NOT EXISTS `wcf1_session_data` (
	 `sessionID` char(40) NOT NULL DEFAULT '',
	 `userData` mediumtext,
	 `sessionVariables` mediumtext,
	 PRIMARY KEY (`sessionID`)
) ENGINE=MyISAM;

Siehe auch: https://wcfinfo.de/faq/#faqEntry-14

Fischii · Jun 9th 2016

Kann ich eigentlich nicht einfach nur ein update drüber laufen lasssen oder 4.1 drüber spielen lassen, da ich mir die 4.1 noch zulegen wollte.

Black Rider · Jun 9th 2016

Das würde ich bei einer kaputten Datenbank nicht empfehlen.

Fischii · Jun 9th 2016

Jetzt habe ich diese fehler meldung.

Code

Fatal error: Invalid SQL: SELECT COUNT(*) AS count FROM wbb1_1_visitor visitor WHERE visitor.lastActivityTime >= 1465423200 LIMIT 1




You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146
Information:




error message: Invalid SQL: SELECT COUNT(*) AS count FROM wbb1_1_visitor visitor WHERE visitor.lastActivityTime >= 1465423200 LIMIT 1
error code: 1146
sql type: MySQLDatabase
sql error: Table 'db1066521-RTM.wbb1_1_visitor' doesn't exist
sql error number: 1146
sql version:
file: /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.5.36-1~he.squeeze0
wcf version: 1.1.8 (Tempest)
date: Thu, 09 Jun 2016 13:50:23 +0000
request: /
referer: http://www.rtm-base.de/include.php?path=start.php
Stacktrace:




#0 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT \t\tCOUNT(...', 1, 0)
#1 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/data/visitors/Visitors.class.php(21): Database->getFirstRow('SELECT \t\tCOUNT(...')
#2 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/system/event/listener/IndexPageVisitorsListener.class.php(18): Visitors->countVisitors()
#3 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/system/event/EventHandler.class.php(207): IndexPageVisitorsListener->execute(Object(IndexPage), 'IndexPage', 'assignVariables')
#4 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/page/AbstractPage.class.php(73): EventHandler::fireAction(Object(IndexPage), 'assignVariables')
#5 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/lib/page/IndexPage.class.php(26): AbstractPage->assignVariables()
#6 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/page/AbstractPage.class.php(93): IndexPage->assignVariables()
#7 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/page/AbstractPage.class.php(46): AbstractPage->show()
#8 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#9 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/lib/util/RequestHandler.class.php(101): RequestHandler->__construct('Index', Array, 'page')
#10 /is/htdocs/wp1066521_IUS29K79O8/www/RTM-Base/forum/wbb3/wbb3/index.php(8): RequestHandler::handle(Array)

Display More

norse · Jun 9th 2016

Nun wird es spannend. Diese Tabelle gehört nicht zum Standardumfang des WBB (Meine Referenz ist das WBB 3.1.8). Ich habe auch keine Ahnung, von welchem Paket sie stammen könnte. Was halten die anderen Helfer von einer Neuinstallation mit anschließendem Datenimport, um zumindest die relevanten Inhalte zu retten?

Gruß norse

Fischii · Jun 9th 2016

Ja das würde mich auch mal intressieren!

Und wenn das klappen würde wäre es schon mal super...

**Andrea Berg** · Jun 10th 2016

Ein Datenimport funktioniert nur, wenn die dafür relevanten Tabellen alle in der Datenbank vorhanden sind. Also ist die große Frage welche Tabellen aktuell alles vorhanden sind? Bei 101 Tabellen fehlen ca. 36 Tabellen (ohne Plugins).

PS: Wichtige Information: Burning Board 3.1 - Einstellung der Unterstützung

Fischii · Jun 12th 2016

Habe mir gerade die Datenbank angeschaut. Es sind alle daten und Tabellen von Posts,Boards, Users vorhanden und andere auch.

Ich werde morgen mal eine neue Datenbank anlegen und es dort neu installieren und vorher werde die Datenbank vom Board exportieren und es in der neuen Datenbank importieren.

Vielleicht habe ich ja glück und es klappt..

SoftCreatR · Jun 12th 2016

Quote from norse

Ich habe auch keine Ahnung, von welchem Paket sie stammen könnte.

woltlab.com/pluginstore/file/705/

Bekomme immer diese fehler meldung

Participate now!

Share

Similar Threads

Aktuelles WCF Update lässt sich nicht installieren

Fehlermeldung foreach

Fehler beim löschen eines Dateianhangs aus gelöschtem Thread

Users Viewing This Thread

Participate now!

Share

Similar Threads

Aktuelles WCF Update lässt sich nicht installieren

Fehlermeldung foreach

Fehler beim löschen eines Dateianhangs aus gelöschtem Thread​

Users Viewing This Thread

Fehler beim löschen eines Dateianhangs aus gelöschtem Thread