Unknown column 'Array' in 'where clause'

[pgowder]

I'm getting error emails about missing column - array??

What causes this?


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

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

[Chuck S]

Interesting what version of Photopost is this? Looks to me like an older bug with the rss feature do you have a script name?

[pgowder]

6.1

Next time I get that message I'll look.

[Chuck S]

Yeah I thought we fixed this but thats what it looks like to me the external.php was fixed awhile back I think on this issue if I am not mistaken.

[pgowder]

An error was encountered during execution of the query:

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

The query returned with an errorcode of:

Unknown column 'Array' in 'where clause'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Chuck S]

HELP! RSS Feeds not working for cats

Interesting I show the code is correctly fixed in this old bug.

[pgowder]

Originally Posted by Chuck S

HELP! RSS Feeds not working for cats

Interesting I show the code is correctly fixed in this old bug.

So do I need to make the change like in that post you linked to?

[Chuck S]

You should not have to as that code in our downloaded code for 6.2 is correct. You would only make that change if your using an older external.php file.

[pgowder]

So what do I need to do?

[Chuck S]

Is your extermal.php file coded as noted in that one thread?

[pgowder]

Content visible to verified customers only.

[Chuck S]

Yes your external.php file is not updated to the currrent code which is noted in that thread. Please apply the fix noted in this thread

HELP! RSS Feeds not working for cats