Another 6.1 Upgrade Error

[TEAMBAJAMARINE]

UPGRADE From 6.02 to 6.1
An error was encountered during execution of the query:

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

The query returned with an errorcode of:
Unknown column 'Array' in 'where clause'

[Chuck S]

Try editing that category and select your view of the gallery thumbnail puzzle etc and save and the error should go away. It seems there is some erroneous data saved in the cat record that should not be there.

[TEAMBAJAMARINE]

Okay I understand that. How do I find which category this is?

[Chuck S]

start with any top level category

[TEAMBAJAMARINE]

New error Chuck, any idea why I am seeing these errors all of a sudden with the upgrade? Good news is, the photo gallery front end is working fine, check it out for yourself...http://www.teambajamarine.com/photopost/
its just the emails buggers I am getting.

SELECT catname,extra1,extra2,extra3,extra4,extra5,extra6,numextra FROM pp_categories WHERE id=

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

[Chuck S]

Thats weird error there. Thats from bulkupload and why would defcat be empty.

I think maybe a spider playing with urls.

You can most certainly find the query on line 538 and encapsulate the variable to null that email like so

$defcat in that query would become '$defcat'

[TEAMBAJAMARINE]

In laymans terms? I dont understand any of that.

[Chuck S]

Laymans terms HMM. You have a spider playing games there with your site script urls only way I can think of that defcat would be empty as you select the category on uploadphoto.php and it is passed to uploadproduct in the url.

In the file bulkupload.php line 538 is this query

Content visible to verified customers only.

All your doing on that line is finding $defcat and making it '$defcat'

[TEAMBAJAMARINE]

ah. got it. you guys are so smart with this stuff, its scary.

[Chuck S]

Nah buddy just experience man. I have been breathing this code for like what over 5 years now.

[TEAMBAJAMARINE]

Chuck,
Regarding the first post, I am still seeing the error, just a different Array number. I have done what you told me about editing the TOP LEVEL categorys as I have switched them from GALLERY to THUMBNAIL and saved. I ask, should I cahnge all the sub categorys as well?

[Chuck S]

Yes try doing the subcats as well that suggests that a category in that query which is being replaced as array has something saved in edit categories in a field that is not suppose to have that data.

[TEAMBAJAMARINE]

Wow! So many sub categories to do, but worth it. Not only did it change my Photo Gallery to a nice streamlined new look, I believe I did find the problem in 2 categorys that also had sub categorys. When I altered the THUMBNAIL LAYOUT from the default GALLERY to THUMBNAIL - w/ TITLES another duplicate subcategory popped up and had no data in it and a sort order of 9999. I simply deleted that phantom sub category. This make sense Chuck?

[Chuck S]

yeah something like I said was out of whack in categories that caused that error and checking and saving the cats again seem to solve it for most people

[TEAMBAJAMARINE]

Bad news Chuck, I still get this error, but I do know what category this is, what do you suggest I try next? Keep in mind, I have only seen these errors after my upgrade from 6.02 to 6.1

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

[Chuck S]

I have seen this pop up here and there before 6.1

What category is it? Link?

[TEAMBAJAMARINE]

Chuck,
I never recieved these erros before, only after my upgrade from 6.02 to 6.1. I am actually getting the errors sent to by email and they seem to be different categorys nows. I am familiar and can acsess MYSQL database if that will help me do domething. Here are just three errors...

SELECT * FROM pp_photos WHERE cat IN (32,Array) ORDER BY date DESC LIMIT 50
http://www.teambajamarine.com/photop...ery.php?cat=32

SELECT * FROM pp_photos WHERE cat IN (8,Array) ORDER BY date DESC LIMIT 50
http://www.teambajamarine.com/photop...lery.php?cat=8

SELECT * FROM pp_photos WHERE cat IN (3100,Array) ORDER BY date DESC LIMIT 50
http://www.teambajamarine.com/photop...y.php?cat=3100

[Chuck S]

Feel free to pm me an admin login ftp login and I see look if i see anything.

[TEAMBAJAMARINE]

Chuck,
Sent you the PM from TEAMBAJAMARINE.

[Chuck S]

Not a problem will have a look.