warnings and no login

[stip]

Hi,
i get the following two messages:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ...visitdresden/pixelpost/includes/functions.php on line 312

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ... pixelpost/includes/functions.php on line 358

...and can't login with my username. asking for a new passsword won't help.

Any suggestions?

Ulrich

[tinyblob]

sounds like you maybe dont have the right prefix in the includes/pixelpost.php file
did the install run okay?

[stip]

same remarks when installing
the "individual part" of pixelpost.php was a copy of the original 1.4.3 version
hm

[tinyblob]

instead of uploading the old one, try just entering the old info into the new pixelpost.php file
see what happens then

[blinking8s]

you need to enter the information into the new pixelpost.php provided with 1.5beta

[stip]

sorry for misunderstanding formulation: i only copied the four lines with the individual information to prevent typos - do it is the new file.

retyping won't help, by the way...

[raminia]

does your host let you create new tables from PHP script? ask them.

tell my what's your PHP and MySQL version from admin panel >> Options >> general info

EDIT:
and check if you have correct DB prefix name in pixelpost.php

[stip]

so, latest status: getting into the admin section, but still having those two lines:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in visitdresden/pixelpost/includes/functions.php on line 312

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in visitdresden/pixelpost/includes/functions.php on line 358

- and another thing with the german Umlaute - this will be another thread and work for Conny :-)

[stip]

does your host let you create new tables from PHP script? ask them.

tell my what's your PHP and MySQL version from admin panel >> Options >> general info

EDIT:
and check if you have correct DB prefix name in pixelpost.php


raminia, the prefix is correct - as a normal visitor you can see the page (http://fotos.visitdresden.net).

as far as i know the host lets me create new tables - at least it worked until yesterday :-)

versions:
PHP-version 5.0.5
MySQL version 4.1.15-Debian_0.dotdeb.0-log

thanks everybody!

[raminia]

edit includes/functions.php and add
echo $query."<br />"; before
$query = mysql_query( $query ); on line 313
and tell me what you see in addition to warnings

[stip]

just one more line on top,
like this:

show tables from db1020136-stipvisiten like 'pixelpost_addons'

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in visitdresden/pixelpost/includes/functions.php on line 313

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in visitdresden/pixelpost/includes/functions.php on line 359

...the line is 311 in my file, not 313. hope this is not the reason :-)

[raminia]

This is presumed to be fixed. Try
http://forum.pixelpost.org/showpost.php?p=21694&postcount=34
for the fix. I problem persist please notify.