Author Archive

List of English stop words

Stop words are basically words that should not be indexed in a search. This is because these words are commonly used and most likely will not provide search results that will be helpful to the user. The following is a list of English stop words that I have used:

a’s, able, about, above, according, accordingly, across, actually, after, afterwards, again, against, ain’t, all, allow, allows, almost, alone, along, already, also, although, always, am, among, amongst, an, and, another, any, anybody, anyhow, anyone, anything, anyway, anyways, anywhere, apart, appear, appreciate, appropriate, are, aren’t, around, as, aside, ask, asking, associated, at, available, away, awfully, be, became, because, become, becomes, becoming, been, before, beforehand, behind, being, believe, below, beside, besides, best, better, between, beyond, both, brief, but, by, c’mon, c’s, came, can, can’t, cannot, cant, cause, causes, certain, certainly, changes, clearly, co, com, come, comes, concerning, consequently, consider, considering, contain, containing, contains, corresponding, could, couldn’t, course, currently, definitely, described, despite, did, didn’t, different, do, does, doesn’t, doing, don’t, done, down, downwards, during, each, edu, eg, eight, either, else, elsewhere, enough, entirely, especially, et, etc, even, ever, every, everybody, everyone, everything, everywhere, ex, exactly, example, except, far, few, fifth, first, five, followed, following, follows, for, former, formerly, forth, four, from, further, furthermore, get, gets, getting, given, gives, go, goes, going, gone, got, gotten, greetings, had, hadn’t, happens, hardly, has, hasn’t, have, haven’t, having, he, he’s, hello, help, hence, her, here, here’s, hereafter, hereby, herein, hereupon, hers, herself, hi, him, himself, his, hither, hopefully, how, howbeit, however, i’d, i’ll, i’m, i’ve, ie, if, ignored, immediate, in, inasmuch, inc, indeed, indicate, indicated, indicates, inner, insofar, instead, into, inward, is, isn’t, it, it’d, it’ll, it’s, its, itself, just, keep, keeps, kept, know, knows, known, last, lately, later, latter, latterly, least, less, lest, let, let’s, like, liked, likely, little, look, looking, looks, ltd, mainly, many, may, maybe, me, mean, meanwhile, merely, might, more, moreover, most, mostly, much, must, my, myself, name, namely, nd, near, nearly, necessary, need, needs, neither, never, nevertheless, new, next, nine, no, nobody, non, none, noone, nor, normally, not, nothing, novel, now, nowhere, obviously, of, off, often, oh, ok, okay, old, on, once, one, ones, only, onto, or, other, others, otherwise, ought, our, ours, ourselves, out, outside, over, overall, own, particular, particularly, per, perhaps, placed, please, plus, possible, presumably, probably, provides, que, quite, qv, rather, rd, re, really, reasonably, regarding, regardless, regards, relatively, respectively, right, said, same, saw, say, saying, says, second, secondly, see, seeing, seem, seemed, seeming, seems, seen, self, selves, sensible, sent, serious, seriously, seven, several, shall, she, should, shouldn’t, since, six, so, some, somebody, somehow, someone, something, sometime, sometimes, somewhat, somewhere, soon, sorry, specified, specify, specifying, still, sub, such, sup, sure, t’s, take, taken, tell, tends, th, than, thank, thanks, thanx, that, that’s, thats, the, their, theirs, them, themselves, then, thence, there, there’s, thereafter, thereby, therefore, therein, theres, thereupon, these, they, they’d, they’ll, they’re, they’ve, think, third, this, thorough, thoroughly, those, though, three, through, throughout, thru, thus, to, together, too, took, toward, towards, tried, tries, truly, try, trying, twice, two, un, under, unfortunately, unless, unlikely, until, unto, up, upon, us, use, used, useful, uses, using, usually, value, various, very, via, viz, vs, want, wants, was, wasn’t, way, we, we’d, we’ll, we’re, we’ve, welcome, well, went, were, weren’t, what, what’s, whatever, when, whence, whenever, where, where’s, whereafter, whereas, whereby, wherein, whereupon, wherever, whether, which, while, whither, who, who’s, whoever, whole, whom, whose, why, will, willing, wish, with, within, without, won’t, wonder, would, would, wouldn’t, yes, yet, you, you’d, you’ll, you’re, you’ve, your, yours, yourself, yourselves, zero

Have fun!

MySQL database restoration error

So I was trying to restore a backup database from a .sql file through the following command:

mysql database < file.sql

And an error resulted:

Got a packet bigger than ‘max_allowed_packet’ bytes

This is most likely due to the fact that there are large images and other files in the database causing problems. I had to edit the MySQL configuration files and added the following:

vim /etc/my.cnf

set-variable=max_allowed_packet=xM

For my particular issue, I had to change x to 512. This may vary depending on how large your files are.

Microsoft Dynamics CRM 4.0 woe part 2

Microsoft Dynamics CRM, this is truly a beast of a software. Installation is often a hit or miss based on what is currently installed on the PC.

Recently I had to install CRM onto a PC plagued with problems. There were updates for Windows, software half installed and remaining files from previously installed software. To add to that the PC was at a remote location and required a VPN connection back to the main office. Refer to my other posting to see how that was resolved.

Thinking that I had resolved the problem, I had left the user to the PC – boy was I wrong. CRM did not like the fact that I had previously logged into that PC with my account (when I was foolishly testing it). Basically, the CRM checks if there is already an user installed into the SQL server and if there is, CRM will not allow another user. Attempting to resolve this by removing the data proved to be a futile effort. I basically had to uninstall everything including CRM and the SQL Server to allow the user to register himself on Outlook with the CRM plugin.

Hopefully, this time around, the issue is finally laid to rest!

WordPress for Blackberry

Boy-o-boy, how things have changed since I first started using WP! Seems like you can now do any and everything with your phone now!

Well, this is just a test post to see how this works. If all is well, I will post more from my BB!

CRM 4.0 Dynamics woe

Working on another PC, I am came across issues with CRM. Basically, it would not install due to the fact that that I was installing the ‘offline version’. The only thing that showed up on the install was:

Microsoft SQL Server 2005 Express Edition (CRM) – Installation Failed

With no hints at hand, I had to search around to see what was wrong. The CRM installation was less than helpful as it did not provide any further details regarding this error. However, an eureka moment occurred! Could this be the same error I was receiving with the massive Windows Updates failures I was trying to deal with last week?

So, I took a stab to look through the list of programs installed and sure enough, MSXML6 was installed. Previously, Microsoft SQL Server updates were failing because MSXML6 update was installed, the removal of this patch allowed the Microsoft SQL Server to install properly.

Happily I thought I could just remove it and reinstall, but of course, there had to be a catch! Simply clicking remove from the Add / Remove Programs (in Control Panel) did nothing – uninstall failed. Argh! So back to the drawing board!

After more research, it turns out that this is a not an uncommon problem for programs to not uninstall properly. Microsoft has even created a tool to remedy this!

Windows Installer CleanUp Utility

After installing the tool, removing MSXML6, I was able to continue with the install of CRM! Got the user to log in, setup the CRM settings to point to the correct server location and off we go!

Another issue resolved…

Virtualization part 3

To finish this journey, I will conclude that we have decided to not upgrade the servers at this point in time. There was really not much changes that we found useful or beneficial at all. So I just downloaded the latest files from VMware and installed the latest vSphere 4 directly from those files. It worked right away after that.

So the lesson of the day is… have the latest and greatest!

Virtualization part 2

Continuing on the theme of Virtualization, I tried to maintain our VMs via vSphere 4, however I quickly found that vSphere will not run on Windows 7 still! Seems like we need to update to the latest patch with a newer version of the vSphere client. I’ll have to wait another day before I can test and verify this though. Onward to more W7 problems!

VMware Conversion & Virtualization

So… I finally got the chance to update to Windows 7 and test out its new features to be able to provide support! However, I need to be able to access my old OS and any of the items in it. Since we were planning on supporting the Virtualization of PCs in the future as well, I thought to test it out on my PC.

Everything went smoothly except for one thing, there was an error:

FAILED: Unable to find the system volume, reconfiguration is not possible.

After some research, it turns out that the VMware vCenter Converter does not like any missing or irregular autoexec.bat, config.sys or boot.ini files. More specifically for me was the boot.ini as I had already installed Windows 7 in a dual boot mode. So I changed the boot.ini to:

boot loader
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
operating systems
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS=”Windows XP Professional, Standard” /fastdetect

Everything worked out fine after that. Now I’m happily using Windows 7 and running my XP programs and other items at the same time. True XP compatibilty mode!