exceeds max. length: 64 ?? How to fix?

I know I saw the answer for this somewhere here before, but I cannot find it now, and have not seen it in the manual yet though it may be in there. I did buy the E-book now.

I am running Zencart 151 and Easy Populate 4

With the CSV file I get from the distributor some of the Item titles are over 64 characters long I think is what the problem is. I'm sure I saw how to change the setting in Zencart to allow more than 64 limit and I think I did that on my online store before, but now I need to do it with my local PC store so I can create the product lists local and test, then I'll export them as CSV and import them to the online store.

WARNING! - Model: BKCRUSM - Products name: "Rocky Mountain Hides™ Solid Genuine Cowhide Leather Cruiser Jacket" exceeds max. length: 64

So I get this as a title, "Rocky Mountain Hides™ Solid Genuine Cowhide Leather Cruise"

I think changing the setting from 64 to about 75 or 80 should fix all 614 items.

My new store is https://www.Gearedtoride.com but I don't have these items online yet I need to fix.

Go to phpMyAdmin and find your database ...

Now adjust the tables:
products_name
orders_products

and adjust the field size for:
products_name

to something like 96 ...

NOTE: Be sure to do both tables ...

Thanks!

That got me down from 612 warnings to only 32 now. LOL
I'll edit those 32 if I need them.

Help, I crashed my site!

Does Zencart need the password to use the database? I did change that!
If it does need the new password how/where would I put it since I can not get into anything for the store now?

I made a backup of the database, then went in to change those product settings from 64 to 96 as mentioned.
I had already done that on the local PC store with no problems, so now I was doing the online store the same.
Now I cannot get into my store at all, not admin or the store front!
I did restore the DB backup I made just before I made changes, that made no difference! I still can't get in!

The only thing I can think of off hand is I changed the password for the database because I forgot what it was, and what I had wrote down did not work.

I found part of my answer, yes on the password so that is probably the problem I have.
But I have not found how to provide the new password to the Zencart yet.

Zencart 151

I found it and fixed it.
Sorry, I got in a bit of panic when I broke it!

Just had to edit both config.php files to change the database password, now things seem to be working again.

Be aware that 32-bit xp may truncate the length of filenames to 64 chars.

Thanks.
I forgot about that perhaps, but the file names are not long, it's the title in the CSV file that is too long.

Bikerstuff:

Help, I crashed my site!

Does Zencart need the password to use the database? I did change that!
If it does need the new password how/where would I put it since I can not get into anything for the store now?

I made a backup of the database, then went in to change those product settings from 64 to 96 as mentioned.
I had already done that on the local PC store with no problems, so now I was doing the online store the same.
Now I cannot get into my store at all, not admin or the store front!
I did restore the DB backup I made just before I made changes, that made no difference! I still can't get in!

The only thing I can think of off hand is I changed the password for the database because I forgot what it was, and what I had wrote down did not work.

I realize that this issue has been addressed as described above and seems to have been corrected within a fairly short time of identifying that the problem existed. Just wanted to say/add that assistance might have been gained faster if a new thread (in the sheer panic) had been started. I think I mayhave seen how the posts in this thread had been increasing; however, I hadn't read it until now. Hopefully that type of problem doesn't happen agaain, :) but I wanted to point out that assistance is more likely to be provided on a topic that is titled something related to that topic. Certainly an update "back" at the original location is helpful, even if just a link to the other thread.

For what it's worth, glad you figured it out and got it fixed.

Thanks.

I think I had posted here though because the second problem happened when I tried to fix the first.
Local database for test store and online store datadase are not the same and I was not sure if I had messed up something else or my database.