forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: loubymar 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?
-
open include/config.inc.php and enter the mysql details of your new server. Then upload it again replacing the old file
-
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
-
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
-
I do not know 'bigdump'
For your MySQL username and password... you should ask your host in case you don't know it
-
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
-
enable debug mode and post the actual error message
http://coppermine-gallery.net/tutorial/debug_mode.php
-
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
-
Ok, i removed that code it said on functions.inc.php, n i could log into gallery, but they no admin tools!
-
It ok never mind, ignore my last post, sorry
-
FULL DEBUG INFO:
USER:
------------------
Array
(
[ID] => aa1353397c72cee2eb620713a3733548
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => Webmaster
[groups] => Array
(
)
[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: ;
-
So whats the problem and what do i need to do to resolve it???
Thanks
Louis
-
properly restore your database backup
-
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 (http://forum.coppermine-gallery.net/index.php?topic=38595.0).
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.
-
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
-
I don't think i did a back up 2, but if i have where will i find it?
-
Where ever you put it. How are we suppossed to know where you store your backups?
-
I not done one then!! What else can i do, is it possible to create the table again?
-
you said in your first post, you 'downloaded' the gallery from funpic and as well the MySQL... then that MySQL is your backup
-
But i think i dropped the category table b4 i realised i had to do the download MySQL
-
would it be possible to create it again and if so how?
-
as long as your site and your account on funpic is existing it should be possible. Usually you use phpmyadmin to create a database dump. Funpic has that installed too. Read funpic FAQ and the phpmyadmin documentation for that.
-
What about if i installed coppermine again created the category on the main page, and download the category table of MySQL and upload on to my previous one with all my pictures and users on! Do u think that cud work??
-
then you basically have 'imported' the categories, no albums, users, pics, comments etc
-
Ok, so doing that will not do anything? So i need to create the table my self on Phpmyadmin?
-
again: go to your funpic account and backup your mysql db. Then restore it on your new server. That's the procedure when you move
-
Then what do you expect us to advice?
-
i backed it up funpic MySQL and put it on new server, but still no category table! Is they no other way that i cud keep all my pics and users and re-create the category table again? Or i am left with no other choice but to re-install coppermine competely?
-
If i re-installed coppermine, would it be possible to get all the users and pictures of the old gallery, and put them on the new 1? Not all my pics are on server!
-
then there is no way to restore that table !
you need to re-create it
-
The table? How
-
- Find your table prefix from include/config.inc.php
- go to phpmyadmin or any other mysql tool that you have and run this query (Cahnge the CPG_ with your table prefix):
CREATE TABLE CPG_categories (
cid int(11) NOT NULL auto_increment,
owner_id int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
description text NOT NULL,
pos int(11) NOT NULL default '0',
parent int(11) NOT NULL default '0',
thumb int(11) NOT NULL default '0',
PRIMARY KEY (cid),
KEY cat_parent (parent),
KEY cat_pos (pos),
KEY cat_owner_id (owner_id)
) TYPE=MyISAM COMMENT='Used to store categories';
after that you have an empty table
Go to admin mode and :
- re-create categories
- set the albums
-
Im not 100% sure what u mean!
I can't see table prefix in include/config.inc.php
And im on phpmyadmin, but where do i go to run this query (Cahnge the CPG_ with your table prefix):???
Can u explain more 2 me plz?
Sorry
-
I can't see table prefix in include/config.inc.php
Download it to your local computer via ftp and open it with a simple text editor (such as notepad)
And im on phpmyadmin, but where do i go to run this query (Cahnge the CPG_ with your table prefix):???
- Select your CPG database from left menu
- Click SQL button on top menu
- Paste that code to text area
- Hit the Go button
-
ok, i done phpmyadmin bit, but what do i do when i opened include/config.inc.php? What am i pasting on to it?
http://anagallery.ifastnet.com/cpg148/index.php
-
You shouldn't pass anything on that file !
you should have something like this on that file:
// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] = 'cpg148_';
that indicate your table prefix , cahnge the CPG_ under query with your prefix
also if it's hard for you ,you can simply look at the other tables on your cpg database and find out what table prefix you are using by phpmyadmin
-
Ok, i done that, but now when i add a news category on the gallery, it doesn't show on homepage, and i can only see the gallery if it is in debug_mode, what do i need to do?
Many Thanks
Louis
-
Yes they will not show up until you have albums under ...
you need to set albums as suggested , go to each album properties and set the correct category for it
-
Great, they isn't cpg148_albums in MySQL datebase! I reali can't believe this!
Is they any way that i can create cpg148_albums again? cus it not on backup iver, i must ave deleted that 2!!!
I no what i done, i have read the docs for Big Dump, and read it wrong!
If not im just gonner have to re-install coppermine! :(
-
I think it's better to re-install coppermine and re-upload your image using batch add
- overwrite all files and folder except include/config.inc.php and albums folder
- and then use batch add
-
Is they no way i can keep the members??
-
On the new datebase i cud manually add all the users through phpmyadmin, cus i will have the users info on my old server, do u think that wud b possible??
-
Yes it would be possible , you need to run an insert ... select mysql query
I think you should hire someone to do that for you ...
-
I tested it on my old server and it worked ok, it just copying n pasting!
-
Issue solved then?
-
yes, i did backup of the user section on Phpmyadmin on old server, n put it onto new, so i got all my users back,
Many Thanks For all your help
Any Sorry for any problems i may have caused
Louis