I have just recently installed mySQL 4.1.20 max on a Mac OS X 10.3.9 and when I view my page it has mySQL statements written all over the page. I haven't the slightest clue to what I did wrong since I am new to mySQL. Here is an example of the error...
(mysql): SELECT * FROM mdl_course WHERE id = '1' LIMIT 1
(mysql): SELECT section, id, course, summary, sequence, visible FROM mdl_course_sections WHERE course = '1' ORDER BY section
(mysql): SELECT * FROM mdl_course_categories WHERE parent = '0' ORDER BY sortorder ASC
(mysql): SELECT COUNT(*) FROM mdl_course
(mysql): SELECT c.* ,c.sortorder FROM mdl_course c WHERE c.category = '1' AND c.visible > 0 ORDER BY c.sortorder ASC
(mysql): SELECT * FROM mdl_course WHERE id = '1' LIMIT 1
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '66d39efd283de286c9192281666950b3' AND timemodified > '1150385047' LIMIT 1
(mysql): SELECT * FROM mdl_cache_text WHERE id = '-1'
(mysql): INSERT INTO mdl_cache_text ( MD5KEY, FORMATTEDTEXT, TIMEMODIFIED ) VALUES ( '66d39efd283de286c9192281666950b3', '', 1150385107 )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM mdl_event WHERE timestart + timeduration >= 1149120000 AND timestart <= 1151711999 AND ( (groupid = 0 AND courseid IN (1))) AND visible = 1 ORDER BY timestart
This is written on the page along with the regular contents of the page. It is very confusing to me. Please help if you can. TIA.
(mysql): SELECT * FROM mdl_course WHERE id = '1' LIMIT 1
(mysql): SELECT section, id, course, summary, sequence, visible FROM mdl_course_sections WHERE course = '1' ORDER BY section
(mysql): SELECT * FROM mdl_course_categories WHERE parent = '0' ORDER BY sortorder ASC
(mysql): SELECT COUNT(*) FROM mdl_course
(mysql): SELECT c.* ,c.sortorder FROM mdl_course c WHERE c.category = '1' AND c.visible > 0 ORDER BY c.sortorder ASC
(mysql): SELECT * FROM mdl_course WHERE id = '1' LIMIT 1
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '66d39efd283de286c9192281666950b3' AND timemodified > '1150385047' LIMIT 1
(mysql): SELECT * FROM mdl_cache_text WHERE id = '-1'
(mysql): INSERT INTO mdl_cache_text ( MD5KEY, FORMATTEDTEXT, TIMEMODIFIED ) VALUES ( '66d39efd283de286c9192281666950b3', '', 1150385107 )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM mdl_event WHERE timestart + timeduration >= 1149120000 AND timestart <= 1151711999 AND ( (groupid = 0 AND courseid IN (1))) AND visible = 1 ORDER BY timestart
This is written on the page along with the regular contents of the page. It is very confusing to me. Please help if you can. TIA.