Upgraded from .71 to .82 and have serveral problems!

Having trouble installing serendipity?
Post Reply
imile
Regular
Posts: 9
Joined: Thu Dec 23, 2004 12:59 am

Upgraded from .71 to .82 and have serveral problems!

Post by imile »

At the admin login I receive this error:

Code: Select all

Notice: Undefined index: QUERY_STRING in d:\imakeitlookeasy.com\include\compat.inc.php on line 111

Warning: Cannot modify header information - headers already sent by (output started at d:\imakeitlookeasy.com\include\compat.inc.php:111) in d:\imakeitlookeasy.com\serendipity_admin.php on line 9
And once I log in, I receive this error:

Code: Select all

Warning: mysql_query(): 20 is not a valid MySQL-Link resource in d:\imakeitlookeasy.com\include\db\mysql.inc.php on line 37

Warning: mysql_error(): 20 is not a valid MySQL-Link resource in d:\imakeitlookeasy.com\include\db\mysql.inc.php on line 40
I've tried searching but I haven't had much luck.

Thanks for the help.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Upgraded from .71 to .82 and have serveral problems!

Post by garvinhicking »

The first error happens because your server does not seem to have a $_SERVER['REQUEST_URI'] string. Which webserver and version are you using? And which PHP version?

The second error means that the database setup you entered in your configuration does not seem to work....

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
imile
Regular
Posts: 9
Joined: Thu Dec 23, 2004 12:59 am

Re: Upgraded from .71 to .82 and have serveral problems!

Post by imile »

garvinhicking wrote:The first error happens because your server does not seem to have a $_SERVER['REQUEST_URI'] string. Which webserver and version are you using? And which PHP version?

The second error means that the database setup you entered in your configuration does not seem to work....

Regards,
Garvin
Running IIS 5.1 on Windows 2000 and PHP 5.0.3. You can see my PHP info here

Even though you state that the second error has something to with the database setup, everything loads fine on the /index.php, I just receive these errors towards the admin login however I CAN login.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Upgraded from .71 to .82 and have serveral problems!

Post by garvinhicking »

Thanks a lot. The first issue was because the $_SERVER['QUERY_STRING'] is only set if a query string exists; this is different than in Apache. I#ve committed a fix to our 0.9 SVN repository for this.

You can surround it by setting your PHP errorlevel to E_WARNING only. There might be other areas where E_NOTICE errorlevel might give additional error messages which do no harm.

It might even be that this is also causing the other warning message.

Where exactly do you get that mysql_query error message? Can you make a screenshot? And could you tell me which event plugins you have installed and if you made any modifications to the code?

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
imile
Regular
Posts: 9
Joined: Thu Dec 23, 2004 12:59 am

Re: Upgraded from .71 to .82 and have serveral problems!

Post by imile »

garvinhicking wrote:Thanks a lot. The first issue was because the $_SERVER['QUERY_STRING'] is only set if a query string exists; this is different than in Apache. I#ve committed a fix to our 0.9 SVN repository for this.

You can surround it by setting your PHP errorlevel to E_WARNING only. There might be other areas where E_NOTICE errorlevel might give additional error messages which do no harm.

It might even be that this is also causing the other warning message.

Where exactly do you get that mysql_query error message? Can you make a screenshot? And could you tell me which event plugins you have installed and if you made any modifications to the code?

Regards,
Garvin
Garvin,

Thank you for the quick reply. How would I go about setting my PHP errorlevel to E_WARNING only? I checked my php.ini file where I thought it would be located but I didn't see anything.

You are good, looks like the mysql errors are linked to the sidebar/event plugins. Here is the screen capture of the mysql errors. As you can see from the screen cap, I cannot tell you which event plugins I have installed. Thanks again!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Upgraded from .71 to .82 and have serveral problems!

Post by garvinhicking »

You can change the errorleven in your php.ini via:

Code: Select all

error_reporting  =  E_ALL & ~E_NOTICE & ~E_WARNING
[code]

This would suppress notices and warnings. You may want to only set that for the serendipity try by putting

[code]
php_value error_reporting 2037
into a .htaccess file. This requires a "AllowOverride All" setting for the Serendipity directory - I don'T know how that works with IIS to support .htaccess files.

About the MySQL Errors - on the screenshot, is there anything more on the next page? Because that'S were the interesting event plugins would be listed. At the screenshot the output seems to go on...

Could you remove the "phpStats" sidebar box from your plugin list temporarily? Maybe this is causing the problems.
Which serendipity version are you using, BTW?

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
imile
Regular
Posts: 9
Joined: Thu Dec 23, 2004 12:59 am

Re: Upgraded from .71 to .82 and have serveral problems!

Post by imile »

garvinhicking wrote:
Could you remove the "phpStats" sidebar box from your plugin list temporarily? Maybe this is causing the problems.
Regards,
Garvin
I'm running .8.2 and removing the phpStats sidebar fixed the problem. I going to change my php.ini file right now and I will post back with results.
imile
Regular
Posts: 9
Joined: Thu Dec 23, 2004 12:59 am

Re: Upgraded from .71 to .82 and have serveral problems!

Post by imile »

garvinhicking wrote:You can change the errorleven in your php.ini via:

Code: Select all

error_reporting  =  E_ALL & ~E_NOTICE & ~E_WARNING
[code]


Regards,
Garvin[/quote]

Changing that errorlevel in my php.ini file stopped the errors at the login screen.  Thanks again for the help.  And a small note to anyone who might have this problem too, you do not need to restart the php service or reboot windows if you edit the php.ini file.

Thank again!
Post Reply