Forum Moderators: coopster

Message Too Old, No Replies

Photopost Search Error

         

netlovers

10:53 am on Mar 3, 2007 (gmt 0)

10+ Year Member



I have installed Photopost Gallery it is working fine.But when i m searching for images it is showing 2 errors and not displaying any images.
Following is link for image of error so if anybody has solution for this problem plz help me.
<snip>

[edited by: dreamcatcher at 11:06 am (utc) on Mar. 3, 2007]
[edit reason] no urls, thanks. [/edit]

dreamcatcher

11:08 am on Mar 3, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi netlovers,

We do not allow person urls on this forum. For more info, see our T.O.S [webmasterworld.com]

Please post a brief description of the errors you are seeing as we`ll see if we can help.

dc

netlovers

2:03 pm on Mar 3, 2007 (gmt 0)

10+ Year Member



Ok sorry.
Actually when i m searching for any picture in photopost it is giving the following errors and not showing any search results.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\apache\Apache2\htdocs\photopost\search.php on line 242

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\apache\Apache2\htdocs\photopost\search.php on line 443

dreamcatcher

2:38 pm on Mar 3, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Looks like the query is failing, hence the error. Do you have the code that creates the database query?

dc

eelixduppy

2:40 pm on Mar 3, 2007 (gmt 0)



It cannot be narrowed down to one thing wrong, but it does narrow it down a lot. The possible problems are these:
1) Wrong user permissions
2) Your database does not exist or has different spelling
3) You have an error in the query on that page
4) There's a spelling error of some sort

My guess would be that there's an error in the query, and you can find out by adding the following bold part after the query:


$result = mysql_query("your query here") [b]or die(mysql_error());[/b]

or by running the query manually through phpmyadmin, etc. Once you figure out the error, you have to adjust it accordingly.

If this isn't the problem you can test the other possibilities.

Good luck! :)

[edit]
Me = slow typer ;)