"albums" problem

[Flaunt]

When clicking "albums" in the admin panel, a white page shows up on firefox.  "Page cannot be displayed" shows up on IE.  I replaced the albmgr.php with a fresh one but the problem persists.

What should I do?

[Tranz]

Enable debug mode in Config and post the error message when you go to the albums page.

[miss1030]

Maintenance mode has already been enabled.  Click both categories and Albums from the admin panel results to a blank white page on FF and a page cannot be displayed on IE.  No error message visible so far.

(I run the site with the album problem)

[Tranz]

So this happens to more pages than the albums manager? Try reuploading the file, lest it was corrupted.

[Flaunt]

Yup, so far only 2 pages are giving this error.   I deleted the 2 files and replaced them with fresh ones from a 1.4.6 install.  Same result

[Tranz]

What's your gallery url?

[Flaunt]

http://avril-images.net

Test account:

username: test
password: 123456

If you need admin access to actually view the culprit pages, you may change the password and tell me here so I can promote the account

[Tranz]

I don't understand what you meant about changing the password. I hope you didn't post an admin account. I was unable to log in. Can you doublecheck that the login works?

[Flaunt]

The login works but for some reason, after it welcomes you, you are logged out again.  I cleared my cookies but nothing.  It's fine with the admin account though.  So I enabled Maintenance Mode Again and I tried making a new account because I thought I may ahve somehow bungled the registration of test somewhere.  I got the following error upon submitting the registration form:

While executing query "INSERT INTO cpg135_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4, user_profile5, user_profile6) VALUES (NOW(), 'NO', '29df6deb6cbd1d612bd2e428abab1b92', 'dummm', '123456', 'wacky_lokpo@hotmail.com', '', '', '', '', '', '')" on 0

mySQL error: Duplicate entry '0' for key 1

Oh, dear.  I also changed the password for test to "cattle" but it gives the same effect as the previous login attempt.

[Tranz]

You have the same issue as your batch upload thread: http://forum.coppermine-gallery.net/index.php?topic=31724

You will need to do the same suggested fix to the users table.

[Tranz]

Since you have the same issue on 2 tables so far, you likely have them on all of them that require autoincrement.

Checkout http://avril-images.net/sql/schema.sql. And do a search for auto_increment. That will tell you which tables need to be fixed, along with which field to auto increment.

[Flaunt]

I've auto incremented every specified field and now everything is working perfectly.  At least the parts that were bothering me earlier   Well, if something else comes up, I'll start a thread right away. 

Thank you for your help!   

[Tranz]

Was the problem in your first post here solved with the autoincrement?

[Flaunt]

Yes.  I had to auto increment pid in cpg135_pictures and do this:

ALTER TABLE cpg135_pictures AUTO_INCREMENT = 1

Following your suggestion, I auto incremented every field said to so in the schema and also did the above query, changing only the tables names   It seems to be working now! 

[Flaunt]

Oopsy, yet another problem!

When you click a category, there are spaces for random images from that category and the latest additions to that category and its subcategories.  Scroll to the latest additions.  The pictures appearing there are not just for the category but for the whole gallery itself. 

second thing is the random pictures in a category.  Some pictures are also lost and when you click a thumbnail, it doesn't take you to its picture page but to an error page.  The error it gave out was:

The selected album/file does not exist !

File: /home/melissa/public_html/displayimage.php - Line: 266

Test Account:

Username: test
password: cattle

[Joachim Müller]

one issue per thread!

[Flaunt]

Oh, sorry!

[Flaunt]

I noticed that this seems to happen everytime a gallery is moved. Why?

[Nibbler]

You need to make sure the auto_increment values are preserved when you dump the database. I think it might be a non-default option in phpmyadmin.

[Flaunt]

How do I do that?  My phpmyadmin skills are limited to drop