Print

[vecinoo]

i updated the files (from 1.33 to 1.4)
without /albume
without changing anycontent.php and include\config.inc.php

i ran myURL/update.php
and......all already done and OK, but, when trying to

"It's recommended to check your file versions if you just upgraded from an older version of coppermine." i get the message "Fatal Error:"

if trying to go directly,

If you didn't (or you don't want to check), you can go to your gallery's start page appears a blank page

all i can say: H E L P

[Tranz]

http://coppermine-gallery.net/tutorial/ read up on manually enabling debug mode so you can get a more detailed error message.

[vecinoo]

is simply "fatal error"

http://www.superpoze.lx.ro

try and see

[Nibbler]

Please do as suggested by supporters.

Manually enabling debug_mode

[vecinoo]

sorry, i m hurrying.

ok. i followed the flash instructions.

and i get this:

While executing query "SELECT extension, mime, content, player FROM cpg133_filetypes;" on 0

mySQL error: Unknown column 'player' in 'field list'

i m lost again...

cpg_133 is the folder in wich is installed the gallery. also, the beginning name of the table (!?)

[vecinoo]

cpg_133 is the folder in wich is installed the gallery. also, the beginning name of the table (!?)

[Tranz]

You haven't replaced all files properly. The update info is from 1.3. http://www.superpoze.lx.ro/cpg133/sql/update.sql

That's why running update.php didn't update the database completely.

[vecinoo]

hmm... 

what can be done, then?  (sorry for being such a geek)

[Tranz]

Replace your existing files with the new ones from 1.4. Make sure that the old files get overwritten.

[vecinoo]

let me hug u.

works... but... there is some...

please, see:

http://www.superpoze.lx.ro/cpg133/index.php

there is something at debug...

[vecinoo]

  i cannot CONFIG

USER:
------------------
Array
(
    [ID] => 123e391647ed63ab48b323b38e04220c
    [am] => 1
    [liv] => Array
        (
           

• => 1623
[1] => 605
            [2] => 1419
            [3] => 932
            [4] => 1650
        )

)

==========================
USER DATA:
------------------
Array
(
   

[user_id] => 1
    [user_name] => vecinoo
    [groups] => Array
        (
           

• => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   

• => SELECT extension, mime, content, player FROM cpg133_filetypes; (0.001s)
[1] => select * from cpg133_plugins order by priority asc; (0s)
    [2] => delete from `superpoze_lx_ro`.cpg133_sessions where time<1149085668 and remember=0; (0.016s)
    [3] => delete from `superpoze_lx_ro`.cpg133_sessions where time<1147879668; (0.012s)
    [4] => select user_id from `superpoze_lx_ro`.cpg133_sessions where session_id=md5("11f6ae17b87b6066aa57cf0d3f2755ecba08882d304be092d1027ac6e76ac26a"); (0.001s)
    [5] => select user_id as id, user_password as password from `superpoze_lx_ro`.cpg133_users where user_id=1 (0.017s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `superpoze_lx_ro`.cpg133_users AS u INNER JOIN `superpoze_lx_ro`.cpg133_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.049s)
    [7] => SELECT user_group_list FROM `superpoze_lx_ro`.cpg133_users AS u WHERE user_id='1' and user_group_list <> ''; (0.002s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg133_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 1 (0.015s)
    [10] => update `superpoze_lx_ro`.cpg133_sessions set time='1149089268' where session_id=md5('11f6ae17b87b6066aa57cf0d3f2755ecba08882d304be092d1027ac6e76ac26a'); (0.001s)
    [11] => SELECT user_favpics FROM cpg133_favpics WHERE user_id = 1 (0.001s)
    [12] => DELETE FROM cpg133_banned WHERE expiry < '2006-05-31 15:27:49' (0s)
    [13] => SELECT * FROM cpg133_banned WHERE (ip_addr='85.186.255.51' OR ip_addr='0.0.0.0' OR user_id=1) AND brute_force=0 (0.001s)
    [14] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = ''  ORDER BY pos (0.002s)
    [15] => SELECT aid FROM cpg133_albums as a WHERE category>=10000 (0.001s)
    [16] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.002s)
    [17] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '1'  ORDER BY pos (0.002s)
    [18] => SELECT aid FROM cpg133_albums WHERE category = 7 (0.002s)
    [19] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0.002s)
    [20] => SELECT count(*) FROM cpg133_albums as a WHERE category = '7' (0.002s)
    [21] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,2 (0.002s)
    [22] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (24, 25)GROUP BY a.aid (0.003s)
    [23] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '7'  ORDER BY pos (0s)
    [24] => SELECT aid FROM cpg133_albums WHERE category = 2 (0s)
    [25] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
    [26] => SELECT count(*) FROM cpg133_albums as a WHERE category = '2' (0.001s)
    [27] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,6 (0.002s)
    [28] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (7, 8, 9, 22, 34, 33)GROUP BY a.aid (0.001s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='123' (0.001s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='1517' (0.001s)
    [31] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '2'  ORDER BY pos (0.001s)
    [32] => SELECT aid FROM cpg133_albums WHERE category = 3 (0s)
    [33] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [34] => SELECT count(*) FROM cpg133_albums as a WHERE category = '3' (0.001s)
    [35] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 0,6 (0.001s)
    [36] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (10, 2, 11, 20, 28, 30)GROUP BY a.aid (0.001s)
    [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='424' (0.002s)
    [38] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '3'  ORDER BY pos (0s)
    [39] => SELECT aid FROM cpg133_albums WHERE category = 4 (0s)
    [40] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
    [41] => SELECT count(*) FROM cpg133_albums as a WHERE category = '4' (0.001s)
    [42] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,5 (0s)
    [43] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (13, 14, 15, 29, 31)GROUP BY a.aid (0s)
    [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='1502' (0s)
    [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='1198' (0s)
    [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='416' (0.001s)
    [47] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '4'  ORDER BY pos (0.001s)
    [48] => SELECT aid FROM cpg133_albums WHERE category = 5 (0s)
    [49] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
    [50] => SELECT count(*) FROM cpg133_albums as a WHERE category = '5' (0s)
    [51] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,6 (0.001s)
    [52] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (16, 17, 18, 21, 19, 23)GROUP BY a.aid (0s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='187' (0.002s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='1486' (0s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='191' (0.001s)
    [56] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '5'  ORDER BY pos (0s)
    [57] => SELECT aid FROM cpg133_albums WHERE category = 6 (0s)
    [58] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
    [59] => SELECT count(*) FROM cpg133_albums as a WHERE category = '6' (0s)
    [60] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,1 (0s)
    [61] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg133_albums AS a  LEFT JOIN cpg133_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (26)GROUP BY a.aid (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg133_pictures WHERE pid='570' (0s)
    [63] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '6'  ORDER BY pos (0s)
    [64] => SELECT aid FROM cpg133_albums as a WHERE category = '0' (0.002s)
    [65] => SELECT count(*) FROM cpg133_albums as a WHERE 1 (0s)
    [66] => SELECT count(*) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [67] => SELECT count(*) FROM cpg133_comments as c LEFT JOIN cpg133_pictures as p ON c.pid=p.pid LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [68] => SELECT count(*) FROM cpg133_categories WHERE 1 (0s)
    [69] => SELECT sum(hits) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [70] => SELECT COUNT(*) FROM cpg133_pictures WHERE approved = 'NO' (0.003s)
    [71] => SELECT count(*) FROM cpg133_albums as a WHERE category = '0' (0.001s)
    [72] => SELECT COUNT(*) from cpg133_pictures WHERE approved = 'YES'  (0.002s)
    [73] => SELECT * FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (0.043s)
    [74] => SELECT COUNT(*) from cpg133_pictures WHERE approved = 'YES'  (0s)
    [75] => SELECT * FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0.001s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.1.4 - OK
------------------
mySQL version: 4.1.14-standard
------------------
Coppermine version: 1.4.6(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
module doesn't exist
==========================
Module: zlib
------------------
module doesn't exist
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
==========================
email
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |
==========================
Size and Time
------------------
Directive | Local Value | Master Value |  |  |  |  |  |  |  |
==========================
Page generated in 0.513 seconds - 76 queries in 0.206 seconds - Album set : ; Meta set: ;

[vecinoo]

i think, because the language.

GOD!

[vecinoo]

oh.... still errors

[Tranz]

oh.... still errors

I don't see any errors. The initial issue has been resolved so I'll mark the thread accordingly. If you get error messages, search the boards for them. If you still need help, post them in new thread(s).

[Joachim Müller]

Turn debug_mode off if this is the only thing that bothers you. As your gallery appears to be working again, you can do so by going to coppermine's config (maintenance settings). In the future, don't post debug_output unless requested, it clutters the board.

[vecinoo]

yep. i turned off debug.

i must thank for your assistance.

come to Cavnic, Romania  be my guests