mysql&admin panel problems

winky · August 17th, 2006, 07:51 AM

Hi all,

Is few days i've landed in this great photopost world, and now i find first problems.

on CP under Manage Albums. notthing is there , a white page, all other options seems to work great, unless sorting where i get this error :

Code:

Content visible to verified customers only.

some help pls will be really apreciated

take care
ciao

Chuck S · August 17th, 2006, 07:58 AM

You would have a white page under manage albums if you have no albums

In admin => global options select debug setting to be display errors and then try sorting and see if you can give us an exact error so we can assist you.

I have viewed those lines and see no specific issue. Did you recently upgrade maybe forget to run an upgrade script?

winky · August 17th, 2006, 11:56 AM

nope...just newby of P.P. bought it just few days back

and 1st installed on a vb3.6.0
I'll do what u asked me ..and report asap
ty so much for help

winky · August 17th, 2006, 12:02 PM

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

Script: adm-misc

Query: SELECT id,catname,thumbs,cattype,parent,thumbnail,sortorder FROM pp_categories WHERE id=notcat LIMIT 1

Result: Unknown column 'notcat' in 'where clause'

Database handle: Resource id #5

winky · August 17th, 2006, 02:38 PM

Edited: double message clear

Chuck S · August 17th, 2006, 03:39 PM

In adm-misc.php try this line change STRING IN BOLD TO INT

Code:

Content visible to verified customers only.

winky · August 17th, 2006, 05:14 PM

I did it sir, but same error (Warning) is there.
If u like I PM u admin login details

Chuck S · August 17th, 2006, 07:02 PM

resert that line to STRING

Try in adm-misc.php line 3437 this in bold question I would ask is why are you the only one getting this.

Code:

Content visible to verified customers only.

winky · August 18th, 2006, 03:17 AM

Quote:

Originally Posted by Chuck S

resert that line to STRING

Try in adm-misc.php line 3437 this in bold question I would ask is why are you the only one getting this.

Code:

Content visible to verified customers only.

ty so much now errors are disappeared.

a little problem is there (on same page of sorting interface) I can se thumbnails, but if I click on the image name to view it, then a IE page will come out telling me that this page is not availabe.... but images are there and shows up thumbs and in gallery also the larger one.

reguarding why only to me happend? I explain in few words. Do you know Murphy's Laws?? Well, they were expressly written for me

take care
ciao

Chuck S · August 18th, 2006, 07:05 AM

You would need to PM me admin login and url I want to look at your system and see whats going on before I ask say anything else

winky · August 18th, 2006, 01:33 PM

Sure Man, I'll do it now.

In this moment is loaded the "patched" adm-misc.php

..PMing you

Chuck S · August 24th, 2006, 08:49 PM

I do not get any errors on your site where do you get the errors what are your exact actions

winky · August 25th, 2006, 03:06 AM

after modifies on adm-misc sort problems are not any more there.
but if u try to
PP Admin panel > order images > click on 1 of 2 demo photos linkname > will get path error. (seems that images were not uploaded on correct location, but they are displayed :S )
by the way, why I had to modify the adm-misc and not using a standard one? is there an error on my installation?

ty so much for your very kind interest on my problem.

take care
ciao

Chuck S · August 25th, 2006, 09:04 AM

I dont get any errors on order images either sorry appears to be just fine

winky · August 25th, 2006, 01:33 PM

Chuck, ty for kind attention and tests made on my site.

Sort errors, as I told b4 are disappeared, after applying modifications on adm-misc.php that you suggested me in a previous post.
For curiosity I would like to know why I had to customize that file. There were an issue on my installation, or that is a modification that everybody has to apply for?

Reguarding path errors, I can assure you that I can see them and to me seems to be still there.

Please try on my installation: PP Admin panel > order images > click on "Test" link or on "BE001089ACD" link.
You should get a Not Found Page. "The requested URL /mysubfolder(*)/forum/photopost/data/500/1BE001089ACD.jpg (**) was not found on this server."

(*)changed by me here for privacy, from actual subpath to "mysubfolder".

(**)All this path is incomplete as is missing the root and I guess should be something like /myroot.xyz/mysubfolder*/forum/photopost/data/500/1(***)BE001089ACD.jpg
But I do not know where and how to set that path, on config all seems ok

(***) there is always in both test pictures that 1 trailing the real filename ...could be a reason why it don't find it? ...actually isn't the same file name/path.

I really apologize for my bad english

take care, Ty a lot

ciao

Chuck S · August 25th, 2006, 01:53 PM

Line 3586 of adm-misc.php remove this in bold

Code:

Content visible to verified customers only.

Cant say about the other thing or the edit you did as this is nothing I can replicate

winky · August 25th, 2006, 02:15 PM

K i'll do it right now. and le u know immediatelly

winky · August 25th, 2006, 02:23 PM

Yeh now is working!!
ty man really good help & fast!!

full sattisfaction guarantee

!!!!

... were those 2 modifications i made on the php file just expressly for my case/configuration or are they little bugs and in next package will be fixed?

Chuck S · August 25th, 2006, 02:26 PM

The second one is a bug that will be fixed for sure

winky · August 25th, 2006, 02:36 PM

again ty!