adm-misc-php

[420]

i keep thinking the issue could be from some corrupted files during the transfer you made for me from 420times.com to 420magazine.com

isn't there a way to give the gallery files a tune-up and oil change?
is my only option of optimizing through the sql databases in phpmyadmin?

[420]

i "repaired" and "optimized" the "vbulletin" (420magazine.com) database again in phpmyadmin and then i ran a "check", it said this... what does it mean?

Problems with indexes of table `photo_cache`
The following indexes appear to be equal and one of them should be removed: PRIMARY, id
Problems with indexes of table `photo_favorites`
The following indexes appear to be equal and one of them should be removed: userid, userid_2
Problems with indexes of table `rp_cache`
The following indexes appear to be equal and one of them should be removed: PRIMARY, id
Problems with indexes of table `rp_reviewtypes`
The following indexes appear to be equal and one of them should be removed: PRIMARY, id
Problems with indexes of table `thread`
The following indexes appear to be equal and one of them should be removed: postuserid, postuserid_2

[420]

does this have to do with the multiple installations?
if we delete vb gallery installations from all domains on my server and make double sure that all 3 installations of photopost pro are on separate databases, will this hopefully resolve this issue?

it looks as if maybe two galleries are sharing the same database and getting confused?

i am not a tech, but i'm trying my heart out.

[420]

now i "repaired" and "optimized" and ran a "check" on the "420girls" database and got these errors.

Problems with indexes of table `photo_cache`
The following indexes appear to be equal and one of them should be removed: PRIMARY, id
Problems with indexes of table `photo_favorites`
The following indexes appear to be equal and one of them should be removed: userid, userid_2

am i getting close?

[420]

i ran a "check" on the last photopost pro installation i have, that you have not upgraded yet, still running pp pro 5.62 "shellyjones" shellyjones.com and it gives me this error

Problems with indexes of table `pp_cache`
The following indexes appear to be equal and one of them should be removed: PRIMARY, id

i have a lot of caching issues as well in this gallery, maybe these cahce errors are all related and causing these issues?

[Chuck S]

No those are warnings Rob not errors depending on the options your doing. Those are just telling you there possible double indexes which is fine.

Rob what you do is up to you. I am telling you I am not a server guy but I know enough to know between all your sites you have alot of people online at one time. Feel free to email Michael and see if he has any ideas about your slowness. You can surely delete all your vbgalleries if you want. Thats less people looking at double galleries and less bandwidth sure.

[420]

i have emailed michael and alerted my host to this thread for more support on this issue.

can i pay you to remove all of the vb galleries and all of their files and databases and admin control panels for vb gallery and anything having to do with vb gallery from my server?

this will avoid further trouble shooting in that area, hopefully.

[420]

still waiting for a reply from michael.

just received this error in the gallery.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT SUM(filesize) AS fsize FROM photo_photos WHERE userid= AND storecat=0

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND storecat=0' at line 1

Database handle: Resource id #19

[Chuck S]

Your userid variable is empty for some odd reason. When I get home I can apply a patch so you dont get that error. In bulkupload.php the userid variable can be encapsulted.

Content visible to verified customers only.

[420]

thanks chuck.

i now have my host's top programmer ivan looking into this situation, we are still waiting for michael to reply.

looking forward to resolving this issue finally.
hope you have a great day.

[Chuck S]

I will thanks.

[420]

okay, i found something new that may explain the problem here.

in the admin control panel, when i click on "Manage Albums", i get a list of a bunch of albums that are missing photos and a few random galleries with a few photos... but this list only shows about a hundred galleries, most of which have 0 photos in them, not the 25,000 photos i have in these galleries.

is it possible this is an issue that was created when you moved my galleries from 420times.com to 420magazine.com

it sounds logical that maybe these orphaned galleries are somehow a failed part of the transfer and creating these speed issues?

[Chuck S]

what do you mean by missing categories? Missing photos sure I can see you having missing photos if you did not transfer the photo to the new server but you should have data directories and you have category inserts so I cant see that being an issue. Albums that are empty should not be an issue just like categories can be empty.

Nothing there would affect upload speed of a file. I suggest you wait and see what Michael says since he works with some large sites.

[420]

i did not say anything about missing categories.
i will wait for michael.
thanks.

[Chuck S]

You stated all the empty cats and some missing photos. I was saying that would not be linked to your uploaded file taking a while to upload to your server.

[420]

can you please goto my admin control panel and click on "Manage Albums" so you see what i am talking about?

even if you do not believe this is related to the speed issue, i do believe it could be related to the transfer that you did for me and could be causing other issues.

I have spent thousands of hours in the last 6 months trying to figure out this problem with your software and cleaning out the galleries and doing everything in my power to clean it up for optimal performance, including paying numerous programmers to try to figure it out.

i would greatly appreciate your help.

thank you chuck.

[Chuck S]

I knew where you where talking about. Loads fine for me fast you have tons of personal albums users have created and I see no missing images.

[420]

what i am trying to say is that the albums you see, are not all of the albums...
that is only about 10% of the albums...

where are all of the rest of the albums?
i cannot manage them, they are not there.

[420]

most of the "Albums" listed on this page
http://www.420magazine.com/gallery/s...cat=500&limit=

are not in the "Manage Albums" in the admin control panel

try to find my album in the "Manage Albums"
My username is 420

[420]

or try to find username MadameCrash or berrydizzle
these albums all have hundreds of photos, not accessible through the "Manage Albums"...
are we on the same page?