MiniCMS - Problem

[Boogie69]

Hallo,

hab nun Coppermine Photo Gallery 1.5.24 (stable) installiert.

Dazu auch das miniCMS

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

[Αndré]

Bitte den Debug-Modus aktivieren und die erweiterte Fehlermeldung posten.

[Boogie69]

Ich hoffe, ich hab des richtige gefunden..

Code Select Expand


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..

[Αndré]

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

Code Select Expand

CPG_
durch deinen Tabellenpräfix

Code Select Expand

jwv_
und führe diese Abfrage aus. Falls du dabei eine Fehlermeldung erhältst, kopier sie bitte.

[Boogie69]

Also, ich hab nun in der minicms/plugins/basic.sql alles ersetzt..

nun hab ich das hier..

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..

Code Select Expand


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       


==========================


[Αndré]

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.

[Boogie69]

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