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