forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: rissa on January 13, 2006, 03:17:51 am
-
After loging into the account at the login page; http://www.bamargera.net/gallery/login.php I get this error...
Fatal error: Call to a member function on a non-object in /home/bamarger/public_html/gallery/login.php on line 37
And I just learned mySQL so I'm not familiar with anything, may someone please help me? Thank you.
-
Please post a non-admin test account.
-
Please post a non-admin test account.
I'm sorry, I can't even do that cuz the gallery doesn't work to even attempt that from some other errors. ???
Would you like to PM me and you can login using my password and such?
-
No, my mistake. I should have realized that. Your version is 1.3.5 so you should have posted in that forum. An admin will probably move this thread over there.
Did this error just happen? How long have you been using Coppermine?
I would guess your MySQL server is not responding. Do you have phpMyAdmin to logon to the MySQL account directly (or some other webhost panel)?
-
It just happened. And I only just learned mySQL so I'm completely lost. :( I know it's probably fault for not studing it more.
I actually just switched to coppermine from 4images.
Coppermine was very easy and learnable till this error accored.
I do have a panel and it's located here, https://st31.startlogic.com/phpMyAdmin-2.6.3/index.php
-
Have you tried to logon? If you can, then it must be something else. If you cannot, then maybe your webhost's MySQL server is down and will be up later.
Was the Coppermine installation working properly before this happened? Did you change any core scripts? If it was working and you didn't change any core scripts or change anything manually in the MySQL database, you might try to run install.php again to setup the MySQL configuration again.
Once you get things working, you should upgrade to 1.4.3. It's easy to upgrade and there are lot of useful features in the current version.
-
Yes, I have loged in and that works fine from there.
It's just when I go to log in to the actually gallery to update and upload pictures.
I already have so many pictures and things in there. And I do recall, on accident deleting a script so I reuploaded it from the backup, and that's when this error occured.
If I go and do the reinstallation, will my pictures still be saved? Or do I have to back them up?
-
I would recommend backing up your database first. It's easy to do in phpMyAdmin under "Export" or "Dump Schema & Data". Save it to a file on your computer. Make sure to check off structure and data and select SQL for the type. I usually check off "Complete inserts" and "extended inserts" as well but I don't think it's necessary. You could output one file without (which is the default) and one with to be safe. Open the file with a text editor to make sure it looks like your data is in there. You don't have to know MySQL to do this; that's the magic of phpMyAdmin.
You probably should backup up your files as well, but I'm not sure how an installation or re-installation or upgrade would delete your photos. If you have some custom files like anycontent.php or your theme, you should back those up at least. If it's easy for you to backup your whole folder, go ahead to be safe.
Then you could try a re-installation or maybe a straight upgrade to 1.4.3. Someone else might know better if there are risks with doing an upgrade in your case, but I think it should be OK. The upgrade will give you a clean copy of the 1.4.3 scripts and convert your database to the new version (which is quite simple).
Unless you touched your database; in that case something might go haywire. If you only deleted a script, your database should be fine.
If you back things up, feel free to try things; I would do the 1.4.3 upgrade. If things go strange, you can restore your database & files back using your backup and try again. The documentation (linked above and in the 1.4.3 package) tells you step-by-step how to upgrade.
-
Okay, I will try all this.
I have not touched my database.
Where can you get the updated version of coppermine? The one you are talking about 1.4.3?
And by backing up my files and such I am backing up the photos as well right?
-
You can download 1.4.3 by using the link at the top of this page: "Downloads".
Yes, if you backup your entire folder including subfolders, you will backup your current Coppermine files plus photo albums. The albums are located under the subdirectory "albums", unless you set them up someplace else. In that case, I guess I'm wrong and you'll have to back them up from where they are.
To backup everything, you back up two things: your files and your database.
-
Backing up isn't something that you should reserve for updates. It should be an ongoing thing you do so that it's not a big project when you need to do a backup, since you can do it incrementally, and you don't lose data when horrible things happen. We've seen it many times, unfortunately, when something happens with the server and people lose precious data along with the (sometimes) irreplaceable photos.
-
Alright, I just updated coppermine to 1.4.3 and I have my photos saved, but as I go to the gallery I now get this error...
While executing query "SELECT extension, mime, content, player FROM cpg135_filetypes;" on 0
mySQL error: Unknown column 'player' in 'field list'
-
You missed a step... running update.php. I just did it for you and the gallery is up, but offline.
-
Yeah, I was just going to say what TranzNDance said - really! update.php adds that column as part of the upgrade.
-
Thank you so much guys!
I did put the gallery offline to work on something the first time with uploading.
I logged in this morning, and the CONFIG isn't working to put it back up. it's just a little blank space and no writing to edit and nothing comes up to change my status. Is there something missing for that? Here's all that DEBUG info
USER:
------------------
Array
(
[ID] => b91530b8c45996c7d0ab369d38e52e4e
[am] => 1
[liv] => Array
(
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => rissa
[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] => 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] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg135_filetypes; (0s)
[1] => select * from cpg135_plugins order by priority asc; (0s)
[2] => delete from `bamarger_images`.cpg135_sessions where time<1137164980 and remember=0; (0s)
[3] => delete from `bamarger_images`.cpg135_sessions where time<1135958980; (0s)
[4] => select user_id from `bamarger_images`.cpg135_sessions where session_id=md5("0e3eacd333953b7fd9cdfb9125412b4dabf945cbab6dc790b51b2249487e59d9"); (0s)
[5] => select user_id as id, user_password as password from `bamarger_images`.cpg135_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 `bamarger_images`.cpg135_users AS u INNER JOIN `bamarger_images`.cpg135_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `bamarger_images`.cpg135_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 cpg135_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg135_usergroups WHERE group_id= 1 (0s)
[10] => update `bamarger_images`.cpg135_sessions set time='1137168580' where session_id=md5('0e3eacd333953b7fd9cdfb9125412b4dabf945cbab6dc790b51b2249487e59d9'); (0s)
[11] => SELECT user_favpics FROM cpg135_favpics WHERE user_id = 1 (0s)
[12] => DELETE FROM cpg135_banned WHERE expiry < '2006-01-13 16:09:40' (0s)
[13] => SELECT * FROM cpg135_banned WHERE (ip_addr='24.187.255.200' OR ip_addr='24.187.255.200' OR user_id=1) AND brute_force=0 (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.0.16
------------------
Coppermine version: 1.4.3(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 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.1
==========================
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/local/lib/php | .:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -i -t | /usr/sbin/sendmail -i -t
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 | 8M | 8M
post_max_size | 8M | 8M
==========================
Page generated in 0.09 seconds - 14 queries in 0 seconds - Album set : ; Meta set: ;
-
don't post debug output unless requested.
-
rissa: You have to be more detailed about what's happening but that doesn't mean you should post everything on the page like debug info because some things are not related. What I mean is what's happening right now? You login, everything looks normal, you click on the config button, but nothing comes up - is that what you see?
Oh,wait a second, let's pause. Your original problem is now solved (by upgrading), so you should start a new thread with your current problem. There's a one question per thread policy, for organization and archival purposes (to help other people).
-
^^ Thank you, will do a new thread right now. :)