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
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