Errors after upgrade - what went wrong?

[Gotmian]

Hello all

I get the following errors after upgrading to 6.1

I guess something went wrong with the upgrade process, but I don't know how to fix it.

An error was encountered during execution of the query:

SELECT * FROM pp_photos WHERE cat IN (1173,Array) ORDER BY date DESC LIMIT 50

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

Any ideas?

Thanks in advance...

[Chuck S]

HELP! RSS Feeds not working for cats

That should help you

[Gotmian]

I have 3 more problems. If you can help, I'd really appreciate it.

1. First of all when someone clicks at www.myxbox.gr/gallery the system redirects him to "http://myxbox.gr/gallery/" and automatically the system won't recognize the user as logged in.
If he goes to www.myxbox.gr/gallery/, everything is OK.
Why is that?

2. Second, when someone clicks on the "quick links" of "recent additions" or "top images" the format is with "/" which automatically causes the gallery to malfunction - meaning it won't load properly the forum template files and create a kinda messed up image.
Any ideas how to fix this? Already tried disabling Spider URLs.

3. Final issue is the thing with auto thubnail... As I have a gaming website, I need to stop this function, as I don't want it to create thubnails on its own. I was unable to locate the option to do that - is there any manual change I can make?

Thanks in advance, Keep up!

[Chuck S]

1. You need to set cookies correctly in your system

You cant create a cookie on one domain and expect it read on another and www.domain.com and domain.com are two separate domains as far as cookies are concerned.

You can set your cookies in both vb and photopost to .myxbox.gr and your cookies will be fine

2. Not sure what you mean things look fine to me

3. You can tag an image to use a static image by viewing an image and hitting make index thumb otherwise turn off the cat avatar column.

[Gotmian]

Originally Posted by Chuck S

1. You need to set cookies correctly in your system

You cant create a cookie on one domain and expect it read on another and www.domain.com and domain.com are two separate domains as far as cookies are concerned.

You can set your cookies in both vb and photopost to .myxbox.gr and your cookies will be fine

Hey!

Kudos for the answer, it worked fine!

Is there any way for me to fix this "bug" so the system won't redirect the Main Index - MyXbox.gr Photo Gallery to myxbox.gr/gallery/ while the Main Index - MyXbox.gr Photo Gallery works always fine?
It is not something that used to happen one month ago...

[Michael P]

This has to do with your server configuration; but I am not sure what to tell you to change. You server is looking for a file and not processing the directory to find the index file.

[Gotmian]

...and problems just keep coming

An error was encountered during execution of the query:

SELECT id,cat FROM pp_photos WHERE storeid=

The query returned with an errorcode of:

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 '' at line 1

Any ideas on this one?

[Chuck S]

That is interesting. That query is only ran in editphoto and adm-photo.php when there are additional categories and a numeric phoedit or pid variable is passed so honestly I dont see how that variable could be empty since the query is only ran if a variable is present