franck: thanks again for your help.  Those are all potential ideas, thanks.  Interesting how I can't seem to do a simple "include" of wiki code into the center column without being constrained by the module dimensions.  I'll keep looking...  Thanks again.
franck:  this seems to do it:   {INCLUDE(page=>Nav)}{INCLUDE}       yeah!
Petjal2: yes that too ;)
:)
Isn't there an on/off switch for the wiki page "saved by" message (2.0)? I can't find it on wiki admin page.
This message should be optional, I think (not sure what the purpose of it is, really).
Apart from the version number, it just repeats information that is/can be displayed already at page bottom.
hello all...getting a new database error on stats....http://sh.nu/p/24799
vers 2.0
jcyrisse, It works ok for me. I wonder if your db needs an update.
i just upgraded...like 2 days ago
think i need to run scripts again?
on the db?
I haven't seen this error in any 2.0 version, so it's not a bug, that I know of.
So maybe your installation is not complete in some way.
oh geese
go figure
ok...think of me as a 3rd grader...how do i troubleshoot it? rerun the 1.9-2.0 scripts? and the sec db script?
It isn't clear to me what the db error is. http://sh.nu/p/24799 shows the full error message?
I don't know what the secdb script is for. I haven't used it, only 1.9-2.0.
yes...that is all i am seeing
You could verify that the tiki_stats table structure in tiki.sql file is the same as what's in your db.
(just look and compare, I mean)
Do you have phpmyadmin on your server, to check the db?
sec...brb
back
you mean do a repair?
No, if a repair was needed, the message would say so. Since it's a query problem, there must be a mismatch between what the stats php file is asking for and what the db has. So maybe the tiki_stats db table is missing something.
(AFAIK -- I'm no expert.)
ok...so how would i know if i was missing something?
heh...think i am missing a programmer brain
Open tiki.sql in a text editor and find tiki_stats. Then look at you db's tiki_stats table using phpmyadmin. See if the structure is the same.
...same column names, etc.
Or just do an update with the Tiki install file.
k
run the 1.9-2.0 update script on that page.
that probably is easiest
Well, if it doesn't help, then you can try the other things.
yes
ok..will try that
Hi all.  How can I (most easily) program a specific banner image to appear in the top or right panel based upon which tw page is being displayed?  Thanks.
Petjal2: that's a little bit complicated...
I thought it might be...
but I suppose you can extract the {$page} name and apply some code...
oh well, I'll save that one for later.
how about this one:  how do I call an image from my gallery into a banner?  I can't seem to get the syntax right.
Petjal2: I would categorise the pages, and use the category to display a particular image...
ooh, that might be easier, huh?
Petjal2: you can use <img src="show_image.php?id=??" >
I'm not sure about the show_image, but the syntax is displayed when you look at an image in the image gallery
I'll try putting something like that in the html block...
for categories, you still need to extract the {$category(?)} variable,,,
how do i remove db/lock to run the db scripts again?
jcyrisse: you need to edit tiki-install.php
k
or restore it, I think now it is saved with a different extension
k...there are two files
one that is tiki-install.php
and the other tiki-install_disable.php
yes delete first one , rename and edit second one
or something like this
Tiki sounds very complicated, judging from your conversation. I guess I am simple-minded. I often just replace the files with new versions and use phpmyadmin sql input to update the db.
(actually never used tiki-install until fairly recently)
well, ok...reran script, and still getting the error
You do have objects (wiki pages, galleries, etc.) to have stats for, right?
(Stupid question, I know)
uhhuh
I just asked because of the query, and it's good not to make assumptions.
I'd try replacing tiki-stats.php, tiki-stats.tpl and lib/stats/ with fresh versions.
when i run the query outside of tw.o i get results
just to make sure the files are all there and not corrupted, etc.
i am worried about maybe some corruption in my image files
checking that
Have you done any customizing of files?
no...not that i recall
i think it has to do with corrupt files
i had some weird things going on with my images so i am thinking that has someting to do with it
anyway..hey...any of you have any experience with the 3d browser>?
i keep getting blank pages
using moreneat.css
to view...but see nothing
It uses a java applet so you need to have java installed on your pc.
yup...have it
my mindmaps show up fine
so, dont think it is a java thing
3d browser has worked and not worked at various times, for me.
Now I'm trying and I'm just getting a blank popup with a busy pointer.
...in Opera. In FF3 the popup closed itself.
hmmm....on the demo site...i was able to view ok...but haven't seen it actually work in my site yet
Yep, seems to depend on the phase of the moon or solar storms or something. ;-)
Correction: popup didn't close in FF3, I just lost track of it. But it's empty.
The applet tag is there, but nothing happened.
ah...gotta be the solar flares
Well, whoever's aware of changes affecting the 3d browser files, etc., would know, but I don't. 
well, maybe someone will read the logs and run across this thread
SVN:  Commit by sept_7 :: r 14123 /branches/experimental/tiki-pdo/ (42 files in 9 dirs): [MRG] Automatic merge, trunk 14089 to 14117  
SVN:  Commit by sept_7 :: r 14124 /branches/experimental/tiki-pdo/ (48 files in 7 dirs): [MRG] Automatic merge, trunk 14117 to 14122  
hi there! a question about tw 1.9.11: it is said in docs for drop-down tracker field that 'If the field is optional, an empty value will be automatically added at the top of the values.', but i set Mandatory field checkbox and empty value still appears as first value in list.
is this a bug or a kind of misunderstanded feature?
Hi all,  I need some advice on, I think, sessions.  I need to set the system so that after a period of time a user is automatically logged out.  Any ideas?
Sorry, period on inactivitly
i think this is in the php.ini: session.gc_maxlifetime
Thanks rick - I'll give it a try.  Got another 1.  How do I stop users logging in with the same u/n from 2 locations at the same time?
Does the PMwiki Cookbook work with tikiwiki?
stop logging from 2 locatiosn.... try using cookies
not sure?
in Admin home  :  General Settings, what does Session liftime in minutes" refer to?
... session lifetime?
yeah
it is the session lifetime.
use it to override the session.gc_maxlifetime
see the docs: http://doc.tikiwiki.org/tiki-index.php?page=General%20Admin
Is that like the inactivity question above?  Set the session for 60 mins and at the end it logs out autoatically?
y, i believe that is correct
Thanks - I give it a try
In the bread crumb feature, can the "Location" (1st entry) be changed?
SVN:  Commit by ricks99 :: r 14125 /trunk/ (2 files in 2 dirs): [FIX]fixed typo "maintenance"  
SVN:  Commit by ricks99 :: r 14126 /branches/2.0/ (2 files in 2 dirs): [FIX]fixed typo "maintenance"  
hi all
hi trooper, who left
polom
hi all, i'm trying to get my oracle db working, and it seems that it just might (everything connects fine, theres just some 1450 sql statements that go wrong... :) ). Anyway, what I've run into now is that some of the table names are too long (apparently anything over 30 characters). I was thinking that locally, I can just do that by writing a shell script that searches all the files (I know, a lot) and changes the names of all the table names and su
ch with tiki_ -> tw_, edit_ -> e_, users_->u_, etc., to save room. Would this be enough to change all of them at once and not break tw?
tomekkott: : I don't know
tomekkott:  but it would be most interesting to find a solution for Tiki & Oracle :-)
Are you using latest version of Oracle?
marclaporte: well, the added problem is that my solution requires an old version of oracle, so even if I get it to work, no guarantee it will work for everyone
no, oracle 8i
*sigh*
you mean they don't only force you to use oracle, but a very old version of it?
yup
gotta love universities, huh?
anyway, what do you all think is the best scripting language to go through entire tw dirs looking for all the permission names and table names and such?
and is there a list somewhere of all those names and permissions and such?
PHP, you can use the tokenizer function to parse the files as PHP would
then you can focus on strings or just pieces that matter
In the bread crumb feature, can the "Location" (1st entry) be changed?
here's a question, I somehow got a table name to start with an '_' (which is illegal in Oracle) and now I can't remove it because it is an illegal name
any ideas how to force that?
I don't know of any table in tiki starting with _...
in mysql, you can enclose the token between backquotes and use any name you wish
havn't used oracle in years
hmm, yeah, idon't think it was on purpose, something with me trying to install it must've gotten stuck and sent the "_" as a first char
thanks
SVN:  Commit by lphuberdeau :: r 14128 /trunk/lib/wiki-plugins/ (3 files): [MOD] More info functions  
could someone tell me the difference between KEY and PRIMARY KEY in MySQL? It appears that simply "KEY" isn't supported by oracle 8i, so I'm trying to figure out how best to translate
KEY is an index
no unique constraint
hmmm
moo
moo
What's with dev.tw.o?  Is that appearance due to bad CSS or something?  Looks like big table splattered across the page.  And... not answering to Refresh.
looks fine to me
dev.tw.o still not answering me.
fine to me
info.tw.o is working.  My browser is working.
In case it's a URL issue, I'm trying http://dev.tikiwiki.org/
And now it looks fine to me.
here's a question about databases: if I don't have a KEY, what changes? Speed of access to whatever I'm trying to find?
and secondly, what does a statement such as  "KEY body (body(255))" mean: only use the first 255 characters of the column body (datatype = text) when creating the key?
probably
but yes, it would cause major performance issues
but oracle has indexes, just not named the same way
dev.tw.o search box for "block list" seems to be displaying non-CSS results. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=block+list&where=pages&search=Go
Well, that was strange.
SVN:  Commit by lphuberdeau :: r 14130 /trim/ (6 files in 4 dirs): [NEW] Backup restore/site migration support  
har har
:)
lphuberdeau: yes, but oracle can't index "text" datatypes (which get translated as CLOB)
that can be a problem
tiki abuses text variables... often should be varchars
for the body of an article or wiki, I can sure understand using text
i might just have to pick a size for varchar that works for me
that shouldn't be indexed... really
and translate all text -> varchars
in my conversion script, i might just drop any index that wants to index text
the problem is the size differences
text can hold more than varchar, which is limited to 256 chars or something like that
i see
oh, changed with MySQL 5... limit now 2^16 rather than 2^8
UTF-8 characters take up a byte each, right?
depends on the character
english characters do, because UTF-8 is ASCII compliant
but accentuated characters often take 2
some characters take up to 6 I think
ok, so 2bytes per character would be a good conservative estimate
for a large average of chars
for latin/european languages, average is closer to 1 than 2
they wrote the spec ;)
hehe
actually, it's mostly because asian languages have thousands of characters and they need at least 3 bytes themselves
sure, that makes sense
I think they end up using UTF-32 most of the time
now i just have to figure out how to strip only key's which reference text variables...
you know having a rogue installation of MySQL wouldn't be so hard?
I've been in gov agencies where they did that ;)
well, here's the kicker: their php HAS MYSQL COMPILED IN
THEY JUST WON"T LET ME USE IT
aaaaaarhghasdfhlkasdjfhlaskdjfhaklsdjhfouygole ,mnbv
hehe
bribe them
hmm, bribing university wide webmaster, might send the wrong message...
or go up... to install the application with their requirements, I need X days of work, alternative is free and takes 5 minutes
unfortunately for me, i'm just a grad student
they don't care :(
that can be a problem
but then you are not bound to university hosting
it takes me about an average of 4 days to get a response by email, and emails the only option
i am if our org wants a university subdomain
*it is, rather
Worse: If you are able to bribe your webmaster, you then know you have a webmaster who can be bribed.  Could be bribed by someone else.
too late for me to work on a Friday... taking off
true
You only need the university web server if they won't point a subdomain to a server which works better for you.
tomekkott: Grad student, you are confused.  Universities view grad students as workers, so your complaint about having to do work won't make sense.
i think universities view us more as "peons"
and "cheap labor" 
not really "workers"
i swear i'm not a bitter grad student, i love my program, just dealing with stupid webmasters is annoying
Hmm.  No THUMBDIV plugin on RC4, and BOX isn't showing the image I put inside.
quick php question, $cols = split(",",$var); If there aren't any commas to begin with, can I still do foreach ($cols as $vars) ?
nvmd, it was a different problem
question: when doing the installation for MySQL, each statement that is separated by a ; is written all together to MySQL, not seaprated by lines, right?
or are statements separated via ;\n
Hello! :)
Quite quiet in here. .P
sweet, down to only 700 sql errors from 1500 in oracle... now we can get down to business... :)
alright, gonna take a break tho
haha. :)
hard work.
I'm trying to show a captioned image, and keep getting whitespace to left of image: {BOX(title=>"Glass Molds", float=>right,width=160px)}{THUMB(id=208,float=>right,max=160)}{THUMB}{BOX}
SVN:  Commit by marclaporte :: r 14131 /trunk/templates/tiki-view_articles.tpl: [MOD] Add a tip to add an article if there are none and person is allowed  
Hmm.. I'm not seeing the WYSIWYG editor in Wiki.  Get a big empty pane.  On trunk.
Maybe that only happens when creating a page...
... nope, editing an existing page doesn't show WYSIWYG either, just delays while editor files are loaded and then a blank pane.
The CATEGORY plugin is emitting ~np~ ~/np~ around its output.  Trunk.
BTY: thanks to whoever put the Plugin help in trunk.  Good idea.
always been there, was just hidden a bit
hi all,
is there any way to send an initial value using the tracker plugin, without displaying the input fields for it?
i know about making a field non-public
but then on another wiki page i could not have another form where i would like to display/edit the field.
i guess maybe inserting a hidden input field would help, is this possible?
is it possible to add hidden html form input fields to the tracker plugin?
Hello all