category error

[Paulw01]

Hi there,

Ive imported 320 subcategories via csv, and category id 310 - named "Blessid Union" does not display due to an error. No idea whats causing it, is the id number 310 assigned elsewhere within presta shop ?
Ive checked spelling, uppercase / lowercase, font type in the csv and cannot work out why this one subcategory will not create itself?
Any ideas welcome !
thanks
PAul

[Patric]

You are certainly using PS version 1.1 or older. In these versions, there is a blacklist of forbidden words (for security reasons). "union" belongs to this list.

[Paulw01]

ok, many thanks for that information, Is there a way I can still use that name by modifying it somehow ? Or do I need to upgrade software ?

[Patric]

Until version 1.1 (included) the only way to use one of these forbidden words was to remove it from the blacklist in the file :

classes/Db.php

private static $_blacklist = 'UNION|LOAD_FILE|OUTFILE|DUMPFILE|ESCAPED|TERMINATED|CASCADE|INFILE|X509|TRIGGER|REVOKE';

But given that this list has been created for security reasons, this is at your own risks !

Else, you can wait for the 1.2 final release, which won't contain this blacklist anymore. But we can give you no deadline for this release.

[Paulw01]

ok, thanks, will try and modify the category name somehow with spelling or characters. Just need to keep some relevance to name for customers to search. (I have approx 3000 products ready to upload with extra 12000 at some point so have lots of different names for subcategories !

Thank you.