Site Info using wrong database :/

Worker Joined: Oct 18, 2005 Posts: 127 Location: NYC

Not sure why or what I was suppose to change but didn't:

I installed 2.4 to my second site. Changed the database in the config. Everything else is pulling from the correct database but the Site Info block is reading from the first site database. The second site is displaying users from the first database instead of the second database.... everything else on the site is pulling from the correct second database Confused

Posted: Sat Jun 26, 2010 1:52 pm

Posted: Sat Jun 26, 2010 2:43 pm

is this the same site info block from the current release?

Posted: Sat Jun 26, 2010 5:53 pm

spasticdonkey wrote:

is this the same site info block from the current release?

I updated both of my sites with 2.4 and I am using the the site info block that came with it.

any ideas of what is happening?

Worker Joined: Aug 26, 2007 Posts: 236

Have you tried to empty the cache in the web browser? I always do that when strange things happen.

Posted: Sun Jun 27, 2010 6:24 am

I noticed the block uses $user_prefix and $prefix, are they both set correctly in config.php?

Posted: Sun Jun 27, 2010 6:28 am

slackervaara wrote:

Have you tried to empty the cache in the web browser? I always do that when strange things happen.

I do that all the time. That's not the problem.

It's very strange. The rest of the site is pulling from the correct database, it's just the Site Info block that is pulling from the wrong database Confused

Posted: Sun Jun 27, 2010 7:09 am

we were posting at the same time, in case you missed this...

spasticdonkey wrote:

I noticed the block uses $user_prefix and $prefix, are they both set correctly in config.php?

is this a conversion or a new install? What info is it pulling from the other site? Everything or just some of the data?

Posted: Sun Jun 27, 2010 7:47 am

spasticdonkey wrote:

we were posting at the same time, in case you missed this...

spasticdonkey wrote:

I noticed the block uses $user_prefix and $prefix, are they both set correctly in config.php?

is this a conversion or a new install? What info is it pulling from the other site? Everything or just some of the data?

I'll check that now.

Both sites were upgrades.

It's pulling membership, people online, page hits, etc. All the info that appears in the Site Info block is from the first site and not the second site.

Thanks

JoAnne

Posted: Sun Jun 27, 2010 7:57 am

$user_prefix and $prefix are set correctly in config.php

Confused

Posted: Sun Jun 27, 2010 9:22 am

hmmm, weird.

I would probably try sql logging in rnconfig to try and see exactly what is going on.
$loglevel = 4;

so just to be clear, you upgraded 2 sites and for some reason the site info block is pulling the same info for both sites?

Posted: Sun Jun 27, 2010 9:42 am

spasticdonkey wrote:

so just to be clear, you upgraded 2 sites and for some reason the site info block is pulling the same info for both sites?

Yes that is correct. Has never happened before. I can't figure out why as everything looks correct. I am not an expert by any means.... but I have upgraded several times before, even from non RN versions.

Posted: Sun Jun 27, 2010 10:22 am

spasticdonkey wrote:

I would probably try sql logging in rnconfig to try and see exactly what is going on.
$loglevel = 4;

Set loglevel = 4

rnlogs does not state any errors

this is the only reference to 'Site info'

June 27, 2010, 11:05 am SQL was: SELECT bposition FROM nuke_blocks WHERE title='Site Info v2.2.2'

Doesn't state anywhere from which database it is pulling from

Posted: Sun Jun 27, 2010 10:39 am

I am going to upload that block again from the RN 2.4 download just to see if that makes any difference..... it's the same one but it can't hurt to try it.

Posted: Sun Jun 27, 2010 11:01 am

JoAnne wrote:

I am going to upload that block again from the RN 2.4 download just to see if that makes any difference..... it's the same one but it can't hurt to try it.

Well that didn't help, but no surprises there.

The 'Who's Online' is correct, but the 'Site info' block is stating how many is online at the other site Laughing

very strange Confused

Posted: Sun Jun 27, 2010 11:11 am

Just out of curiosity, try this block instead and see if the results are similar.. [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Jun 27, 2010 1:44 pm

spasticdonkey wrote:

Just out of curiosity, try this block instead and see if the results are similar.. [ Only registered users can see links on this board! Get registered or login! ]

That block is displaying the correct info

Posted: Wed Jun 30, 2010 11:18 am

Will RN Team work on a fix for this? or should I just use the other site block which I will have to customize?

Thank you!

JoAnne

Posted: Wed Jun 30, 2010 9:53 pm

I could never really understand what was causing this behavior. Maybe someone else has an idea? Until we can reproduce it, it's hard to know what to fix Sad

Posted: Thu Jul 01, 2010 4:39 am

spasticdonkey wrote:

I could never really understand what was causing this behavior. Maybe someone else has an idea? Until we can reproduce it, it's hard to know what to fix Sad

Does anyone else have two sites on the same server? A main site and then a second site both using RN 2.4? Maybe then it could be reproduced.

I could add a third test site to see if it is reproduced if that would help. I could give access to my sever and sites to someone on the RN Team as well.

Thanks

JoAnne

Posted: Mon Jul 12, 2010 4:33 am

Could someone at least tell me what was changed in this block because this did not happen until I upgraded?

or if you can't do that does anyone have an older version of this block so I can compare the changes myself?

Thank you

JoAnne

Posted: Mon Jul 12, 2010 5:33 am

The block was not changed as far as I can remember. All I can offer is if you want to give me FTP access to the site I will look at it.