Advertisement
mugs

ProgrammingError: syntax error at or near "FROM"

Jan 19th, 2015
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 4.04 KB | None | 0 0
  1. 2015-01-16 11:43:41,364 9907 ERROR springFresh openerp.sql_db: Programming error: syntax error at or near "FROM"
  2. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
  3.                     ^
  4. , in query
  5.             INSERT INTO mrp_bom_line_mrp_property_rel
  6.                 (mrp_bom_line_id, mrp_property_id)
  7.                 VALUES(%s, bom_rel.mrp_property_id)
  8.             FROM mrp_bom_mrp_property_rel bom_rel
  9.             WHERE bom_rel.mrp_bom_id = %s
  10.            
  11. 2015-01-16 11:43:41,365 9907 ERROR springFresh OpenUpgrade: mrp: error in migration script /home/mugo/dev/odoo-venv/OpenUpgrade/addons/mrp/migrations/8.0.1.1/post-migrate.py: syntax error at or near "FROM"
  12. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
  13.                     ^
  14.  
  15. 2015-01-16 11:43:41,365 9907 ERROR springFresh OpenUpgrade: syntax error at or near "FROM"
  16. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
  17.                     ^
  18. Traceback (most recent call last):
  19.   File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/openupgrade/openupgrade.py", line 724, in wrapped_function
  20.     func(cr, version)
  21.   File "/home/mugo/dev/odoo-venv/OpenUpgrade/addons/mrp/migrations/8.0.1.1/post-migrate.py", line 206, in migrate
  22.     migrate_bom_lines(cr, pool)
  23.   File "/home/mugo/dev/odoo-venv/OpenUpgrade/addons/mrp/migrations/8.0.1.1/post-migrate.py", line 83, in migrate_bom_lines
  24.     """, (bom_line_id, row['id']))
  25.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/sql_db.py", line 158, in wrapper
  26.    return f(self, *args, **kwargs)
  27.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/sql_db.py", line 234, in execute
  28.    res = self._obj.execute(query, params)
  29. ProgrammingError: syntax error at or near "FROM"
  30. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
  31.                    ^
  32.  
  33. 2015-01-16 11:43:41,367 9907 ERROR springFresh openerp.modules.loading: Error executing post migration script for module mrp
  34. : syntax error at or near "FROM"
  35. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
  36.                    ^
  37.  
  38. 2015-01-16 11:43:41,368 9907 CRITICAL springFresh openerp.service.server: Failed to initialize database `springFresh`.
  39. Traceback (most recent call last):
  40.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/service/server.py", line 901, in preload_registries
  41.    registry = RegistryManager.new(dbname, update_module=update_module)
  42.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/modules/registry.py", line 324, in new
  43.    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  44.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/modules/loading.py", line 398, in load_modules
  45.    force, status, report, loaded_modules, update_module, upg_registry)
  46.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/modules/loading.py", line 295, in load_marked_modules
  47.    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks, upg_registry=upg_registry)
  48.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/modules/loading.py", line 215, in load_module_graph
  49.    migrations.migrate_module(package, 'post')
  50.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/modules/migration.py", line 179, in migrate_module
  51.    mod.migrate(self.cr, pkg.installed_version)
  52.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/openupgrade/openupgrade.py", line 724, in wrapped_function
  53.    func(cr, version)
  54.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/addons/mrp/migrations/8.0.1.1/post-migrate.py", line 206, in migrate
  55.    migrate_bom_lines(cr, pool)
  56.  File "/home/mugo/dev/odoo-venv/OpenUpgrade/addons/mrp/migrations/8.0.1.1/post-migrate.py", line 83, in migrate_bom_lines
  57.    """, (bom_line_id, row['id']))
  58.   File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/sql_db.py", line 158, in wrapper
  59.     return f(self, *args, **kwargs)
  60.   File "/home/mugo/dev/odoo-venv/OpenUpgrade/openerp/sql_db.py", line 234, in execute
  61.     res = self._obj.execute(query, params)
  62. ProgrammingError: syntax error at or near "FROM"
  63. LINE 5:             FROM mrp_bom_mrp_property_rel bom_rel
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement