Bei mir wurde heute aus irgend einem Grund die Einstellung auf den Standardwert 5 zurück gesetzt.
Möchte ich sie nun ändern erhalte ich folgenden Fehler:
Spoiler anzeigen
Fatal error: Invalid SQL: INSERT INTO wcf1_user_option_value (userID, userOption188, userOption192, userOption189, userOption190, userOption191) VALUES (11556, '1', '0', '8', '', '') ON DUPLICATE KEY UPDATE userOption188 = VALUES(userOption188),userOption192 = VALUES(userOption192),userOption189 = VALUES(userOption189),userOption190 = VALUES(userOption190),userOption191 = VALUES(userOption191)
You get more information about the problem in our knowledge base: woltlab.com/help/?code=1054
Information:
error message: Invalid SQL: INSERT INTO wcf1_user_option_value (userID, userOption188, userOption192, userOption189, userOption190, userOption191) VALUES (11556, '1', '0', '8', '', '') ON DUPLICATE KEY UPDATE userOption188 = VALUES(userOption188),userOption192 = VALUES(userOption192),userOption189 = VALUES(userOption189),userOption190 = VALUES(userOption190),userOption191 = VALUES(userOption191)
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'userOption192' in 'field list'
sql error number: 1054
sql version:
file: /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.2-1ubuntu4.19
wcf version: 1.1.9 (Tempest)
date: Tue, 26 Mar 2013 22:27:04 +0000
request: /index.php?UserProfileEdit
referer: dotasource.de/index.php?UserPr…ngs.latestPostsAndThreads
Stacktrace:
#0 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/data/user/UserEditor.class.php(225): MySQLDatabase->sendQuery('INSERT INTO???w...')
#1 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/data/user/UserEditor.class.php(244): UserEditor::insertUserOptions('11556', Array, true)
#2 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(197): UserEditor->update('', '', '', NULL, Array, Array, NULL)
#3 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/AbstractForm.class.php(45): UserProfileEditForm->save()
#4 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/AbstractForm.class.php(90): AbstractForm->submit()
#5 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(93): AbstractForm->readData()
#6 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/page/AbstractPage.class.php(90): UserProfileEditForm->readData()
#7 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(177): AbstractPage->show()
#8 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/page/AbstractPage.class.php(46): UserProfileEditForm->show()
#9 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#10 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('UserProfileEdit', Array, 'form')
#11 /var/www/vhosts/dotasource.de/httpdocs/index.php(8): RequestHandler::handle(Array)
#12 {main}
Möchte ich sie nun ändern erhalte ich folgenden Fehler:
Fatal error: Invalid SQL: INSERT INTO wcf1_user_option_value (userID, userOption188, userOption192, userOption189, userOption190, userOption191) VALUES (11556, '1', '0', '8', '', '') ON DUPLICATE KEY UPDATE userOption188 = VALUES(userOption188),userOption192 = VALUES(userOption192),userOption189 = VALUES(userOption189),userOption190 = VALUES(userOption190),userOption191 = VALUES(userOption191)
You get more information about the problem in our knowledge base: woltlab.com/help/?code=1054
Information:
error message: Invalid SQL: INSERT INTO wcf1_user_option_value (userID, userOption188, userOption192, userOption189, userOption190, userOption191) VALUES (11556, '1', '0', '8', '', '') ON DUPLICATE KEY UPDATE userOption188 = VALUES(userOption188),userOption192 = VALUES(userOption192),userOption189 = VALUES(userOption189),userOption190 = VALUES(userOption190),userOption191 = VALUES(userOption191)
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'userOption192' in 'field list'
sql error number: 1054
sql version:
file: /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.2-1ubuntu4.19
wcf version: 1.1.9 (Tempest)
date: Tue, 26 Mar 2013 22:27:04 +0000
request: /index.php?UserProfileEdit
referer: dotasource.de/index.php?UserPr…ngs.latestPostsAndThreads
Stacktrace:
#0 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/data/user/UserEditor.class.php(225): MySQLDatabase->sendQuery('INSERT INTO???w...')
#1 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/data/user/UserEditor.class.php(244): UserEditor::insertUserOptions('11556', Array, true)
#2 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(197): UserEditor->update('', '', '', NULL, Array, Array, NULL)
#3 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/AbstractForm.class.php(45): UserProfileEditForm->save()
#4 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/AbstractForm.class.php(90): AbstractForm->submit()
#5 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(93): AbstractForm->readData()
#6 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/page/AbstractPage.class.php(90): UserProfileEditForm->readData()
#7 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/form/UserProfileEditForm.class.php(177): AbstractPage->show()
#8 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/page/AbstractPage.class.php(46): UserProfileEditForm->show()
#9 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#10 /var/www/vhosts/dotasource.de/httpdocs/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('UserProfileEdit', Array, 'form')
#11 /var/www/vhosts/dotasource.de/httpdocs/index.php(8): RequestHandler::handle(Array)
#12 {main}