coppermine-gallery.com/forum

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

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

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: ;

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

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

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

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.

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

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

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.

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

Thanks again.

Anthony