It is currently Tue May 22, 2012 10:59 pm

All times are UTC + 2 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: product_attributes module problem
PostPosted: Tue Apr 26, 2011 1:41 am 
Offline

Joined: Tue Apr 26, 2011 1:31 am
Posts: 2
I've added the product_modules addon, and created an attribute called wheel-size. This created a problem viewing products because the SQL generated interprets the "-" as a subtract, resulting in an error dialog box saying there's no field called "size". I've removed the product_attributes module, but the problem persists.

Is there a shortcut to removing the remnants of the module, or do I have to create a new database. I do have a lot of products, etc. defined, and would rather not reload everything.


Top
 Profile  
 
 Post subject: Re: product_attributes module problem
PostPosted: Wed Apr 27, 2011 10:01 am 
Offline

Joined: Mon Jan 03, 2011 2:35 pm
Posts: 19
you should use wheel_size instead of wheel-size (note the underscore), as "-" is not allowed for PostgreSQL column name.

I suggest you use a PostgreSQL adm intool (e.g. pgAdmin III) to drop the column and reload the module. You might need to restart OpenERP with option -d <your module name> to restart/reload the DB tables.


Top
 Profile  
 
 Post subject: Re: product_attributes module problem
PostPosted: Wed Apr 27, 2011 2:39 pm 
Offline

Joined: Tue Apr 26, 2011 1:31 am
Posts: 2
Thanks. The "-" character isn't invalid in a column name, but there are consequences as I found. I was hoping to find out a) what table is the column defined in, and b) is it referenced in any other tables that need to be cleaned up.

I did remove the module, hoping that would help. But even with it removed, the remnants remain and I can no longer view products.

I'll pass a message on to the developer of the module to do some up-front checks to prevent anyone from defining an attribute with an embedded "-".


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP