Hello.
I want to upgrade my Coppermine 1.1.1 Devel (intergrated with Invision Power Board 1.2 Final and with 'Hardwired' theme) to 1.3.1. Is this possible without losing any user albums, photos, member groups? If yes, how do I do this? What steps do I take?
p.s.
i've read the 1.3.1 manual - 3.2 Upgrading from releases of version 1.1 - but there isn't much.
the fact that yours is a devel version (that is pre-release) is the only thing that causes worry.
Make a database dump, and a backup copy of all your current files. Edit the new bridge file and include/init.inc.php.
Then overwrite the files on your install, with the new ones. Make sure your include/config.inc.php and install.lock is still there.
One thing the docs do miss with the 1.1 upgrade, you must now create a new folder inside the albums folder, named 'edit', and chmodd to the same.
Now browse to yoursite.com/upgrade.php. That should be it, no loss of anything.
BUT, as yours is a devel version, I cannot be 100%, so if it does go wrong, restore your old files and use the dump to return the database to original.
QuoteNow browse to yoursite.com/upgrade.php
you mean, "update.php"..
and, i take it i won't have to (re-)apply my own theme to the gallery again.. or will i?
Yes, Casper meant "update.php".
Themes designed for cpg1.1.x will not work with cpg1.3.x, but you can ugrade your theme as well. Take a look into the docs folder that comes with the cpg1.3.1 package, there's a file "theme.htm" in it that explains how to convert your custom theme to make it work with cpg1.3.x
GauGau
well, i use modified hardwired theme and i noticed it in 1.3.1 archive package as well. so i guess i'll be able to apply it to my gallery again.
and don't close this topic just yet!.. i'm still figuring out how to make that "database dump".. ;D when/if i reach some result, i'll post a message here.
http://coppermine.sourceforge.net/faq.php#BackupDatabase
For details, refer to the phpMyAdmin manual.
GauGau
thanks for the docs link.
i can't seem to find "install.lock". is it vital?
install.lock isn't in the distro. It's created after you install/upgrade Coppermine.
that's why i'm asking if it's vital (to update gallery without it being present). i dont seem to have it. must have deleted it after install..
I don't think 1.1x versions used install.lock. You won't have any problems.
done everything like said here. help?..
QuoteNotice: Undefined index: upload_form_config in /home/domains/####/www/htdocs/gallery/bridge/invisionboard.inc.php on line 143
Notice: Undefined index: custom_user_upload in /home/domains/####/www/htdocs/gallery/bridge/invisionboard.inc.php on line 144
Notice: Undefined index: num_file_upload in /home/domains/####/www/htdocs/gallery/bridge/invisionboard.inc.php on line 145
Notice: Undefined index: num_URI_upload in /home/domains/####/www/htdocs/gallery/bridge/invisionboard.inc.php on line 146
did you replace your bridge file as well? You have to replace all older files with those from the package. Back up your old stuff first.
If you don't have a file install.lock, delete the file install.php from the coppermine root dir to make sure nobody runs the install script again and messes up your coppermine install.
GauGau
yes, i replaced new and updated with my access parameters bridge file as well. i replaced all older files as well.
i dont have install.lock and i deleted install.php right away after the update. and after all that i received what i quoted earlier..
update process went successfuly though. i that error stuff appeared afterwards.
hmm.. guess there's no help available for this.
how exactly do i restore my database with phpmyadmin (2.5.1)?
did you switch debug_mode off in coppermine config? The notices should go away then.
Don't give up yet with the upgrade process!
Help for phpMyAdmin can be obtained from the phpMyAdmin manual that comes with the distro, or take a look at the FAQ: http://www.phpmyadmin.net/documentation/#faqusing .
GauGau
Quote from: GauGau on August 16, 2004, 08:04:41 AM
did you switch debug_mode off in coppermine config? The notices should go away then.
Don't give up yet with the upgrade process!
before or after the upgrade? either way i didn't switch that.. and it was OFF before the upgrade.
and when i logged out of admin mode it kept only showing me "there was error processing database query" or smth, with big letters.
if you're interested, i'm willing to provide you with login and password of my domain as well as mySQL parametres so you could look/try for yourself (carefully not deleting anything though). i'd be grateful if you succeed upgrading it..
Post a link to your page for a start.
GauGau
the site is http://www.industry.ee/, gallery is http://www.industry.ee/gallery/. although i restored it to it's original state, so you won't see much there. plus, it's closed to unregistered users.. ::)
i can try to "upgrade" it again, so you could see the errors.. or you can try upgrading it yourself, doing it the best way possible.
well, if you don't let me see it, then I can't help you. I will not do the upgrade for you. If you have a closed gallery and request support, you will have to set up a test user and post the account data here (you can disbale the user once the issue has been fixed).
I'm sorry you gave up so soon, without even giving me the chance to look into this, it's a pity I wasted hal the morning trying to help you best I could.
GauGau
well, i didn't know i will be receiving help that soon and i wanted my gallery to function properly..
but ok, i've done the upgrade process again, which ran smooth. but the result is the same again. pls check (http://www.industry.ee/gallery/) and see if you can help.
waiting for your reply.
GauGau, where are you?.. :\'(
:)
switch debug_mode back on to see what query actually fails. If you have integrated, post your changes in the bridge file (removing your password with asterisks). I have a life, I'm not online all day. Allow days, not hours before bumping!
GauGau
Ok.
Debug Info
While executing query "SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = '' ORDER BY pos" on 0
mySQL error: Unknown column 'thumb' in 'field list'
USER:
------------------
Array
(
[ID] => 324dc7bd2f2367fae9f792aed1faee2d
[am] => 1
[liv] => Array
(
[0] => 656
)
)
==========================
USER DATA:
------------------
Array
(
[0] => 1
[user_id] => 1
[1] => Sotsirh
[user_name] => Sotsirh
[2] => 4
[mgroup] => 4
[3] => 4
[group_id] => 4
[4] => Fьhrer
[group_name] => Fьhrer
[5] => 0
[group_quota] => 0
[6] => 0
[has_admin_access] => 1
[7] => 1
[can_rate_pictures] => 1
[8] => 1
[can_send_ecards] => 1
[9] => 1
[can_post_comments] => 1
[10] => 1
[can_upload_pictures] => 1
[11] => 1
[can_create_albums] => 1
[12] => 0
[pub_upl_need_approval] => 0
[13] => 0
[priv_upl_need_approval] => 0
[groups] => Array
(
[0] => 4
)
[can_see_all_albums] => 1
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content FROM cpg11d_filetypes;
[1] => SELECT id as user_id, name as user_name, mgroup FROM `gothic`.ibf_members WHERE id='1' AND password='b06ea7f425a3791315eb0cde0591b652'
[2] => SELECT * FROM cpg11d_usergroups WHERE group_id = '4'
[3] => DELETE FROM cpg11d_banned WHERE expiry < 1092721273
[4] => SELECT * FROM cpg11d_banned WHERE ip_addr='82.147.170.172' OR ip_addr='82.147.170.172' OR user_id=1
[5] => SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = '' ORDER BY pos
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.8 - OK
------------------
mySQL version: 4.0.20-log
------------------
Coppermine version: 1.3.1
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.23 compatible)
FreeType Support enabled
FreeType Linkage with freetype
T1Lib Support enabled
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 1
Active Links 2
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.2.1
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/php:/usr/share/pear | .:/usr/share/php:/usr/share/pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.039 seconds - 6 queries in 0.002 seconds - Album set :
bridge info
Did you replace the files in the sql folder as well and run update.php after uploading all cpg1.3.1 files? Sounds like you didn't. I ran update.php for you, but no success. Use a database tool like phpMyAdmin and browse the categories table: post the structure here.
GauGau
Actually I did replace the files in sql folder and did run update.php (everything was "OK" or "Already done" there)
here's browsed categories..
update..
[attachment deleted by admin]
in phpMyAdmin, try running this query:ALTER TABLE `cpg11d_categories` ADD `thumb` INT NOT NULL AFTER `parent` ;
GauGau
QuoteMySQL said:
Access denied for user: 'support_got@localhost' to database 'gothic'
guess i need to contact my hosters..
right, your mySQL user doesn't have the necessary permissions to execute an "ALTER" command. After your webhost has granted permissions, make sure to run update.php once more...
GauGau
ok, that solved the problem. thanks!
there's another one though.. my events gallery appears on the gallery index page now.. while it's not supposed to be there (but only in "Events").. how do i fix it?
please start a new thread on the new issue, this one is already cluttered up enough.
GauGau