openerp-india team mailing list archive

[Vishnu S <vishnu.cepit@xxxxxxxxx>]

** Description changed:

  Hi,
  
-     I tried to restore a database and it worked fine if the database did not contain complex constraints(foreign key  relationships ).But when i tried to restore a db having complex constraints,it always produces an error 'object.object' not found.
- The same i tried in ubuntu 11.10 and it worked perfectly.
- Please see the error message generated
- PS:The table which i am trying to restore containing a table called 'idea_idea'
- and other tables related to it.
+     I have created my module say 'my_app' which contains few tables with
+ foreign key constraints.This is what i have tried to install it in a
+ different DB.
  
- OpenERP version-openerp-allinone-setup-6.0-20120217-r3584(2)
- PostgreSQL version - 8.3
+ I have a table called 'idea_idea' and other related tables.
+ 
+ 1)Created a new database say 'demo_db'
+ 2)logged into OpenERP for this db
+ 3)copied my module to 'addons' folder
+ 4)updated module list
+ 5)applied scheduled upgrades to the module.
+ 
+ This is what i got
  
  Environment Information : 
  System : Windows-Vista-6.1.7601-SP1
  OS Name : nt
  Operating System Release : Vista
  Operating System Version : 6.1.7601
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.3
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "netsvc.pyo", line 489, in dispatch
    File "service\web_services.pyo", line 599, in dispatch
    File "osv\osv.pyo", line 122, in wrapper
    File "osv\osv.pyo", line 176, in execute
    File "osv\osv.pyo", line 167, in execute_cr
    File "C:\Program Files\OpenERP 6.0\Server\addons\base\module\wizard\base_module_upgrade.py", line 98, in upgrade_module
    File "pooler.pyo", line 60, in restart_pool
    File "pooler.pyo", line 39, in get_db_and_pool
    File "addons\__init__.pyo", line 883, in load_modules
    File "addons\__init__.pyo", line 719, in load_module_graph
    File "addons\__init__.pyo", line 414, in init_module_objects
    File "osv\orm.pyo", line 2693, in _auto_init
    File "sql_db.pyo", line 78, in wrapper
    File "sql_db.pyo", line 131, in execute
  ProgrammingError: relation "idea_idea" does not exist
+ 
+ 
+ I have tried it in both windows 7 and ubuntu and came across with 
+ the same problem.
+ 
+ But when i tried to install a module which contains tables
+ with no constraints,the module was installed successfully.

** Description changed:

  Hi,
  
      I have created my module say 'my_app' which contains few tables with
  foreign key constraints.This is what i have tried to install it in a
  different DB.
  
- I have a table called 'idea_idea' and other related tables.
+ I have a table called 'idea_idea' in 'my_app' and other related tables.
  
  1)Created a new database say 'demo_db'
  2)logged into OpenERP for this db
  3)copied my module to 'addons' folder
  4)updated module list
  5)applied scheduled upgrades to the module.
  
  This is what i got
  
- Environment Information : 
+ Environment Information :
  System : Windows-Vista-6.1.7601-SP1
  OS Name : nt
  Operating System Release : Vista
  Operating System Version : 6.1.7601
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.3
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
-   File "netsvc.pyo", line 489, in dispatch
-   File "service\web_services.pyo", line 599, in dispatch
-   File "osv\osv.pyo", line 122, in wrapper
-   File "osv\osv.pyo", line 176, in execute
-   File "osv\osv.pyo", line 167, in execute_cr
-   File "C:\Program Files\OpenERP 6.0\Server\addons\base\module\wizard\base_module_upgrade.py", line 98, in upgrade_module
-   File "pooler.pyo", line 60, in restart_pool
-   File "pooler.pyo", line 39, in get_db_and_pool
-   File "addons\__init__.pyo", line 883, in load_modules
-   File "addons\__init__.pyo", line 719, in load_module_graph
-   File "addons\__init__.pyo", line 414, in init_module_objects
-   File "osv\orm.pyo", line 2693, in _auto_init
-   File "sql_db.pyo", line 78, in wrapper
-   File "sql_db.pyo", line 131, in execute
+   File "netsvc.pyo", line 489, in dispatch
+   File "service\web_services.pyo", line 599, in dispatch
+   File "osv\osv.pyo", line 122, in wrapper
+   File "osv\osv.pyo", line 176, in execute
+   File "osv\osv.pyo", line 167, in execute_cr
+   File "C:\Program Files\OpenERP 6.0\Server\addons\base\module\wizard\base_module_upgrade.py", line 98, in upgrade_module
+   File "pooler.pyo", line 60, in restart_pool
+   File "pooler.pyo", line 39, in get_db_and_pool
+   File "addons\__init__.pyo", line 883, in load_modules
+   File "addons\__init__.pyo", line 719, in load_module_graph
+   File "addons\__init__.pyo", line 414, in init_module_objects
+   File "osv\orm.pyo", line 2693, in _auto_init
+   File "sql_db.pyo", line 78, in wrapper
+   File "sql_db.pyo", line 131, in execute
  ProgrammingError: relation "idea_idea" does not exist
  
- 
- I have tried it in both windows 7 and ubuntu and came across with 
+ I have tried it in both windows 7 and ubuntu and came across with
  the same problem.
  
  But when i tried to install a module which contains tables
  with no constraints,the module was installed successfully.

** Description changed:

  Hi,
  
      I have created my module say 'my_app' which contains few tables with
  foreign key constraints.This is what i have tried to install it in a
  different DB.
  
  I have a table called 'idea_idea' in 'my_app' and other related tables.
  
  1)Created a new database say 'demo_db'
  2)logged into OpenERP for this db
  3)copied my module to 'addons' folder
  4)updated module list
  5)applied scheduled upgrades to the module.
  
  This is what i got
  
  Environment Information :
  System : Windows-Vista-6.1.7601-SP1
  OS Name : nt
  Operating System Release : Vista
  Operating System Version : 6.1.7601
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.3
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "netsvc.pyo", line 489, in dispatch
    File "service\web_services.pyo", line 599, in dispatch
    File "osv\osv.pyo", line 122, in wrapper
    File "osv\osv.pyo", line 176, in execute
    File "osv\osv.pyo", line 167, in execute_cr
    File "C:\Program Files\OpenERP 6.0\Server\addons\base\module\wizard\base_module_upgrade.py", line 98, in upgrade_module
    File "pooler.pyo", line 60, in restart_pool
    File "pooler.pyo", line 39, in get_db_and_pool
    File "addons\__init__.pyo", line 883, in load_modules
    File "addons\__init__.pyo", line 719, in load_module_graph
    File "addons\__init__.pyo", line 414, in init_module_objects
    File "osv\orm.pyo", line 2693, in _auto_init
    File "sql_db.pyo", line 78, in wrapper
    File "sql_db.pyo", line 131, in execute
  ProgrammingError: relation "idea_idea" does not exist
  
  I have tried it in both windows 7 and ubuntu and came across with
  the same problem.
  
  But when i tried to install a module which contains tables
  with no constraints,the module was installed successfully.
+ 
+ OpenERP version - openerp-allinone-setup-6.0-20120217-r3584(2)
+ Ubuntu -11.10
+ Postgres -8.3

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/936931

Title:
  ""Database restore issue with windows7 ""

Status in OpenERP Server:
  New

Bug description:
  Hi,

      I have created my module say 'my_app' which contains few tables
  with foreign key constraints.This is what i have tried to install it
  in a different DB.

  I have a table called 'idea_idea' in 'my_app' and other related
  tables.

  1)Created a new database say 'demo_db'
  2)logged into OpenERP for this db
  3)copied my module to 'addons' folder
  4)updated module list
  5)applied scheduled upgrades to the module.

  This is what i got

  Environment Information :
  System : Windows-Vista-6.1.7601-SP1
  OS Name : nt
  Operating System Release : Vista
  Operating System Version : 6.1.7601
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.3
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "netsvc.pyo", line 489, in dispatch
    File "service\web_services.pyo", line 599, in dispatch
    File "osv\osv.pyo", line 122, in wrapper
    File "osv\osv.pyo", line 176, in execute
    File "osv\osv.pyo", line 167, in execute_cr
    File "C:\Program Files\OpenERP 6.0\Server\addons\base\module\wizard\base_module_upgrade.py", line 98, in upgrade_module
    File "pooler.pyo", line 60, in restart_pool
    File "pooler.pyo", line 39, in get_db_and_pool
    File "addons\__init__.pyo", line 883, in load_modules
    File "addons\__init__.pyo", line 719, in load_module_graph
    File "addons\__init__.pyo", line 414, in init_module_objects
    File "osv\orm.pyo", line 2693, in _auto_init
    File "sql_db.pyo", line 78, in wrapper
    File "sql_db.pyo", line 131, in execute
  ProgrammingError: relation "idea_idea" does not exist

  I have tried it in both windows 7 and ubuntu and came across with
  the same problem.

  But when i tried to install a module which contains tables
  with no constraints,the module was installed successfully.

  OpenERP version - openerp-allinone-setup-6.0-20120217-r3584(2)
  Ubuntu -11.10
  Postgres -8.3

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/936931/+subscriptions