Critical Error when viewing images Critical Error when viewing images
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Critical Error when viewing images

Started by lauraa855, August 20, 2010, 11:22:22 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lauraa855

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.

François Keller

did you run the update.php file after the ugrade ?
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog


Nibbler

...but you didn't upload the new update.php. Use versioncheck.php to make sure you uploaded all the new files.

lauraa855

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.

lauraa855

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.

lauraa855

I re-upgraded to 1.5 and the error is still there  ???

Debug info is the same as the first post.

taucher_0815


phill104

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.
It is a mistake to think you can solve any major problems just with potatoes.


taucher_0815

any plugins installed? if yes: disable them...

May be one is not compatible with 1.5.x

phill104

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.
It is a mistake to think you can solve any major problems just with potatoes.

Joe Carver

This does not seem right.
Quote from: lauraa855 on August 20, 2010, 11:22:22 AM
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.


lauraa855

Quote from: Joe Carver on August 20, 2010, 11:53:59 PM
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 :/

lauraa855

Thanks for everyones suggestions but my friend has fixed it!

She suggested turning of the rating permission in "groups" and it worked perfectly :)