Cannot Create Entry

dweiss · Post by **dweiss** » Mon Feb 27, 2006 2:26 am

I can't seem to add FAQs (questions and answers) from the admistrative control panel. I choose create entry, enter the question and the answer and hit save - but then it gives me a page titled "Administration of Records" and the message: "An error occured."

What's going on here?

If I add my question under a user ID and then fill in the answer as the administrator, sometimes that works, but it still gives me the error above in some cases.

The program was fantasically easy to install, so I think it is installed correctly. FWIW, I'm running the system on Apache 2.2, MySQL 5 and PHP 5.

I'd appreciate any help you can provide.

Thanks,

Post by **Thorsten** » Mon Feb 27, 2006 7:29 am

Hi,

do you have choosed a category?

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 7:40 am

Yes, I've got a category specified.

Post by **Thorsten** » Mon Feb 27, 2006 8:30 am

Hi,

please enable the debug mode in inc/init.php and try it again. Please post the queries and errors you'll get here.

Thanks!

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 8:58 am

Here is what I get from the control panel after logging in as Admin, which is followed (after the row of *****) by what I'm getting when I just try to go to the main page as an ordinary user.

Just in case, my configuration is PHP 5.x, MySql 5.x, and Apache 2.2 all on windows 2000.

Thanks,

-Danny.

phpMyFAQ Information
Visits
4
Articles
5
Comments
0
Open questions
1
System Information
phpMyFAQ Version
phpMyFAQ 1.5.6
Server Software
Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.1
PHP Version
PHP 5.1.1
Register Globals
off
Safe Mode
off
Database Client Version
5.0.18
Database Server Version
5.0.18-nt
Webserver Interface
APACHE2HANDLER
Online Version Information

DEBUG INFORMATION:

DELETE FROM faqadminsessions WHERE time < 1141025086
SELECT id, name, realname, email, pass, rights FROM faquser WHERE name = 'admin' AND pass = '9a0f7361daa8027b9831fbf875810661'
SELECT uin FROM faqadminsessions WHERE uin = 'ee1338ae0e94d29143f0a1104946d4af'
INSERT INTO faqadminsessions (uin, time, ip, usr, pass) VALUES ('ee1338ae0e94d29143f0a1104946d4af',1141026886,'192.168.2.40','admin','9a0f7361daa8027b9831fbf875810661')
SHOW TABLE STATUS

*********************************************************

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Notice: strtotime() [function.strtotime]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 153

Notice: date() [function.date]: Timezone setting (date.timezone) or TZ environment variable contains an unknown timezone in C:\xampp\xampp\htdocs\phpmyfaq\inc\functions.php on line 155

Danny's phpMyFAQ
Contact Help Open questions Ask question Add content Search
Navigation
Home
Show all categories
Membership
Sitemap

Search

change language Arabic Basque Chinese (Simplified) Chinese (Traditional) Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Indonesian Italian Japanese Korean Latvian Norwegian BokmÃ¥l Polish Portuguese Romanian Russian Serbian Slovenian Spanish Swedish Turkish Vietnamese

1 Users online TOP 10
6 views:
What are the different classes of membership in the ...
4 views:
What are the different classes of membership in the ...
3 views:
What is the annual cost for a Regular membership? ...
The five questions posted most recently:
What is the annual cost for a Regular membership? ... (2006-02-27 00:50)
What are the different classes of membership in the ... (2006-02-27 00:19)
What are the different classes of membership in the ... (2006-02-27 00:19)
Danny's phpMyFAQ News
No news is good news.
There are 3 records online

powered by phpMyFAQ 1.5.6

DEBUG INFORMATION:
SELECT id, lang, parent_id, name, description FROM faqcategories WHERE lang = 'en' ORDER BY id
SELECT count(sid) FROM faqsessions WHERE time > 1141026502 GROUP BY ip
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqdata.thema AS thema, faqcategoryrelations.category_id AS category_id, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqvisits.visits DESC
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqcategoryrelations.category_id AS category_id, faqdata.thema AS thema, faqdata.datum AS datum, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqdata.datum DESC

Post by **Thorsten** » Mon Feb 27, 2006 9:01 am

Hi,

thanks a lot. Is it possible to get the queries when you try to add a record?

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 9:06 am

How would I do that?

-Danny.

Post by **Thorsten** » Mon Feb 27, 2006 9:11 am

Hi,

just login into the admin panel and try to add a record.

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 9:22 am

Is this what you need?:

Administration of Records
An error occured.

DEBUG INFORMATION:

DELETE FROM faqadminsessions WHERE time < 1141026704
SELECT usr, pass FROM faqadminsessions WHERE uin = '0a104f8a2cb3c987571962a7582c3aca'
UPDATE faqadminsessions SET time = 1141028504 WHERE uin = '0a104f8a2cb3c987571962a7582c3aca'
SELECT id, name, realname, email, pass, rights FROM faquser WHERE name = 'admin' AND pass = '9a0f7361daa8027b9831fbf875810661'

Post by **Thorsten** » Mon Feb 27, 2006 9:28 am

Hi,

right.

This error message occurs if you have no category selected and no title for the entry entered. Is that your problem?

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 9:33 am

Thorsten -

Well, that could depend on what we mean by selected. I'm about to feel like an idiot. Would you mean that if I only have a single category and I want to add a question/answer, then I have to click on the category name in the upper box so that it is highlighted before I do the entry of the question and answer?

If that's what you mean, then perhaps we've solved this and it was user error (isn't it always!). I'm going to take out the debug command and see what happens. While you clarify the above.

-Danny.

Post by **Thorsten** » Mon Feb 27, 2006 9:41 am

Hi,

right. You have to click on one or more categories and enter a title for the FAQ record.

bye
Thorsten

dweiss · Post by **dweiss** » Mon Feb 27, 2006 9:44 am

Thorsten -

Yep, that did it. Sorry for being such a dunce. I could blame on on the fact that I'm here typing at almost 4 AM, but the fact is it just didn't occur to me that I had to select the category if I had only created one category.

Thank you very much for helping me through this. It's a nice piece of software and I'm hoping I can put it to good use.

Post by **Thorsten** » Mon Feb 27, 2006 9:45 am

Hi,

no problem.

bye
Thorsten