Filament Manager: Import / Export Problem


#1

Hello,
I want to use the postgresql Feature of the Filament Plugin. (I'm using the latest octoprint
OctoPrint 1.3.10 running on OctoPi 0.15.1) So, I exported my Spools and Profiles, using the Plugin Import & Export Function. After that I've selected the Database Option, Test Connection to Database Server runs without Problems. So I restarted Octoprint after saving and after this, I want to restore the exported Data to the Database via the "Import Function".

But I get the following in the Logs:

 octoprint.plugins.filamentmanager - ERROR - Data import failed: (psycopg2.ProgrammingError) FEHLER:  Syntaxfehler bei »ON«
LINE 1: ...) VALUES ('1', '3d Hero', 'PETG', '1.25', '1.75') ON CONFLIC...
                                                             ^
 [SQL: 'INSERT INTO profiles (id, vendor, material, density, diameter) VALUES (%(id)s, %(vendor)s, %(material)s, %(density)s, %(diameter)s) ON CONFLICT (id) DO UPDATE SET id = %(param_1)s, vendor = %(param_2)s, material = %(param_3)s, density = %(param_4)s, diameter = %(param_5)s'] [parameters: {'diameter': u'1.75', 'vendor': u'3d Hero', 'density': u'1.25', 'param_5': u'1.75', 'param_4': u'1.25', 'material': u'PETG', 'param_1': u'1', 'param_3': u'PETG', 'param_2': u'3d Hero', 'id': u'1'}]

Hope you can help me...
TIA,
Thomas


#2

Hello,
more Logs, I added some Profiles and Spools manually, but the Problem still exists: In the moment when I choose any Spool via the Filament Manage I'll get an Error:



`- octoprint.plugins.filamentmanager - ERROR - Failed to update selected spool for tool0: (psycopg2.ProgrammingError) FEHLER:  Syntaxfehler bei »ON«
LINE 1: ...ES (0, '1e9fab6a-0bae-11e9-8cf6-b827eb51b0a5', 1) ON CONFLIC...
                                                             ^
 [SQL: 'INSERT INTO selections (tool, client_id, spool_id) VALUES (%(tool)s, %(client_id)s, %(spool_id)s) ON CONFLICT ON CONSTRAINT selections_pkey DO UPDATE SET spool_id = %(param_1)s'] [parameters: {'tool': 0, 'param_1': 1, 'client_id': '1e9fab6a-0bae-11e9-8cf6-b827eb51b0a5', 'spool_id': 1}]
2019-02-12 16:19:02,574 - tornado.access - ERROR - 500 PATCH /plugin/filamentmanager/selections/0 (::ffff:192.168.178.42) 102.78ms
`

Same Problem, when I restart Octoprint:


2019-02-12 16:11:46,439 - octoprint.plugins.filamentmanager - ERROR - Failed to initialize database: (psycopg2.ProgrammingError) FEHLER:  Syntaxfehler bei »ON«
LINE 7:                                        ON CONFLICT (table_na...
                                               ^
 [SQL: '\n                                   CREATE FUNCTION update_lastmodified()\n                                   RETURNS TRIGGER AS $func$\n                                   BEGIN\n                                       INSERT INTO modifications (table_name, action, changed_at)\n                                       VALUES(TG_TABLE_NAME, TG_OP, CURRENT_TIMESTAMP)\n                                       ON CONFLICT (table_name) DO UPDATE\n                                       SET action=TG_OP, changed_at=CURRENT_TIMESTAMP\n                                       WHERE modifications.table_name=TG_TABLE_NAME;\n                                       PERFORM pg_notify(TG_TABLE_NAME, TG_OP);\n                                       RETURN NULL;\n                                   END;\n                                   $func$ LANGUAGE plpgsql;\n                                   ']
2019-02-12 16:11:48,261 - octoprint.util.pip - INFO - Using "/home/pi/oprint/bin/python2 -m pip" as command to invoke pip
2019-02-12 16:11:50,116 - octoprint.util.pip - INFO - Version of pip is 19.0.1
2019-02-12 16:11:50,117 - octoprint.util.pip - INFO - pip installs to /home/pi/oprint/lib/python2.7/site-packages (writable -> yes), --user flag needed -> no, virtual env -> yes
2019-02-12 16:11:50,118 - octoprint.util.pip - INFO - ==> pip ok -> yes
2019-02-12 16:11:50,125 - octoprint.plugin.core - INFO - Initialized 40 plugin implementation(s)
2019-02-12 16:11:50,143 - py.warnings - WARNING - /home/pi/oprint/local/lib/python2.7/site-packages/octoprint/util/__init__.py:623: UnicodeWarning: Unicode unequal comparison failed to convert both arguments to Unicode - interpreting them as being unequal
  if value_source != value_target:

2019-02-12 16:11:50,168 - octoprint.plugin.core - INFO - 44 plugin(s) registered with the system:
|  3D Geeks (1.0.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_geeks3d
|  ABL Expert Plugin (0.1) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_ABL_Expert
|  Action Command Prompt Support (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/action_command_prompt
|  Announcement Plugin (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/announcements
|  Anonymous Usage Tracking (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/tracking
|  Application Keys Plugin (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/appkeys
|  Backup & Restore (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/backup
|  Bed Leveling Wizard (0.2.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_bedlevelingwizard
|  Bed Visualizer (0.1.7) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_bedlevelvisualizer
|  BetterHeaterTimeout (1.1.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_BetterHeaterTimeout
|  BLTouch Plugin (0.3.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_BLTouch
|  Core Wizard (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/corewizard
|  Cost Plugin (0.1.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_cost
| !CuraEngine (<= 15.04) (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/cura
|  Discovery (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/discovery
|  DisplayLayerProgress Plugin (1.9.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_DisplayLayerProgress
|  EEPROM Marlin Editor Plugin (1.2.1) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_eeprom_marlin
|  Emergency Stop Button (0.1.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_estop
|  Fan Speed Control (0.2.1) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_fanspeedslider
|  Filament Manager (0.5.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_filamentmanager
|  Filament Sensor NG (1.0.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_filamentsensorng
|  FileManager (0.1.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_filemanager
|  Firmware Updater (1.1.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_firmwareupdater
|  Force Login (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/forcelogin
|  Fullscreen Plugin (0.0.4) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_fullscreen
|  Logging (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/logging
|  Navbar Temperature Plugin (0.11) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_navbartemp
| !OctoKlipper (0.2.5) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_klipper
|  Pi Support Plugin (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/pi_support
|  Plugin Manager (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/pluginmanager
|  Preheat Button (0.3.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_preheat
|  Print History Plugin (1.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_printhistory
|  Printer Safety Check (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/printer_safety_check
|  Printer Stats (1.0.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_stats
|  Slic3r (1.1.1) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_slic3r
|  Slicer (1.4.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_slicer
| !SnapStream (0.2.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_snapstream
|  Software Update (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/softwareupdate
|  Telegram Notifications (1.4.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_telegram
|  Tempsgraph Plugin (0.3.3) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_tempsgraph
|  TouchUI (0.3.12) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_touchui
| !Virtual Printer (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/virtual_printer
|  Webcam Tab (0.1.2) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_webcamtab
|  YouTube Live (0.5.0) = /home/pi/oprint/local/lib/python2.7/site-packages/octoprint_youtubelive
2019-02-12 16:11:50,189 - octoprint.environment - INFO - Detected environment is Python 2.7.13 under Linux (linux2). Details:
|  hardware:
|    cores: 4
|    freq: 1400.0
|    ram: 918183936
|  os:
|    id: linux
|    platform: linux2
|  plugins:
|    pi_support:
|      model: Raspberry Pi 3 Model B Plus Rev 1.3
|      octopi_version: 0.15.1
|  python:
|    pip: 19.0.1
|    version: 2.7.13
|    virtualenv: /home/pi/oprint