EasyPopulate 4.0 Support Thread

[rosrooster]

How do you change the database field lengths? I keep getting these errors
WARNING! - Model: SPST8116A - Products name: "17 GATOR ORANGE REAR TAILLIGHT SPST8116A " exceeds max. length: 21.333333333333
SKIPPED! - Model: SPST8116A - Category name: "Power Wheels and Ride on parts" exceeds max. length: 10.666666666667

[rosrooster]

this is what it says on my admin page
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
but on the database the char limits are much higher than that

[rosrooster]

I got it figured out. Its in the easypopulate2.php in the admin folder the values were divided by 3

[chadderuski]

I got it figured out. Its in the easypopulate2.php in the admin folder the values were divided by 3

Did you install zencart 1.5 with iso-8859 or utf8?

UTF8 is multibyte... and you need to divide by 3 to get character count. However, if your store is set UTF8 and your databases are iso-8859 it may be confusing the script.

[Bigjohnjps]

this is what it says on my admin page
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
but on the database the char limits are much higher than that

I am receiving the same error. On the right side it shows:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB CharSet: DB_CHARSET

Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333

Running Easy Populate 4.0.20 - Beta 5-20-2012
on Zencart 1.3.8

I do not have a easypopulate2.php file as referenced in a previous post.
How can I increase this limit?

thanks!

[chadderuski]

I am receiving the same error. On the right side it shows:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB CharSet: DB_CHARSET

Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333

Running Easy Populate 4.0.20 - Beta 5-20-2012
on Zencart 1.3.8

I do not have a easypopulate2.php file as referenced in a previous post.
How can I increase this limit?

thanks!

"easypopulate2.php" was posted in error. This file does not exist.

Your problem is that your Database Character Set is not defined, i.e. DB_CHARSET
Since you are on zencart 1.38, I'm assuming that your are using collation: latin1_general_ci

Since EP doen't know what character set is correct, it is assuming UTF8, and dividing your field length by 3 (necessary for multi-byte character encoding).

Open easypopulate_4.php and go to about line 126. You'll see a number of variables with "/3" ... just remove this block of code.

I'll work on a better way to check for collation. I believe this was fixed in 1.39, and 1.5 uses UTF8 by default.
You should consider upgrading ... 1.38 is getting QUITE old.

-chadd