VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: edogden on December 04, 2013, 12:51:53 PM

Title: DB ####_virtuemart_products_en_gb Help
Post by: edogden on December 04, 2013, 12:51:53 PM
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.
Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: GJC Web Design on December 04, 2013, 17:15:23 PM
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?

Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: edogden on December 05, 2013, 11:32:56 AM
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
Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: GJC Web Design on December 05, 2013, 11:46:09 AM
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?
Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: edogden on December 05, 2013, 12:26:07 PM
Yes :)
Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: GJC Web Design on December 05, 2013, 12:49:55 PM
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?

Title: Re: DB ####_virtuemart_products_en_gb Help
Post by: edogden on December 05, 2013, 12:54:42 PM
I had a look for it to didn't find anything.

So what keeps setting back to defaults?