View unanswered posts | View active topics
|
Page 1 of 1
|
[ 3 posts ] |
|
| Author |
Message |
|
hfraser
|
Post subject: product_attributes module problem Posted: Tue Apr 26, 2011 1:41 am |
|
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 |
|
 |
|
mangosteen
|
Post subject: Re: product_attributes module problem Posted: Wed Apr 27, 2011 10:01 am |
|
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 |
|
 |
|
hfraser
|
Post subject: Re: product_attributes module problem Posted: Wed Apr 27, 2011 2:39 pm |
|
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 |
|
 |
|
Page 1 of 1
|
[ 3 posts ] |
|
|
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
|