lat9 / dbio

Database Input/Output for Zen Cart
GNU General Public License v3.0
3 stars 1 forks source link

DbIoHandler.php does not handle fieldtype as longtext #192

Closed torvista closed 2 years ago

torvista commented 3 years ago

I was getting this error on my site but not on vanilla ZC157/8.

✗ importGetHeader: Unknown datatype (longtext) for products_description::products_description on line #1 ✗ importGetHeader: Unknown datatype (longtext) for products_description::products_description on line #1 ✗ importGetHeader: Unknown datatype (longtext) for meta_tags_products_description::metatags_keywords on line #1 ✗ importGetHeader: Unknown datatype (longtext) for meta_tags_products_description::metatags_description on line #1 ✗ importGetHeader: Unknown datatype (longtext) for meta_tags_products_description::metatags_keywords on line #1 ✗ importGetHeader: Unknown datatype (longtext) for meta_tags_products_description::metatags_description on line #1

I discovered that on my site the products description, metatag keywords and metatag descriptions were all of type longtext. Don't know when or why that happened, but it seems that the switchcase that handles this around 711 should have longtext added. Although anything that actually required longtext would not be an a csv! I think I'll be changing these fields back to text anyway.

case 'char':
case 'text':
case 'varchar':
case 'mediumtext':
case 'longtext':

I note the error messages seem to be duplicated but that would be for the dual-language import, so they are missing the _en , _es identifier, I think.