Gallery Suite keine Bilder nach import

Harald Nigg · November 16, 2017 at 5:29 PM

Hallo WL,

mit der Beta3 ist ja auch eine Betaversion von der neuen Galerie da.

Diese habe ich mir dann auch gleich installiert.

Und auch aus meinem aktiven System die Bilder importiert.

Sie stehen auch in der Datenbank so wie sind sie im Verzeichnis UserImage der Galerie.

Trotzdem werden die Bilder nicht angezeigt, das selbe Problem habe auch mit den Attachments.

Matthias Schmidt · November 17, 2017 at 6:36 AM Official Post

Hast Du die Anzeigen nach dem Import aktualisiert?

Harald Nigg · November 17, 2017 at 8:22 AM

Ja habe ich.

Und die Vorschaubilder und Bilder werden überhaupt nicht angezeigt.

Obwohl sie auf dem Server unter UserImages liegen.

Hier der Link zum Betatestforum: https:\\beta.tourneo-forum.de

Harald Nigg · November 21, 2017 at 2:47 AM

Code

Could not execute statement 'INSERT INTO gallery1_image_marker (imageID,positionX,positionY,userID,description,markerID) VALUES (?,?,?,?,?,?)'

Stacktrace:

#0 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/data/DatabaseObjectEditor.class.php(36): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /var/www/virtual/tourneo-forum.de/beta/htdocs/gallery/lib/system/importer/ImageMarkerImporter.class.php(39): wcf\data\DatabaseObjectEditor::create(Array)
#2 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/WBB4xExporter.class.php(1953): gallery\system\importer\ImageMarkerImporter->import(1, Array)
#3 [internal function]: wcf\system\exporter\WBB4xExporter->exportGalleryImageMarkers(0, 1000)
#4 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/AbstractExporter.class.php(152): call_user_func(Array, 0, 1000)
#5 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/worker/ImportWorker.class.php(95): wcf\system\exporter\AbstractExporter->exportData('com.woltlab.gal...', 0)
#6 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/acp/action/WorkerProxyAction.class.php(92): wcf\system\worker\ImportWorker->execute()
#7 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AbstractAction.class.php(47): wcf\acp\action\WorkerProxyAction->execute()
#8 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#9 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/Request.class.php(83): wcf\action\AJAXInvokeAction->__run()
#10 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/RequestHandler.class.php(96): wcf\system\request\Request->execute()
#11 /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)
#12 {main}

Display More

Diesen Fehler bekomme ich beim Import von meinem anderen Forum in das Testforum.

Matthias Schmidt · November 28, 2017 at 7:55 AM Official Post

Ist das die vollständige Fehlermeldung? Schaue bitte im ACP bei den Fehlermeldungslogs nach, ob Du dort die komplette Fehlermeldung findest.

Harald Nigg · November 28, 2017 at 12:14 PM

Das ist die Fehlermeldung die kommt beim Importieren vom aktiven System ins Testsystem.

Danach bricht es ab mehr kommt da nicht.

Matthias Schmidt · November 28, 2017 at 4:00 PM Official Post

Quote from Matthias Schmidt

Schaue bitte im ACP bei den Fehlermeldungslogs nach, ob Du dort die komplette Fehlermeldung findest.

Hast Du das gemacht?

Harald Nigg · November 28, 2017 at 5:09 PM

~~Hab ich nach gesehen und es ist keine Log da.~~

Die Kategorien legt er an aber alles andere eben nicht.

Keine Bilder etc.

Requested URL: /cms/acp/index.php?worker-proxy/&t=7d99566f315d13b2a1785c333dcf5432bc6a7aa2

Referrer: https://beta.tourneo-forum.de/cms/acp/index.php?data-import/

Error Message: Could not execute statement 'INSERT INTO gallery1_image_marker (imageID,positionX,positionY,userID,description,markerID) VALUES (?,?,?,?,?,?)'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: null

Query Parameter 2: 860

Query Parameter 3: 380

Query Parameter 4: null

Query Parameter 5: 'Rostblase...'

Query Parameter 6: 1

Stacktrace

/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/data/DatabaseObjectEditor.class.php (36): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/gallery/lib/system/importer/ImageMarkerImporter.class.php (39): wcf\data\DatabaseObjectEditor::create(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/WBB4xExporter.class.php (1953): gallery\system\importer\ImageMarkerImporter->import(…)
[internal function] (?): wcf\system\exporter\WBB4xExporter->exportGalleryImageMarkers(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/AbstractExporter.class.php (152): call_user_func(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/worker/ImportWorker.class.php (95): wcf\system\exporter\AbstractExporter->exportData(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/acp/action/WorkerProxyAction.class.php (92): wcf\system\worker\ImportWorker->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AbstractAction.class.php (47): wcf\acp\action\WorkerProxyAction->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AJAXInvokeAction.class.php (63): wcf\action\AbstractAction->__run(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'imageID' cannot be null

Type: PDOException

File (Line): /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/data/DatabaseObjectEditor.class.php (36): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/gallery/lib/system/importer/ImageMarkerImporter.class.php (39): wcf\data\DatabaseObjectEditor::create(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/WBB4xExporter.class.php (1953): gallery\system\importer\ImageMarkerImporter->import(…)
[internal function] (?): wcf\system\exporter\WBB4xExporter->exportGalleryImageMarkers(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/exporter/AbstractExporter.class.php (152): call_user_func(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/worker/ImportWorker.class.php (95): wcf\system\exporter\AbstractExporter->exportData(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/acp/action/WorkerProxyAction.class.php (92): wcf\system\worker\ImportWorker->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AbstractAction.class.php (47): wcf\acp\action\WorkerProxyAction->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/action/AJAXInvokeAction.class.php (63): wcf\action\AbstractAction->__run(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/virtual/tourneo-forum.de/beta/htdocs/cms/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Tue, 28 Nov 2017 16:10:01 +0000
Message: Could not execute statement 'INSERT INTO    gallery1_image_marker
                     (imageID,positionX,positionY,userID,description,markerID)
             VALUES        (?,?,?,?,?,?)'
PHP version: 7.1.1
WoltLab Suite version: 3.1.0 Beta 3
Request URI: /cms/acp/index.php?worker-proxy/&t=7d99566f315d13b2a1785c333dcf5432bc6a7aa2
Referrer: https://beta.tourneo-forum.de/cms/acp/index.php?data-import/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Peak Memory Usage: 3557592/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO    gallery1_image_marker
                     (imageID,positionX,positionY,userID,description,markerID)
             VALUES        (?,?,?,?,?,?)'
Error Code: 23000
File: /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo2OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtzOjQ6Im51bGwiO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjg2MDt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTozODA7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO3M6NDoibnVsbCI7fWk6NDthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNSI7aToxO3M6MTQ6IidSb3N0Ymxhc2UuLi4nIjt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aToxO319
Stack Trace: [{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/gallery\/lib\/system\/importer\/ImageMarkerImporter.class.php","line":39,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"imageID":"[redacted]","positionX":"[redacted]","positionY":"[redacted]","userID":"[redacted]","description":"[redacted]","markerID":"[redacted]"}]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/exporter\/WBB4xExporter.class.php","line":1953,"function":"import","class":"gallery\\system\\importer\\ImageMarkerImporter","type":"->","args":[1,{"imageID":"[redacted]","positionX":"[redacted]","positionY":"[redacted]","userID":"[redacted]","description":"[redacted]","markerID":"[redacted]"}]},{"function":"exportGalleryImageMarkers","class":"wcf\\system\\exporter\\WBB4xExporter","type":"->","args":[0,1000],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/exporter\/AbstractExporter.class.php","line":152,"function":"call_user_func","args":[["[redacted]","[redacted]"],0,1000],"class":"","type":""},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/worker\/ImportWorker.class.php","line":95,"function":"exportData","class":"wcf\\system\\exporter\\AbstractExporter","type":"->","args":["com.woltlab.gallery.image.marker",0]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/acp\/action\/WorkerProxyAction.class.php","line":92,"function":"execute","class":"wcf\\system\\worker\\ImportWorker","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'imageID' cannot be null
Error Code: 23000
File: /var/www/virtual/tourneo-forum.de/beta/htdocs/cms/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/gallery\/lib\/system\/importer\/ImageMarkerImporter.class.php","line":39,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"imageID":"[redacted]","positionX":"[redacted]","positionY":"[redacted]","userID":"[redacted]","description":"[redacted]","markerID":"[redacted]"}]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/exporter\/WBB4xExporter.class.php","line":1953,"function":"import","class":"gallery\\system\\importer\\ImageMarkerImporter","type":"->","args":[1,{"imageID":"[redacted]","positionX":"[redacted]","positionY":"[redacted]","userID":"[redacted]","description":"[redacted]","markerID":"[redacted]"}]},{"function":"exportGalleryImageMarkers","class":"wcf\\system\\exporter\\WBB4xExporter","type":"->","args":[0,1000],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/exporter\/AbstractExporter.class.php","line":152,"function":"call_user_func","args":[["[redacted]","[redacted]"],0,1000],"class":"","type":""},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/worker\/ImportWorker.class.php","line":95,"function":"exportData","class":"wcf\\system\\exporter\\AbstractExporter","type":"->","args":["com.woltlab.gallery.image.marker",0]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/acp\/action\/WorkerProxyAction.class.php","line":92,"function":"execute","class":"wcf\\system\\worker\\ImportWorker","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/virtual\/tourneo-forum.de\/beta\/htdocs\/cms\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

So noch mal Probiert um zu testen ob er jetzt eine Log anlegt.

Dukemaster · December 1, 2017 at 12:50 PM

Hallo Matthias,

habe letzte Woche gleiche(n) Fehler reproduziert und irgendwo hatte ich auch schon dokumentiert, jedoch nur nebenbei in anderem Thread nicht als eigenständige Fehler-Meldung, nämlich daß der Image Marker immer wieder einen Abbruch mit Endlosschleife erzeugt.

Umgebung:

BurningBoard + Blog + Galerie + Kalender meines hiesigen 3.0.0pl11 Produktivsystems in eine neu-installierte 3.1.0 Beta 3 per ACP-Datenimportfunktion zu importieren.

Unterschied zum Import vom Themenersteller Harald Nigg :

Die realen Bilder (+Anhänge+Avatare+Smileys) hatte ich zum Zeitpunkt des Import-Tests noch nicht in die neue Installation kopiert/verschoben gehabt.

Denn ich wusste zu dem Zeitpunkt auch noch nicht, daß die reale Existenz der Bilder beim Import abgefragt wird. Das hat Alexander Ebert danach erklärt.

Gruß

Harald Nigg · December 1, 2017 at 5:50 PM

Dachte schon ich stell mich zu blöd an.

Harald Nigg · December 2, 2017 at 7:50 AM

So habe Matthias Schmidt per PN geantwortet.

Gallery Suite keine Bilder nach import

Participate now!

Similar Threads

Patch-Day 07.08.2017