Hallo zusammen,
leider erhalte ich einen Fehler Error beim Eintrag eines Link vom Kunden. Das gesamte ACP wird dabei Lahmgelegt.
Hier der Fehlercode:
Code
System Information
PHP Version:
8.1.27
WoltLab Suite Core:
5.5.20
Peak Memory Usage:
3.204/512 MiB
Request URI:
POST /wcf/acp/index.php?easy-ads-banner-edit/274-haufe-2024-1/
Referrer:
https://sifaboard.de/wcf/acp/index.php?easy-ads-banner-edit/274/
User Agent:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36
Original Error
Error Type:
PDOException
Error Message:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'pictureLink' at row 1
Error Code:
22001
File:
*/lib/system/database/statement/PreparedStatement.class.php (126)
Stack Trace:
#0 */lib/system/database/statement/PreparedStatement.class.php (126):
PDOStatement->execute()
#1 */lib/data/DatabaseObjectEditor.class.php (55):
wcf\system\database\statement\PreparedStatement->execute()
#2 */lib/data/AbstractDatabaseObjectAction.class.php (388):
wcf\data\DatabaseObjectEditor->update()
#3 */lib/data/easyads3/banner/BannerAction.class.php (80):
wcf\data\AbstractDatabaseObjectAction->update()
#4 */lib/data/AbstractDatabaseObjectAction.class.php (216):
wcf\data\easyads3\banner\BannerAction->update()
#5 */lib/form/AbstractFormBuilderForm.class.php (188):
wcf\data\AbstractDatabaseObjectAction->executeAction()
#6 */lib/form/AbstractForm.class.php (80):
wcf\form\AbstractFormBuilderForm->save()
#7 */lib/form/AbstractForm.class.php (152):
wcf\form\AbstractForm->submit()
#8 */lib/form/AbstractFormBuilderForm.class.php (147):
wcf\form\AbstractForm->readData()
#9 */lib/page/AbstractPage.class.php (353):
wcf\form\AbstractFormBuilderForm->readData()
#10 */lib/page/AbstractPage.class.php (135):
wcf\page\AbstractPage->show()
#11 */lib/system/request/Request.class.php (90):
wcf\page\AbstractPage->__run()
#12 */lib/system/request/RequestHandler.class.php (107):
wcf\system\request\Request->execute()
#13 */acp/index.php (11):
wcf\system\request\RequestHandler->handle()
Final Error
Error Type:
wcf\system\database\exception\DatabaseQueryExecutionException
Error Message:
Could not execute statement 'UPDATE wcf1_easyads_banner SET customerID = ?, title = ?, typeID = ?, bannerContent = ?, isExternal = ?, pictureLink = ?, pictureAlt = ?, width = ?, height = ?, codeHeadInclude = ?, codeBodyFirst = ?, codeBodyLast = ?, maxViews = ?, maxClicks = ?, faktor = ?, customMessage = ? WHERE bannerID = ?'
Error Code:
22001
File:
*/lib/system/database/statement/PreparedStatement.class.php (144)
Query Parameter 1:
'21'
Query Parameter 2:
'Haufe_2024_1'
Query Parameter 3:
'7'
Query Parameter 4:
'1'
Query Parameter 5:
0
Query Parameter 6:
'https://shop.haufe.de/prod/haufe-gefaehrdungsbeurteilung?chorid=04544799&em_src=display&em_cmp=direktbuchung/vertical/ArbeitsschutzGefaehrdungsbeurteilungBanner/100127/04544799&akttyp=display&med=direktbuchung&aktnr=100127&wnr=04544799&cmp=ArbeitsschutzGefaehrdungsbeurteilungBanner&utm_id=vertical/100127/04544799&utm_source=display&utm_medium=direktbuchung&utm_campaign=ArbeitsschutzGefaehrdungsbeurteilungBanner'
Query Parameter 7:
''
Query Parameter 8:
0
Query Parameter 9:
0
Query Parameter 10:
''
Query Parameter 11:
''
Query Parameter 12:
''
Query Parameter 13:
0
Query Parameter 14:
0
Query Parameter 15:
1
Query Parameter 16:
''
Query Parameter 17:
274
Stack Trace:
#0 */lib/data/DatabaseObjectEditor.class.php (55):
wcf\system\database\statement\PreparedStatement->execute()
#1 */lib/data/AbstractDatabaseObjectAction.class.php (388):
wcf\data\DatabaseObjectEditor->update()
#2 */lib/data/easyads3/banner/BannerAction.class.php (80):
wcf\data\AbstractDatabaseObjectAction->update()
#3 */lib/data/AbstractDatabaseObjectAction.class.php (216):
wcf\data\easyads3\banner\BannerAction->update()
#4 */lib/form/AbstractFormBuilderForm.class.php (188):
wcf\data\AbstractDatabaseObjectAction->executeAction()
#5 */lib/form/AbstractForm.class.php (80):
wcf\form\AbstractFormBuilderForm->save()
#6 */lib/form/AbstractForm.class.php (152):
wcf\form\AbstractForm->submit()
#7 */lib/form/AbstractFormBuilderForm.class.php (147):
wcf\form\AbstractForm->readData()
#8 */lib/page/AbstractPage.class.php (353):
wcf\form\AbstractFormBuilderForm->readData()
#9 */lib/page/AbstractPage.class.php (135):
wcf\page\AbstractPage->show()
#10 */lib/system/request/Request.class.php (90):
wcf\page\AbstractPage->__run()
#11 */lib/system/request/RequestHandler.class.php (107):
wcf\system\request\Request->execute()
#12 */acp/index.php (11):
wcf\system\request\RequestHandler->handle()
Alles anzeigen
Das ist der Link zur Landingpage:
Haufe Gefährdungsbeurteilung
Im Gegensatz zu Excel-, Word- oder komplexen Management-Lösungen, bildet Haufe Gefährdungsbeurteilung den gesamten Prozess intuitiv und selbsterklärend ab -…
shop.haufe.de
Kann man das so erweitern das man längere Links eintragen darf oder muss ich deem Kunden sagen das gar nicht mit ihren links....
Viele Grüße Toni