MySQL errors

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
Tinman
Posts: 19
Joined: Sun May 09, 2010 3:34 pm

MySQL errors

Post by Tinman » Sun May 09, 2010 3:43 pm

I've somehow managed to install Ubuntu, learn the basics of command line, modify files using nano, modify apache2 files, install and create a DB with phpmysql.... which has brought me to this list of sql errors.

A little push in the right direction on addressing these issues would be appreciated.

DEBUG INFORMATION:
/phpMyFAQ/phpmyfaq/inc/Init.php:
PMF_Configuration->getAll() in line 103:

SELECT
config_name, config_value
FROM
mbcfaqconfig


/phpMyFAQ/phpmyfaq/index.php:
PMF_Session->checkSessionId() in line 205:

SELECT
sid
FROM
mbcfaqsessions
WHERE
sid = 2
AND
ip = '192.168.1.104'
AND
time > 1273328859


/phpMyFAQ/phpmyfaq/index.php:
PMF_Session->checkSessionId() in line 205:

UPDATE
mbcfaqsessions
SET
time = 1273415259,
user_id = -1
WHERE
sid = 2
AND ip = '192.168.1.104'


/phpMyFAQ/phpmyfaq/index.php:
PMF_Category_Tree_DataProvider_SingleQuery->__construct() in line 251:

SELECT
fc.id AS id,
fc.lang AS lang,
fc.parent_id AS parent_id,
fc.name AS name,
fc.description AS description,
fc.user_id AS user_id
FROM
mbcfaqcategories fc
WHERE
1=1
AND
fc.lang = 'en'
ORDER BY fc.id


/phpMyFAQ/phpmyfaq/index.php:
PMF_Tags->existTagRelations() in line 382:

SELECT
COUNT(record_id) AS n
FROM
mbcfaqdata_tags


/phpMyFAQ/phpmyfaq/inc/Faq.php:
PMF_Faq->getStickyRecordsData() in line 2299:

SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
mbcfaqdata fd
LEFT JOIN
mbcfaqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
mbcfaqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
mbcfaqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20100509162739'
AND
fd.date_end >= '20100509162739'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND
( fdg.group_id IN (-1)
OR
(fdu.user_id = -1 AND fdg.group_id IN (-1)))

Thorsten
Posts: 14731
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: MySQL errors

Post by Thorsten » Sun May 09, 2010 3:51 pm

Hi,

you have the DEBUG log enabled. You can turn it off by deactivating it in inc/Init.php.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply