Mir ist beim Testen gerade ein Fehler aufgefallen, der entsteht wenn ich Versandkosten für eine eigens angelegte Steuerklasse hinzufügen möchte. Sobald ich als Versandkosten 0€ eintrage (unabhängig davon welches Land ich auswähle) erscheint folgender Fehler Fatal error: Could not execute prepared statement: SQLSTATE[HY000]: General error: 1364 Field 'tax' doesn't have a default value
Sat, 16 May 2015 18:17:11 +0000
Message: Could not execute prepared statement: SQLSTATE[HY000]: General error: 1364 Field 'tax' doesn't have a default value
File: /var/www/virtual/viecode1/html/w6zry/wcf/lib/system/database/statement/PreparedStatement.class.php (100)
PHP version: 5.5.5
WCF version: 2.0.9 (Maelstrom)
Request URI: /w6zry/acp/index.php/ShippingAdd/?
Referrer: http://testing.viecode.de/w6zry/acp/index.php/ShippingAdd/?
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/600.6.3 (KHTML, like Gecko) Version/8.0.6 Safari/600.6.3
Information: "<b>sql type:<\/b> wcf\\system\\database\\MySQLDatabase<br \/><b>sql error:<\/b> Field 'tax' doesn't have a default value<br \/><b>sql error number:<\/b> HY000<br \/><b>sql version:<\/b> 5.1.73-log<br \/><b>sql query:<\/b> INSERT INTO\tshop1_shipping\n\t\t\t\t\t(name,description,taxCategoryID,isActive,icon,price,maxWeight)\n\t\t\tVALUES\t\t(?,?,?,?,?,?,?)<br \/><b>sql query parameter 0:<\/b>Kostenloser Versand<br \/><b>sql query parameter 1:<\/b><br \/><b>sql query parameter 2:<\/b>2<br \/><b>sql query parameter 3:<\/b>1<br \/><b>sql query parameter 4:<\/b><br \/><b>sql query parameter 5:<\/b>a:1:{s:1:"*";a:1:{s:3:"EUR";d:0;}}<br \/><b>sql query parameter 6:<\/b>0<br \/>"
Stacktrace:
#0 /var/www/virtual/viecode1/html/w6zry/wcf/lib/data/DatabaseObjectEditor.class.php(38): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 [internal function]: wcf\data\DatabaseObjectEditor::create(Array)
#2 /var/www/virtual/viecode1/html/w6zry/wcf/lib/data/AbstractDatabaseObjectAction.class.php(308): call_user_func(Array, Array)
#3 [internal function]: wcf\data\AbstractDatabaseObjectAction->create()
#4 /var/www/virtual/viecode1/html/w6zry/wcf/lib/data/AbstractDatabaseObjectAction.class.php(182): call_user_func(Array)
#5 /var/www/virtual/viecode1/html/w6zry/lib/acp/form/ShippingAddForm.class.php(203): wcf\data\AbstractDatabaseObjectAction->executeAction()
#6 /var/www/virtual/viecode1/html/w6zry/wcf/lib/form/AbstractForm.class.php(63): shop\acp\form\ShippingAddForm->save()
#7 /var/www/virtual/viecode1/html/w6zry/wcf/lib/form/AbstractForm.class.php(114): wcf\form\AbstractForm->submit()
#8 /var/www/virtual/viecode1/html/w6zry/lib/acp/form/ShippingAddForm.class.php(166): wcf\form\AbstractForm->readData()
#9 /var/www/virtual/viecode1/html/w6zry/wcf/lib/page/AbstractPage.class.php(179): shop\acp\form\ShippingAddForm->readData()
#10 /var/www/virtual/viecode1/html/w6zry/lib/acp/form/ShippingAddForm.class.php(270): wcf\page\AbstractPage->show()
#11 /var/www/virtual/viecode1/html/w6zry/wcf/lib/page/AbstractPage.class.php(86): shop\acp\form\ShippingAddForm->show()
#12 /var/www/virtual/viecode1/html/w6zry/wcf/lib/system/request/Request.class.php(58): wcf\page\AbstractPage->__run()
#13 /var/www/virtual/viecode1/html/w6zry/wcf/lib/system/request/RequestHandler.class.php(108): wcf\system\request\Request->execute()
#14 /var/www/virtual/viecode1/html/w6zry/acp/index.php(11): wcf\system\request\RequestHandler->handle('shop', true)
#15 {main}
