Menu Content

Support

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

Joomsef 3.8.2 does not include section name on URL
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). 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
  • 2

TOPIC: Joomsef 3.8.2 does not include section name on URL

Joomsef 3.8.2 does not include section name on URL 12 years, 6 months ago #24036

Hi there,

my paid Joomsef 3.8.2 does not include section names on URLs and i can not find the any option
to enable it as it was on the older version i used

can anyone help me? It is very important to keep the same urls on my website

thanks in advance
The topic has been locked.

Re: Joomsef 3.8.2 does not include section name on URL 12 years, 6 months ago #24041

  • fiba
  • OFFLINE
  • Posts: 75
Did you look to Manage Extensions->Content and here to Show section option?
The topic has been locked.

Re: Joomsef 3.8.2 does not include section name on URL 12 years, 6 months ago #24047

i found it thanks!!!

BUT

when i tried to save i have the following error

500 - An error has occurred.

TableExtension::store failed - Unknown column 'filters' in 'field list' SQL=UPDATE `jos_sefexts` SET `id`='4',`title`='',`filters`='',`params`='pagination=0\nmultipagetitles=1\nguessId=0\ncompatibility=0\nshow_category=1\nshow_section=1\ntitle_alias=global\ncategory_alias=global\nsection_alias=global\nadd_layout=2\ndef_layout=default\ngooglenewsnum=0\ndigits=3\ndateformat=ddmm\niddatesep=\niddateorder=0\nnumberpos=1\nmeta_titlecat=0\nmeta_desc=1\ndesc_len=150\nmeta_keys=1\nkeys_minlen=3\nkeys_count=8\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=2\nitemid=0\noverrideId=\nignoreItemids=\nuseSitename=1\ncustomSitename=\npageLimit=\nhandling=0\nshowMenuTitle=1\ncustomMenuTitle=\ncustomNonSef=\nstopRule=\ndownloadId=\nacceptVars=\nacceptStrict=0\nvarFilterFail=
The topic has been locked.

Re: Joomsef 3.8.2 does not include section name on URL 12 years, 6 months ago #24048

  • fiba
  • OFFLINE
  • Posts: 75
It seems, that in your database is missing this column. Open your PHPMyAdmin and paste this query:
ALTER TABLE jos_sefexts ADD (`filters` text);
or send me on email Diese E-Mail-Adresse ist gegen Spambots geschützt! Du musst JavaScript aktivieren, damit Du sie sehen kannst. credentials to your database and I will add this column to your database.
The topic has been locked.

Joomsef 4 & J2.5.4 "Main Menu" not accessible 11 years, 11 months ago #29292

  • ekk
  • OFFLINE
  • Posts: 11
Hi,

I cannot display menu items in Administrator panel ( "Main Menu"), instead the following error msg is displayed:


500 - Unknown error

Table 'usermain_defusr.main_associations' doesn't exist SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,COUNT(asso2.id)>1 as association,e.name AS name FROM `main_menu` AS a LEFT JOIN `main_languages` AS l ON l.lang_code = a.language LEFT JOIN `main_users` AS u ON u.id = a.checked_out LEFT JOIN `main_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN main_viewlevels AS ag ON ag.id = a.access LEFT JOIN main_associations AS asso ON asso.id = a.id AND asso.context='com_menus.item' LEFT JOIN main_associations AS asso2 ON asso2.key = asso.key LEFT JOIN main_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' GROUP BY a.id ORDER BY a.lft asc Table 'usermain_defusr.main_associations' doesn't exist SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,COUNT(asso2.id)>1 as association,e.name AS name FROM `main_menu` AS a LEFT JOIN `main_languages` AS l ON l.lang_code = a.language LEFT JOIN `main_users` AS u ON u.id = a.checked_out LEFT JOIN `main_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN main_viewlevels AS ag ON ag.id = a.access LEFT JOIN main_associations AS asso ON asso.id = a.id AND asso.context='com_menus.item' LEFT JOIN main_associations AS asso2 ON asso2.key = asso.key LEFT JOIN main_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' GROUP BY a.id ORDER BY a.lft asc LIMIT 0, 100 Table 'usermain_defusr.main_associations' doesn't exist SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,COUNT(asso2.id)>1 as association,e.name AS name FROM `main_menu` AS a LEFT JOIN `main_languages` AS l ON l.lang_code = a.language LEFT JOIN `main_users` AS u ON u.id = a.checked_out LEFT JOIN `main_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN main_viewlevels AS ag ON ag.id = a.access LEFT JOIN main_associations AS asso ON asso.id = a.id AND asso.context='com_menus.item' LEFT JOIN main_associations AS asso2 ON asso2.key = asso.key LEFT JOIN main_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' GROUP BY a.id ORDER BY a.lft asc
The topic has been locked.

Re: Joomsef 4 & J2.5.4 "Main Menu" not accessible 11 years, 11 months ago #29297

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,
I don't think this SQL comes from JoomSEF. As the error says, you are probably missing the main_associations table in your database.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
  • 2
User Login Empty