Page 1 of 1

SQL importieren - Bildpfade anpassen?

Posted: Thu 26. Apr 2012, 09:36
by kiessler
Hi,
wir haben auf einem anderen Server eine zweite PHPWCMS-Version (Testversion) aufgespielt um dort mal ein Backup einzuspielen.
Funktioniert soweit alles bis auf die Bilder, die werden nicht anzeigt. Pfad im Quelltext: content/images/temp
Im Backend -> Dateimanager der Testversion sind Bilder vorhanden können aber nciht angezeigt werden, irgendwas stimmt mit dem Pfad nicht. Habt ihr schonmal so was gehabt, wo könnte ich suchen bzw. was anpassen?

Re: SQL importieren - Bildpfade anpassen?

Posted: Thu 26. Apr 2012, 10:14
by update
kiessler wrote:Pfad im Quelltext: content/images/temp
???
Subfolder-Installation?
WIe sieht der Pfad in der conf aus?

Re: SQL importieren - Bildpfade anpassen?

Posted: Thu 26. Apr 2012, 11:14
by Oliver Georgi
content/images leeren.

$phpwcms['root'] anpassen an aktuelle Verhältnisse.
Schreibrechte beachten für content/images

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 10:44
by kiessler
content/images leeren -> hatte ich bereits gemacht, ohne Erfog
Schreibrechte beachten für content/images -> sind auf 777
$phpwcms['root'] anpassen an aktuelle Verhältnisse -> auf der Testversion und in der Originalinstallation steht 'phpwcms'
Pfad Testversion: /httpdocs/phpwcms/content
Pfad Originalinstallation: /phpwcms/content

Kapiere den Zusammenhang nicht, wenn ich die Pfade in der Testversion ändere, funktioniert dann ein zurückspielen der SQL-Daten noch, wenn die Originalinstallation flöten geht?
Und wieso soll nur der Bilderpfad angepasst werden, denn der normale Content wird in der Testversion angezeigt.

Ich hab mal in der englischen Doku zum Thema Backup gelesen, aber von Pfadanpassen steht da nix.

Seit ihr nochmal so gut und gebt mir einen Tipp? :D

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 11:04
by update
OOOh OOh Oh!!! :roll:
Poste mal Deine Conf- Datei (Pw und DB- logins natürlich mit xxx unkenntlich machen)

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 11:52
by kiessler
Ist die von der Testinstallation


<?php

// database values
$phpwcms['db_host'] = 'localhost';
$phpwcms['db_user'] = 'xxx';
$phpwcms['db_pass'] = 'xxx';
$phpwcms['db_table'] = 'xxx';
$phpwcms['db_prepend'] = 'xxx';
$phpwcms['db_pers'] = 1;
$phpwcms['db_charset'] = 'utf8';
$phpwcms['db_collation'] = 'utf8_unicode_ci';
$phpwcms['db_version'] = 'xxx';
$phpwcms['db_timezone'] = 'xxx';
// set MySQL session time zone http://dev.mysql.com/doc/refman/5.5/en/ ... pport.html
// site values
$phpwcms['site'] = 'http://';
$phpwcms['admin_name'] = 'xxx'; //default: Webmaster
$phpwcms['admin_user'] = 'xxx'; //default: admin
$phpwcms['admin_pass'] = 'xxx'; //MD5(phpwcms)
$phpwcms['admin_email'] = 'xxx' //default: noreplay@host

// paths
$phpwcms['DOC_ROOT'] = $_SERVER['DOCUMENT_ROOT'];// real DOC_ROOT seems to be: '/var/www/vhosts/xxx/httpdocs//inc'
$phpwcms['root'] = 'phpwcms/'; //default: ''
$phpwcms['file_path'] = 'filearchive'; //default: 'filearchive'
$phpwcms['templates'] = 'template'; //default: 'template'
$phpwcms['content_path'] = 'content'; //default: 'content'
$phpwcms['cimage_path'] = 'images'; //default: 'images'
$phpwcms['ftp_path'] = 'upload'; //default: 'upload'

// content values
$phpwcms['file_maxsize'] = 2097152; //Bytes (50 x 1024 x 1024)
$phpwcms['content_width'] = 538; //max width of the article content column - important for rendering multi column images
$phpwcms['img_list_width'] = 100; //max with of the list thumbnail image
$phpwcms['img_list_height'] = 75; //max height of the list thumbnail image
$phpwcms['img_prev_width'] = 538; //max width of the large preview image
$phpwcms['img_prev_height'] = 400; //max height of the large preview image
$phpwcms['max_time'] = 1800; //logout after max_time/60 seconds

// other stuff
$phpwcms['compress_page'] = 0; //0 = OFF, 1-9: page compression ON (1 = low level, 9 = highest level)
$phpwcms['imagick'] = 0; //0 = GD, 1 = ImageMagick, 2 = ImageMagick 4.2.9
$phpwcms['imagick_path'] = ''; //Path to ImageMagick (default='' - none)
$phpwcms['use_gd2'] = 1; //0 = GD1, 1 = GD2
$phpwcms['rewrite_url'] = 0; //whether URL should be rewritable
$phpwcms['wysiwyg_editor'] = 1; //0 = no wysiwyg editor, 1 = CKEditor, 2 = FCKeditor
$phpwcms['phpmyadmin'] = 0; //enable/disable phpMyAdmin in Backend
$phpwcms['allowed_lang'] = array('en','de','fr','es'); //array of allowed languages: array('en', 'de', 'fr', 'es')
$phpwcms['be_lang_parse'] = false; // to disable backend language parsing use false, otherwise 'BBCode' or 'BraceCode'
$phpwcms['DOCTYPE_LANG'] = ''; //by default same as $phpwcms['default_lang'], but can be injected by whatever you like
$phpwcms['default_lang'] = 'de'; //default language
$phpwcms['charset'] = 'utf-8'; //default charset 'iso-8859-1'
$phpwcms['allow_remote_URL'] = 1; //0 = no remote URL in {PHP:...} replacement tag allowed, 1 = allowed
$phpwcms['gt_mod'] = 1; //0 = Graphical Text MOD disabled, 1 = enabled
$phpwcms['jpg_quality'] = 85; //JPG Quality Range 25-100
$phpwcms['sharpen_level'] = 1; //Sharpen Level - only ImageMagick: 0, 1, 2, 3, 4, 5 -- 0 = no, 5 = extra sharp
$phpwcms['allow_ext_init'] = 1; //allow including of custom external scripts at frontend initialization
$phpwcms['allow_ext_render'] = 1; //allow including of custom external scripts at frontend rendering
$phpwcms['cache_enabled'] = 0; //cache On/Off - 1 = caching On / 0 = caching Off (default)
$phpwcms['cache_timeout'] = 0; //default cache timeout setting in seconds - 0 = caching Off
$phpwcms['imgext_disabled'] = ''; //comma seperated list of imagetypes which should not be handled 'pdf,ps'
$phpwcms['multimedia_ext'] = 'aif,aiff,mov,movie,mp3,mpeg,mpeg4,mpeg2,wav,swf,swc,ram,ra,wma,wmv,avi,au,midi,moov,rm,rpm,mid,midi'; //comma seperated list of file extensiosn allowed for multimedia
$phpwcms['inline_download'] = 1; //1 = try to display download documents in new window; 0 = show safe under dialog
$phpwcms['form_tracking'] = 1; //make a db entry for each form
$phpwcms['formmailer_set'] = array('allow_send_copy' => 0, 'global_recipient_email' => 'mail@example.com'); //for better security handling
$phpwcms['allow_cntPHP_rt'] = 1; //allow PHP replacement tags and includes in content parts
$phpwcms['GETparameterName'] = 'id'; //must have a minimum of 2 chars
$phpwcms['BOTS'] = array('googlebot', 'msnbot', 'bingbot', 'ia_archiver', 'altavista', 'slurp', 'yahoo', 'jeeves', 'teoma', 'lycos', 'crawler'); //don't start session
$phpwcms['mode_XHTML'] = 1; // Doctype: 1 = XHTML 1.0 Transitional, 0 = HTML 4.01 Transitional, 2 = XHTML 1.0 Strict, 3 = HTML5
$phpwcms['header_XML'] = 0; // Content Type: 1 = application/xhtml+xml, 0 = text/html
$phpwcms['IE_htc_hover'] = 0; // fix IE CSS anomalities
$phpwcms['IE_htc_png'] = 0; // IE <7 PNG fix
$phpwcms['IE7-js'] = 0; // load IE7-js - fix for HTML/CSS/PMG bugs in IE, will disable IE_htc_hover/IE_htc_png
$phpwcms['php_timezone'] = ''; // overwrite PHP default time zone http://php.net/manual/en/timezones.php
$phpwcms['Bad_Behavior'] = 0; // 1 enables spam/bot blocking by Bad Behavior, 0 off
$phpwcms['wysiwyg_template'] = array( 'FCKeditor' => 'phpwcms_basic,phpwcms_default,Default,Basic', 'CKEditor' => 'phpwcms_basic,phpwcms_default,Default,Basic' );
$phpwcms['GET_pageinfo'] = 0; // will add "&pageinfo=/cat1/cat2/page-title.htm" based on the breadcrumb information for each site link
$phpwcms['version_check'] = 1; // checks for current release of phpwcms online
$phpwcms['SESSION_FEinit'] = 0; // set 1 to enable sessions in frontend, 0 to disable sessions in frontend
$phpwcms['Login_IPcheck'] = 0;
$phpwcms['frontend_edit'] = 0; // enable content specific direct links - linking direct into the backend
$phpwcms['gd_memcheck_off'] = 0; // disable GD php memory check before resize an image
$phpwcms['enable_chat'] = 0; // enable or disable chat function, by default it is disabled - not recommend anymore to use it
$phpwcms['enable_messages'] = 0; // enable or disable internal messags, by default it is disabled - not recommend anymore to use it
$phpwcms['enable_seolog'] = 1; // enable or disable logging of search engine referrer data
$phpwcms['i18n_parse'] = 1; // enable|disable browser based language parser - all @@Text@@ will be parsed and checked for translation/var based replacement
$phpwcms['i18n_complex'] = 0; // enable|disable the way browser language setting should be used, false = the easier way (always 2 chars 'en'), true - 'en-gb'...
$phpwcms['FCK_FileBrowser'] = 1; // enable|disable phpwcms Filebrowser in FCKeditor instead of built-in FCK file bowser support
$phpwcms['JW_FLV_License'] = ''; // insert your JW FLV Media Player License Code here - License warning will no longer displayed
$phpwcms['feuser_regkey'] = 'FEUSER';
$phpwcms['login.php'] = 'login.php';
$phpwcms['js_lib'] = array('mootools-1.2'=>'MooTools 1.2', 'mootools-1.1'=>'MooTools 1.1', 'jquery'=>'jQuery 1.3', 'jquery-1.4'=>'jQuery 1.4');

// dynamic ssl encryption engine
$phpwcms['site_ssl_mode'] = '0'; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms['site_ssl_url'] = ''; //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. 'https://www.yourdomainhere.tld'
$phpwcms['site_ssl_port'] = '443'; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'

// smtp values
$phpwcms['SMTP_FROM_EMAIL'] = 'xxx'; // reply/from email address
$phpwcms['SMTP_FROM_NAME'] = 'phpwcms webmaster'; // reply/from name
$phpwcms['SMTP_HOST'] = 'localhost'; // SMTP server (host/IP)
$phpwcms['SMTP_PORT'] = 25; // SMTP-Server port (default 25)
$phpwcms['SMTP_MAILER'] = 'mail'; // default phpMailer: smtp, mail (default), sendmail
$phpwcms['SMTP_AUTH'] = 1; // sets SMTP_AUTH to ON/OFF
$phpwcms['SMTP_USER'] = 'xxx'; // default SMTP login (user) name
$phpwcms['SMTP_PASS'] = 'xxx'; // default SMTP password


define('PHPWCMS_INCLUDE_CHECK', true);


?>

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 12:04
by update
Was ist denn das für eine phpwcms-Version? Scheint schon was älteres zu sein.

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 12:10
by kiessler
Ne eigentlich nicht
phpwcms 1.4.7 (2010/12/18, r411)

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 12:29
by Oliver Georgi
1.4.7 ist natürlich alt.

In der Datenbank stehen keine absoluten Pfade.

Ich vermute mal Du hast entweder nicht alles vollständig übertragen (filearchive) oder bei der Übertragung Benutzer falsch gesetzt (FTP->FTP). Desweiteren könnte es auch ein Problem beim Wiedereinspielen der SQL Kopie sein (Charset), Datenbankversionswechsel usw.

Re: SQL importieren - Bildpfade anpassen?

Posted: Fri 27. Apr 2012, 13:59
by kiessler
ok danke. Ich gleiche die Punkte mal ab und melde mich dann nochmal.