Just an update on this shf404 issue i am having, I noticed another field in the database that was different, it is the language one on items, a new one adds * the imported ones do not have anything, so I added a * on a test old imported item and it works!!!!!!!!
The next thing to figure out, how to run a Query on 1500+ items to add * into a blank field
May have to check the categories as well
HELP:
I tried to run these Queries -
UPDATE `jos_k2_items` SET language = * WHERE language = NULL
UPDATE `jos_k2_items` SET language = * WHERE language = IS NULL
UPDATE `jos_k2_items` SET language = * WHERE language = NONE
and get the same syntax error, trying to find out more
The language field on the imported items has nothing inside so i used NULL, also tried leaving that blank and adding 0, what is the terminology you use for a blank field database query?
UPDATE:
Found the Query, big learning curve, added the following on k2 items and k2 categories
UPDATE `jos_k2_items` SET language = "*" WHERE language = ""
UPDATE `jos_k2_categories` SET language = "*" WHERE language = ""
My SHF404 Now seems to work with the imported 1500+ k2 in items and categories, hope this helps others
Paul
Happy as a pig in s*** at the minute