problem with smf

Mannie_F · March 19th, 2010, 04:12 PM

I have installed photopost twice now. Both times i have an error Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/******/public_html/art/forums/smf.php on line 151

when i look in that folder there is not even a file smf.php
i cannot login but it sees the users from the forum it says there are 19 users wich is right

Mannie_F · March 19th, 2010, 04:37 PM

ah now i could look in the other post about this and it is fixed. Might be a good idea to change that in the download for new members

Chuck S · March 19th, 2010, 07:31 PM

There is an smf.php file in the forums folder

Are you using smf 1 or smf 2?

Not really sure what you mean by other thread

Mannie_F · March 20th, 2010, 12:44 AM

smf 2, the other thread about smf 2, there was a mistake in install php

Chuck S · March 20th, 2010, 05:49 PM

Line 151 tells me you dont have the correct database info or table prefix entered for smf so it appears you have incorrectly installed the application.

Mannie_F · March 21st, 2010, 03:10 AM

well it was in the install.php where i had to change it to smf2 what was mentioned in the other post. Everything is working now when i did that

Chuck S · March 21st, 2010, 06:57 AM

However since the file says smf.php please reinstall and select smf2 integration so it picks up the proper integration. Yours is set to smf not smf2.

Mannie_F · March 21st, 2010, 07:04 AM

I think there is a communication problem, i had changed that line on install and reinstalled wich worked fine. So consider this solved

Chuck S · March 21st, 2010, 07:45 AM

LOL okay thanks I never see where you said it was resolved and you kept posting so

Rozay · August 9th, 2010, 11:34 AM

Hi Chuck,
I have installed PPC and tried to integrate with existing SMF forum. PPC reads member count right, but there's something wrong. After I log in, it says Login Successful, but in upper right corner its still Login..., so it don't really recognizes me. There's something wrong with the database configuration I guess, but I'm not that good at it...

Chuck S · August 9th, 2010, 12:26 PM

My suggestion is to rerun through install and make sure you have correctly entered your smfcookie name where asked for it on install. You can also check to make sure your cookies in your forum are set like this

cookie path /

cookie domain .yoursite.com

Rozay · August 9th, 2010, 03:36 PM

The cookie settings for PPC must be OK, because when I click "Delete my cookies" under the login fields, it finds SMFCookie463, which exactly matches cookie name shown in SMF admin panel, so it should be set correctly.

I have two options at SMF:
- Enable local storage of cookies (SSI won't work well with this on.)
- Use subdomain independent cookies (turn off local cookies first!)
Any idea which should be thicked?

I still cant find where to look in SMF to find out the cookie path setting...

Rozay · August 9th, 2010, 05:57 PM

I ran a php-check on my domain and I found out these values:

- session.cookie_path /
- session.cookie_domain no value

I guess the second line might explain the issue?

Chuck S · August 9th, 2010, 06:04 PM

I beleive you want to use subdomain independent cookies which should mean it would create a cookie with the domain .yoursite.com which is what you want.

If your cookies do not match between classifieds and smf then you will not be logged into both.