Public Forums 71,145 posts

[marigny Friend marignyJoin date: April 2008Posts: 68Downloads:0Uploads:0 Thanks: 29 Thanked: 3 times in 1 posts]

#128596

table-Problem with JA Showcase (Joomla Fagus Quickinstall 1.13)

Hi ,

I hope someone can help me with a poblem.

I´ve installed JA Showcase at http://www.onlinepoker.poker-champions.eu

I made 30 items, but the order for all items is “0”. So I can´t reorder them in backend.
At MYSYL database I saw there is only 1 table-item called

jos_2jashowcase

……. but the table-items for my 30 items are missing. Grrrrrr…!!

Can i make this missing tables myself and if “Yes”, how I have to call them?

Best regards :p

Marigny

—————-

79 queries executed

1
SELECT folder, element, published, params
FROM jos_2mambots
WHERE published >= 1
AND access <= 0
AND folder = ‘system’
ORDER BY ordering2
SELECT folder, element, published, params
FROM jos_2mambots
WHERE published >= 1
AND access <= 0
AND folder = ‘sefpatch’
ORDER BY ordering3
SELECT `id`,`link` FROM jos_2menu WHERE `menutype` = ‘mainmenu’ AND `published` > 0 AND `link` LIKE ‘%com_frontpage%’ LIMIT 14
SELECT id FROM jos_2mambots WHERE element = ‘joomsef_metabot’ AND folder = ‘system’ AND published = 15
SELECT * FROM jos_2redirection WHERE oldurl = ” OR oldurl = ‘index.php’ LIMIT 16
SELECT id, link
FROM jos_2menu
WHERE menutype = ‘mainmenu’
AND published = 1
ORDER BY parent, ordering
LIMIT 17
SELECT template
FROM jos_2templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 61 )
ORDER BY menuid DESC
LIMIT 18
DELETE FROM jos_2session
WHERE (
( time < ‘1210916304’ )
AND guest = 0
AND gid > 0
) OR (
( time < ‘1210916304’ )
AND guest = 1
AND userid = 0
)9
SELECT *
FROM jos_2session
WHERE session_id = ‘6321dd4a861cca93bab1967bb0750b46’10
UPDATE jos_2session SET `time`=’1210917204′,`userid`=’0′,`usertype`=”,`us ername`=”,`gid`=’0′,`guest`=’1′ WHERE session_id=’6321dd4a861cca93bab1967bb0750b46’11
SELECT id FROM jos_2mambots WHERE element = ‘joomsef_metabot’ AND folder = ‘system’12
SELECT *
FROM jos_2mambots
WHERE id = ’20’13
SELECT template
FROM jos_2templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 61 )
ORDER BY menuid DESC
LIMIT 114
SELECT *
FROM jos_2menu
WHERE id = 6115
SELECT *
FROM jos_2menu
WHERE id = ’61’16
SELECT count(*) FROM jos_2jashowcase WHERE published=1 AND catid=3717
SELECT *
FROM jos_2jashowcase WHERE published=1 AND catid=37 ORDER BY ordering ASC, id DESC LIMIT 0,2018
SELECT title, id FROM jos_2categories WHERE published=1 AND section=’com_ja_showcase’ ORDER BY ordering ASC19
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_content.xml’20
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=11&task=view’21
SELECT `title` from jos_2content where id = ’11’22
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=9&task=view’23
SELECT `title` from jos_2content where id = ‘9’24
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=45&task=view’25
SELECT `title` from jos_2content where id = ’45’26
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=8&task=view’27
SELECT `title` from jos_2content where id = ‘8’28
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=46&task=view’29
SELECT `title` from jos_2content where id = ’46’30
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=11&task=view’31
SELECT `title` from jos_2content where id = ’11’32
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=14&task=view’33
SELECT `title` from jos_2content where id = ’14’34
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=14&task=view’35
SELECT `title` from jos_2content where id = ’14’36
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=5&task=view’37
SELECT `title` from jos_2content where id = ‘5’38
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=45&task=view’39
SELECT `title` from jos_2content where id = ’45’40
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=1&task=view’41
SELECT `title` from jos_2content where id = ‘1’42
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=47&task=view’43
SELECT `title` from jos_2content where id = ’47’44
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=47&task=view’45
SELECT `title` from jos_2content where id = ’47’46
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_jashowcase.xml’47
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_jashowcase&limit=20&limitsta rt=20’48
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_jashowcase&limit=20&limitsta rt=20’49
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_jashowcase&limit=20&limitsta rt=20’50
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=1&task=section’51
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=7&sectionid=3&tas k=category’52
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=4&task=blogsectio n’53
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_newsfeeds.xml’54
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_newsfeeds’55
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_weblinks.xml’56
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_weblinks’57
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_search.xml’58
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_search’59
SELECT COUNT( id )
FROM jos_2menu
WHERE type = ‘content_item_link’
AND published = 160
SELECT id
FROM jos_2menu
WHERE type = ‘content_item_link’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=49’61
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=49&task=view’62
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=13&task=blogcateg ory’63
SELECT id
FROM jos_2menu
WHERE type = ‘content_item_link’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=13’64
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=13&task=view’65
SELECT id
FROM jos_2menu
WHERE type = ‘content_item_link’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=1’66
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=1&task=view’67
SELECT id, title, module, position, content, showtitle, params
FROM jos_2modules AS m
INNER JOIN jos_2modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 61 )
ORDER BY ordering68
SELECT a.*
FROM jos_2components 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’69
SELECT id
FROM jos_2menu
WHERE link = ‘index.php?option=com_search’
AND published = 170
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
FROM jos_2content AS a
INNER JOIN jos_2categories AS cc ON cc.id = a.catid
INNER JOIN jos_2sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-05-16 07:53’ )
AND (a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-05-16 07:53’ )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering71
SELECT folder, element, published, params
FROM jos_2mambots
WHERE access <= 0
AND folder = ‘content’
ORDER BY ordering72
SELECT id, name, link, parent, type, menutype, access
FROM jos_2menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering73
SELECT m.*
FROM jos_2menu AS m
WHERE menutype = ‘topmenu’
AND published = 1
AND parent = 0
ORDER BY ordering74
SELECT COUNT( id )
FROM jos_2menu
WHERE type = ‘content_typed’
AND published = 175
SELECT id
FROM jos_2menu
WHERE type = ‘content_typed’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=5’76
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=5&task=view’77
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_content&id=1&task=view’78
SELECT *
FROM jos_2sefexts
WHERE file = ‘com_contact.xml’79
SELECT oldurl FROM jos_2redirection WHERE newurl = ‘index.php?option=com_contact’

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#249650

Hi.
Plz send me an account.

1 user says Thank You to Sherlock for this useful post

1. marigny

[marigny Friend marignyJoin date: April 2008Posts: 68Downloads:0Uploads:0 Thanks: 29 Thanked: 3 times in 1 posts]

#249722

Thank you for your help. Send PN to you with account…..:D

[marigny Friend marignyJoin date: April 2008Posts: 68Downloads:0Uploads:0 Thanks: 29 Thanked: 3 times in 1 posts]

#250606

Hallo nguoiabcd,

do you forget me? I send account at 19.05.08, but since 1 week you don´t answer.

Best regards

Marigy

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#250814

Hi.
I have solved HERE

[Author]

Posts