Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
'externalLink' value exceeds maximum field size Small Hitch

 
 


floodrod
User

Oct 24, 2006, 7:38 AM

Post #1 of 7 (4991 views)
Shortcut
'externalLink' value exceeds maximum field size Small Hitch Can't Post
got bout 4-5k articles, switched to sql, everythings in place.

Can't get thru transfer of articles due to 'externalLink' value exceeds maximum field size of 255

Sounds like some of my outside links exceed 255 characters. How and where do I go to adjust that field size to allow publishing to continue?

Thanks


Dave
Staff / Moderator


Oct 24, 2006, 10:30 AM

Post #2 of 7 (4982 views)
Shortcut
Re: [floodrod] 'externalLink' value exceeds maximum field size Small Hitch [In reply to] Can't Post
Hi Floodrod,

It's right here:

Admin > Database Editor > Articles Table > externalLink > Stored As

And change that from 'string' to 'memo'.

Hope that helps, let me know if I can provide more details for you or you need anything else.

Dave Edis - Senior Developer
interactivetools.com
 


terr@M
User

Sep 11, 2009, 2:28 PM

Post #3 of 7 (4490 views)
Shortcut
'externalLink' changed to stored as memo but reverts back [In reply to] Can't Post
Reviving this old thread because I am having the same problem, and while I tried the suggested fix (changing the "stored as" option to memo), for some reason the database option reverts from memo back to string, so I can't get the upgrade script to complete because it'll encounter a 255+ string and throw an error.

I thought permissions might be the culprit, so I went back over everything and as far as the files and folders specified, they are as specified in the setup documentation.

*Something* is causing the field to revert to a 255 string in the AM CMS as well as the SQL database.

Two questions:
What else can I look at?
Assuming I can get the memo field type to 'stick', is there any problem leaving it that way? This client often needs to use the field for some very long URLs and as rapidly as they need to put out numerous articles early every morning they can't realistically be expected to use a URL shortener.

Please help. Frown
::
[b]teresa[/b]
[url "http://www.thesimplerweb.com"]www.thesimplerweb.com[/url]

(This post was edited by terr@M on Sep 14, 2009, 10:38 AM)


Donna
Staff / Moderator


Sep 14, 2009, 11:29 AM

Post #4 of 7 (4450 views)
Shortcut
Re: [terr@M] 'externalLink' changed to stored as memo but reverts back [In reply to] Can't Post
Hi there,

Hmm, I think at this point we'll get you to toss us a support request so we can take a look at this directly for you. You can fill this out here:

https://www.interactivetools.com/support/email_support.cgi

Donna

--
support@interactivetools.com


terr@M
User

Sep 14, 2009, 12:31 PM

Post #5 of 7 (4449 views)
Shortcut
Re: [Donna] 'externalLink' changed to stored as memo but reverts back [In reply to] Can't Post
Thanks, Donna. Will head over & fill out the support request.

After more troubleshooting I can say that the 'stored as' type is definitely reset after I run the upgrade script.
::
[b]teresa[/b]
[url "http://www.thesimplerweb.com"]www.thesimplerweb.com[/url]

(This post was edited by terr@M on Sep 14, 2009, 1:02 PM)


terr@M
User

Sep 15, 2009, 2:32 PM

Post #6 of 7 (4431 views)
Shortcut
Re: [terr@M] 'externalLink' changed to stored as memo but reverts back [In reply to] Can't Post
I think I got it. This is probably undocumented or not recommended, but it worked. Please tell me if it's dangerous Sly

I searched the AM interface files and scripts for references to the externalLink field. One I found in a file called From141.pm seemed to set the data's stored as type to string. So I changed it to memo there, then ran the upgrade script. Voila - it ran, completed & gave me the congratulations message. All ~35K articles appear to have been transferred.

So, is there a possibility that the edit I made would cause problems elsewhere?
::
[b]teresa[/b]
[url "http://www.thesimplerweb.com"]www.thesimplerweb.com[/url]


Donna
Staff / Moderator


Sep 16, 2009, 9:51 AM

Post #7 of 7 (4378 views)
Shortcut
Re: [terr@M] 'externalLink' changed to stored as memo but reverts back [In reply to] Can't Post
Hi there,

Glad to hear that worked for you!

That should probably be fine -- that file *should* only be used during the upgrade. As always, keep a backup, but I think you'll be good to go. :)

Donna

--
support@interactivetools.com