Loading...
 
Architecture / Installation

Architecture / Installation


No Admin Menu?

posts: 62 United Kingdom

OK so I am a gluton for punishment ( it keeps me out of trouble biggrin )

I had not bothered with TikiWiki previously as I do not use MySQL, but the switch to ADOdb for 1.8 was too tempting to resist. It has taken the best part of the day, but I have a copy of the database running on Firebird1.5, and I've added it to the install screen. Everything is comng up, except I presume that when logging in as admin I should get the admin page?

It forced the change of password OK

I had Menu & Assistant left, and Login right, Admin->Modules worked, and I've added a logo left and a calendar right. Also I can manually access tiki-adminusers and have added a couple more, BUT I am missing the admin home page. When should that have been created? From the *.sql script, or when running install?

I'm sure it is just a missing database entry? but which one confused

posts: 2881 United Kingdom

Hi lsces,

The who admin sections are either accessed by clicking the :: as per the assistant module notes or by Clicking on Admin (Click!) link directly.

Which database have you used, maybe there is a problem with compatibility in the database layer?

Damian


posts: 62 United Kingdom

>The who admin sections are either accessed by clicking the :: as per the assistant >module notes or by Clicking on Admin (Click!) link directly.

Admin is missing from that list - I just have Wiki and Image Galleries

> Which database have you used, maybe there is a problem with compatibility in the
> database layer?

I said frown - I've ported the stuff over to Firebird 1.5 so I may well have a problem in that layer, I've now found the HomePage in "tiki_pages", but I'm not sure what I am looking for next. Either it has not been populated properly ( should there be stuff in the "data" field ? ) , or something else is giving me 'Permission denied you can not view this page' - which is what I am trying to track in the code at the moment wink


posts: 1001 Canada

your report has something strange.
If you can assign modules, you must be logged in as admin, which means you shouldn't see some "Permission denied you can not view this page"
...and you should see the admin menu!
The best thing to do might be to check a movie from TikiMovies to be sure you don't miss something about the interface which is admittedly not the simplest one.
In all cases, if accessing #tikiwiki with ConnectingtoIrc is posible for you, there are good chances you'll get an answer faster.


posts: 62 United Kingdom

OK it's getting late, but I have cracked it.

The ibase module in your copy of ADOdb has a couple of errors, resulting in the field names being flatened to lower case. ( Will post that to both ADOdb list and firebird-php )

Second problem was some missing quotes in one of the SQL statements ( will cross-check that later and post the location )

Third problem. As a result of one and two, the permissions cache had been built with wrong values. All I had to do was delete it and let it rebuild, and we seem to be in business.

NOW to learn how to use it ( after a couple of hours sleep ! )


posts: 62 United Kingdom

OK Just to document these before they get lost.

tikilib.php
Line 366
$query .= " where ttf.`fieldId`=ttif.`fieldId` and ttif.`itemId`=tti.`itemId` and `type`=? and tti.`status`=? and `value`=?";
to
$query .= " where ttf.`fieldId`=ttif.`fieldId` and ttif.`itemId`=tti.`itemId` and ttf.`type`=? and tti.`status`=? and ttif.`value`=?";
While fields are unique, qualifying prevents possible problems later

line 394
$query .= " where ttf.`fieldId`=ttif.`fieldId` and ttif.`itemId`=tti.`itemId` and `type`=? and tti.`status`=? and value=?";
to
$query .= " where ttf.`fieldId`=ttif.`fieldId` and ttif.`itemId`=tti.`itemId` and ttf.`type`=? and tti.`status`=? and ttif.`value`=?";
As above, but problem was the missing `` round value

tikidblib
Add after line 158
case "firebird":

same as postgres and sybase ( at present )

lib/adodb/drivers/adodb-ibase.inc.php
Line 638
$fld->name = strtolower($ibf'alias');
to
$fld->name = $ibf'alias';

I had added Firebird to tiki-install.php, but it is best loaded manually, a rough cut
of a blank database script is attached. It needs a bit more work yet, but will run from the admin tools I have tried. Main problem is that Firebird retains a 255 character limit on Index keys, so a few fields have had to be trimmed, such as 'user' is now (90) rather than (200), but so far everything is working fine!



Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.