forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: EveoftheWarcom on August 06, 2006, 11:01:05 am

Title: Guests cannot get full size images after clicking thumnails?
Post by: EveoftheWarcom on August 06, 2006, 11:01:05 am

Hi,

This problem sort of came out of the blue for us. On my coppermine gallery the guests cannot view any of the images. It comes up saying this;

"There was an error while processing a database query "

http://forums.eveofthewar.com//photos/ If you click any thumbnail on my gallery you will see the same problem.

I've already checked the user setting in config and they seem fine.

We upgraded months ago and have not really had this problem before.

If anyone could point me in the right direction in how to get this problem fixed i would be massively grateful.

Thanks

Anthony

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Nibbler on August 06, 2006, 12:16:17 pm

Enable debug mode and post the mysql error message you get when you replicate the error.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: EveoftheWarcom on August 06, 2006, 01:42:25 pm

Here is the message;
(Note: i can view full size images, but visitors can't)

USER:
------------------
Array
(
    [ID] => 32299447922e8b2000e1007ec1fa9dd5
    [am] => 1
    [liv] => Array
        (
           

• => 5040
[1] => 5101
            [2] => 2075
            [3] => 4493
            [4] => 4631
        )

   

[name] => Dave D
    [lap] => 2
    [uid] => 79
    [search] => ###Star Wars
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Anthony
    [groups] => Array
        (
           

• => 1

        )

    [disk_max] => 100000
    [disk_min] => 100000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 1
    [num_file_upload] => 10
    [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] => 100000
    [can_see_all_albums] => 1
    [group_id] => 1
)

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

• => SELECT extension, mime, content, player FROM cpg132_filetypes; (0s)
[1] => select * from cpg132_plugins order by priority asc; (0s)
    [2] => delete from `eveofthe_forums`.cpg132_sessions where time<1154860869 and remember=0; (0.001s)
    [3] => delete from `eveofthe_forums`.cpg132_sessions where time<1153654869; (0s)
    [4] => select user_id from `eveofthe_forums`.cpg132_sessions where session_id=md5("dcf4ad8e779c5eb8515bffa1350050b88634c6cb5658bebc931e4a5e94ee7a7d"); (0s)
    [5] => select user_id as id, user_password as password from `eveofthe_forums`.cpg132_users where user_id=1 (0s)
    [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 `eveofthe_forums`.cpg132_users AS u INNER JOIN `eveofthe_forums`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `eveofthe_forums`.cpg132_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [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 cpg132_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1 (0s)
    [10] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 1 (0s)
    [11] => DELETE FROM cpg132_banned WHERE expiry < '2006-08-06 11:41:09' (0s)
    [12] => SELECT * FROM cpg132_banned WHERE (ip_addr='81.77.87.120' OR ip_addr='81.77.87.120' OR user_id=1) AND brute_force=0 (0s)
    [13] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'  (0s)
    [14] => SELECT * FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,1 (0s)
    [15] => SELECT title, comments, votes, category, aid FROM cpg132_albums WHERE aid='254' LIMIT 1 (0s)
    [16] => SELECT name, parent FROM cpg132_categories WHERE cid = '46' (0s)
    [17] => SELECT cid, name, parent FROM cpg132_categories WHERE cid = '34' (0s)
    [18] => SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip, pid FROM cpg132_comments WHERE pid='5240' ORDER BY msg_id ASC (0s)
    [19] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' (0s)
    [20] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'  (0s)
    [21] => SELECT * FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,10 (0.001s)
)

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

[album] => lastup
    [cat] => 0
    [pos] => 0
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.27-standard
------------------
Coppermine version: 1.4.4(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
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 1
Active Links 2
Client API version 4.0.27
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/eveofthe/:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 15M | 15M
post_max_size | 55M | 55M
==========================
Page generated in 0.144 seconds - 22 queries in 0.002 seconds - Album set : ; Meta set: ;

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Nibbler on August 06, 2006, 01:56:03 pm

You need to replicate the error and post the mysql error message.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Joachim Müller on August 06, 2006, 01:59:32 pm

This means: don't post the debug_output, but the actual mysql error you get.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: EveoftheWarcom on August 06, 2006, 02:09:23 pm

Oops  ;D

Is this the one you mean?

While executing query "INSERT INTO cpg132_hit_stats
                          SET
                            pid = 5240,
                            search_phrase = '',
                            Ip   = '81.77.87.120',
                            sdate = '1154866115',
                            referer='http://forums.eveofthewar.com//photos/index.php',
                            browser = 'Microsoft Internet Explorer 6.0',
                            os = 'Windows XP'" on 0

mySQL error: Can't open file: 'cpg132_hit_stats.MYI'. (errno: 145)

Anthony

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Nibbler on August 06, 2006, 02:11:47 pm

That's the one. You need to either repair the table yourself using phpmyadmin or ask your host to fix it for you.

http://forum.coppermine-gallery.net/index.php?topic=10409.0

Also update your gallery.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: EveoftheWarcom on August 06, 2006, 02:53:59 pm

Quote from: Nibbler on August 06, 2006, 02:11:47 pm

That's the one. You need to either repair the table yourself using phpmyadmin or ask your host to fix it for you.

http://forum.coppermine-gallery.net/index.php?topic=10409.0

Also update your gallery.

Cheers, but whats phpmyadmin?

Anthony

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Nibbler on August 06, 2006, 02:59:37 pm

It's a script for working with mysql databases. It is commonly preinstalled by webhosts and can be obtained from phpmyadmin.net if not.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: Joachim Müller on August 06, 2006, 03:01:47 pm

Tools recommended by the devs: phpMyAdmin (http://forum.coppermine-gallery.net/index.php?topic=31423.msg145472#msg145472). In the future, search before asking questions. Googling would have told you as well.

Title: Re: Guests cannot get full size images after clicking thumnails?
Post by: EveoftheWarcom on August 06, 2006, 03:05:09 pm

Fixed now thanks  ;D. I just had to go into the controll panel, then MySQL and press repair.

Thanks again.

Anthony