DB ####_virtuemart_products_en_gb Help

[edogden]

Hello,

I am trying to find the file that sets the ####_virtuemart_products_en_gb table and creates the product_name structure row.

I would like to change the char type to text so it can be bigger by default

If I do this in the DB virtueMart resets it to default values when I add a new product.

Thanks for anyones help.

[GJC Web Design]

just change it directly in the DB with phpmyadmin etc

at the mo it is     product_name   char(180)

or do you mean when you run the install?

[edogden]

Hi,

At the moment I am manually changing it in the DB to text
but as I said when I add a product in the back end VM changes it back to char(180)
So it must be set from a file but which file?

Thanks

[GJC Web Design]

but if the db field IN THE TABLE is set to char(180) it will shorten it to 180 charactors

of are you saying u change it to varchar (2000) in the DB table and a script changes it back?

[edogden]

Yes

[GJC Web Design]

did a quick search of all instances of product_name in the admin files - see no code that would do this

why would they bother? why run a sql script on every product save?

[edogden]

I had a look for it to didn't find anything.

So what keeps setting back to defaults?