Members: 16,996
Threads: 38,846
Posts: 159,391
Online: 23

Newest Member: Kl_broka@rediffmail.com


Odoo.tv - Outdoor Television


Sedo - Domains kaufen und verkaufen das Projekt mambers.com steht zum Verkauf Besucherstatistiken von mambers.com etracker® Web-Controlling statt Logfile-Analyse

Go Back   Mambers.com > Mambo 4.5.1 > Mambo 4.5.1 Bugs

Reply
 
LinkBack Thread Tools Display Modes
Old 11.03.2005, 12:57   #1 (permalink)
Baby Mamber
 
Join Date: Mar 2005
Posts: 2
Thev is on a distinguished road
Default Database code displayed on website - any ideas

Any one help with working out what the problem can be that has produced this code on my website at http://www.voscur.org/cvs/

I'm fairly new to Mambo and I'm not experienced at PHP or Mysql...but any pointers would be great to debug this error.

Thanks in advance
Thev



42 queries executed
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'--------------------------------------------------------------------------------2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='77' LIMIT 1--------------------------------------------------------------------------------3
DELETE FROM mos_session
WHERE (time < 1110536847)--------------------------------------------------------------------------------4
SELECT * FROM mos_session WHERE session_id='c842ee35e1f7a8115b894cf13bc224f4'--------------------------------------------------------------------------------5
UPDATE mos_session SET `time`='1110537747',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1' WHERE session_id='c842ee35e1f7a8115b894cf13bc224f4'--------------------------------------------------------------------------------6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering--------------------------------------------------------------------------------7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering--------------------------------------------------------------------------------8
SELECT access FROM mos_menu WHERE id='77'--------------------------------------------------------------------------------9
SELECT * FROM mos_menu WHERE id='77'--------------------------------------------------------------------------------10
SELECT * FROM mos_sections WHERE id='10'--------------------------------------------------------------------------------11
SELECT a.*, COUNT( b.id ) AS numitems
FROM mos_categories AS a
LEFT JOIN mos_content AS b ON b.catid = a.id AND b.state = '1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2005-03-11 10:42:27' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2005-03-11 10:42:27' )
WHERE a.section = '10' AND a.published = '1'
AND a.access <= '0'
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering--------------------------------------------------------------------------------12
SELECT name FROM mos_sections WHERE id=10--------------------------------------------------------------------------------13
SELECT name FROM mos_categories WHERE id=141--------------------------------------------------------------------------------14
SELECT name FROM mos_sections WHERE id=10--------------------------------------------------------------------------------15
SELECT name FROM mos_categories WHERE id=114--------------------------------------------------------------------------------16
SELECT id FROM mos_mambots WHERE element = 'tinymce' AND folder = 'editors'--------------------------------------------------------------------------------17
SELECT * FROM mos_mambots WHERE id='10'--------------------------------------------------------------------------------18
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '77' OR mm.menuid = '0')
ORDER BY ordering--------------------------------------------------------------------------------19
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenumenu_style' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering--------------------------------------------------------------------------------20
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1--------------------------------------------------------------------------------21
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering--------------------------------------------------------------------------------22
SELECT m.* FROM mos_menu AS m
WHERE menutype='MainMenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering--------------------------------------------------------------------------------23
SELECT name FROM mos_sections WHERE id=10--------------------------------------------------------------------------------24
SELECT name FROM mos_sections WHERE id=10--------------------------------------------------------------------------------25
SELECT name FROM mos_categories WHERE id=141--------------------------------------------------------------------------------26
SELECT name FROM mos_sections WHERE id=16--------------------------------------------------------------------------------27
SELECT name FROM mos_sections WHERE id=4--------------------------------------------------------------------------------28
SELECT name FROM mos_sections WHERE id=9--------------------------------------------------------------------------------29
SELECT name FROM mos_sections WHERE id=7--------------------------------------------------------------------------------30
SELECT name FROM mos_sections WHERE id=1--------------------------------------------------------------------------------31
SELECT name FROM mos_sections WHERE id=6--------------------------------------------------------------------------------32
SELECT name FROM mos_sections WHERE id=3--------------------------------------------------------------------------------33
SELECT name FROM mos_sections WHERE id=18--------------------------------------------------------------------------------34
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=18 0'--------------------------------------------------------------------------------35
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=18 0'--------------------------------------------------------------------------------36
SELECT i.title AS item_title, c.name AS category_name, s.name AS section_name FROM mos_content AS i LEFT JOIN mos_categories AS c ON i.catid=c.id LEFT JOIN mos_sections AS s ON c.section=s.id WHERE i.id=180--------------------------------------------------------------------------------37
SELECT name FROM mos_sections WHERE id=12--------------------------------------------------------------------------------38
SELECT name FROM mos_sections WHERE id=21--------------------------------------------------------------------------------39
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1--------------------------------------------------------------------------------40
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 1,1--------------------------------------------------------------------------------41
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='2'--------------------------------------------------------------------------------42
SELECT name FROM mos_banner WHERE bid=2--------------------------------------------------------------------------------
Thev is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 11.03.2005, 13:50   #2 (permalink)
Junior Mamber
 
Join Date: Feb 2005
Posts: 26
shadoe is on a distinguished road
Default Re: Database code displayed on website - any ideas

Turn off debug in configuration and it will probably disappear. I turned debugging on and it appeared
shadoe is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 11.03.2005, 18:41   #3 (permalink)
Baby Mamber
 
Join Date: Mar 2005
Posts: 2
Thev is on a distinguished road
Default Re: Database code displayed on website - any ideas

Nice one, did the trick. i must of checked it when i was trying to sort another problem out.

Many thanks, Thev
Thev is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need ideas to create a searchable talent database??? aly Development Discussions 6 28.03.2005 20:45
Calling data from a database in a Content Item BobDonut Mambo 4.5.1 'How Do I' Questions 1 25.02.2005 18:30
Component/Module/Bot code checker initiative active6 Mambo 4.5 Security 5 06.02.2005 06:53
Database connections fuelinjection Mambo 4.5.1 'How Do I' Questions 0 17.10.2004 16:26
Establishing a MySQL database kippwinger Mambo 4.5.1 Installation and Upgrades 2 20.08.2004 09:17


All times are GMT +2. The time now is 08:38.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0
A vBSkinworks Design
© Copyright 2004-2008 by Arthur Konze Webdesign.