Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1] 2 3   Go Down

Author Topic: Can't get on gallery at all!  (Read 13815 times)

0 Members and 1 Guest are viewing this topic.

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Can't get on gallery at all!
« on: November 18, 2006, 10:41:02 am »

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?
« Last Edit: November 19, 2006, 07:02:29 pm by Sami »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Can't get on gallery at all!
« Reply #1 on: November 18, 2006, 11:15:49 am »

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #2 on: November 18, 2006, 04:54:52 pm »

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
Logged

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #3 on: November 18, 2006, 06:46:31 pm »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Can't get on gallery at all!
« Reply #4 on: November 18, 2006, 07:41:40 pm »

I do not know 'bigdump'

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #5 on: November 18, 2006, 07:47:34 pm »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Can't get on gallery at all!
« Reply #6 on: November 18, 2006, 07:54:11 pm »

enable debug mode and post the actual error message

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #7 on: November 18, 2006, 07:59:54 pm »

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
Logged

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #8 on: November 18, 2006, 08:11:13 pm »

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #9 on: November 18, 2006, 08:12:56 pm »

It ok never mind, ignore my last post, sorry
Logged

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #10 on: November 18, 2006, 08:20:02 pm »

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #11 on: November 18, 2006, 08:23:54 pm »

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

Thanks
Louis
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Can't get on gallery at all!
« Reply #12 on: November 18, 2006, 10:17:05 pm »

properly restore your database backup

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Can't get on gallery at all!
« Reply #13 on: November 19, 2006, 07:28:40 am »

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.
Logged

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #14 on: November 19, 2006, 08:32:34 am »

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
Logged

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #15 on: November 19, 2006, 08:34:01 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Can't get on gallery at all!
« Reply #16 on: November 19, 2006, 09:05:37 am »

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #17 on: November 19, 2006, 09:17:28 am »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Can't get on gallery at all!
« Reply #18 on: November 19, 2006, 09:28:58 am »

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

loubymar

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 83
Re: Can't get on gallery at all!
« Reply #19 on: November 19, 2006, 09:33:35 am »

But i think i dropped the category table b4 i realised i had to do the download MySQL
Logged
Pages: [1] 2 3   Go Up
 

Page created in 0.028 seconds with 21 queries.