Bug auf der Adminoberfläche?

[tabbit]

Hallo,

wenn ich mich auf der Adminoberfläche anmelde, kommt in meiner neuen FAQ-Datenbank folgende Meldung:

phpMyFAQ Information

→ Visits

phpMyFAQ notice [8]: Undefined index: CC_faqsessions in index.php on line 333
→ Articles

phpMyFAQ notice [8]: Undefined index: CC_faqdata in index.php on line 335
→ Comments

phpMyFAQ notice [8]: Undefined index: CC_faqcomments in index.php on line 337
→ Open questions

phpMyFAQ notice [8]: Undefined index: CC_faqquestions in index.php on line 339

Es handelt sich dabei um die neueste Version von phpmyfaq (heute erst runtergeladen) mit MySQL Datenbank dahinter...

Vielen Dank,
Tobias

[Thorsten]

Hi,

hast du phpMyAdmin installiert? Wenn ja, dann führe mal bitte auf der DB, in der phpMyFAQ installiert ist, das folgende SQL Query aus:

Code: Select all

SHOW TABLE STATUS

Danke!

bye
Thorsten

[tabbit]

Hallöle,

alles klar, hier ist der Output - ich hoffe, man kann was erkennen - ich habe die Standardsetup-PHP Seite genommen, um die Datenbank einrichten zu lassen...

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 424
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use phpmyfaq;
Database changed
mysql> show table status;
+------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation |Checksum | Create_options | Comment |
+------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------+
| cc_faqadminlog | InnoDB | 10 | Compact | 17 | 963 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqattachment | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqattachment_file | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcaptcha | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcategories | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcategory_group | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcategory_user | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcategoryrelations | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqchanges | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqcomments | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqconfig | InnoDB | 10 | Compact | 45 | 364 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqdata | MyISAM | 10 | Dynamic | 4 | 1323 | 5292 | 281474976710655 | 7168 | 0 | NULL | 2010-08-20 10:56:32 | 2010-08-23 12:11:55 | NULL | utf8_general_ci | NULL | | |
| cc_faqdata_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqdata_revisions | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqdata_tags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqdata_user | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqglossary | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqgroup | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqgroup_right | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqlinkverifyrules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqnews | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqquestions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqright | InnoDB | 10 | Compact | 33 | 496 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqsearches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqsessions | InnoDB | 10 | Compact | 26 | 630 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqstopwords | InnoDB | 10 | Compact | 3331 | 44 | 147456 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqtags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faquser | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 32768 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faquser_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:33 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faquser_right | InnoDB | 10 | Compact | 66 | 248 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:33 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faquserdata | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faquserlogin | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:32 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqvisits | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:33 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| cc_faqvoting | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 10:56:33 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqadminlog | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:18 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqattachment | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:18 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqattachment_file | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:18 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcaptcha | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:18 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcategories | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcategory_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcategory_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcategoryrelations | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqchanges | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqcomments | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqconfig | InnoDB | 10 | Compact | 45 | 364 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqdata | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2010-08-20 12:16:19 | 2010-08-20 12:16:19 | NULL | utf8_general_ci | NULL | | |
| facilit_faqdata_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqdata_revisions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqdata_tags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqdata_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqglossary | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqgroup | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqgroup_right | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqlinkverifyrules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqnews | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqquestions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqright | InnoDB | 10 | Compact | 33 | 496 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqsearches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqsessions | InnoDB | 10 | Compact | 11 | 1489 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqstopwords | InnoDB | 10 | Compact | 3331 | 44 | 147456 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqtags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faquser | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faquser_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faquser_right | InnoDB | 10 | Compact | 33 | 496 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faquserdata | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faquserlogin | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqvisits | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
| facilit_faqvoting | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2010-08-20 12:16:19 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 10240 kB |
+------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------+
68 rows in set (0.01 sec)


Viele Grüße,
Tobias

[Thorsten]

Hi,

ah, Windows-Problem.

Gehe mal in die config/database.php und ändere da den Tabellenprefix auf Kleinbuchstaben, dann klappt das.

bye
Thorsten