This issue is really a repeat of one I posted on the SSO forum

http://drupal.org/node/632950

But im not really sure its an SSO issue, and since its related to Domain Prefix, thought I would post it here as well.

I have several sites, and I want common pages with different content to have the same url alias. Pages like:

- /about, /advertising /terms-of-use etc.

So rather than

site1.com/about
site2.com/about-0

I need

site1.com/about
site2.com/about

I think this is possible with Domain Prefix, but upon enabling it, selecting "Generate tables as defined below" and create or copy URL alias table (ive tried both) I get this error:

Warning: Unknown column 's.domain' in 'where clause' query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'v6c5kio4q9i6q5n876k88rp712' AND s.domain = 'newdomain.com' in C:\wamp\www\primarydomain.com.au\includes\database.mysqli.inc on line 128

Also get Access Denied.

So it generates a table like domain_15_url_alias in the database, and makes a bunch of entries in the Domain Prefix table, including something like:

domain_id status tablename module source
15 1 sessions system 0

Thats about all the information I have. Just wondering if anyone can shed some light on it. I really need to this working, rather than create aliases like> http://site.com/about-site1.com....

Comments

Netbuddy’s picture

Netbuddy commented

Oh. Should add, that If I do log in... (even though it has Access Denied) I get taken to my SSO controller domain, which is not, obviously the Primary Domain Access domain, nor this new domain. It still shows Access Denied on the page btw, but I can actually get into the administration area of the SSO controller site.

Thats why im not sure which module is causing this problem...

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Closed (duplicate)

I suspect this is related to SSO. I don't know what this query is about, and Domain Prefix would only run it if you tried to prefix the {sessions} table.

SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'v6c5kio4q9i6q5n876k88rp712' AND s.domain = 'newdomain.com'

This looks like a query to get your login information.

It may just be a typo in SSO somewhere. The {sessions} table has a 'hostname' column, but not a 'domain' column.

I could not replicate this just using DA. Marking as duplicate and sending you back to SSO.

kruser’s picture

kruser commented

Netbuddy - did you ever figure out why the table prefixes conflicted with SSO? I'm encountering the exact sames issue. If I remove all my table prefixes, then SSO works.