Page 1 of 1

Pre upgrade question

Posted: Fri Mar 06, 2009 8:47 am
by markjsb
I'm trying to upgrade from 1.2.5 to 1.5.3. I've taken a backup of the site and am trying to host locally so I can perform the upgrade on my local machine - leaving limited disruption to the live site.

I've changed the config.php to my local server settings but when I connect I get a message in the browser stating that the url could not been found or something.

Any ideas how to get it working locally - I'm sure it's some setting in the DB?

Many thanks for any assistance

Mark

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 9:57 am
by Rolf
Hi markjsb

Please sent us your config.php text

Rolf  :)

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 10:32 am
by markjsb

Code: Select all

<?php


#CMS Made Simple Configuration File
#Please clear the cache (Site Admin->Global Settings in the admin panel)
#after making any changes to path or url related options

#-----------------
#Database Settings
#-----------------

#This is your database connection information.  Name of the server,
#username, password and a database with proper permissions should
#all be setup before CMS Made Simple is installed.
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'removed';
$config['db_password'] = 'removed';
$config['db_name'] = 'vineyaab';

#If app needs to coexist with other tables in the same db,
#put a prefix here.  e.g. "cms_"
$config['db_prefix'] = 'cms_';

#Use persistent connections?  They're generally faster, but not all hosts
#allow them.
$config['persistent_db_conn'] = false;

#Use ADODB Lite?  This should be true in almost all cases.  Note, slight
#tweaks might have to be made to date handling in a "regular" adodb
#install before it can be used.
$config['use_adodb_lite'] = true;

#-------------
#Path Settings
#-------------

#Document root as seen from the webserver.  No slash at the end
#If page is requested with https use https as root url
#e.g. http://blah.com
$config['root_url'] = 'http://localhost:8888/vineyard/';
if(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on')
{
$config['root_url'] = str_replace('http','https',$config['root_url']);
}

#Path to document root. This should be the directory this file is in.
#e.g. /var/www/localhost
$config['root_path'] = '/Applications/MAMP/htdocs/vineyard/';

#Name of the admin directory
$config['admin_dir'] = 'admin';

#Where do previews get stored temporarily?  It defaults to tmp/cache.
$config['previews_path'] = '/Applications/MAMP/htdocs/vineyard/tmp/cache';

#Where are uploaded files put?  This defaults to uploads.
$config['uploads_path'] = '/Applications/MAMP/htdocs/vineyard/uploads';

#Where is the url to this uploads directory?
$config['uploads_url'] = $config['root_url'] . '/uploads';


#---------------
#Upload Settings
#---------------

#Maxium upload size (in bytes)?
$config['max_upload_size'] = 8000000;

#Permissions for uploaded files.  This only really needs changing if your
#host has a weird permissions scheme.
$config['default_upload_permission'] = '664';

#------------------
#Usability Settings
#------------------

#Allow smarty {php} tags?  These could be dangerous if you don't trust your users.
$config['use_smarty_php_tags'] = false;

#CMSMS Debug Mode?  Turn it on to get a better error when you
#see {nocache} errors.
$config['debug'] = false;

#Automatically assign alias based on page title?
$config['auto_alias_content'] = true;

#------------
#URL Settings
#------------

#Show mod_rewrite URLs in the menu? You must enable 'use_hierarchy' for this to work for modules
$config['assume_mod_rewrite'] = false;

#Extension to use if you're using mod_rewrite for pretty URLs.
$config['page_extension'] = '';

#If you don't use mod_rewrite, then would you like to use the built-in
#pretty url mechanism?  This will not work with IIS and the {metadata} tag
#should be in all of your templates before enabling.
$config['internal_pretty_urls'] = false;

#If you're using the internal pretty url mechanism or mod_rewrite, would you like to
#show urls in their hierarchy?  (ex. http://www.mysite.com/parent/parent/childpage)
$config['use_hierarchy'] = false;

#If using none of the above options, what should we be using for the query string
#variable?  (ex. http://www.mysite.com/index.php?page=somecontent)
$config['query_var'] = 'page';

#--------------
#Image Settings
#--------------

#Which program should be used for handling thumbnails in the image manager.
#See http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel/Content/Image_Manager for more
#info on what this all means
$config['image_manipulation_prog'] = 'GD';
$config['image_transform_lib_path'] = '/usr/bin/ImageMagick/';

#Default path and URL for uploaded images in the image manager
$config['image_uploads_path'] = '/Applications/MAMP/htdocs/vineyard/uploads/images';
$config['image_uploads_url'] = $config['root_url'] . '/uploads/images'; 


#------------------------
#Locale/Encoding Settings
#------------------------

#Locale to use for various default date handling functions, etc.  Leaving
#this blank will use the server's default.  This might not be good if the
#site is hosted in a different country than it's intended audience.
$config['locale'] = '';

#In almost all cases, default_encoding should be empty (which defaults to utf-8)
#and admin_encoding should be utf-8.  If you'd like this to be different, change
#both.  Keep in mind, however, that the admin interface translations are all in
#utf-8, and will be converted on the fly to match the admin_encoding.  This
#could seriously slow down the admin interfaces for users.
$config['default_encoding'] = '';
$config['admin_encoding'] = 'utf-8';

#---------------------------------------------
#Use the old stylesheet logic?  It's much slower, but it works with older
#versions of CMSMS.  You'll also need this set to true if there is a module
#that uses a stylesheet callback.  Leave it as false instead you really
#need it.
$config['old_stylesheet'] = false;

# URL of the Admin Panel section of the User Handbook
$config['wiki_url'] = 'http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel';

#Enable backwards compatibility mode?  This basically will allow some
#modules written before 1.0 was released to work.  Keep in mind that this
#will use a lot more memory and isn't guaranteed to fix the problem.
$config['backwards_compatible'] = false;

#Not used anymore... kept around, just in case
$config['disable_htmlarea_translation'] = false;
$config['use_Indite'] = true;
?>

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 11:32 am
by spike
have you mis-spelled your database name?

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 12:10 pm
by Rolf
I asume you are running XAMPP or WAMPP kind of Localhost at your C-drive...

Here the url-settings on one of my local sites:

Code: Select all

#-------------
#Path Settings
#-------------

#Document root as seen from the webserver.  No slash at the end
#If page is requested with https use https as root url
#e.g. http://blah.com
$config['root_url'] = 'http://localhost/foldername';
if(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on')
{
$config['root_url'] = str_replace('http','https',$config['root_url']);
}

#Path to document root. This should be the directory this file is in.
#e.g. /var/www/localhost
$config['root_path'] = 'c:\xampp\htdocs\foldername';

#Name of the admin directory
$config['admin_dir'] = 'admin';

#Where do previews get stored temporarily?  It defaults to tmp/cache.
$config['previews_path'] = 'c:\xampp\htdocs\foldername\tmp\cache';

#Where are uploaded files put?  This defaults to uploads.
$config['uploads_path'] = 'c:\xampp\htdocs\foldername\uploads';

#Where is the url to this uploads directory?
$config['uploads_url'] = $config['root_url'] . '/uploads';


#---------------
#Upload Settings
#---------------

#Maxium upload size (in bytes)?
$config['max_upload_size'] = 20000000;

#Permissions for uploaded files.  This only really needs changing if your
#host has a weird permissions scheme.
$config['default_upload_permission'] = '664';

#------------------
#Usability Settings
#------------------

#Allow smarty {php} tags?  These could be dangerous if you don't trust your users.
$config['use_smarty_php_tags'] = false;

#Automatically assign alias based on page title?
$config['auto_alias_content'] = true;

#------------
#URL Settings
#------------

#Show mod_rewrite URLs in the menu? You must enable 'use_hierarchy' for this to work for modules
$config['assume_mod_rewrite'] = false;

#Extension to use if you're using mod_rewrite for pretty URLs.
$config['page_extension'] = '';

#If you don't use mod_rewrite, then would you like to use the built-in
#pretty url mechanism?  This will not work with IIS and the {metadata} tag
#should be in all of your templates before enabling.
$config['internal_pretty_urls'] = false;

#If you're using the internal pretty url mechanism or mod_rewrite, would you like to
#show urls in their hierarchy?  (ex. http://www.mysite.com/parent/parent/childpage)
$config['use_hierarchy'] = false;

#If using none of the above options, what should we be using for the query string
#variable?  (ex. http://www.mysite.com/index.php?page=somecontent)
$config['query_var'] = 'page';

#--------------
#Image Settings
#--------------

#Which program should be used for handling thumbnails in the image manager.
#See http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel/Content/Image_Manager for more
#info on what this all means
$config['image_manipulation_prog'] = 'GD';
$config['image_transform_lib_path'] = '/usr/bin/ImageMagick/';

#Default path and URL for uploaded images in the image manager
$config['image_uploads_path'] = 'c:\xampp\htdocs\foldername\uploads\images';
$config['image_uploads_url'] = $config['root_url'] . '/uploads/images'; 
Change 'foldername' into your folder on your C-drive
Please note the difference in slashes and backslashes!!

Hope this helps.

Rolf  :)

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 12:53 pm
by markjsb
Yeah I've got all the paths perfect - I did a separate install - I still had the installer, but as soon as I put the online DB over the installed one it gives that message.

I'm running my server on a Mac so no C: drive and that's why the slashes are different - using MAMP localhost

If anyone else knows the problem be glad of the help

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 1:16 pm
by spike
I run MAMP on a mac -

the only differences I can see to my config files is that you have trailing slashes on some of your paths, which may or may not be a problem and I always run my installs directly in the root (htdocs)

gruss - spike

P.S. are you typing the correct address in your browser in your case it should be:

http://localhost:8888/vineyard/index.php

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 1:28 pm
by markjsb
Yeah typing correct address - thanks.

Appreciate everyone's help, guess it just won't work!

Thanks

Mark

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 1:48 pm
by spike
One last try - did you install 1.5.3 into MAMP before you imported the database ?

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 2:50 pm
by markjsb
No - at this stage I'm just trying to get the old site working locally before doing the upgrade and then I'll upload the upgrade.

Mark

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 3:07 pm
by spike
Yes - but have you actually installed CMSMS locally on your MAMP - you have to do a regular install - you can't just copy stuff over.

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 3:10 pm
by markjsb
I used 1.2.5 - the old installer then copied my DB with all my content over the top. This is when it broke, so I couldn't upgrade to 1.5.3.

Re: Pre upgrade question

Posted: Fri Mar 06, 2009 5:16 pm
by spike
It must be your database that's giving you headaches  - mark - try exporting it again using different settings (switch off hexadecimal for instance) or use zip instead of gzip, whatever . . .

I use MAMP a lot and have done dumps and upgrades with it many times without hitch - and if hitch then it was me.

Drink a cup of tea and make a new start with a clean install and do-it-again

best of luck - gruss - spike