Hallo,
hab nun Coppermine Photo Gallery 1.5.24 (stable) installiert.
Dazu auch das miniCMS (http://forum.coppermine-gallery.net/index.php/topic,68455.0.html)
Die Installation ging problemlos..
Wenn ich dann nach der Installation auf die Startseite klicke, kommt eine Fehlermeldung..
- Kritischer Fehler
- Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten
Habs dann noch unter Xampp versucht, eine Neu-Install ohne andere Plugins..
Das selbe Ergebnis..
Was nun ???
lg Boogie69
Bitte den Debug-Modus aktivieren und die erweiterte Fehlermeldung posten.
Ich hoffe, ich hab des richtige gefunden..
While executing query 'SELECT * FROM jwv_cms WHERE conid='0' AND type='0' ORDER BY cpos' in plugins/minicms/codebase.php on line 92
mySQL error: Table 'startcon_cpg432.jwv_cms' doesn't exist
Datei: ....copper/include/functions.inc.php - Zeile: 272
Das steht nun alles bei der Fehlermeldung..
Die benötigte Tabelle wurde nicht angelegt. Mich verwundert, dass dies sowohl bei deiner Galerie, als auch im XAMPP passiert ist. Gerade XAMPP schränkt standardmäßig nichts ein.
Wie auch immer, das Einfachste wird wohl sein, wenn du die Tabelle manuell mittels phpMyAdmin oder einem ähnlichen Werkzeug anlegst. Öffne dazu die Datei minicms/plugins/basic.sql, kopiere den gesamten Inhalt in einen Texteditor (z.B. notepad.exe, nicht Word oder so!), ersetze alle
CPG_
durch deinen Tabellenpräfix
jwv_
und führe diese Abfrage aus. Falls du dabei eine Fehlermeldung erhältst, kopier sie bitte.
Also, ich hab nun in der minicms/plugins/basic.sql alles ersetzt..
nun hab ich das hier..
Quote
While executing query 'SELECT * FROM jwv_cms WHERE conid='0' AND type='0' ORDER BY cpos' in plugins/minicms/codebase.php on line 92
mySQL error: Table 'startcon_cpg432.jwv_cms' doesn't exist
Datei: ....copper/include/functions.inc.php - Zeile: 272
Vielleicht hilft das weiter..
USER:
------------------
Array
(
[ID] => 8d9ae33c787aba53f69656325faa5dd6
[am] => 1
[lang] => german
[liv_a] => Array
(
[0] => 1
)
[liv] => Array
(
[0] => 8
[1] => 10
[2] => 45
[3] => 46
[4] => 162
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => admin
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[access_level] => 3
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[can_create_public_albums] => 0
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT name, value FROM jwv_config [include/init.inc.php:179] (0.13 ms)
[1] => SELECT * FROM jwv_plugins ORDER BY priority [include/plugin_api.inc.php:52] (0.06 ms)
[2] => DELETE FROM `startcon_cpg432`.jwv_sessions WHERE time < 1380716717 AND remember = 0 [bridge/coppermine.inc.php:251] (0.14 ms)
[3] => DELETE FROM `startcon_cpg432`.jwv_sessions WHERE time < 1379510717 [bridge/coppermine.inc.php:255] (0.07 ms)
[4] => UPDATE jwv_config SET value = 1380720317 WHERE name = 'session_cleanup' [bridge/coppermine.inc.php:259] (0.16 ms)
[5] => SELECT user_id, time FROM `startcon_cpg432`.jwv_sessions WHERE session_id = '186c3c0b8ba43585c800cb544b2c54c8' [bridge/coppermine.inc.php:267] (0.05 ms)
[6] => SELECT user_id, user_password FROM `startcon_cpg432`.jwv_users WHERE user_id = 1 [bridge/coppermine.inc.php:279] (0.04 ms)
[7] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `startcon_cpg432`.jwv_users AS u LEFT JOIN `startcon_cpg432`.jwv_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' [bridge/udb_base.inc.php:70] (0.05 ms)
[8] => SELECT user_group_list FROM `startcon_cpg432`.jwv_users AS u WHERE user_id='1' AND user_group_list <> '' [bridge/coppermine.inc.php:205] (0.04 ms)
[9] => SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM jwv_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:323] (0.05 ms)
[10] => SELECT group_name FROM jwv_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:327] (0.05 ms)
[11] => SELECT COUNT(*) FROM jwv_categorymap WHERE group_id in (1) [bridge/udb_base.inc.php:340] (0.04 ms)
[12] => UPDATE `startcon_cpg432`.jwv_sessions SET time = 1380720317 WHERE session_id = '186c3c0b8ba43585c800cb544b2c54c8' [bridge/coppermine.inc.php:324] (0.12 ms)
[13] => UPDATE `startcon_cpg432`.jwv_users SET user_lastvisit = NOW() WHERE user_id = '1' [bridge/coppermine.inc.php:328] (0.41 ms)
[14] => SELECT lang_id FROM jwv_languages WHERE enabled='YES' [include/init.inc.php:330] (0.09 ms)
[15] => SELECT user_favpics FROM jwv_favpics WHERE user_id = 1 [include/init.inc.php:388] (0.05 ms)
[16] => SELECT * FROM jwv_plugins [plugins/slider/include/load_sliderset.php:23] (0.05 ms)
[17] => SELECT * FROM jwv_plugin_slider [plugins/slider/include/load_sliderset.php:35] (0.06 ms)
[18] => SHOW TABLES LIKE 'jwv_cms_config' [plugins/minicms/include/init.inc.php:54] (0.25 ms)
[19] => SELECT * FROM jwv_cms_config [plugins/minicms/include/init.inc.php:58] (0.05 ms)
[20] => DELETE FROM jwv_banned WHERE expiry < '2013-10-02 15:25:18' [include/init.inc.php:444] (0.41 ms)
[21] => SELECT null FROM jwv_banned WHERE (user_id=1 OR '62.68.193.22' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:460] (0.14 ms)
[22] => SELECT name, description, thumb FROM jwv_categories WHERE cid = 1 [index.php:271] (0.05 ms)
[23] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
FROM jwv_albums AS a
INNER JOIN jwv_pictures AS p ON p.aid = a.aid
WHERE a.category > 10000
AND approved = 'YES' [index.php:295] (0.04 ms)
[24] => SELECT name, description, cid, thumb, depth, lft
FROM jwv_categories AS c
WHERE depth BETWEEN 0 + 1 AND 0 + 2
ORDER BY c.lft [index.php:319] (0.04 ms)
[25] => SELECT category, COUNT(*) AS num
FROM jwv_albums AS a
INNER JOIN jwv_categories ON cid = category
WHERE depth BETWEEN 0 + 1 AND 0 + 2
GROUP BY category ORDER BY NULL [index.php:361] (0.04 ms)
[26] => SELECT title, r.description, keyword, category, aid, alb_hits, visibility, r.thumb, r.owner
FROM jwv_categories AS c
INNER JOIN jwv_albums AS r ON r.category = c.cid
WHERE c.depth BETWEEN 0 + 1 AND 0 + 2
ORDER BY r.pos, r.aid [index.php:382] (0.05 ms)
[27] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload
FROM jwv_categories AS c
INNER JOIN jwv_albums AS r ON r.category = c.cid
INNER JOIN jwv_pictures AS p ON p.aid = r.aid
WHERE (1)
AND approved = 'YES'
AND c.depth BETWEEN 0 + 1 AND 0 + 2
GROUP BY r.aid
ORDER BY NULL [index.php:417] (0.05 ms)
[28] => SELECT extension, mime, content, player FROM jwv_filetypes [include/functions.inc.php:5786] (0.07 ms)
[29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM jwv_pictures WHERE ((aid = '1' ) ) AND approved='YES' ORDER BY RAND() LIMIT 0,1 [index.php:1079] (0.28 ms)
[30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM jwv_pictures WHERE pid='22' [index.php:1066] (0.05 ms)
[31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM jwv_pictures WHERE pid='392' [index.php:1085] (0.05 ms)
[32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM jwv_pictures WHERE pid='91' [index.php:1085] (0.05 ms)
[33] => SELECT COUNT(*) FROM jwv_albums AS a WHERE 1 [index.php:545] (0.05 ms)
[34] => SELECT COUNT(*) FROM jwv_pictures WHERE approved = 'YES' [index.php:558] (0.04 ms)
[35] => SELECT COUNT(*) FROM jwv_comments [index.php:577] (0.04 ms)
[36] => SELECT COUNT(*) FROM jwv_categories [index.php:583] (0.04 ms)
[37] => SELECT SUM(hits) FROM jwv_pictures WHERE approved = 'YES' [index.php:596] (0.04 ms)
[38] => SELECT COUNT(*) FROM jwv_pictures WHERE approved = 'NO' [include/functions.inc.php:2428] (0.05 ms)
[39] => SELECT lang_id, abbr FROM jwv_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2316] (0.05 ms)
[40] => DELETE FROM jwv_temp_messages WHERE time < 1380716718 [include/functions.inc.php:4931] (0.08 ms)
[41] => SELECT * FROM jwv_plugins [plugins/slider/include/load_sliderset.php:23] (0.05 ms)
[42] => SELECT * FROM jwv_plugin_slider [plugins/slider/include/load_sliderset.php:35] (0.05 ms)
[43] => SELECT * FROM jwv_cms WHERE conid='0' AND type='0' ORDER BY cpos [plugins/minicms/codebase.php:92] (0.09 ms)
[44] => DELETE FROM jwv_temp_messages WHERE time < 1380716718 [include/functions.inc.php:4931] (0.08 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
COOKIE :
------------------
Array
(
[cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiI4ZDlhZTMzYzc4N2FiYTUzZjY5NjU2MzI1ZmFhNWRkNiI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo2OiJnZXJtYW4iO3M6NToibGl2X2EiO2E6MTp7aTowO2k6MTt9czozOiJsaXYiO2E6NTp7aTowO3M6MToiOCI7aToxO3M6MjoiMTAiO2k6MjtzOjI6IjQ1IjtpOjM7czoyOiI0NiI7aTo0O3M6MzoiMTYyIjt9fQ==
[9271f408179155816fa9750e6f888534] => 0e9f1b28524acf702189d94f98d1d629
)
==========================
VERSION INFO :
------------------
PHP version 5.3.27 OK
MySQL version 5.5.32-cll OK
Coppermine version 1.5.24 stable
==========================
Module: GD
------------------
Exact version 2.1.0
GD Version bundled (2.1.0 compatible)
FreeType Support 1
FreeType Linkage with freetype
T1Lib Support
GIF Read Support 1
GIF Create Support 1
JPEG Support 1
PNG Support 1
WBMP Support 1
XPM Support 1
XBM Support 1
JIS-mapped Japanese Font Support
==========================
Key config settings
------------------
site_url http://../copper/
charset utf-8
allow_private_albums 1
cookie_name cpg15x
cookie_path /
impath
lang german
main_page_layout minicms/slider/breadcrumb/catlist/alblist/random,2/lastup,2
silly_safe_mode 0
smtp_host
theme curve
thumb_method gd2
==========================
Plugins
------------------
Name LightBox NotesFor.net
Actions plugin_install, plugin_uninstall
Filters file_data, theme_img_navbar
--------------
Name Slider
Actions plugin_install, plugin_uninstall, page_start
Filters plugin_block
--------------
Name EnlargeIt!
Actions plugin_install, plugin_uninstall, page_start
Filters page_meta, theme_display_thumbnails_params, admin_menu
--------------
Name Flash Media Player
Actions plugin_install, plugin_uninstall, plugin_cleanup, page_start
Filters html_other_media
--------------
Name Download album as ZIP-Archive
Actions
Filters theme_thumbnails_title
--------------
Name MiniCMS
Actions plugin_install, plugin_configure, page_start, post_breadcrumb
Filters plugin_block
--------------
==========================
Server restrictions
------------------
safe_mode 0
safe_mode_exec_dir /usr/bin
safe_mode_gid 0
safe_mode_include_dir
sql.safe_mode 0
disable_functions
file_uploads 1
include_path .:/opt/alt/php53/usr/share/pear:/opt/alt/php53/usr/share/php
open_basedir
allow_url_fopen 1
max_execution_time 30
max_input_time -1
upload_max_filesize 2M
post_max_size 32M
memory_limit 128M
suhosin.post.max_vars 1000
suhosin.request.max_vars 1000
==========================
Page (performance)
------------------
Parameter Current Peak
Memory usage 5,86 MB 7,82 MB
Page generation 3034.53 ms 3034.53 ms
Page query time 3.9 ms 3.9 ms
Page query count 45 45
==========================
Quote from: Boogie69 on October 02, 2013, 03:33:16 PM
ich hab nun in der minicms/plugins/basic.sql alles ersetzt..
Das solltest du aber gar nicht machen. Du sollst die Abfrage direkt mit phpMyAdmin durchführen. Wenn dir das nichts sagt, bemühe bitte Google was phpMyAdmin ist und wie du darin Abfragen ausführst.
So, das Problem ist beseitigt..
Hab des ganze bei meinem US-Hoster hochgeladen und installiert..
Da hat es mit dem miniCMS geklappt..
Hab dann einfach die fehlende Tabelle mit phpmyadmin exportiert und bei meinem DE-Hoster importiert..
Und es funktioniert..
Nun wart ich auf des näxte Problem *g