Can't get on gallery at all!

[loubymar]

My gallery is at: http://anagallery.ifastnet.com/cpg148/ but was at: http://anagallery.an.funpic.org/cpg148/

My ftp server is: Smart FTP

I am gettin this error on both of the pages above:
Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'anagallery'@'192.168.101.1' (using password: YES)

I download gallery folder of funpic one, and got the My SQL of it to, i then uploaded it to new server ifastnet.com, but i now i can't get on at all, what can i do???
Or what have i done wrong?

[Stramm]

open include/config.inc.php and enter the mysql details of your new server. Then upload it again replacing the old file

[loubymar]

I done that, but it still saying: Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'anagallery'@'localhost' to database 'anagallery'

I logged onto my new server and created a My SQL, but and changed details again, but still didn't work, i want all my members to there and my pictures to!

Thanks
Louis

[loubymar]

Cud u tell me how to do the big bump, the big dump i downloaded on put on my server, i also downloaded my SQL that i needed and uploaded that to server, but still gettin same error, and on the Big Dump, i get:

Database connection failed due to Access denied for user 'anagallery'@'localhost' (using password: YES)

Edit the database settings in /home/anagallery/bigdump/bigdump.php or contact your database provider

What do i need to do??

Louis

[Stramm]

I do not know 'bigdump'

For your MySQL username and password... you should ask your host in case you don't know it

[loubymar]

Ok, i gettin sum where, cus i can see my gallery now, but i get this:

Critical error 

There was an error while processing a database query 

What does this mean and what can i do to resolve it?
Thanks
Louis

[Stramm]

enable debug mode and post the actual error message

http://coppermine-gallery.net/tutorial/debug_mode.php

[loubymar]

This is the error:

While executing query "DELETE FROM cpg148_banned WHERE expiry < '2006-11-18 18:58:57'" on 0

mySQL error: Table 'anagallery_anagallery.cpg148_banned' doesn't exist

This can be found at: http://anagallery.ifastnet.com/cpg148/thumbnails.php?album=lastup

[loubymar]

Ok, i removed that code it said on functions.inc.php, n i could log into gallery, but they no admin tools!

[loubymar]

It ok never mind, ignore my last post, sorry

[loubymar]

FULL DEBUG INFO:

USER:
------------------
Array
(
    [ID] => aa1353397c72cee2eb620713a3733548
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Webmaster
    [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 cpg148_filetypes; (0s)
      [1] => select * from cpg148_plugins order by priority asc; (0s)
      [2] => delete from `anagallery_anagallery`.cpg148_sessions where time<1163873923 and remember=0; (0.105s)
      [3] => delete from `anagallery_anagallery`.cpg148_sessions where time<1162667923; (0.236s)
      [4] => select user_id from `anagallery_anagallery`.cpg148_sessions where session_id=md5("f211f84343d4494e6b4729933e313fb0ba7e5e87586dc8b59f60b21e3a4fe223"); (0.003s)
      [5] => select user_id as id, user_password as password from `anagallery_anagallery`.cpg148_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 `anagallery_anagallery`.cpg148_users AS u INNER JOIN `anagallery_anagallery`.cpg148_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `anagallery_anagallery`.cpg148_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 cpg148_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  cpg148_usergroups WHERE group_id= 1 (0s)
      [10] => update `anagallery_anagallery`.cpg148_sessions set time='1163877523' where session_id=md5('f211f84343d4494e6b4729933e313fb0ba7e5e87586dc8b59f60b21e3a4fe223'); (0s)
      [11] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM cpg148_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE (0s)
      [13] => REPLACE INTO cpg148_mod_online (user_id, user_name, user_ip, last_action) VALUES ('1', 'Webmaster', '80.195.227.99', NOW()) (0s)
      [14] => DELETE FROM cpg148_banned WHERE expiry < '2006-11-18 19:18:43' (0s)
      [15] => SELECT * FROM cpg148_banned WHERE (ip_addr='80.195.227.99' OR ip_addr='80.195.227.99' OR user_id=1) AND brute_force=0 (0s)
      [16] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = ''  ORDER BY pos (0s)
      [17] => SELECT aid FROM cpg148_albums as a WHERE category = '0' (0s)
      [18] => SELECT count(*) FROM cpg148_albums as a WHERE 1 (0s)
      [19] => SELECT count(*) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
      [20] => SELECT count(*) FROM cpg148_comments as c LEFT JOIN cpg148_pictures as p ON c.pid=p.pid LEFT JOIN cpg148_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
      [21] => SELECT count(*) FROM cpg148_categories WHERE 1 (0s)
      [22] => SELECT sum(hits) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a ON p.aid=a.aid WHERE 1 (0s)
      [23] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0s)
      [24] => SELECT count(*) FROM cpg148_albums as a WHERE category = '0' (0s)
      [25] => SELECT COUNT(*) from cpg148_pictures WHERE approved = 'YES'  (0s)
      [26] => SELECT * FROM cpg148_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (0.017s)
      [27] => SELECT COUNT(*) from cpg148_pictures WHERE approved = 'YES'  (0s)
      [28] => SELECT * FROM cpg148_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0s)
      [29] => SELECT COUNT(*) FROM `anagallery_anagallery`.cpg148_users (0s)
      [30] => SELECT COUNT(*) FROM cpg148_mod_online (0s)
      [31] => SELECT COUNT(*) FROM cpg148_mod_online WHERE user_id <> 0 (0s)
      [32] => SELECT user_id, user_name FROM `anagallery_anagallery`.cpg148_users ORDER BY user_id DESC LIMIT 1 (0s)
      [33] => SELECT user_id, user_name FROM cpg148_mod_online WHERE user_id <> 0 (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.2.0 - OK
  ------------------
  mySQL version: 5.0.24a-Debian_9-log
  ------------------
  Coppermine version: 1.4.9(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: 2.0 or higher
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XPM Support:
  XBM Support:
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 4.1.11
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/run/mysqld/mysqld.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | On | On
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | /tmp | /tmp
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | exec,system,passthru,readfile,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,dl,popen,parse_ini_file,show_source,curl_exec,popen,pcntl_exec,fsockopen,socket_accept,socket_bind,socket_clear_error,socket_close,socket_connect,socket_create_listen,socket_create_pair,socket_create,socket_get_option,socket_getpeername,socket_getsockname,socket_last_error,socket_listen,socket_read,socket_recv,socket_recvfrom,socket_select,socket_send,socket_sendto,socket_set_block,socket_set_nonblock,socket_set_option,socket_shutdown,socket_strerror,socket_write,stream_socket_client,stream_socket_server,pfsockopen,stream_set_blocking,stream_set_timeout,ftp_alloc,ftp_cdup,ftp_chdir,ftp_chmod,ftp_close,ftp_connect,ftp_delete,ftp_exec,ftp_fget,ftp_fput,ftp_get_option,ftp_get,ftp_login,ftp_mdtm,ftp_mkdir,ftp_nb_continue,ftp_nb_fget,ftp_nb_fput,ftp_nb_get,ftp_nb_put,ftp_nlist,ftp_pasv,ftp_put,ftp_pwd,ftp_quit,ftp_raw,ftp_rawlist,ftp_rename,ftp_rmdir,ftp_set_option,ftp_site,ftp_size,ftp_ssl_connect,ftp_systype,chown,getrusage,get_current_user,set_time_limit,getmyuid,getmypid,dl,leak,listen,chgrp,link,symlink,glob | exec,system,passthru,readfile,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,dl,popen,parse_ini_file,show_source,curl_exec,popen,pcntl_exec,fsockopen,socket_accept,socket_bind,socket_clear_error,socket_close,socket_connect,socket_create_listen,socket_create_pair,socket_create,socket_get_option,socket_getpeername,socket_getsockname,socket_last_error,socket_listen,socket_read,socket_recv,socket_recvfrom,socket_select,socket_send,socket_sendto,socket_set_block,socket_set_nonblock,socket_set_option,socket_shutdown,socket_strerror,socket_write,stream_socket_client,stream_socket_server,pfsockopen,stream_set_blocking,stream_set_timeout,ftp_alloc,ftp_cdup,ftp_chdir,ftp_chmod,ftp_close,ftp_connect,ftp_delete,ftp_exec,ftp_fget,ftp_fput,ftp_get_option,ftp_get,ftp_login,ftp_mdtm,ftp_mkdir,ftp_nb_continue,ftp_nb_fget,ftp_nb_fput,ftp_nb_get,ftp_nb_put,ftp_nlist,ftp_pasv,ftp_put,ftp_pwd,ftp_quit,ftp_raw,ftp_rawlist,ftp_rename,ftp_rmdir,ftp_set_option,ftp_site,ftp_size,ftp_ssl_connect,ftp_systype,chown,getrusage,get_current_user,set_time_limit,getmyuid,getmypid,dl,leak,listen,chgrp,link,symlink,glob
  file_uploads | On | On
  include_path | .:/usr/share/php:/tmp/ | .:/usr/share/php:/tmp/
  open_basedir | /home:/tmp | /home:/tmp
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/bin/nosendmail | /usr/bin/nosendmail
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 20 | 20
  max_input_time | 20 | 20
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.493 seconds - 34 queries in 0.364 seconds - Album set : ; Meta set: ;

[loubymar]

So whats the problem and what do i need to do to resolve it???

Thanks
Louis

[Stramm]

properly restore your database backup

[Joachim Müller]

And stop breaking every rule, considering your negative karma our tolerance for misbehaviour from you is zero. Don't post debug_output unless requested. Stop speed-posting. Don't spread identical issues over multiple threads.

If the error message says that a mySQL table is missing, it's not very clever to delete the line of code that triggers the error message. You should make sure that the table exists instead. Obviously, you have not set up your gallery properly in the first place, or you have misconfigured it.

[loubymar]

the catagory table is not there on My SQL Phpmyadmin, i read the instructions wrong, as i thought it said drop the tables, so i drop the catagory table, then stopped and realised i done wrong, is they i can get it back, cus its not there, or i can't find it, is they that i can create it again or something?

And sorry for posting twice, i just assumed that next to this post it said solved and thought that no1 wud answer cus it said that next it!
Many Thanks
Louis

[loubymar]

I don't think i did a back up 2, but if i have where will i find it?

[Joachim Müller]

Where ever you put it. How are we suppossed to know where you store your backups?

[loubymar]

I not done one then!! What else can i do, is it possible to create the table again?

[Stramm]

you said in your first post, you 'downloaded' the gallery from funpic and as well the MySQL... then that MySQL is your backup

[loubymar]

But i think i dropped the category table b4 i realised i had to do the download MySQL