I have a problem with Model longer than 12 digits

[jdelgado]

hi,

After I uploaded (using EasyPopulate) a list of 330 books to my OSC site, I'm using for Model number a code that in Spain is called ISBN code and it is a unique number every book comes with.

I think it is also used in many other countries.

This code is 13 digits long, but after the upload I realised that it had been cut to the first 12 digits only.

 

Is it because OSC has a predefined length of 12 digits for the Model number?

Can I change that number?

Where is variable set?

 

If not, where do you think my problem may come from?

 

Thanks in advance.

[gogowanda]

got the same problem, i'm listening...

[Guest]

You would change it in the MySQL database. products_model is currently varchar(12). If you edit the database (e.g. with phpMyAdmin), you can change the variable to 13.

 

Good luck,

Matt

[jdelgado]

Oh, you were right!

 

I modified the DB using PHPMyAdmin and uploaded again my list of books and it now works great.

 

Thanks so much!

[iamkim]

hmmm... i don't see where to change the model var from the admin panel in OSCommerce.. do I need another program?

[rockgremlin]

I just barely posted about this same problem. I want to change the number of variables that can be entered in the Products Model, but do I need another program to do this? :'(

[Jack_mcs]

hmmm...  i don't see where to change the model var from the admin panel in OSCommerce.. do I need another program?

<{POST_SNAPBACK}>

As mentioned, you need to use the phpmyadmin program to edit the database. That is not reachable via your sites admin section. You generally need to go to your hosts panel. The program is usually located there.

 

Jack

[Birky]

As mentioned, you need to use the phpmyadmin program to edit the database. That is not reachable via your sites admin section. You generally need to go to your hosts panel. The program is usually located there.

 

Jack

<{POST_SNAPBACK}>

 

Hi

 

I've been looking in phpmyadmin but, can't seem to locate the products_module section that was mentioned earlier in the sql db.....can anyone enlighten me as to where this section is so that I can change it from 12?

 

TIA

[Jack_mcs]

You need to select your database. Then in the left column, select the products table. On the right side, you will see products_model as one of the fields. Edit that to change its size.

 

Jack

[Birky]

You need to select your database. Then in the left column, select the products table. On the right side, you will see products_model as one of the fields. Edit that to change its size.

 

Jack

<{POST_SNAPBACK}>

 

Thanks Jack..found it :thumbsup:

[Birky]

Thanks Jack..found it :thumbsup:

[bitter-girl.com]

I have 3-digit model numbers and yet I'm still getting this error! Any ideas?

 

Thanks!

[bitter-girl.com]

Also -- just checked via phpmyadmin -- it was 12, as you'd all said -- I changed it to 30, tried to upload the EasyPopulate file again..... same error!

[Jack_mcs]

Did you also change the size in the admin/easypopulate.ph file? They have to match.

 

Jack

[bitter-girl.com]

Did you also change the size in the admin/easypopulate.ph file? They have to match.

 

Jack

<{POST_SNAPBACK}>

 

Hi Jack -- downloaded easypopulate.php and found the location in the file where the error text comes from, but not where to change that number. Am I totally overlooking something? Thanks.

[♥Vger]

admin/easypopulate.php

-----------------------------

 

//**** Size of products_model in products table ****
// set this to the size of your model number field in the db.  We check to make sure all models are no longer than this value.
// this prevents the database from getting fubared.  Just making this number bigger won't help your database!  They must match!
global $modelsize;
$modelsize = 100;

 

Vger