Fragment

[Faulkds]

I'm trying to paste about 200 characters in to a fragment text box.

I'm unable to do this as I get an error saying "string data right truncated"

Any advise would be appreciated

[grantglendinnin]

See here - Actinic's fix is to not use that many characters. Seriously.

[Faulkds]

i didnt think i was using that much to be honest....

This is the text i wanted to put in... - Its also going in to a text field

We are official resellers for Harris Performance Products Ltd and we have the complete 2009 range available. We stock everything from general accessories to frame kits, exhaust systems and much more. Harris products are very well know for their excellence in providing the highest standard parts for both road bikes and racing bikes and we can provide you with all of their products at a price you won’t believe. Have a look through the sub menus within this section to quickly find exactly what you’re after and much more.

[leehack]

Are you putting it in the title or the description field? I have much more than that in fragments and have no problems.

[Faulkds]

Hi Lee,

its just in the text field e.g description... - In the fragment you have a field called text...

I deleted the fragment and recreated it and now get the following message

"an error occured prepairing a product for creation, string data, right truncated"

Also I can't reduce the content length as there would be not point in putting it into the catalog.

I have tried purging and compacting without any success..

[leehack]

Sounds like a database problem to me, support will be the place for that i'm afraid. Might be worth searching on that error message, i have certainly read it a few times on here. There may be a quicker answer than going to support.

[grantglendinnin]

Open your Site folder, then open ActinicCatalog.mdb in Microsoft Access, then Tools > Compact and Repair.

If you ain't got MS Access, you'll need to contact support.

[PatchworkRabbit]

That blurb is 435 characters, so you'd have to lose over half of it.

[Faulkds]

Is there a way of just increasing the field length?

[leehack]

The field length is fine as standard, yours is broken, hence you need to get it fixed, not bandaged up.

[Faulkds]

Mate, actinic support won't be able to fix it....

Im my expereince, they can deal with the basics but this will be way out of their league... So please can i have a plaster ?

[TraceyHand]

Mate, actinic support won't be able to fix it....

Im my expereince, they can deal with the basics but this will be way out of their league... So please can i have a plaster ?

if you moan, whinge and complain long enough and loud enough, get the ticket handed over to someone who CAN fix it.
Trust me, there are people at Actinic Support who can (if it's fixable, that is)
You just have to yell loud enough

[Faulkds]

Thanks Tracey....

I think we dropped out support agreement as we found the forum more helpful. I think the last time I used them I had a database issue and they never really done anything.

[Faulkds]

OK,

What i have done is exported my catalog to file....

Deleted the access database and replaced it with the original...

All is now fine...

Problem is now ive lost all my catalog settings e.g term and conditions, payment methods etc.

Is there a way of exporting the catalog details with out the product details from the database.

I dont want to have to re enter all the details

[Faulkds]

Can anyone advise what I can do to rebuild my catalog?

I have emailed logged a call with actinic but dont hold much hope...