changi|ffa: thx
 New Forum Posts: GROUPSTAT PROBLEM - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=42436
tikiwiki: 03jean-lucnavarro * r38111 10/trunk/lang/fr/language.php: [TRA] more French translations + corrections
tikiwiki: 03jean-lucnavarro * r38112 10/trunk/lib/wiki-plugins/ (wikiplugin_files.php wikiplugin_mediaplayer.php): [FIX] added tra(..)
tikiwiki: 03jonnybradley * r38113 10/branches/8.x/ (2 files in 2 dirs): [FIX] fgals uploads: Don't show wiki syntax link if not in fgal manager mode
tikiwiki: 03jonnybradley * r38114 10/branches/8.x/lib/prefslib.php: [FIX] prefs: Check help for empty() not isset() so as to show info icon for hints (thanks marclaporte)
polom y'all
hi
polom
on whichtable are the custom headers stored ? 
tiki_preferences it should be
y
i wonder how to use the pdf export functions?
Sp4rKy: you might find this table/primer useful: http://bit.ly/9cQi19
I like you guys
oeversetten: you need either a webservice, or wkhtmlpdf installed on ur web server
which are you using?
yes, it says so but wkhtmltopdf does not work quite well and i dont like to use a webservice
it outputs me 0bytes
you are using wkhtmlpdf and you have veriified installation on your server?
yes, i installed it
check error log
which one? that of tiki?
server log.
it says "print_pdf_from_url : none=>webkit"
check for why wkhtmltopdf is producing 0k pdf
hm... looks like url is not being passed....
that i'm not sure :( someone else may come along with more info
tikiwiki: 03jonnybradley * r38115 10/branches/8.x/templates/admin/include_search.tpl: [FIX] prefs: Add missing search prefs to admin panel (could do with some hints & help maybe?)
i dont know if i like wkhtmltopdf, because in command line it outputs nothing if there is no X server, but why having X on a web server?
oeversetten, are you sure it needs the X server running or does it just need libraries from X?
tikiwiki: 03jonnybradley * r38116 10/branches/8.x/lib/prefslib.php: [FIX] prefs: Find trackerfield dynamically generated pref locations, and be more complete in showing plugin pref locations.
i google some, there says "No longer requires an XServer to be running", so maybe my current version is just old
oh. possibly.
oeversetten, you still need X client libs
http://code.google.com/p/wkhtmltopdf/ <- details here
polom all
polom RobertPlummer 
merbster: yes, there i am at the moment
it seems that the version newer than my current are "only" release candidates
Merbster: So you are going to be meeting up with the Tiki group in Germany?
RobertPlummer, I'd like to, but wether I have the time and can argue the relevancy of it for my boss I am not yet sure
Merbster: Let him know that without our help, you wouldn't have gotten very far with this last project.  For an end user/developer, we need use cases to make Tiki better, yours is a great example.  With a few minutes meeting, we can understand better what your needs are.
Merbster: I hope that didn't sound bad. I know you are a very capable developer.
RobertPlummer, I understand what you mean, we say the same when people show up and ask us why we're chatting during work hours ;)
Tell them to join you, perhaps it could speed up development even more.
tikiwiki: 03jonnybradley * r38117 10/trunk/ (15 files in 10 dirs): [MRG] Automatic merge, branches/8.x 38094 to 38116
merbster: newer version is better, but it still shout for some gui to render images
oeversetten, I haven't installed that lib - we run Tiki on Windows - I was just trying to share some of my "general" linux knowhow. 
i try to ask the developer for a workaround
oeversetten, a workaround for what?
it seems not to render images without an open GUI
oeversetten, wouldn't Tiki be that gui?
hehe
I could be wrong - I don't know how it's supposed to be set up - but that is what I'd expect
i estimate it needs a Qt-GUI open
oeversetten, I found ap age on doc.t.o that says PDF generation was removed
oeversetten, http://doc.tiki.org/PDF <- 
?
why?
Says on the page.
You'd probably have to solve hte problem by using Tikis "Show as print" and then use a client side PDF printer - like CutePDF
that is inconvenient :(
oeversetten, imagine the server load when 1000 users start a PDF generation at once
i m used to use ctrl+p and output it in file, but it looks garbage used on wiki pages
hmm
that is the administrators choice ;)
the page says it is removed in tiki 2 but webkit introduced in 6
oeversetten, I just skimmed it
I am busy with debugging what we call "Consultant code"
the old pdf generation (tiki2) was remvoed due to licensing issues - not compatible with lgpl
hmm, but thanks anyway maybe i try to used cups-pdf instead
hi
xhello
hi sacra and AlRahal (and everyone!)
Hi all, I have a problem with tikiwiki6.3
no need to ask to ask, just ask! :)
ok 
the problem is the following
I have upgraded my a tiki2.4 to tiki6.3 
the site is working 
but,
when I set the option Show PHP ERROR visible to admin only 
I only get a white page no error on the log.
AlRahal: that's sort of a feature ;) what does the error say when it's switched on (or you are admin)?
polom
hi chibaguy 
hi jonnyb
Yes I am the admin
if I am logged in as admin I'm still able to browse the wiki
chibaguy: did you spot my attempt at fixing tabs on tikinewt the other day? (and was it ok?)
but once I log off the wiki is not reachable
AlRahal: down at the bottom somewhere it should say "show errors" (or something) and if you click it a list of error should appear
Yes it does!
one of those presumably is a bad one and killing your tiki for anon
I tink that can be someting related to categories
jonnyb, I didn't check in detail, though I know some of the themes' tab styles are more complicated than they need to be.
jonnyb, was that tabs, or buttons, you fixed?
had a go at buttons a couple of weeks ago, and tabs last week - i don't think either had been updated much since Tiki 6 (or 5 maybe)
tikiwiki: 03jean-lucnavarro * r38118 10/branches/8.x/lang/fr/language.php: [bp/r38111][TRA] more French translations
plomo, i recall discussions several month ago  about "doubt" to keep google map integrated. At two I cannot see sign of this (on the contrary). Can someone tell more about mapping plan for the future in TW ?
yes, jonnyb, it'd be good to have a look again at tabs and try to make the style methods the same for all the themes unless there's a good reason to diverge.
chibaguy: indeed - also buttons...
yes, I was just going to say. I did do some changing for buttons recently.
Bernard1: LP added the google maps layers to the openstreetmap stuff for tiki 8, so they should be back now
jonnyb: good to hear, tks ! 
chibaguy (and all) - How's 8.x looking in IE these days? Just trying it for the first time in ages and it's not great here! (login and search modules on left, not right for a start)
jonnyb, check if IE is in Quirks mode
Also I think IE 9 is actually pleasant
Is it correct that if you activate "MySQL Search (legacy)", then tiki-searchresults.php is used, and if not, then tiki-searchindex.php is used?
thanks Merbster (been a while since i experienced the pain of IE...)
Did anyone of you encounter a problem when trying to debug "virtual applications" in IIS with Xdebug?
chibaguy, I can confirm that
yes, it's gone into quirks mode, but usually there's a reason for that isn't there? like doctype errors
jonnyb, you can define it yourself
Mine has never entered quirks mode automatically - atleast not in 9
I'm asking because search-results though simpler is a little nicer looking and search-index, I think, would be kind of scary to people accustomed to google, etc.
chibaguy, it's possible to style both - it was SJ-Jay who did it though
Oh, I see. OK.
i'm still in 8 for extra pain! :) (and it looks fine on non-quirks mode - maybe i left it in that mode ages ago)
Merbster: what are "virtual applications"?
jonnyb, masochist
jonnyb, it's a weird IIS concept
that would be a no for me then :)
jonnyb, I just checked in IE today, about the wide code page, but haven't actually looked with IE for quite a while.
but basically it means if you want to execute a script placed in /lib/mySpeciealFolder/myScript.php - you have to mark /lib/mySpecialFolder as a "virtual application" in order for IIS to allow PHP execution directly
jonnyb, what happens is that you can change settings for that individual virtual application - but a side effect is that XDebug is being screwed by it
a Microsoft OS and browser is enough self inflicted misery for me for now, thanks
last time I had IIS trouble I went to ##iis but that channel is deserted now
lol
On tiki-searchindex.php, what is the purpose of the "categories" textfield, is "lookup" the same meaning as "search" or "find", and what does checking "Deep search" do? If a person has searched with the module search form, then it is a bit strange to me to arrive at the search results and see these new fields.
chibaguy, if you are running a tiki version that you have upgraded across generations you might have two search modules
one from 6 and one from 7
the one from 7 mirrors the Unified Search options
but can be customized (when including the module) too look liek the old one
This is a new install I'm using.
chibaguy: lookup make a category or tag picker dialog appear
But what does the user think about the search results that are already displayed, after doing a search from the module? What is the reason for making a category or tag picker appear?
I mean was the first search not complete, or something?
chibaguy, I guess it is for further filtering
I see.
hmm, well i suppose it lets you fine tune your search
it's some new GUI stuff that needs feedback and improvement
I think some explanation would be good, like "Search results are below. To filter/fine tune your search..do this...." or something.
Our consultant wrote code to automatically create wiki pages based on data froma  webservice. But it fails silently, uses mysql_query and it's not OO... And my debugger doesn't work... *sigh*
chibaguy, I agree  - but I think it's the case alot of places in tiki.
Yes, it's been improved a lot but there are still places.
tikiwiki: 03jonnybradley * r38119 10/branches/8.x/templates/modules/mod-switch_lang.tpl: [FIX] flags: No need for absolute_uri for flag URLs, and it breaks when the address is different from the host name (e.g. using server IP to access). Also was adding an unnecessary / in the path
Does "Categories" in the tiki-searchindex.php form mean Tiki categories?
chibaguy, I would expect it to
chibaguy, in all other scenarios where I have ecnountered categories in relation to Unified Search it has been tiki categories
Right, thanks, I also did a simple test to check.
Do you know what "Deep search" means here?
i think it's search in child categories too
That makes sense.
also content of wikipages
instead of just title etc.
is there any way of deleting more than one category at a time?
Hmm, I think users expect a search to turn up content in page content, not just titles, by default.
Well, it does.
Maybe deep search applies just to category levels.
Hmm, I can't get a term in the page of a category child to show up in search unless "Categories" is left blank. If I indicate the parent category, child category, or both, and with "deep search" on or off, the term in the child never shows up.
The term in the parent category's page does show up though.
chibaguy, I think sylvieg and lphuberdau are the search experts.
(Categories "Red", "Blue" and "Bluechild" which is a child of "Blue", and a wiki page in each with the term "wiki" being the page content of each, so a simple case.)
I'll check with them some time. It's not so important to me right now, but I was just sort of exploring the search feature.
it has evolved ALOT from 7 to 8
tiki 7 x doesn't support search strings with - in them
I recall the talk here about that problem.
tikiwiki: 03jonnybradley * r38120 10/branches/8.x/lib/smarty_tiki/function.icon.php: [FIX] Icons: Calculate the path_prefix for absolute URI or path before the cache name is worked out so icons for the same tiki accessed from different URLs will be cached separately.
Hello
I need help.  I edited a module.  I hit save instead of preview, now the site is blank
nycdwight: sounds like you have invalid code in your module. You'll need to edit it via the database
Do you know how I do that?
Do you have access to the DB? This primer will help: http://bit.ly/ql80Qt
tikiwiki: 03jonnybradley * r38121 10/branches/8.x/lib/wiki-plugins/wikiplugin_code.php: [FIX] code: Remove colors=1 setting geshi setting which seems to cause codemirror to fail
tikiwiki: 03jonnybradley * r38122 10/branches/8.x/lib/modules/tiki-admin_modules.js: [FIX] modules: Don't return null in beforeunload if not modified (as IE thinks it's a string or something)
anyone using Qumana or Ecto as a blog editor successfully with TW?
jonnyb: I'm wondering about with codemirror if I were to make it scrollable rather than line break, would that be an acceptable fix?
So plugin code would just scroll left and right, and the editor as well.
jonnyb: Just like a normal code editor, seems to make sence.
sense.
hi RobertPlummer - isn't that possible only with fixed width objects?
jonnyb: I can manage it, I'm just asking if it'd be a suitable fix.
even for fluid width layouts? (yes, go for it)
jonnyb: What I can do is detect the width at loadtime, jQuery().width();
Then just use that if there isn't a width set for the plugin only.
I could possibly resize on browser resize, not sure if we'd need to go that far with it though.
yes, that sounds feasible...
RobertPlummer: I committed a fix for the fivealive theme today, to prevent the page backgrounds from breaking due to wide code. Fivealive didn't have a width specified.
..for the center column.
So it went way wide.
tikiwiki: 03robertplummer * r38123 10/branches/8.x/ (3 files in 3 dirs): 
tikiwiki: [FIX] draw fixes to ensure the image is saved to a wiki page on postback
tikiwiki: [FIX] renamed the index in plugin draw to make it not conflict with others
I don't know if it's necessary to make codemirror impose scrolling. The useability problem with that is if the area to be scrolled is tall, then the horizontal scrollbar is out of sight, below the bottom of the viewport, if I'm picturing it right.
that's why I don't like the center column scrollable.
be back soon. dog walk time.
chibaguy: Let me see what it looks like with wide scrolling, we can go from there.
polom
I have a problem with the filegalleries in a 8.0 SVN Branches - daily build from today
fabricius: What is going on?
I do not get the "change
I do not get the change file, respectively actions icon
so I can upload a file, but cannot change a files version
I have archive, open in webdav and share a link to this file
next (maybe related) is AJAX
it is switching off by itself
I do not know, if my database - came from a 6.4 - might be broken
#
Robert -> I made a complete v
RobertPlummer: I made a complete clean installation now and it is working
tikiwiki: 03robertplummer * r38124 10/branches/8.x/lib/codemirror_tiki/ (codemirror_tiki.css codemirror_tiki.js): [FIX] Ensuring that there is a max width from parent set, and applying it to object, tested in chrome, firefox, ie 9
jonnyb: I just submitted a fix that really seems to pull codemirror together.
jonnyb: I was thinking "in the box" and your suggestions helped me to look at what was possible with it without making it too complex.
jonnyb: Inherit parent's width if the width of the current object is too wide....
DUH!
thx RobertPlummer - will have a look later (deep in the bowels of smarty now, having a great Monday! ;) )
I need to test it in older firefox and possibly ie 8 and 7, but it looks to be a golden fix. 
jonnyb: Try not to get digested.
trying...
tikiwiki: 03jean-lucnavarro * r38125 10/trunk/lang/fr/language.php: [TRA] more French translations + some corrections
tikiwiki: 03jean-lucnavarro * r38126 10/trunk/lib/wiki-plugins/ (wikiplugin_module.php wikiplugin_realnamelist.php): [FIX] added tra(..) & typo
tikiwiki: 03jean-lucnavarro * r38127 10/branches/8.x/lang/fr/language.php: [bp/r38125][TRA] more French translations
 New Forum Posts: Image Gallery Questions - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=42439
tikiwiki: 03oeversetten * r38128 10/branches/8.x/lang/nds/language.php: [tra] low german on the way
ok can anyone tell me how to easily update from 7.0 to 7.2 without the wory of losing anything ?
my upgrades when very smoothly. be sure to read the 7.0, 7.1 and 7.2 release notes for any possible "gotchas"
why not make a clean installation with a copy of the databese?
I never update the only running db
well yes, ALWAYS backup
I ever take a dump, make up a new db, get a new tiki.zip, unpack on the server and copy the neede files like favicon to the new tiki root
connect to the new database and upgrade that
i like how joomlas updates are you dont have any do anything really it just does it 
files I always store one levelabove the tiki root -> ../files-filegallery ../files-wikiattachmnets etc.
it is just for safety - I am pretty sure, Tiki would do it aswell, but I just prefer the once half an hour upgrade instead of beiing stuck for days if anything get lost without running backup
My original allways stays online, until the updated backup is tested - then I switch around and the original will be renamed as Archive (still up and running)
with joomla I would do about the same
what makes upgrades quick is to avoid saving files in the root of the software
yeah but they have addons that make backups to easy its not even funny this whole tikiwiki interface is so confusing compared to drupal joomla and wordpress and i cant find any external adons like i can for the other three
hehe - we do not have external addons - that's why you do not find them
we do not need
what you r looking for?
ok
mostlikely Tiki should have it
Tiki is "all-in-one"
well im more of a graphic designer so i like it to be simple and easy to style at the same time your syntax is not universal like drupal and joomla are pretty much
what you want to style? even I can customise Tiki not being gafic designer at all - and we'd like to get more grafis pros in our team
I find it quite easy to design Tiki
most of it
quite easy to modify tiki look&feel
and to move around modules 
and to adjust the css
well like modules or the way h1's h2's and so on and to easily use css3 would be great  different options for navigation the templates that are available are ok but if you want to customize it you really need to know the syntax 
pls give an example
there are a few things, where you might need smarty, that's right
but that would be more structural and not only grafical
just standard css... should be quite easy to modify
can also use the CSS assitant to change styles GUI instead. Tiki generates the css for you
polom
polom chealer 
polom chealer
If I check file gallery permissions like this:
$globalperms = Perms::get( array( 'type' => 'file galleries', 'object' => $fileInfo['galleryId'] ) );
What is the proper way of testing if they have view permission?
if ($globalperms->view_file_gallery != 'y') return;?
could be RobertPlummer - i usually have a look in the debugger and check what's come back
it might just be $globalperms->view though
That is what I did.
It seems there is a bug with it.
Sorting it out....
Ok, it was looking for type called "file galleries"
when it is in fact a permissions type of "file gallery"
There should be selectors for those various types to make it easier.
Perms::get( array( 'type' => 'file gallery', 'object' => $fileInfo['galleryId'] ) );  Should be Perms::getFileGallery($id);
agreed - they seem to get defined differently all over the place
It would take about 3 lines of code for each one and everyone would be much happier.
tikiwiki: 03jonnybradley * r38129 10/branches/8.x/lib/core/Tracker/Field/ItemsList.php: [FIX] trackers: Don't use 'id' technique if ItemsList if the "Value Field ID" option (2) is set as it's only checked in the "value" technique section.
tikiwiki: 03chealer * r38130 10/branches/8.x/templates/styles/darkroom/: [KIL] templates/styles/darkroom/ (empty from r26146)
tikiwiki: 03chealer * r38131 10/branches/8.x/templates/styles/feb12/: [KIL] templates/styles/feb12/ (empty from r26146)
tikiwiki: 03chealer * r38132 10/branches/8.x/templates/styles/jqui/: [KIL] templates/styles/jqui/ (empty from r26146)
tikiwiki: 03chealer * r38133 10/branches/8.x/templates/styles/skeleton/: [KIL] templates/styles/skeleton/ (empty from r32361)
tikiwiki: 03chealer * r38134 10/branches/8.x/templates/styles/thenews/: [KIL] templates/styles/thenews/ (empty from r26146)
tikiwiki: 03robertplummer * r38135 10/branches/8.x/lib/wiki-plugins/wikiplugin_draw.php: [FIX] Permissions fix for viewing draw image in page
does anyone see any problem with the SVG thumbnail view in tiki being the svg image scaled down?
I could not yet get SVG displayed as I wanted
me neither i'm afraid RobertPlummer - just uploaded another one and it gets a text icon
I would think that you could just resize it at the php level, has anyone tried that?
you mean using the draw plugin i guess - doing width & height 50% seems to work for me
jonnyb: ooh, congrats for fixing Tiki8's layout!
hi chealer - chucked it a the w3 validator and it complained about the <li> and <div>s getting all muddled up there
ok, off out shortly - more tomorrow... bibi
chealer: hi, i'm switching theme and tv
don't get any time yesterday to do it sorry
hi everyone! i upgraded from version 7.1 to 8.0 beta and now i get this error message: "Fatal error: Call to undefined method TikiLib::list_slide_styles() in /home/tiki/www/lib/prefs/slide.php on line 12" - any idea?
sipherdee: lib/prefs/slide.php doesn't exist anymore
sipherdee: did you clear tiki caches after the upgrade?
have to go
bye all
hi changi|ffa!
changi|ffa: ok, there is probably still a reference to it somewhere in the code. if i remove the file i get: "Fatal error: Call to a member function list_all_groups() on a non-object in /home/tiki/www/lib/prefs/wikiapproval.php on line 28". i will completely replace the directory structure by the one from the beta archive.
changi|ffa: OK changi|ffa, no problem. let's do it. thanks for fixing Loggar
ricks99: no.
sipherdee: the proper way to upgrade is to remove previous code and add the new code, yes
sometimes refs to old files from prior version will remain.
changi|ffa: I'm semi-busy but will be around. do we start with theme or tv?
themes
have an issue with upgrade SQL
OK
ALTER TABLE `tiki_user_bookmarks_folders` DROP PRIMARY KEY, ADD PRIMARY KEY (`folderId`), ADD KEY `user` (`user`);
doesn't work
because of duplicate primary key
ricks99: it's not a ref to specific files here, it's just Tiki loading all PHP files in some directories, like lib/prefs/
ah.
live and learn
duplicate primary key :-?
yes same Id
thanks changi|ffa, ricks99 and chealer. replacing previous code did the trick!
sipherdee: what do you mean by previous code ? 
changi|ffa: the 7.1 code
changi|ffa: i mean, the code from v7.1.
we have the same folderId for different user
changi|ffa: odd that you're the first to report that.
nobody is using user bookmarks :)
changi|ffa: could you check at which step it fails (dropping, adding the primary key or the other key)?
only mlaporte on themes :)
both because it's in only one step
changi|ffa: yeah, but you see the error in tiki-install I guess. those are usually reported
I did not see that error
ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'
changi|ffa: oh, hum. I guess nobody else has data in it indeed.
changi|ffa: that happens dropping the key?
i think it's when it try to recreate it
I see. I created the patch. I don't know bookmarks internals, did the patch without thinking too much
perhaps it's the AUTO_INCREMENT on folderId that's wrong
Q: 7.2 is the end of the 7.x branch? correct?
ricks99: unless there are security releases, almost certainly
thats what I thought. tx
chealer: i check what is stored in it
i think we can drop the data
I see how that AUTO_INCREMENT worked now: http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html
the thing is it's MyISAM-specific, Arild must have had it on InnoDB
arildb: are you aware that there's a difference between MyISAM and InnoDB about AUTO_INCREMENT columns? "For MyISAM tables, you can specify an AUTO_INCREMENT secondary column in a multiple-column key. See Section 3.6.9, “Using AUTO_INCREMENT”. "
arildb: I imagine it was only done in tiki_user_bookmarks_folders if you only got the error there
it's a useful feature, I'm not sure how to replace it
chealer: No I wasn't. I thought only 1 column was allowed. Do you have the URL you are referring to?
arildb: http://dev.mysql.com/doc/refman/5.1/en/create-table.html has the quote above and links to the URL above
chealer: checking...
chealer: tv is now in tiki8
no problem to upgrade
thanks changi|ffa
tv seems to have survived well for what I know of it
chealer: I was not aware of this difference. Some changes were done in bookmarks and also accounting, I believe to only use a single aiuto_increment column
chealer: yes it seems to be
arildb: what was done on accounting?
chealer: If I recall right there was alos a change there to only use 1 column for the auto_increment PK
arildb: I see 3 possibilities: 1) Revert r37299, won't be good for InnoDB. 2) Removing AUTO_INCREMENT and dealing with it in the code. 3) Putting a normal AUTO_INCREMENT, having it grow faster.
arildb: could you find the patch?
for accounting
chealer: I am trying to understand the problem...
arildb: both 2 and 3 would require to have a more complex migration script to work when several users has folders.
 New Forum Posts: Tracker that allows for multiple selections in one drop-down menu - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=42441
arildb: OK did you check section 3.6.9? I thought what the previous situation did was equivalent to what is done now, but it actually allows the same value for folderId for different users.
s/allows/allowed/
chealer: Yes, I saw it
arildb: so changi got a conflict when attempting to add the primary key on folderId since there are duplicate values
bbl
chealer: I will check a bit...
hello: I need help with twist theme and tikiwiki 6.4. I am getting left column empty, and left column content (col2)  below other content (col1). 
maybe some #xyz {overflow:display; } or so?
Anyone know if there is a way to turn off cache alltogether in tiki?
for developers mode?
I'm trying to get an svg image to create a svg thumbnail, and it is taking forever because caching it taking over.
changi|ffa: could you just skip that patch? we'll need to do a new one anyway. you can remove it if that's easier
chealer: i can leave it so, waiting for the new patch
spreadsheet .js - is there an IRC room on Freenode?
fabricius: You mean jQuery.sheet?
see you all
yes RobertPlummer 
fabricius: I'm the creator of jQuery.sheet
So tiki is as good as any I guess.
or #tikiwiki rather
tikiwiki: 03changi67 * r38136 10/trunk/lib/wiki-plugins/wikiplugin_contributionsdashboard.php: [user:changi:FIX] Remove useless svn properties
did not find a button for switching off caches yet, sorry
you did integrate jQuery.sheet into Tiki or you did write it at all RobertPlummer ?
jQuery.sheet was written apart from tiki
I am pretty sure
jQuery.sheet is a whole different project, and was found by Marc Laporte (as far as I know) and he got me interested in tiki by asking to have it integrated.  jonnyb did most of the initial work, but since 6 I've been the lead.
but Tiki devs sometimes are involved in different than just and only tiki
anyway - I want to get a bit more intl the sheets stuff (as user/admin)
fabricius: Marc integrated it because it offered a newer more refined user interface, graphs, and was written in jQuery.
fabricius: I could use the help, there is plenty to do.
I am not a coder, you know
but I would like to get used to it enough to do training
I have a chance to do my bosses website - already us a Tiki for some of the companies pictures and want to do my timesheets with the Tiki
next would be my consulting website, where I need decent examples for the most amazing features and for the core features
spreadsheet should be there and maybe spreadsheetds from trackes aswell
what help you would need RobertPlummer ?
Someone to be familiar with it would be nice.  And to see how to improve it.
Things that I'd like to see in it are drag and drop selected cells, auto complete, chart builder, sorting.
But there are improvements to be made at the moment with every day use cases.
changi|ffa: so themes is upgraded too? no other problems?
I have played a little bit adding #c1c2 #col2 { display:inline: } (or  overflow:hidden;) and #c1c2 #wrapper #col1.marginleft  { display:inline: } without success. One other hint is really welcome: I am trying to upgrade from tiki-3.1 and i am blocking here.
tikiwiki: 03chealer * r38137 10/branches/8.x/lib/smarty_tiki/function.icon.php: [FIX] "Undefined index: _type" (from r38120)
chealer and changi|ffa: The tiki_user_bookmarks_folders specifies that auto_increment should start at 1. My guess at what's happening is that once the PK is dropped MySQL will reinitialize the auto_increment counter to 1, which causes a conflict when there is data in the table. It is possible to set this counter explicitly by ALTER TABLE tbl_name AUTO_INCREMENT = N. (Can be added to the patch sequence). However, it will fail if N is less than the maxim
um existing folderId value. If this is possible, could we choose N=10000 and assume that it exceeds the most used value for this column?
walter_: maybe you should consider to go straight to 8.0 - since Tiki 7 there have been changes to modules and more stuff -  I am actually developing ón 8 and will use 9 as lts, but not use 6 anymore (I know, 6 is very good, but the upcoming stuff is great)
RobertPlummer: I would need some hints to get strated using the spreadsheets first
chealer and changi|ffa: The patch would then be changed to ALTER TABLE `tiki_user_bookmarks_folders` DROP PRIMARY KEY, AUTO_INCREMENT = 10000, ADD PRIMARY KEY (`folderId`), ADD KEY `user` (`user`);
I am not sure if this will work, but if so it may be a quick and easy solution
fabricius: http://doc.tiki.org/Spreadsheet
RobertPlummer:  some minutes ago, I seem to have understood =SUM(A1;B1)
arildb: that's the problem. [2011-10-10 14:53:16] <changi|ffa> ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'
changi|ffa: right, so manually setting the auto_increment counter to a high value, may work
changi|ffa: Do you have a chance to test the above patch correction?
RobertPlummer: hehe I was eating it, but 1st I am lacking some basic knowledge which would help me and 2nd the doc doeas not answer all of my questions
arildb: sorry, I meant that's *NOT* the problem
fabricius: Are you new to spreadsheets?
yes
I just know the principle
but not much more
RobertPlummer: for ex. I want to get the value of a subsheet (like table2) into the first sheet and calculate with it
chealer: If alter table causes resequencing, maybe it is possible to manually set the new sequence value....
fabricius:  =SHEET2!A1:B2 or =SHEET2!A1
I do not know, what is mainsheet, what subsheet and how to link between the subsheets/tables
It is pretty intuitive to add a sheet.
ah THATS stuff I need
You click the "+" button at the bottom.
arildb: the problem is not the new sequence value. the failure happens on conversion and is caused by duplicate keys
bottom of the spreadsheet.
where I find the numbers? just count?
arildb: did you see what I wrote earlier? "I thought what the previous situation did was equivalent to what is done now, but it actually allows the same value for folderId for different users."
so default SHEET is always 1?
and then count like I made them?
would be kind of obvious
what means the "!"?
just like "take it from there"?
chealer: So we have duplicate folderIds....:-( 
arildb: right
in some installations, which is why we didn't see the problem (we didn't test user bookmarks)
RobertPlummer: next would be the question how to calculate with tracker items (I know the point spreadsheet from tracker - but didn figure out yet how to calculate from there)
fabricius: What version are you on of tiki?
fabricius: It is the same as a instance of sheet, sheets within an instance can call each other.
sorry, let me amend the options I see.
8.0 SVN BRANCHES Daily Build from 10th Oct 11
fabricius: so =SHEET2!A1 doesn't matter if sheet 2 is a file, tracker, or spreadsheet.
All are the same.
chealer: I propose we get rid of the auto_increment and reintroduce the old 2 attribute PK. Then update the code (only add_folder in bookmarklib it seems) to manually increment FolderId
a file?
arildb: 3 possibilities: 1) Revert r37299. 2) Removing AUTO_INCREMENT and generating identifiers in the code. 3) Putting a normal AUTO_INCREMENT, having it grow faster.
you mean a spreadsheet file, not a text or a picture - that must matter!?
1) is bad for InnoDB. 2) requires more changes to the code. 3) requires to have a more complex migration script to work when several users has folders.
chealer: I think 2 is the lesser evil
RobertPlummer: and with what values of the tracker I can calculate? - would it be possible with "date and time"? whoo ... or do I need numeric values?
chealer: would the change requirement be contianed to add_folder, or do you see some side-effects? 
fabricius: That is an area where we need some more help for it to work correctly.
fabricius: Yes and no, dates if in formulas are going to probably work fine, but in remote cells they will not.
Another area is globalisation that needs some attention.
arildb: I know nothing of bookmarklib, but I guess it's very likely add_folder is the only place affected
arildb: I'm OK with 2
chealer: Was the only insert I could find for that table
RobertPlummer: globalisation?
robert
fabricius: date detection, and then things like month/day/year for united states, day/month/year for others depending on your local.
fabricius: jQuery recently came out with a nice lib that handles it all very nice.
I'd like to integrate it.
a coresponding with languages somehow
+
r
chealer: How will we revert the old DB patch? Should we simply delete it, since this is still not a released version? I assume we cannot keep it, since it causes update problems... 
arildb: could you take care of the code? I'll deal with schema updates.
chealer: yes
RobertPlummer: I did setup a tracker -> 4 fields: text (day) /date and time (time1) / date and time (time2) / text (hours)
2 items I did create
thanks. yes, I'll delete it and see if it deserves a script for recent installs
day 1 - 4. oct. 10:00 to 19:00 and 6. oct 11:00 to 19:00
sorry for unclear misstyping
day 1: 4. oct. 10:00 to 19:00 ... and ... day 2: 6. oct 11:00 to 19:00
then I made a spreadsheet and in SHEET2! I di integrate this tracker
arildb: so what was the accounting patch you were referring to?
chealer: If I recall right a similar change was done there
arildb: OK, well, if you can find it, let me know
in SHEET1! I calculate the SUM of =-SHEET2!B2 and =SHEET2!C2 wich makes -> -1317898800 + 1317927600 = 28800
next field I divide through 3600 and get 8
this would be an appropriate result for day 2
but where is day 1? it is not shown in the Spreadsheet - neither in SHEET1! nor in SHEET2!
RobertPlummer: #
fabricius: Is it the very first line possibly being overwritten?
RobertPlummer: line1 is "day, time1, time2, hours" / line2 is values from day2 - values from day1 are missing in the spreadsheet
so I have only 2 instead of three lines
but it is the 2nd line of the tracker (the first line with values) that is missing
RobertPlummer: and I cannot edit the trackerSHEET2! at all 
fabricius: Can you send me a couple screen caps?
robert@tiki.org?
jupi
if you want, you can have a look for yourself aswell - but screenies I'll do aswell
fabricius: tiki 8.0 is beta. I would prefer taking 7.2. I will try 7.2
walter_: yes, you can do that - upgrade from 7 to 8 is easier than from 6 to 7 regarding to css stuff
tikiwiki: 03xavidp * r38138 10/branches/proposals/6.x/lang/ca/language.php: Daily reports and a few other strings translated
RobertPlummer: mail is sent
tikiwiki: 03xavidp * r38139 10/branches/7.x/lang/ca/language.php: Daily reports and a few other strings translated
tikiwiki: 03xavidp * r38140 10/branches/8.x/lang/ca/language.php: Daily reports and a few other strings translated
arildb: I committed r38141. is the bookmarklib part progressing?
chealer: yes, testing now
tikiwiki: 03xavidp * r38142 10/branches/8.x/lang/ca/language.js: a few js strings translated
 RobertPlummer another problem: the reference to the tracker has been SHEET2! -> but when I add more subsheets, the reference counts up:
one more subsheet .+
and it will be SHEET3!
fabricius: It doens't dynamically rename.
It should
and one more will make it SHEET4! and so on
But the feature isn't built in yet,
that means, I have to redo all the formulars in my first sheet in wich I did refer to the tracker
formulas I mean
tikiwiki: 03xavidp * r38143 10/branches/7.x/lang/ca/language.js: a few js strings translated (and probably used also in tiki7, even if it was difficult to know for sure, since they were not in the corresponding ./lang/en/language.js)
chealer: strange, but your commit r38141 did not get listed here 40 and 42 are
tikiwiki: 03robertplummer * r38144 10/branches/8.x/ (lib/wiki-plugins/wikiplugin_draw.php tiki-edit_draw.php): 
tikiwiki: [FIX] Permissions in edit draw
tikiwiki: [FIX] Icon for draw plugin
arildb: yeah, CIA is not so reliable, sometimes it dumps commit with a delay
RobertPlummer: I also cannot delete the subsheet for the tracker (for ex. to make a new one)
Ah I can delete - found it undr edit
tikiwiki: 03arildb * r38145 10/branches/8.x/lib/bookmarks/bookmarklib.php: [FIX] Compliments r38141. Manually increment folderId
chealer: there are more strange cases, which don't seem to cause a problem, e.g. tiki_freetagged_objects which also has a multi-attribute PK with auto increment
arildb: did you consider a WHERE user for the SELECT that determine the current maximum?
arildb: in any case, thanks for compliment, I think that will work, although a complement would have sufficed ;-)
chealer: No, I didn't, but maybe I should have done
:-)
arildb: seems to work. I'll look at the WHERE
chealer: tiki_menu_languages is another case
chealer: where...thanks
arildb: ah, I suppose that the difference with tiki_menu_languages is that menuId (the AUTO_INCREMENT column) is first in the primary key
whereas in bookmark folers it's a "subkey" of user
chealer: yes, I think you are on to something there
chealer: first comment on http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html mentions this
arildb: yes, I guess that comment explains both cases (as tiki_freetagged_objects has a tagId key)
chealer: yes...I still believe there was another problem case though...but I cannot find it
chealer: I found the cases. They involve tiki_acct_journal and several other accounting tables. However, they seem to be intermediate changes between 7.x and 8.x, thus not present in any of the releases. So, I believe it's no problem
polom
hi chibaguy, isn't it too late/early there ? :)
tikiwiki: 03chealer * r38146 10/branches/8.x/lib/bookmarks/bookmarklib.php: Bookmarklib: Calculate the maximum folderId for the current user only in add_folder()
arildb: OK, thanks. yeah, I think these issues were fixed by http://sourceforge.net/apps/trac/tikiwiki/changeset/34899
arildb: I think that case is solved :-)
thanks
changi|ffa: thanks for reporting the bookmarks issue. it should be solved now if you can retry upgrading.
chealer: That change is 4 months old, i.e. before I joined the Tiki team...so I think there was something lingering on that had to be corrected later. However, still no problem.
arildb: well, that change only made it into 7.1, which was released on August 1st, so maybe you had the problem with 7.0
chealer: not sure. It doesn't really matter. Case closed
polom
is there actually a wiki plugin that trailers a certain row of wikipages? mean, given a row of pages and then displays the first, say 60, characters of the pages?
I have found my problem: I am a multitiki site using twist theme. I edit css, it is created into styles/myDomain/twist.css. And look and feel is damaged. It is partially restored when I copied all directory styles/twist to styles/myDomain/twist. what must I do ? have you any sugestions ? I have also copied all styles/*css to styles/myDomain, without success.
found plugin, good night
may be must I edit styles/myDomain/*css and replace each styles/xyz with styles/myDomain/xyz ?