[Solved]: Upgrade without loss

[Joachim Müller]

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

[Zerg]

Ok.

Debug Info

Code Select Expand

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'

Code Select Expand

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 :

[Zerg]

bridge info

[Joachim Müller]

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

[Zerg]

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

[Zerg]

update..

[attachment deleted by admin]

[Joachim Müller]

in phpMyAdmin, try running this query:

Code Select Expand

ALTER TABLE `cpg11d_categories` ADD `thumb` INT NOT NULL AFTER `parent` ;

GauGau

[Zerg]

MySQL said:

Access denied for user: 'support_got@localhost' to database 'gothic'

guess i need to contact my hosters..

[Joachim Müller]

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

[Zerg]

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?

[Joachim Müller]

please start a new thread on the new issue, this one is already cluttered up enough.

GauGau