- I upgraded from CB 1.0 to 1.1 all seemes fine,
- Follow the read me to the letter...
- All works except site links
- All Data present

---but the links on the front page of site does not work???---

it links to nothing 404

In the Admin panel all is present and so I went through and clicked pubish again, but that doesnt active the links to -- News, Link and any page. Anything is acounted for not sure, I am just scratching my head...

Any ideas???

Thanks in advance

Ray

the site Im working on is

SingleDesire.com

Ok - an update that I have found... at
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,42731/catid,41/

After reading this topic I found that my SEF was toggled on. And yes when I toggle it off that links begain to work again...

But with a side effect.

After loging in and scrool to the bottom of the pages there were scrings of inquiry...

For Example -

32 queries executed
1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering

---

2
SELECT id, link
FROM jos_menu
WHERE menutype = 'mainmenu'
AND published = 1
ORDER BY parent, ordering
LIMIT 1

---

3
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1

---

4
DELETE FROM jos_session
WHERE (
( time < '1189210940' )
AND guest = 0
AND gid > 0
) OR (
( time < '1189210940' )
AND guest = 1
AND userid = 0
)

---

5
SELECT *
FROM jos_session
WHERE session_id = '7d3f52c3f95b27f9e7b9f95b50ce32d5'

---

6
UPDATE jos_session SET `time`='1189211840',`userid`='62',`usertype`='Super Administrator',`username`='desire',`gid`='2',`guest`='0' WHERE session_id='7d3f52c3f95b27f9e7b9f95b50ce32d5'

---

7
SELECT id, name, email, block, sendEmail, registerDate, lastvisitDate, activation, params
FROM jos_users
WHERE id = 62

---

8
SELECT *
FROM jos_menu
WHERE id = 1

---

9
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-07 19:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-07 19:37' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 2
AND s.access <= 2
AND cc.access <= 2

---

10
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-07 19:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-07 19:37' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 2
AND s.access <= 2
AND cc.access <= 2
ORDER BY f.ordering
LIMIT 4

---

11
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 2
AND folder = 'content'
ORDER BY ordering

---

12
SELECT params
FROM jos_mambots
WHERE element = 'mosimage'
AND folder = 'content'

---

13
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'

---

14
SELECT m.id
FROM jos_modules AS m
WHERE m.module = 'mod_rssfeed'
AND m.published = 1

---

15
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering

---

16
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 2
AND parent = 0
ORDER BY ordering

---

17
SELECT guest, usertype
FROM jos_session

---

18
SELECT DISTINCT a.username, a.userid, u.name
FROM jos_session AS a, jos_users AS u
WHERE (a.userid=u.id) AND (a.guest = 0) AND (NOT ( a.usertype is NULL OR a.usertype = '' ))
ORDER BY a.username ASC

---

19
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 2
ORDER BY parent, ordering

---

20
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'usermenu'
AND published = 1
AND access <= 2
ORDER BY parent, ordering

---

21
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1

---

22
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-07 19:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-07 19:37' )
AND a.access <= 2 AND cc.access <= 2 AND s.access <= 2
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 5

---

23
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 19
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

24
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0

---

25
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 18
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

26
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 17
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 16
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 15
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

29
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-07 19:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-07 19:37' )
AND a.access <= 2 AND cc.access <= 2 AND s.access <= 2
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 5

---

30
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 1
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

31
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 13
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

---

32
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 2
ORDER BY menutype, parent, ordering



========Dont think this is good==========