Suddanly problem with script....

[darvida]

From one day to the other I get some error messages from my site

http://www.fotografisches.at

The messages are:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/web71/html/fotografisches/index.php on line 145

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/web71/html/fotografisches/index.php on line 146

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/web71/html/fotografisches/index.php on line 149

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/web71/html/fotografisches/index.php on line 155

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/web71/html/fotografisches/mkls_functions.inc.php on line 277

The related code is:

Line 143: else {
Line 144: $row = mysql_query("SELECT * FROM ".$config["tblPrefix"]."image WHERE 1=1 ORDER BY RAND()");
Line 145: $image = mysql_fetch_assoc($row);
Line 146: $prev_image = mysql_fetch_assoc(mysql_query("SELECT * FROM ".$config["tblPrefix"]."image WHERE ID < '".$image["ID"]."' ORDER BY ID DESC"));
Line147: $options["IMAGE_THUMBNAIL_RANDOM"] = "";
Line 148: $count = 1;
Line 149: while($thumb_image = mysql_fetch_assoc($row)) {
Line 150: if($prev_image["ID"] == $thumb_image["ID"]) continue;
Line 151: build_thumb_entry($thumb_image, $options["IMAGE_THUMBNAIL_RANDOM"]);
Line152: if($count > $config["thumb"]["number"]-1) break;
Line 153: $count++;
Line 154 }
Line 155: $options["SITE_PHOTONUMBER"] = mysql_num_rows($row);
Line 156: $options["IMAGE_TITLE"] = $image["name"];
Line 157: $options["IMAGE_NAME"] = $image["imageFile"];
Line 158: $options["MENU"] = build_menu();
Line 159: $options["IMAGE_PREVIOUS_ID"] = $image["ID"];
Line 160: mkls_template("tpls/app/gallerie/index_template.html", $options);
Line 161: }

Can anyone tell me whats the problem.
I´ve changed nothing since weeks, and suddanly that problem...
Tell me if you need more information.
Thanks and lg
Tina

[Connie]

Tina,

if you did not change anything, I am sure PixelPost did not change anything as well

for sure PixelPost is no "Chamaleon" ;=)

ask your hoster

- if he upgraded PHP to PHP 5
- if he changed security configuration
- or another upgrade / modification etc.

[GeoS]

One thing we can say: mkls_functions.inc.php isn't PP's file for sure!!

[darvida]

Thanks for your help.
The problem was, that I had deleted the database and thats why the data could not be find.
Now it works ok again.
lg
Christina

[Connie]

Christina,

what did you do???? Deleting the database is like taking out the backbone of PixelPost...

you had a backup?

Ja, ich sehe, die Bilder sind wieder da! Und was für grossartige Aufnahmen! Holga und Lochkamera, wunderbar!

Ich freue mich, dass es wieder klappt!:)