Hallo Zusammen,
Ich habe mein Board auf der aktuellsten Version 2.3.6 und will die Daten in das neu installierte 3er Board ziehen.
Klappt soweit auch alles, bis auf einen Fatal Error bei 14% des Imports. Folgendes wird angezeigt:
Code
Fatal error: Invalid SQL: SELECT userfields.*, user.* ,( SELECT GROUP_CONCAT(groupid) FROM bb1_user2groups WHERE userid = user.userid ) AS groupids FROM bb1_users user LEFT JOIN bb1_userfields userfields ON (userfields.userid = user.userid) ORDER BY user.userID LIMIT 100 OFFSET 0
You get more information about the problem in our knowledge base: [url]http://www.woltlab.com/help/?code=1064[/url]
Information:
error message: Invalid SQL: SELECT userfields.*, user.* ,( SELECT GROUP_CONCAT(groupid) FROM bb1_user2groups WHERE userid = user.userid ) AS groupids FROM bb1_users user LEFT JOIN bb1_userfields userfields ON (userfields.userid = user.userid) ORDER BY user.userID LIMIT 100 OFFSET 0
error code: 1064
sql type: MySQLDatabase
sql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT GROUP_CONCAT(groupid) FROM bb1_user2groups
sql error number: 1064
sql version:
file: /home/dage/public_html/board3/wcf/lib/system/database/MySQLDatabase.class.php (111)
php version: 5.2.2-0.suhosin.2
wcf version: 1.0.0
date: Tue, 31 Jul 2007 07:46:06 +0000
request: /board3/wbb/acp/index.php?action=Importer&step=users&packageID=38&
referer: [url]http://www.contraproduktiv.de/board3/wbb/acp/index.php?action=Importer&step=userOptions&packageID=38&[/url]
Stacktrace:
#0 /home/dage/public_html/board3/wbb/lib/system/importer/WBB2xExporter.class.php(373): MySQLDatabase->sendQuery('SELECT??userfie...')
#1 /home/dage/public_html/board3/wbb/lib/acp/action/ImporterAction.class.php(97): WBB2xExporter->exportUsers(0, 100)
#2 /home/dage/public_html/board3/wcf/lib/action/AbstractAction.class.php(22): ImporterAction->execute()
#3 /home/dage/public_html/board3/wbb/lib/acp/action/ImporterAction.class.php(30): AbstractAction->__construct()
#4 /home/dage/public_html/board3/wcf/lib/util/RequestHandler.class.php(56): ImporterAction->__construct()
#5 /home/dage/public_html/board3/wcf/lib/util/RequestHandler.class.php(81): RequestHandler->__construct('Importer', Array, 'action')
#6 /home/dage/public_html/board3/wbb/acp/index.php(8): RequestHandler::handle(Array)
#7 {main}
Display More
Hat jemand eine Idee, was ich tun kann? Ich bin leider auf dem Gebiet SQL kein helles Licht.