forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: lauraa855 on August 20, 2010, 11:22:22 am
-
I recently upgraded my gallery to 1.5x
http://www.n-portman.org/gallery
The upgrade seemed to go ok but when I click on a thumbnail to view an image I get a critical error message.
Here is the debug information;
USER:
------------------
Array
(
[ID] => 102caef96c084f06cd4129c521255f61
[am] => 1
[liv] => Array
(
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 710
[user_name] => Laura
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[access_level] => 3
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT name, value FROM cpg132_config [include/init.inc.php:181] (0 ms)
[1] => SELECT * FROM cpg132_plugins ORDER BY priority [include/plugin_api.inc.php:53] (0 ms)
[2] => SELECT user_id, time FROM `nportman_gallery`.cpg132_sessions WHERE session_id = '59e7040f851d408dc6b9df8d0efaa3f9' [bridge/coppermine.inc.php:264] (0 ms)
[3] => SELECT user_id, user_password FROM `nportman_gallery`.cpg132_users WHERE user_id = 710 [bridge/coppermine.inc.php:276] (0 ms)
[4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `nportman_gallery`.cpg132_users AS u LEFT JOIN `nportman_gallery`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='710' [bridge/udb_base.inc.php:70] (0 ms)
[5] => SELECT user_group_list FROM `nportman_gallery`.cpg132_users AS u WHERE user_id='710' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (0 ms)
[6] => 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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM cpg132_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:321] (0 ms)
[7] => SELECT group_name FROM cpg132_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:325] (0 ms)
[8] => SELECT lang_id FROM cpg132_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
[9] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 710 [include/init.inc.php:387] (0 ms)
[10] => DELETE FROM cpg132_banned WHERE expiry < '2010-08-20 04:20:44' [include/init.inc.php:443] (0 ms)
[11] => SELECT null FROM cpg132_banned WHERE (user_id=710 OR '92.30.174.154' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
[12] => SELECT name, description, thumb FROM cpg132_categories WHERE cid = 1 [index.php:268] (0 ms)
[13] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
FROM cpg132_albums AS a
INNER JOIN cpg132_pictures AS p ON p.aid = a.aid
WHERE a.category > 10000
AND approved = 'YES' [index.php:292] (0 ms)
[14] => SELECT name, description, cid, thumb, depth, lft
FROM cpg132_categories AS c
WHERE depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY c.lft [index.php:316] (0 ms)
[15] => SELECT category, COUNT(*) AS num
FROM cpg132_albums AS a
INNER JOIN cpg132_categories ON cid = category
WHERE depth BETWEEN 0 + 1 AND 0 + 1
GROUP BY category ORDER BY NULL [index.php:358] (0 ms)
[16] => SELECT title, r.description, keyword, category, aid, alb_hits, visibility, r.thumb, r.owner
FROM cpg132_categories AS c
INNER JOIN cpg132_albums AS r ON r.category = c.cid
WHERE c.depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY r.pos, r.aid [index.php:379] (3 ms)
[17] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload
FROM cpg132_categories AS c
INNER JOIN cpg132_albums AS r ON r.category = c.cid
INNER JOIN cpg132_pictures AS p ON p.aid = r.aid
WHERE (1)
AND approved = 'YES'
AND c.depth BETWEEN 0 + 1 AND 0 + 1
GROUP BY r.aid
ORDER BY NULL [index.php:414] (6 ms)
[18] => SELECT COUNT(*) FROM cpg132_albums AS a WHERE 1 [index.php:542] (0 ms)
[19] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'YES' [index.php:555] (4 ms)
[20] => SELECT COUNT(*) FROM cpg132_comments [index.php:574] (0 ms)
[21] => SELECT COUNT(*) FROM cpg132_categories [index.php:580] (0 ms)
[22] => SELECT SUM(hits) FROM cpg132_pictures WHERE approved = 'YES' [index.php:593] (20 ms)
[23] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' [include/functions.inc.php:2409] (0 ms)
[24] => SELECT lang_id, abbr FROM cpg132_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
[25] => DELETE FROM cpg132_temp_messages WHERE time < 1282292444 [include/functions.inc.php:4911] (0 ms)
[26] => SELECT COUNT(*)
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
GROUP BY r.aid [include/functions.inc.php:1839] (10 ms)
[27] => SELECT r.aid, a.thumb, a.keyword, a.alb_hits, a.title, MAX(ctime) AS ctime
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
GROUP BY r.aid
ORDER BY ctime DESC
LIMIT 0 ,4 [include/functions.inc.php:1851] (20 ms)
[28] => SELECT pid FROM cpg132_pictures WHERE ((aid = '755' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1877] (0 ms)
[29] => SELECT pid FROM cpg132_pictures WHERE ((aid = '754' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1877] (0 ms)
[30] => SELECT pid FROM cpg132_pictures WHERE ((aid = '753' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1877] (0 ms)
[31] => SELECT pid FROM cpg132_pictures WHERE ((aid = '752' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:1877] (0 ms)
[32] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
FROM cpg132_pictures AS r
WHERE approved = 'YES'
AND r.pid IN (28126,28100,28068,27991) [include/functions.inc.php:1893] (0 ms)
[33] => SELECT extension, mime, content, player FROM cpg132_filetypes [include/functions.inc.php:5780] (0 ms)
[34] => SELECT count(aid) FROM cpg132_albums as a WHERE category = '0' [index.php:728] (0 ms)
[35] => SELECT COUNT(*)
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES' [include/functions.inc.php:1476] (7 ms)
[36] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
ORDER BY r.pid DESC LIMIT 0 ,4 [include/functions.inc.php:1492] (0 ms)
[37] => SELECT COUNT(*)
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
AND hits > 0 [include/functions.inc.php:1682] (15 ms)
[38] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip, UNIX_TIMESTAMP(mtime) AS mtime, lasthit_ip
FROM cpg132_pictures AS r
INNER JOIN cpg132_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
AND hits > 0
ORDER BY mtime DESC, pid ASC
LIMIT 0 ,4 [include/functions.inc.php:1706] (59 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
COOKIE :
------------------
Array
(
[__gads] => ID=4c808a8f4088a06f:T=1275162617:S=ALNI_MYJ7Txmh1h00y6Cz8G1C3Adrb7HZA
[wordpress_test_cookie] => WP Cookie check
[cpg133_data] => YTozOntzOjI6IklEIjtzOjMyOiIxMDJjYWVmOTZjMDg0ZjA2Y2Q0MTI5YzUyMTI1NWY2MSI7czoyOiJhbSI7aToxO3M6MzoibGl2IjthOjA6e319
[de5543e5e39aa1d0cb5967bb52ab8a5a] => 71aa10b20af94d7e416dc3cc40e365a0
[wordpress_logged_in_aa9b9a898f541d05c6d54338dc72e382] => admin|1282463607|432f0a224191732fd9e788e2be1e628d
)
==========================
VERSION INFO :
------------------
<br />
<b>Fatal error</b>: Call to undefined function mb_strlen() in <b>/home/nportman/public_html/gallery/include/functions.inc.php</b> on line <b>6332</b><br />
And this is the info that comes up when I click on an image;
While executing query 'SELECT pic_id FROM cpg132_votes WHERE pic_id=28007 AND user_md5_id='e70611883d2760c8bbafb4acb29e3446'' in include/themes.inc.php on line 3655
mySQL error: Table 'nportman_gallery.cpg132_votes' doesn't exist
Any help would be great.
-
did you run the update.php file after the ugrade ?
-
Yes :]
-
...but you didn't upload the new update.php. Use versioncheck.php to make sure you uploaded all the new files.
-
I did originally.
My host just restored the site for me. I've now upgraded it to 1.4.27 (it was originally 1.4.24) and that seems to be working fine.
Now I'm going to try and upgrade to 1.5 again, hopefully it will work this time.
-
Oh sorry Nibbler, I didn't read your post correctly.
I thought I had uploaded it. My ftp said the transfer was 100% complete. I'll make sure that its uploaded when I try 1.5 again.
-
I re-upgraded to 1.5 and the error is still there ???
Debug info is the same as the first post.
-
check you files here: http://www.n-portman.org/gallery/versioncheck.php
any errors listed?
-
What ftp app did you use? Try the free Filezilla (google it) as that tool is very reliable. You will be amazed by how many problems some other ftp apps cause with the worst being web based ones.
-
check you files here: http://www.n-portman.org/gallery/versioncheck.php
any errors listed?
no errors
-
any plugins installed? if yes: disable them...
May be one is not compatible with 1.5.x
-
Run update.php. If that doesn't work make a backup of both your database and you files. Delete all your files except your albums folder, include/config.inc.php and your anycontent.php file.
Upload all the files from a fresh download of coppermine downloaded from this very site. Please use filezilla as mentioned above.
Run update.php and then versioncheck.php. If all looks good everything should work.
-
This does not seem right.
Call to undefined function mb_strlen() in /home/nportman/public_html/gallery/include/functions.inc.php on line 6332
mb_strlen() has been around since php 4.03, your server responds with PHP/5.3.3.
Ask your webhost about that specific error and if it relates to your php configuration.
-
This does not seem right.
mb_strlen() has been around since php 4.03, your server responds with PHP/5.3.3.
Ask your webhost about that specific error and if it relates to your php configuration.
My host is looking into this.
In the meantime, I've disabled plugins and run update.php - still the same error.
I've also had a look at my database and the cpg_votes table seems to be missing. Could that be causing the problem?
Once my host gets back to me about the php config I'll try deleting files & using FireZilla. I normally use Cyberduck and on my other sites its worked perfectly, I've also had someone else download the files from this site and upload them and its not changed anything :/
-
Thanks for everyones suggestions but my friend has fixed it!
She suggested turning of the rating permission in "groups" and it worked perfectly :)