Forums / Cotonti / General / Trouble with using same user table on two sites

using two or more domains to show unique content

singh336
#29684 2011-05-18 02:30

Yeah, I'm not worried too much about it so much where its necessary to do what I said a few years ago. The idea is cool and  what you've explained should work great.

 

 

What I'm having trouble with now is this:

 

http://streetlegalmods.com/

 

now look at http://www.streetlegalmods.com/

and http://street-legal-mods.com/

 

only the http://www.streetlegalmods.com/ domain is working properly because of whats written in the config.php

Added 4 years later:

To avoid opening another topic, i'll post in this one again.

 

 

So I'm opening a second website along side streetlegalmods.com

 

the new website here streettuningevolutionmods.com

 

I want the two sites to share the users table, groups / ranks etc of course too.

 

What I did was define the prefix's in config.php and the two sites were using the same user table with correct ranks etc everything was fine.

However on the current running public site, something weird was happening.. when I was logged out I noticed that the recent items for example did not update.. it always said for example latest post "58 seconds ago" even if I reloaded the page again 5 minutes later.

 

Further if I logged in, and posted in minichat or forums topic with something, it would show.. but logged back out.. not changes seena nd my posts are not there.. and still it would say last post 58 seconds ago.

 

So what I did was clear disk and internal cache in admin panel of the main site, the two sites dont share same cache dbs, only the user and group related tabes.

 

Clearing the cache worked but it would happen again, only after i switched the DB tables of the second site back to cot_ prefix for example (current site is sed_) then it would work as usual and always update and not get "stuck"

 

why is it doing that ? should I share other tables too like the cache ?

 

I tried with and without auth table shared and i dont think it makes a difference.

 

On top of that I realized with the new site, I can't get forums to show up or page structure.. news works but not forums.

 

Any idea of how to do this the right way ?

Added 34 minutes later:

So what I have realized now with some testing is that

 

The two sites can use the same tables as long as both sites have CACHE set to FALSE in the config php, which really sucks, because I'de like to leave it on, but I do use cloudflare (currently paused until I finish the changes) so maybe it doesn't matter much ?

 

Now the only issue im having is being logged out from one site everytime I'm logged in the other...

I tried sharing the auth table and not sharing it with the two sites, not sure if that even makes a difference..

 

 

Added 1 days later:

okay well turns out I fixed a lot of things by testing.

 

 

I realized that the site id and the key DO have to be the same between both sites

 

i made my cookie domain on both sites to "streetlegalmods.com"

and it was working awesome, both sites can be logged on at once, or just on one site at a time, and they would not affect the other site.

 

 

NOW the big problem, logging on just does NOT work on the new site WHEN "remember me" is selected.. so im thinking something about cookie domain or path is wrong.

 

I have no idea what the cookie path should be set to, does that have anything to do with it possibly? and any ideas what it should be set as for example ?

Added 53 minutes later:

http://www.cotonti.com/forums?m=posts&q=2205

 

found this regarding my issue of not being able to login with remember me checked (not being able to set cookies)

 

deleted the "domain" from the new site in the administration panel and now it works.. just fine too.

 

 

so now some new problems, probably biggest issue right now is why I can't access the "rights" page on a forum for example general discussion:

 

when I click rights in admin panel for this section it tells me this..

 

and now when I try again it works, it was something like bad request parameters :S

 

 

I can't see the forums that I can see when logged into other accounts on the new site, weird. rights look correct too.

Added 4 minutes later:

fixed it by checking the "I" box for the rights under the users rank for that forum section.

 

 

strange... I don't even know what that colum stands for? lol

 

alright, keep pushing now.. can't create a new forum topic because the newspost.tpl is just messed up, maybe something changed i the update and using my old tpl is messing it up. text area is not parsing.

 

just shows "input_textarea_"

Added 58 minutes later:

Okay now my biggest problem, which seems to by my only major issue

 

[img]http://upload.streetlegalmods.com/images/2014/12/12/newtopic.png[/img]

 

 

the newtopic.tpl looks fine but i've replaced it with the default anyways...

 

in dreamweaver it tells me the javascript is wrong or something for the polls but not worried about that right now, even default tpl shows same error.

 

I recently updated to 9.17, maybe thats a reason ? but i've replaced all the system files again, extrafeilds / resources / forms etc

 

something must be wrong internally ? because input_textarea is nothing in the tpl, it is in the system files.. so why does it get stuck there ?

Added 32 seconds later:

http://upload.streetlegalmods.com/images/2014/12/12/newtopic.png

 

apparently html AND bbcodes aren't parasing here :S

Added 1 hours later:

I just want to say the problem seems to be with

 

 

forums.newtopic.php in the modules/forums/inc/ folder

 

the 9.17 version (6.8kb) is just not working for me, 

 

but in 9.15 or 9.16 version, its working fine...

Added 2 days later:

I finally got it working for the most part

 

 

for a person who isn't skilled in php / sql etc i have to say it was very difficult, but i did it. it was one problem after another though, one thing fix would create a bug somewhere else and so on and so on. I can't believe i overcame everything so far and have a working result. its amazing.

 

its too much to explain but if someone is doing the same they can feel free to contact me via the website streetlegalmods.com etc and I can help because lord knows these forums are dead. It's a shame too, brilliant CMF.

<a href="http://www.streetlegalmods.com/">http://www.streetlegalmods.com/</a>
This post was edited by singh336 (2014-12-14 00:55, 9 years ago)