I need help to fix my Coppermine Gallery & Forum Powered by phpBB

[guntherize]

This is a link to my site:
http://photoshowdown.com/main/coppermine/

My first issue is an album that disappeared, yet the photos still remain with the comments that I would like to save the following message is what I receive:

File is in a non existant album (245)!?

File: /homepages/35/d168542458/htdocs/main/coppermine/displayimage.php - Line: 287

Code Select Expand

USER:
------------------
Array
(
    [ID] => 490cb17e9345819c0303d7e84e8d571f
    [am] => 1
    [liv] => Array
        (
            [0] => 92592
            [1] => 88792
            [2] => 27654
            [3] => 94312
            [4] => 38224
        )

    [lap] => 2
    [search] => Array
        (
            [search] => camera
            [album] => search
            [newer_than] =>
            [older_than] =>
            [owner_name] => on
            [type] => AND
            [params] => Array
                (
                    [owner_name] => on
                )

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => camera
    [groups] => Array
        (
            [0] => 102
            [1] => 102
            [2] => 106
            [3] => 110
            [4] => 117
            [5] => 112
            [6] => 113
            [7] => 114
            [8] => 115
            [9] => 116
            [10] => 102
            [11] => 106
            [12] => 110
            [13] => 117
            [14] => 112
            [15] => 113
            [16] => 114
            [17] => 115
            [18] => 116
        )

    [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] => 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] => 0
    [can_see_all_albums] => 1
    [group_id] => 102
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0s)
    [1] => select * from cpg11d_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg11d_bridge (0s)
    [3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = 'd2df2ddf95485895ac142d911df0e579' AND u.user_id > 0 (0s)
    [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2' (0s)
    [5] => SELECT ug.group_id+100 AS group_id FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_user_group AS ug, `db194734934`.phpbb_groups as g WHERE u.user_id=ug.user_id AND u.user_id='2' AND g.group_id = ug.group_id (0s)
    [6] => 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 cpg11d_usergroups WHERE group_id in (102,102,106,110,117,112,113,114,115,116,102,106,110,117,112,113,114,115,116) (0s)
    [7] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 102 (0s)
    [8] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 2 (0s)
    [9] => DELETE FROM cpg11d_banned WHERE expiry < '2009-05-13 20:49:12' (0s)
    [10] => SELECT * FROM cpg11d_banned WHERE (ip_addr='72.197.191.89' OR ip_addr='72.197.191.89' OR user_id=2) AND brute_force=0 (0s)
    [11] => SELECT COUNT(*) FROM cpg11d_pictures WHERE ((owner_name LIKE '%camera%'))  AND approved = 'YES' (0s)
    [12] => SELECT * FROM cpg11d_pictures WHERE ((owner_name LIKE '%camera%'))  AND approved = 'YES' ORDER BY pid DESC  LIMIT 626 ,1 (0.062s)
    [13] => SELECT title, comments, votes, category, aid FROM cpg11d_albums WHERE aid='245' LIMIT 1 (0.001s)
    [14] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
    [album] => search
    [cat] => 0
    [pos] => 626
)

==========================
POST :
------------------
Array
(
    [search] => camera
    [album] => search
    [newer_than] =>
    [older_than] =>
    [owner_name] => on
    [type] => AND
    [params] => Array
        (
            [owner_name] => on
        )

)

==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 4.0.27-max-log
------------------
Coppermine version: 1.4.10(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 0
Active Links 1
Client API version 5.0.67
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
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php | .:/usr/lib/php
open_basedir | no value | 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 | 50000 | 50000
max_input_time | -1 | -1
upload_max_filesize | 20M | 20M
post_max_size | 8M | 8M
==========================
Page generated in 0.146 seconds - 15 queries in 0.063 seconds - Album set : ; Meta set: ;


There are also issues with the mass E-mail that no longer works and the comment alert so people know when someone is leaving a message on their photo that I would like fixed.   

In the forum there is an error message that comes up when you leave a message, but the message is left anyhow.  It discourages members from leaving messages and leads them to believe that  the forum doesn't work.
Here is the message: General Error

Ran into problems sending Mail. Response: 550 must be authenticated

DEBUG MODE

Line : 164
File : smtp.php


I'd love to find someone who can help on an ongoing basis whenever something brakes down.  Please help!

[phill104]

Your biggest problem and one that needs fixing urgently if that you are running CPG 1.4.10.

You will need to get this sorted before doing anything else.

Please read the sticky for this section, things like posting your budget will help in finding someone to do the job.

[guntherize]

The last time I went through an upgrade it was a total disaster.  I lost member's photos and that is when the problems I currently have started in the first place.  I am currently laid-off and not in a financial position to do a major upgrade.  I need some patch work.  You ask me to post what I am willing to pay... What can I get done for $100.  My budget is limited, and the last person I had work on my site left it in a worse position than it was in the first place.  I was told the same thing that you are telling me know to upgrade.  How can I trust that this will work?  What does a total upgrade cost?  A ball park figure would help - thank you!

Gunther Allen

PS - I'm willing to trade photography or graphic work for help. 

[guntherize]

I am hesitant to do another upgrade. The last time I went through an upgrade it was a total disaster.  I lost member's photos and that is when the problems I currently have started. 

I am currently laid-off and not in a good financial position, but I need some work done.  You ask me to post what I am willing to pay... What can I get done for $100.   
What does a total upgrade cost? 
A ball park figure would help - thank you!
Does anyone post how much they charge anywhere???
Do I get quotes per hours -per job?

Gunther

[phill104]

The upgrade procedure really is simple if you follow the docs. The problem is, if you do not learn how to do it you will forever be in the position you are now and needing help.

It also sounds as if you have no backups (and assumption made by the fact that things ar now worse), something also important. If you have backups of your database and files from when all was working then this should be an easy task.

[Gunther Allen]

I am reposting this because the first post had my work e-mail and I was not able to change it.  Below is a few of the problems I've been experiencing.
The back-up I have is not going to help because these issues have been going on for a long time and I've finally decided to address them.  The only new item is that I was backing up albums and one of them disappeared.  Not sure why.  I would like to see if I can salvage the comments and the photos and put them back into an album.  I can find the photos with a search, but the photo only appears as a thumb and the album does not exist???

This is a link to my site:
http://photoshowdown.com/main/coppermine/

My first issue is an album that disappeared, yet the photos still remain with the comments that I would like to save the following message is what I receive:

File is in a non existant album (245)!?

File: /homepages/35/d168542458/htdocs/main/coppermine/displayimage.php - Line: 287

Code Select Expand

USER:
------------------
Array
(
    [ID] => 490cb17e9345819c0303d7e84e8d571f
    [am] => 1
    [liv] => Array
        (
            [0] => 92592
            [1] => 88792
            [2] => 27654
            [3] => 94312
            [4] => 38224
        )

    [lap] => 2
    [search] => Array
        (
            [search] => camera
            [album] => search
            [newer_than] =>
            [older_than] =>
            [owner_name] => on
            [type] => AND
            [params] => Array
                (
                    [owner_name] => on
                )

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => camera
    [groups] => Array
        (
            [0] => 102
            [1] => 102
            [2] => 106
            [3] => 110
            [4] => 117
            [5] => 112
            [6] => 113
            [7] => 114
            [8] => 115
            [9] => 116
            [10] => 102
            [11] => 106
            [12] => 110
            [13] => 117
            [14] => 112
            [15] => 113
            [16] => 114
            [17] => 115
            [18] => 116
        )

    [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] => 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] => 0
    [can_see_all_albums] => 1
    [group_id] => 102
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0s)
    [1] => select * from cpg11d_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg11d_bridge (0s)
    [3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = 'd2df2ddf95485895ac142d911df0e579' AND u.user_id > 0 (0s)
    [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2' (0s)
    [5] => SELECT ug.group_id+100 AS group_id FROM `db194734934`.phpbb_users AS u, `db194734934`.phpbb_user_group AS ug, `db194734934`.phpbb_groups as g WHERE u.user_id=ug.user_id AND u.user_id='2' AND g.group_id = ug.group_id (0s)
    [6] => 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 cpg11d_usergroups WHERE group_id in (102,102,106,110,117,112,113,114,115,116,102,106,110,117,112,113,114,115,116) (0s)
    [7] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 102 (0s)
    [8] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 2 (0s)
    [9] => DELETE FROM cpg11d_banned WHERE expiry < '2009-05-13 20:49:12' (0s)
    [10] => SELECT * FROM cpg11d_banned WHERE (ip_addr='72.197.191.89' OR ip_addr='72.197.191.89' OR user_id=2) AND brute_force=0 (0s)
    [11] => SELECT COUNT(*) FROM cpg11d_pictures WHERE ((owner_name LIKE '%camera%'))  AND approved = 'YES' (0s)
    [12] => SELECT * FROM cpg11d_pictures WHERE ((owner_name LIKE '%camera%'))  AND approved = 'YES' ORDER BY pid DESC  LIMIT 626 ,1 (0.062s)
    [13] => SELECT title, comments, votes, category, aid FROM cpg11d_albums WHERE aid='245' LIMIT 1 (0.001s)
    [14] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
    [album] => search
    [cat] => 0
    [pos] => 626
)

==========================
POST :
------------------
Array
(
    [search] => camera
    [album] => search
    [newer_than] =>
    [older_than] =>
    [owner_name] => on
    [type] => AND
    [params] => Array
        (
            [owner_name] => on
        )

)

==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 4.0.27-max-log
------------------
Coppermine version: 1.4.10(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 0
Active Links 1
Client API version 5.0.67
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
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php | .:/usr/lib/php
open_basedir | no value | 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 | 50000 | 50000
max_input_time | -1 | -1
upload_max_filesize | 20M | 20M
post_max_size | 8M | 8M
==========================
Page generated in 0.146 seconds - 15 queries in 0.063 seconds - Album set : ; Meta set: ;


There are also issues with the mass E-mail that no longer works and the comment alert so people know when someone is leaving a message on their photo that I would like fixed.   

In the forum there is an error message that comes up when you leave a message, but the message is left anyhow.  It discourages members from leaving messages and leads them to believe that  the forum doesn't work.
Here is the message: General Error

Ran into problems sending Mail. Response: 550 must be authenticated

DEBUG MODE

Line : 164
File : smtp.php


I would like to find out approximately how much this would cost me on a project basis.
Per hour or per job.  I am recently unemployed and have to be cost conscious!  Would $10/hour be fair?
If an upgrade is necessary I would need to know how much also and if this will affect my site at all.  I cannot afford to loose anything that I've archived for years.

Thanks - Gunther

[Gunther Allen]

PLEASE DO  NOT RESPOND TO THIS HELP REQUEST.  I discovered that the e-mails were going to my old work address where I was laid-off.  I was not able to change the password and set up a new thread under Gunther Allen.  Please respond there - Thanks!

[Fabricio Ferrero]

Closed as requested.

[Joachim Müller]

Please don't post debug_output unless requested. Please use a better subject next time you start a thread. I have merged your new thread with the existing one.

Closed as requested.

Re-opened

PLEASE DO  NOT RESPOND TO THIS HELP REQUEST.  I discovered that the e-mails were going to my old work address where I was laid-off.  I was not able to change the password and set up a new thread under Gunther Allen.  Please respond there - Thanks!

Subscribe to the existing thread with your new user account instead of creating a new thread. You're constantly breaking a lot of board rules, please stop it.

If an upgrade is necessary I would need to know how much also and if this will affect my site at all. 

Yes, definitely. You're running cpg1.4.10, while the most recent stable release currently is cpg1.4.22, so you're running a totally outdated version where the risk to get hacked is great. We suggest performing this by yourself - you will never be able to maintain your site if you don't perform the upgrade yourself, especially if you're on a tight budget. You have been told so before.

[Gunther Allen]

If I knew how to upgrade or fix the problems myself I would have done it a long time ago.  What kind of help is this.  Insult me and tell me I told you so.  Please if you can help me fine, if not let me find a free lancer with the skills that can show me how to fix my problems so I won't have to bother anyone again.  I find your support site confusing and you assume everyone has the expertise to find their way around as well as you have for years.  I have different sets of skills and I am not a programer.  I am a graphic artist and the person that assisted placing the coppermine script onto my website hasn't helped me in years.  Why can't someone just tell me how much it would cost to fix and update my coppermine and then I could make a decision to proceed or not???  Thank you for your time. Honestly, I have no desire to become a programer!

[phill104]

Upgrading is really not a programming job. All you have to be able to do is copy some files accross and browse to a file (update.php).

It will honestly take you less than half an hour to learn how to do it, probably less if you already can use an ftp app.

Joachim is not trying to insult you but is actually trying to help you to help yourself. Yes, at times the rules of this board are confusing but if you take the time and put in a little effort you will get all the help you need. In this case everything about upgrading is in the docs and if you at least attempt it and ask as per the board rules you will get the help without it costing you. So no need to get the hump, just give it a go and start a thread in the upgrading section.

As for experience, coppermine is not a program directed at those with no skills. You need to be able to use an ftp app and have some very basic skills. If you do not have those skills and are unwilling to learn them (which really is simple) then coppermine is not for you.

[Gunther Allen]

The fear that I have is that I might screw everything up that has been created for years.  The last time there was an upgrade my site ran into many difficulties and this was with an experienced person.  Perhaps it is easier to upgrade now? I am capable enough to understand how to FTP files, but I'm not sure if my site is set up like an ordinary coppermine gallery.  What if it has been tweaked in a way that needs extra attention.  I would not have the skills to deal with that and my site could be down for days if not weeks to get it working again.  This is why I would rather have an experienced person assist me.  If what you are saying is that there is a some type of control file that just needs to be replaced and that is all.. then maybe I can do it myself.  But, I still do not want to chance loosing albums and photos that have been entered by members since 2004.  Already an album has just disappeared for unknown reasons, and I, and all my members would be devastated if I messed things up.  If I were just creating a site I would just do it in a heart beat, but this is quite a different story where I do not want to experiment. 

[Αndré]

The fear that I have is that I might screw everything up that has been created for years.

That's the reason why you should do periodic backups of your files and the database and before every backup.

[Gunther Allen]

I understand that doing a back-up is necessary!  I was doing one and for some reason one of my member's albums just disappeared.  I have no idea why this would happen.  The photos seem to still be there when a search is conducted, but when the photo comes up the message says that no such album exists??  Warrum?

[Gunther Allen]

Hello -

I have a budget of under $100

I believe that my coppermine has been somewhat modified and I am afraid to upgrade to the newest version myself for fear that I will ruin something.

Already there has been a few problems.  I was trying to do a back-up and one of my member's albums just disappeared.

My mass e-mail does not work and either does the e-mail notification when someone leaves a comment.

I also have a phpbb forum where when you leave a message an error message comes up, but yet the message is still published.  It confuses me and members.

My site is http://photoshowdown.com
My webhost is One an One -  They provide no help with the site, but give access and most of the necessary tools 

Kind Regards - Gunther Allen

[Gunther Allen]

Can this entire thread be deleted?  I apologize for the bad subject line, but it was a first attempt.  Is there a way I can delete the entire thread?  I would just like to hire someone and be done with it.  I read all the information on how to install myself and do not feel comfortable trying to myself.

[Gunther Allen]

Why don't you allow people to change their posts or delete them if necessary??  Since you locked my other post and told me to be patient, so I guess I am forced to only used this messy thread.  Whatever?  I was merely trying to follow your rules to begin with. 

$100 to upgrade my coppermine and phpBB.  Anyone interested contact me ASAP!

[Joachim Müller]

Can this entire thread be deleted? 

No, we don't delete threads - they remain, as per board rules.

Why don't you allow people to change their posts or delete them if necessary??

We're definitely not going to discuss board policies with you in this thread. Stop misbehaving. This is the last warning.

[Gunther Allen]

OK - I am still trying to hire someone to help me upgrade and fix my problems.  I followed the Support> Looking for Freelancers / Paid help.  I will to pay up to $100.