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]
