Print Page - Does this look like a database error.

Title: Does this look like a database error.
Post by: hutch-- on July 12, 2005, 03:56:08 AM

I had the current upgrade as 1.0.5

this is what is displaying when going to the URL.

Notice: Only variables should be assigned by reference in /www/m/masmforum/htdocs/simple/Sources/Subs.php on line 232

Notice: Undefined index: is_admin in /www/m/masmforum/htdocs/simple/Sources/Security.php on line 556

Notice: Undefined index: permissions in /www/m/masmforum/htdocs/simple/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /www/m/masmforum/htdocs/simple/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /www/m/masmforum/htdocs/simple/Sources/Subs.php:232)
Notice: Only variables should be assigned by reference in /www/m/masmforum/htdocs/simple/Sources/Subs.php on line 232

It appears they have upgraded to mysql version 4.1 if this matters.

Title: Re: Does this look like a database error.
Post by: theos on July 12, 2005, 05:16:01 AM

I have exactly the same problem!

Hope someone can help us out...

Title: Re: Does this look like a database error.
Post by: [Unknown] on July 12, 2005, 05:39:44 AM

Find in Subs.php:

Code Select

= &mysql_query

And remove the &.

-[Unknown]

Title: Re: Does this look like a database error.
Post by: theos on July 12, 2005, 05:43:15 AM

Thanks!
I already found your solution in another post:

http://www.simplemachines.org/community/index.php?topic=39065.0

:D :D

Title: Re: Does this look like a database error.
Post by: [Unknown] on July 12, 2005, 05:49:20 AM

(just great, now we have to make a release of 1.0.x just for this? Why can't PHP 4.x stay backwards compatible?)

-[Unknown]

Title: Re: Does this look like a database error.
Post by: hutch-- on July 12, 2005, 07:21:48 AM

Thanks [Unknown], The mod worked fine. Who do we shoot, the provider or MySql ? 8)

Title: Re: Does this look like a database error.
Post by: dragon2611 on July 12, 2005, 03:00:15 PM

i just had my friends smf forum go down after updating my server to php 4.4 so i went back to 4.3.11 but as the fix is simple i'll probably be going back to php 4.4 again ;)

Title: Re: Does this look like a database error.
Post by: strongmad on July 12, 2005, 04:10:33 PM

thanks this happend to me after 1.o.5 update, now sorted with subs fix

Title: Re: Does this look like a database error.
Post by: [Unknown] on July 12, 2005, 04:12:09 PM

Quote from: hutch-- on July 12, 2005, 07:21:48 AM
Thanks [Unknown], The mod worked fine. Who do we shoot, the provider or MySql ? 8)

PHP 4.4 is the mischevious one here. Apparently they changed some things to generate error messages that did not before.

-[Unknown]

Title: Re: Does this look like a database error.
Post by: kisii on July 13, 2005, 08:12:07 PM

i have the same problem, I have removed that (&) but i get a different error:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/k/kenyans/htdocs/discussions/Sources/Subs.php on line 1595

Title: Re: Does this look like a database error.
Post by: [Unknown] on July 13, 2005, 08:16:40 PM

Are you using Dreamweaver? Please try a clean copy of the file.

-[Unknown]

Title: Re: Does this look like a database error.
Post by: kisii on July 13, 2005, 08:18:40 PM

yes i am

Title: Re: Does this look like a database error.
Post by: kisii on July 13, 2005, 08:24:29 PM

I have a new sub.php file from from SMF but i get the same error

Title: Re: Does this look like a database error.
Post by: dtm.exe on July 13, 2005, 08:25:45 PM

Quote from: kisii on July 13, 2005, 08:24:29 PM
I have a new sub.php file from from SMF but i get the same error

Try pressing Ctrl + F5 at the error page.

-Dan The Man

Title: Re: Does this look like a database error.
Post by: Chris Cromer on July 13, 2005, 09:49:18 PM

Don't use dreamweaver to edit it if you still are, dreamweaver is the problem. You can use notepad if you are in windows.

Title: Re: Does this look like a database error.
Post by: Lordy on July 14, 2005, 07:38:25 PM

This just fixed the problem on my site too.

PHP version 4.4.0
MySQL version 4.1.11-standard
SMF 1.0.5

Thanks Unknown. 8)

Title: Re: Does this look like a database error.
Post by: deebee on July 17, 2005, 07:29:58 AM

I'm running SMF 1.0.4 on a server that's just been upgraded to php4.4.0. Tried the fix suggested but I'm still getting this error message. Modded the subs.php directly in CuteFTP and it looks fine, no trailing spaces etc.

Any ideas?

Title: Re: Does this look like a database error.
Post by: Ben_S on July 17, 2005, 07:53:50 AM

Try upgrading to 1.0.5, which you should do anyway as 1.0.4 has a security issue.

Title: Re: Does this look like a database error.
Post by: deebee on July 17, 2005, 08:54:04 AM

Hi Ben,

I can't access any aspect of the board including the admin side. All this on my birthday as well!

The error message I get is...

"Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later." Host tells me the server is fine and running OK.

There is just one mod on the board - Mambo-SMF bridge from Mambohacks. Problem is I can't even access the admin side of the board to remove this mod before upgrading to 1.0.5.

Title: Re: Does this look like a database error.
Post by: Meriadoc on July 17, 2005, 09:06:21 AM

Happy birthday! Though sorry this happens on your day.
You can manually upgrade to 1.0.5, you needn't do it from the admin panel.
grab the update/upgrade package from the downloads page (http://www.simplemachines.org/download.php) and FTP the files up, then you can upgrade manually from there.

Title: Re: Does this look like a database error.
Post by: deebee on July 17, 2005, 12:57:02 PM

Will the upgrade package to 1.0.5 which I've just downloaded work on 1.0.4 with a single mod?

The updater package suggested that it would only update 1.0.4 if there were no mods present, that's why I chosen the upgrade installer.

I've backed up all the 1.0.4 forum files and done a sql backup but thougt it wise to ask the question before I attempt the upgrade!

Title: Re: Does this look like a database error.
Post by: deebee on July 17, 2005, 01:35:16 PM

Glad to say I'm back in the board! (forgot to update the settings.php file.....dooh)

Should be able to upgrade now...

Title: Re: Does this look like a database error.
Post by: def9 on July 22, 2005, 03:53:25 PM

Thanks for the fix.

I updated to 1.05 the day you guys released it and just got that error today for the first time.

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: hutch-- on July 12, 2005, 03:56:08 AM