The repligard tgz is supposed to have the 'other user' in it try
zcat nadmin_141_core.xmglz | grep "<person " -3
By the looks of repligard is failing to add this person and leaving the records
hanging without a person record.
I think the ideal fix to this is to have the person record blank on export, and have
repligard assume if the person field is blank, then set the person to the repligard
authenticated user..
thoughts..
(in summary the fix is..)
update page set author = 1 where sitegroup=0;
regards
alan
Nicolas Desir <[EMAIL PROTECTED]> Forwarded From:
> Hello, I do it for Cedric
>
> > Try posting the results to
> > SELECT * FROM host;
> > SELECT id,name FROM page WHERE up=0 AND sitegroup=0
> > SELECT * FROM style WHERE up=0 AND sitegroup=0
>
> Meanwhile I had a look deeper on the tables and replay
> by hand all sql requests made when trying to access /nadmin :
>
> SELECT id,style,root,info&1,Length(prefix),sitegroup FROM host
> WHERE name='fox.yntra.net' AND port IN (0,80) AND
>prefix=Left('/nadmin/',Length(prefix))
> AND IF(8>=Length(prefix),MID('/nadmin/',1+Length(prefix),1) IN ('','/'),0)=1 AND
> online=1 ORDER BY prefix DESC, port DESC
> +----+-------+------+--------+----------------+-----------+
> | id | style | root | info&1 | Length(prefix) | sitegroup |
> +----+-------+------+--------+----------------+-----------+
> | 23 | 4 | 43 | 0 | 7 | 0 |
> +----+-------+------+--------+----------------+-----------+
> 1 row in set (0.00 sec)
>
> SELECT info&2 FROM page WHERE id=43
> +--------+
> | info&2 |
> +--------+
> | 0 |
> +--------+
> 1 row in set (0.00 sec)
>
> SELECT name,value FROM pageelement WHERE page=43 AND info&1=1
> Empty set (0.00 sec)
>
> SELECT name,value FROM pageelement WHERE page=43 AND info&1=0
> Empty set (0.00 sec)
>
> SELECT title,content,author,style,info&1 FROM page WHERE id=43
>
>+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-------+--------+
> | title |
> content
>
> | author | style | info&1 |
>
>+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-------+--------+
> | Nadmin Studio 1.4.1 | <?
> if ($logout=="Y")
> {
> SetCookie("midgardauth","0", "", "/");
> if ($returnpath)
> {
> header ("Location: $returnpath");
> exit;
> }
> }
> ?><[login]>
>
> | 2 | 3 | 0 |
>
>+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-------+--------+
> 1 row in set (0.00 sec)
>
>
> SELECT CONCAT(firstname,' ',lastname) FROM person WHERE id=2
> Empty set (0.00 sec)
>
> So If I understand nadmin root page was orphelin...
> mysql> update page set author = 1 where id = 43;
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
> And I had the login again but the root page wasn't the only one:
> nadmin/newframeset/ 404 Not Found
> (I saved all id with author set to 2 before)
> mysql> update page set author = 1 where author=2;
> Query OK, 32 rows affected (0.00 sec)
> Rows matched: 32 Changed: 32 Warnings: 0
>
> So now it seems to work, Cedric can you confirm?
>
> My question is: why all nadmin pages had their author
> set to 2 which didn't exist?
>
> Thx
>
> Nicolas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
