Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Duplicate entry during virtuemart extension upgrad
(1 viewing) (1) Guest
Support forum for customers who have purchased paid JoomSEF extension. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Duplicate entry during virtuemart extension upgrad

Duplicate entry during virtuemart extension upgrad 14 years, 11 months ago #9880

  • mtg
  • OFFLINE
  • Posts: 14
Hi,
I work on j! 1.5, JoomSEF 3.2.11 regged + VirtueMart JoomSEF Extension 2.0.1 regged

I've upgraded successfully the component (3.2.11 -> 3.4.2 -> 3.5.3)
I've regged the component online

I'm trying to upgrade the virtuemart extension (2.0.1) but i've the following error :

error 500
TableExtension::store failed - Duplicate entry '2' for key 1 SQL=UPDATE `jos_sefexts` SET `id`='2',`title`='',`filters`='',`params`='productid=0\nusesku=0\nmanufacturer=0\nmanufacturerid=1\ncategories=2\ncategoryid=0\nfileid=0\nnonsefflypage=0\nignorecats=0\nsefcart=0\nproduct_title=0\ncategory_title=0\ntitle_sep=-\nproduct_desc=0\ncategory_desc=0\nnumberDuplicates=2\nignoreSource=1\nitemid=0\noverrideId=\nuseSitename=1\ncustomSitename=\npageLimit=\nhandling=0\nshowMenuTitle=1\ncustomMenuTitle=\ncustomNonSef=\nacceptVars=\nacceptStrict=0\nstopRule=\nvarFilterFail=0\ndownloadId=key' WHERE file='com_virtuemart.xml'


What should I do?
uninstall the extension?

Best regards
M.
Last Edit: 14 years, 11 months ago by mtg.
The topic has been locked.

Re:Duplicate entry during virtuemart extension upgrad 14 years, 11 months ago #9908

  • mtg
  • OFFLINE
  • Posts: 14
I've solved this issue deleting the variable : `id`='2' from the query

nevertheless, each action in the virtuemart extension configuration use this statement...
Nobody has this error ?

M
The topic has been locked.

Re:Duplicate entry during virtuemart extension upgrad 14 years, 11 months ago #9943

  • jaku
Hello,

it might be related to upgrade from too-old version.
Please, uninstall and reinstall the VM extension completely.
The topic has been locked.

Re:Duplicate entry during virtuemart extension upgrad 14 years, 11 months ago #10089

  • mtg
  • OFFLINE
  • Posts: 14
Thanks Jan,
I've uninstalled VM ext. 2.0.1 then installed 2.0.16 (with artio 3.5.4)
During this step, I lost a lot of my URLs in jos_sefurls, is it normal?
When i try to manage the extension and save my parameters, i've the following error :

TableExtension::store failed - Duplicate entry '2' for key 1 SQL=UPDATE `jos_sefexts` SET `id`='2',`title`='',`filters`='',`params`='productid=0\nusesku=0\nmanufacturer=0\nmanufacturerid=1\ncategories=2\ncategoryid=0\nproducttype=1\nproducttypeid=0\nproducttypeparameter=0\nfileid=0\nnonsefflypage=0\nignorecats=0\nsefcart=0\nproduct_title=0\ncategory_title=0\ntitle_sep=-\nmeta_desc=1\ndesc_len=250\nproduct_desc=2\ncategory_desc=1\nmeta_keys=1\nkeys_minlen=3\nkeys_count=15\nblacklist=a, able, about, above, abroad, according, accordingly, across, actually, adj, after, afterwards, again, against, ago, ahead, ain\'t, all, allow, allows, almost, alone, along, alongside, already, also, although, always, am, amid, amidst, among, amongst, an, and, another, any, anybody, anyhow, anyone, anything, anyway, anyways, anywhere, apart, appear, appreciate, appropriate, are, aren\'t, around, as, a\'s, aside, ask, asking, associated, at, available, away, awfully, b, back, backward, backwards, be, became, because, become, becomes, becoming, been, before, beforehand, begin, behind, being, believe, below, beside, besides, best, better, between, beyond, both, brief, but, by, c, came, can, cannot, cant, can\'t, caption, cause, causes, certain, certainly, changes, clearly, c\'mon, co, co., com, come, comes, concerning, consequently, consider, considering, contain, containing, contains, corresponding, could, couldn\'t, course, c\'s, currently, d, dare, daren\'t, definitely, described, despite, did, didn\'t, different, directly, do, does, doesn\'t, doing, done, don\'t, down, downwards, during, e, each, edu, eg, eight, eighty, either, else, elsewhere, end, ending, enough, entirely, especially, et, etc, even, ever, evermore, every, everybody, everyone, everything, everywhere, ex, exactly, example, except, f, fairly, far, farther, few, fewer, fifth, first, five, followed, following, follows, for, forever, former, formerly, forth, forward, found, four, from, further, furthermore, g, get, gets, getting, given, gives, go, goes, going, gone, got, gotten, greetings, h, had, hadn\'t, half, happens, hardly, has, hasn\'t, have, haven\'t, having, he, he\'d, he\'ll, hello, help, , hence, her, here, hereafter, hereby, herein, here\'s, hereupon, hers, herself, he\'s, hi, him, himself, his, hither, hopefully, how, howbeit, however, hundred, i, i\'d, ie, if, ignored, i\'ll, i\'m, immediate, in, inasmuch, inc, inc., indeed, indicate, indicated, indicates, inner, inside, insofar, instead, into, inward, is, isn\'t, it, it\'d, it\'ll, its, it\'s, itself, i\'ve, j, just, k, keep, keeps, kept, know, known, knows, l, last, lately, later, latter, latterly, least, less, lest, let, let\'s, like, liked, likely, likewise, little, look, looking, looks, low, lower, ltd, m, made, mainly, make, makes, many, may, maybe, mayn\'t, me, mean, meantime, meanwhile, merely, might, mightn\'t, mine, minus, miss, more, moreover, most, mostly, mr, mrs, much, must, mustn\'t, my, myself, n, name, namely, nd, near, nearly, necessary, need, needn\'t, needs, neither, never, neverf, neverless, nevertheless, new, next, nine, ninety, no, nobody, non, none, nonetheless, noone, no-one, nor, normally, not, nothing, notwithstanding, novel, now, nowhere, o, obviously, of, off, often, oh, ok, okay, old, on, once, one, ones, one\'s, only, onto, opposite, or, other, others, otherwise, ought, oughtn\'t, our, ours, ourselves, out, outside, over, overall, own, p, particular, particularly, past, per, perhaps, placed, please, plus, possible, presumably, probably, provided, provides, q, que, quite, qv, r, rather, rd, re, really, reasonably, recent, recently, regarding, regardless, regards, relatively, respectively, right, round, s, said, same, saw, say, saying, says, second, secondly, , see, seeing, seem, seemed, seeming, seems, seen, self, selves, sensible, sent, serious, seriously, seven, several, shall, shan\'t, she, she\'d, she\'ll, she\'s, should, shouldn\'t, since, six, so, some, somebody, someday, somehow, someone, something, sometime, sometimes, somewhat, somewhere, soon, sorry, specified, specify, specifying, still, sub, such, sup, sure, t, take, taken, taking, tell, tends, th, than, thank, thanks, thanx, that, that\'ll, thats, that\'s, that\'ve, the, their, theirs, them, themselves, then, thence, there, thereafter, thereby, there\'d, therefore, therein, there\'ll, there\'re, theres, there\'s, thereupon, there\'ve, these, they, they\'d, they\'ll, they\'re, they\'ve, thing, things, think, third, thirty, this, thorough, thoroughly, those, though, three, through, throughout, thru, thus, till, to, together, too, took, toward, towards, tried, tries, truly, try, trying, t\'s, twice, two, u, un, under, underneath, undoing, unfortunately, unless, unlike, unlikely, until, unto, up, upon, upwards, us, use, used, useful, uses, using, usually, v, value, various, versus, very, via, viz, vs, w, want, wants, was, wasn\'t, way, we, we\'d, welcome, well, we\'ll, went, were, we\'re, weren\'t, we\'ve, what, whatever, what\'ll, what\'s, what\'ve, when, whence, whenever, where, whereafter, whereas, whereby, wherein, where\'s, whereupon, wherever, whether, which, whichever, while, whilst, whither, who, who\'d, whoever, whole, who\'ll, whom, whomever, who\'s, whose, why, will, willing, wish, with, within, without, wonder, won\'t, would, wouldn\'t, x, y, yes, yet, you, you\'d, you\'ll, your, you\'re, yours, yourself, yourselves, you\'ve, z, zero\nnumberDuplicates=2\nautoCanonical=2\nignoreSource=1\nitemid=0\noverrideId=\nuseSitename=1\ncustomSitename=\npageLimit=\nhandling=0\nshowMenuTitle=1\ncustomMenuTitle=\ncustomNonSef=\nacceptVars=\nacceptStrict=0\nstopRule=\nvarFilterFail=0\ndownloadId=key' WHERE file='com_virtuemart.xml'


Am I the only one having this error ?

Regards

EDIT :
I've deleted manually two duplicates com_virtuemart.xml in jos_sefexts
Now, I can apply my settings
Last Edit: 14 years, 11 months ago by mtg.
The topic has been locked.

Re:Duplicate entry during virtuemart extension upgrad 14 years, 11 months ago #10153

  • jaku
Hello,

ok, you did right as regards deleting the duplicate settings in table.
As regards "loosing" URLs -- it is not "normal", but it could have occured, if someone accessed your site in meantime when you had the original VM extension uninstalled and before you installed the new one.
The topic has been locked.
  • Page:
  • 1
User Login Empty