oh, ok i can add the title part to the code also title param is reserved for title attribute of the link... you can try {img fileId=1 title="View Full Version" thumb rel="shadowbox;type=img;title=My Picture Title"} maybe we can change to support caption param instead of the title in rel we have a desc param in wikiplugin_img ok, than that can be used but isn't it what displays under the image in table ? humm... :-/ polom yes it is polom tikiwiki: 03luciash * r22189 10/trunk/lib/jquery_tiki/tiki-jquery.js: [FIX] ColorBox: support any *box (colorbox|lightbox|shadowbox|box...) in rel attribute i am not sure i like to display the file gallery file description under the thumbnails on the page luciash: is it shadowbox or shadowbox[g] that should be used in rel attribute what would you like? now it can be box is the [g] necessary? shouldn't it be colobox now? (and default to doing all on a page as a gallery?) the [g] was there for shadowbox (or anything inside the [...]) to group items in one "gallery" the [g] is to group them together as a gallery got it hi jonny colorbox by default recognizes by class="colorbox" but i have done compatibility modifications so it will recognize also any rel="shadowbox" or rel="colorbox" etc. marclaporte: was saying shadowbox[g];type=img looks untidy (i agree) hehe why don't we do just 'box' as the rel? so now it can be {img fileId=1 thumb rel=box} or whatever thumb=box if it works better as you wish it's thumb=shadowbox now more future-proof? (as if!) i'll change to thumb=box but maybe i would prefer rel=box as people used to it can add that too why not {img fileId=1 thumb=1 rel=box} ? and can you change the rel thingy? (from colorbox to box) thumb= is the {img} plugin param i think jonnyb: see my last commit rel is a link attr mind you, i should be in bed again... ;) it just doesn't work with an "ox" ;) jonnyb: how do you default to doing all on a page as a gallery? would that be set in jquery or wikiplugin_img? hmmm, not sure it's a tiki-jquery.js thing i think colorbox does group by same rel so if you do rel=box all the images on the page will be in same gallery although some of it has leaked into header_jquery.tpl i think it might "just work" :D i've done an autocomplete for group inputs, but think i'll review it tomorrow before committing (eyes a bit stingy) lindon_: i think better will be rel=box and not thumb=box, because user might want to display an image from image gallery linking somewhere else and diplay the target loation in the colorbox so he would do {img fileId=1 link=somewhere rel=box} without wanting thumb param there's no need for {img} plugin to refer to shadowbox, is there? whatever they put in the rel param overrides the thumb param i mean, no legacy reasons? no with {img fileId=1 link=somewhere rel=box} , the initial image will not be a thumbnail it will be the original true lindon_: i just tried {img fileId=1 thumb=shadowbox rel=shadowbox} and my FF is frozen by JS :( but correct it should spot duplicated rels not good :( lindon_: yes, i put the example sometimes people don't want to display the thumb but image from gallery directly lindon_: what values does thumb param support now ? so why not just {img fileId=1 rel=shadowbox} damn, localhost default session timeout is too short :-p soon to be {img fileId=1 rel=box}? luciash: y, shadowbox, popup, plain, browse, browsepopup jonnyb: because thumb is better default behaviour when inserting images using the icon from file gallery ah, i meant {img fileId=1 thumb=plain rel=shadowbox} maybe {img fileId=1 thumb=y rel=shadowbox} lindon_: ok, can you just remove the shadowbox from the supported values ? maybe ? i put the group autothing here: http://paste-it.net/public/i776fea/ if anyone wants to play - i'm off to zzzzs, mail me if you try it when rel=box does the job, it doesn't seem to be too cluttered as {img fileId=1 thumb=1 rel=box} and less processing for you in the img plugin ;) will do well, you just have to add &display at the end of the links i guess \that's a question i had when is &display necessary? if you think the direct download dialog is useful on images, you can exchange the thumb param value shadowbox for download to display the image and not to fire the download modal dialog okay, so it only relates to file gallery images good idea on the param switch so the supported thumb param values would become y, download, popup, plain, browse, browsepopup yes it only relates to file gallery images would probably delete plain since y will now be plain instead of defaulting to shadowbox lindon_: thank you ! and don't forget the &thumb ! ;) err, &thumbnail :) tiki-download_file.php?fileId=1&thumbnail thanks for testing! (to display the file gallery thumbnail on the wiki page) won't forget the thumbnails! tikiwiki: 03chealer * r22190 10/trunk/db/ (5 files): [FIX] "DROP TABLE IF EXISTS `tiki_calendar_recurrence`;" failure due to reference from tiki_calendar_items.recurrenceId (regression from r15918) jonnyb: i don't know how to re-generate the tiki-jquery.min.js with my latest changes it's disconnected for now - waiting for a script to minify i left them there to remind me to write one nn tikiwiki: 03chealer * r22191 10/trunk/lib/core/lib/TikiDb/Bridge.php: tikiwiki: [FIX] queryError() (fixes r20205) tikiwiki: Closes: 2788 ( link_cache creates SQL error ) tikiwiki: 03marclaporte * r22192 10/branches/3.0/lang/fr/language.php: [FIX] Translation which was obviously not done in context. tikiwiki: 03luciash * r22193 10/trunk/lib/jquery_tiki/tiki-jquery.js: [FIX] ColorBox: support for inline content tikiwiki: 03chealer * r22194 10/trunk/db/tiki-db-adodb.php: [FIX] ADOdb on PostgreSQL tikiwiki: 03chealer * r22195 10/trunk/installer/installlib.php: tikiwiki: [FIX] DB abstraction: fix update query tikiwiki: +class Installer extends TikiDb_Bridge tikiwiki: [FIX] empty queries fail on PostgreSQL tikiwiki: 03chealer * r22196 10/trunk/installer/installlib.php: runFile(): speed up and simplify tikiwiki: 03chealer * r22197 10/trunk/templates/ (tiki-admin_content_templates.tpl tiki-editpage.tpl): [FIX] HTML special chars encoding tikiwiki: 03chealer * r22198 10/trunk/ (installer/tiki-installer.php tiki-install.php): tikiwiki: [FIX] DB abstraction: fix has_tiki_db() and has_tiki_db_20() tikiwiki: get rid of now unused process_sql_file() and list_tables() tikiwiki: 03chealer * r22199 10/trunk/installer/tiki-installer.php: [FIX] typo "SQLLite" -> "SQLite" tikiwiki: 03luciash * r22200 10/trunk/lib/jquery_tiki/tiki-jquery.js: [FIX] ColorBox: support title attribute of links + simplified functions tikiwiki: 03chealer * r22201 10/trunk/templates/database-connection-error.tpl: [FIX] DB error message display tikiwiki: 03lindonb * r22202 10/trunk/lib/wiki-plugins/wikiplugin_img.php: tikiwiki: [FIX] Use file and image gallery thumbnails when thumb=y. Replace tikiwiki: thumb=shadowbox with rel=box. So now {img fileId=1 thumb=y rel=box} works. Added tikiwiki: 'download' option for thumb parameter to show download dialog box for file tikiwiki: gallery images. tikiwiki: 03chealer * r22204 10/trunk/templates/tiki-pagehistory.tpl: tikiwiki: [FIX] colons inside tr blocks tikiwiki: [FIX] HTML special chars encoding tikiwiki: 03chealer * r22205 10/trunk/lib/wiki/wikilib.php: [FIX] get_user_all_pages() (DB abstraction, PostgreSQL) tikiwiki: 03chealer * r22206 10/trunk/installer/tiki-installer.php: [FIX] DB abstraction (PostgreSQL): fix general settings (admin email, sender email, browser title, secure login) tikiwiki: 03chealer * r22207 10/trunk/templates/tiki-lastchanges.tpl: [FIX] HTML special chars encoding chealer, umm, excuse me if I'm jumping the gun ... did you just fix tiki install for PostgreSQL? btiffin: yes oohh weee. ;) btiffin: well, it's not completely tested yet chealer, I have two more days off (it's 4am now, so...) I'll try it out. I'm keen, it's the showstopper for not dumping MW at work. We're a Postgres shop. Thanks for any and all efforts. btiffin: well, it will need your help too, still quite a few problems tikiwiki: 03lindonb * r22208 10/trunk/lib/wiki-plugins/wikiplugin_img.php: [FIX] Skip old code if rel=box. Other cleanup of prior commit (broke mouseover). tikiwiki: 03chealer * r22209 10/trunk/templates/tiki-admin-include-login.tpl: tikiwiki: [FIX] HTML special chars encoding tikiwiki: [FIX] colons inside tr blocks polom Hi there polom polom marclaporte: final verdice on pgsql for 4.0 freeze? In or out? verdict even. well, if we are strict, out and kissaki updated page but I am flexible ^^ perhaps we'll remove from installer, but have manual install procedure? that was moments before it was said to work in IRC let's find a win-win compromise but the countdown was already 1 day over, so I at least added it... looks stupid, the negative countdown going on but we should completely drop SQlite, Oracle and Sybase code there are other features marked as "experimental", why not this? Oracle & Sybase: because we have no realistic developer base to handle dthacker: because this one is blocking devs to use advanced MySQL stuff (stored procedures, etc.) Kissaki : hehe SQlite is for embedded databases, I don't see a real use case for Tiki -1 for dropping SQLite sqlite use case-embedded install? demos? i see usecase for light tiki sites like blogs or simple wikis marclaporte: once code goes down rabbit hole of specific mysql features, what affect on keeping db-independence? sqlite for low-frequentized sites, small or private servers (hosting at home), if you wanna give it out as a presentation / wiki-information db on a CD or as a download, or if you just want a wiki on your dektop to store Infos and take notes there you have it! :) hehe: show me the code :-) +1 Kissaki marclaporte: code is there, just broken as it was for pgsql ;) well, we'll have to drop it for tiki 4 but why drop it entirely sure, not drop, but say it's not supported remove it from installer dropdown for now, but that's all imho yeah ok, but we need to set a timer we can continue improving the code to support more dbs as it's proof it's not impossible dead code is not cool well, how far is pgsql? mailinglist said that resource issue in the menu was fixed, so it's working, right? it's not that bad, it's only one sql file man ;) marclaporte: ^ I am very proud of your work guys! marclaporte: could you expand a bit on how code for other db's is blocking advanced mysql development? Is it in adodb? a specific tiki area? chealer did help a lot recently chealer, luci, and Kissaki are my heroes! ^^ heh i mean if others can have it, why not us ;) for SUMO, there is talk to use stored procedures to improve performance. Stored procedures can't have DB independance We'd have to maintain in double, triple stored procedures, huh :-p what's that ? it's moving more work to the DB ah caching queries ? or is it different ? *g* which real sites will run PG? themes? well, now i think we should keep pgsql in the installer with all the efforts made recently and people willing to test and help more... we can see how it goes to 4.1 it might be possible to create equivalent stored procedures for some work, but there will be more corner cases we will not state it's fully supported but an option and people can fill bug reports and help eventually tikiwiki: 03frank_p * r22210 10/branches/2.0/lang/de/language.php: translate so lets have those two in the installer for now, the rest keep as it is but remove for installer dropdown s/for/from when will stored procedures start happening? 5.0? tikiwiki: 03frank_p * r22211 10/branches/3.0/lang/de/language.php: translate dthacker: it was just suggestion from SUMO for now iiuc dthacker: no fixed date/decission yet (?) http://dev.tikiwiki.org/Architecture+Suggestions+From+Mozilla#Other marclaporte: you wanna dogfood pgsql on themes ? "Stored procs are not used on purpose because they prevent database abstraction. At least, this was the case before. Imposing a limitation to MySQL 5 is not much of a problem anymore. However, with the come-back of PgSQL, writing procs twice is impractical." luciash: we need to Dogfood somewhere, or else it's utopia and we'll have same drama in one year well, I'd like to hear some concrete examples for stored procedures... not that much logic is done directly with the DB data, right? conditional selects and joins should be enough after all marclaporte: we ave to wait for 4.1 i guess for the dogfooding site i think for sure we shouldn't write the procedures twice but maybe generate like we do with tiki.sql now store procedure abstraction layer? Interesting. This is a systemic issue, which requires a systemic approach/solution best would be if it would possible to run all the installation/upgrade/etc. SQL via PHP... then it could reuse the current convert functions why wait? It works or not? :-) :-) would the use of more OO in php help? http://www.php.net/manual/en/pdo.prepared-statements.php wtf is with that headline? nothing about stored procedures on the whole page marclaporte: installation works but not fully all the features and gary wouldn't be much happy i guess with broken parts of the site like file galleries ;) marclaporte: you would need to ask gary if he agrees so nobody can tell me conrete examples for stored procs? :) Kissaki: i hear it for the first time ;) :P job one is clean psql, I think. Then worry about store procs. +1 Kissaki: is manual install documented somewhere? yes the installer does link to it "select db and enter data bla or manually install http://doc.tikiwiki.org/Manual+Installation :) wow, even the upgrade now seemed to work on my pgsql trunk installer, cooool :) luciash: amazing! that never worked before thanks to chealer yes, stored procedures is not short term. But it's something we'll eventually look into if PG is dropped But I am very pleased that you all are not going to let that happen Kissaki & luciash: what are the odds to make it work on http://db.tikiwiki.org/postgresql-trunk/ ? if it's the recent trunk, probably pgsql 7 only a guess though so you think it's because my PG is too old? oh, one little error in the installer but the local.php with pgsql credentials is created mlaporte: i think chealer wrote something about it in the devlist mail mlaporte: if you have another server where you could try with pgsql8 it would be great while you guys are in the installer, did you notice: Installer puts in db/local.php : $dbversion_tiki='2.0'; nope, it puts 4.0 here lol luciash: let's get amette & changi|lunching to set something up on the community server. Because I don't want to upgrade my server at this time back later. if we want to migrate an existing site from mysql to pg (ex.: themes.tikiwiki.org or info.tikiwiki.org): what needs to be done? marclaporte: sure, i thought you have more hostings maybe ;) I'll check versions on my other servers marclaporte: well, maybe we would need to set up a new one... i don't know how to migrate the data from mysql to pgsql is there any i18n.tw.o ? yes but it's unused this could be a great candidate I want to make a translation server there mysql to pgsql we'd have to dump data and parse them in pgsql exporting to an sql script, the installer sql script converter could even work if there's db dependent syntax in the script http://tikiwiki.org/Infrastructure+Team#Setup_i18n.tikiwiki.org_with_PostgreSQL dthacker, Kissaki, luciash, changi|lunching ^^ :) tikiwiki: 03jonnybradley * r22212 10/trunk/ (2 files in 2 dirs): tikiwiki: [FIX] Add sefurl to img. tikiwiki: Had the change order of regexp matches to pick up tumbnail etc before download. tikiwiki: 03jonnybradley * r22213 10/trunk/lib/ (jquery_tiki/tiki-jquery.js wiki-plugins/wikiplugin_img.php): [FIX] No need for rel to have type=img for colorbox (type= only needed if not an image) Kissaki : & luciash: I sent chealer password of db.tikiwiki.org for PG testing jonnyb: are you sure ? by default colorbox doesn't treat links as images, does it ? jonnyb: i mean if they don't end *jpg or something chealer seems to be quite good with PG i added a clause to the photo:true code in tiki-jquery.js marclaporte: sure jonnyb: ah, cool works for me i will test it jonnyb: what are you up to next? group name autocomplete i have it working but rtying to add some perms checking (with LP's help) can i install multitiki and install a different profile on each ? just curious hiAll! anyone familiar with menu maintenance? why is a section 1 level menu item with no options under it tries to open a new empty level under itself? next menuitem is a section1 too, looks weird..check out two "Community" menu it is me who is currently messing it up :) but will roll back if this is the above written is the expected behaviour (which is strange for me) hiYou! gezza: when using cssmenus it must be option instead of section level it's logical "Community" menuitem is section 0 "Teams" was "option" wow, that was the trick, thanks! :) tikiwiki: 03jonnybradley * r22214 10/trunk/ (3 files in 3 dirs): tikiwiki: [ENH] Add autocomplete to group name fields. tikiwiki: Implemented in wikiplugin_group only so far (just add 'filter' => 'username' to the param def). tikiwiki: Proper perms checking TODO but only works for validated users in the meantime. marclaporte: the issue with $dbversion_tiki='2.0'; seems to be for upgraded sites ah I see on one upgraded to trunk i have $dbversion_tiki='3.0'; gezza: anything else you wish that they provided? for me they are fine, unlimited space, dbs, can install tiki without fantastico too, helpdesk was quick&good nice thanks, they seem a little more expensive than other hosts like bluehost any thoughts? marclaporte: what is function of packaging scripts? Create generic bundle? http://dev.tikiwiki.org/How+to+release gezza: what? stored procedures in DBMS, as discussed/mentioned above tikiwiki: 03jonnybradley * r22215 10/trunk/ (lib/tiki-js.js tiki-ajax_services.php): tikiwiki: [ENH] Add autocomplete to user name fields. tikiwiki: Implemented in wikiplugin_group only so far (just add 'filter' => 'username' to the param def). tikiwiki: Perms TODO as for groups. marclaporte: I just tried with pgsql 7 on debian in a VirtualMachine, VirtualBox and had the same problem as on your box. I just can't connect to the db, not even with pgAdmin locally sorta like your problem, if that is it... ^^ strange if you write a simple php app, doesn it connect? I even installed pgAdmin3, made by pgsql devs as an admin GUI and can't seem to connect to localhost via that port, which even "/etc/init.d/postgresql-7.4 status" tells me it uses so I won't even try a "simple php app" hehe are there any pg apps you can apt-get install? maybe it's a setting... Kissaki: i was guided by https://help.ubuntu.com/community/PostgreSQL but i have pgsql 8.x on my ubuntu do we have demo sites for fresh install + profile ? jonnyb: did you try toolbars with NoScript? jonnyb : I still see tools and they just make the page refresh not yet i'm afraid - you? hmm - one for next week :) heh :-) no rush I still don't get how to do a replace with toolbar oh? :( you found the tool? marclaporte: I can run scripts as mentioned on that page. sort of a b>a icon (blue) ok, found it looks fine (better than the Blog one) just entered admin in the Find field automatically ;) then realized login link is down on the page ;) luciash: The connection was reset haha dthacker: ok, so you would be official packager! Kissaki: oh ? weird ooo. pressure's on. :) can you start trying them out? so we can ask Nyloth if we need help marclaporte: do we have a branch yet? or should I pull trunk? just try with trunk ok, I'll start this evening US time. or you can try with 3.3 polom hi luciash marclaporte: for now I have enough to fill my plate with localhost, but thanks for db.tw.o anyway. maybe, one day chealer: no prob Kissaki has "proof" it's not a specific issue of my server and supporting PG 7.4 is not important or I'm just stupid marclaporte: ah, yeah, if it's PG 7, I'm not going to work on it Was just trying to make sure it's not a server issue tikiwiki: 03marclaporte * r22216 10/trunk/ (4 files in 3 dirs): [MOD] Moving find/search and replace admin option from wiki to textarea admin panel now that it's available for any edit box because it would be nice to get PG on shared hosting... I heard PG 7 would be EOLed this year. and I had enough issues with the latest PG software (already 5 bugs reported against PG/phppgadmin) yep, i think we can drop support for pgsql7 and focus on pgsql8 only +1 luciash: the bad thing is when search engines index fullscreen=y and fullscreen=n independantly marclaporte: that should be fixed marclaporte: by adding no robots in meta of the fullscreen page probably and rel=nofollow on the fullscreen icon link sounds to easy to be true :-) my vote: http://dev.tikiwiki.org/How+to+release#To_branch_or_not_to_branch tikiwiki: 03jonnybradley * r22217 10/trunk/ (4 files in 4 dirs): tikiwiki: [MOD] Refactoring autocomplete code. tikiwiki: Left the ones in tracker_item_field_input.tpl as i can't get them to work. tikiwiki: Also one in {textarea} block that will probably be kil'ed what do you think about adding more autocompletes? should we (i) use a class (like .pagename or .username) or attach the jq code directly? tikiwiki: 03chealer * r22218 10/trunk/lib/bookmarks/bookmarklib.php: [FIX] DB abstraction: remove_url() (user left unquoted) class is simpler but slightly (even) more work for the browser on page load tikiwiki: 03chealer * r22219 10/trunk/lib/multilingual/multilinguallib.php: [FIX] DB abstraction: getMissingTranslationBits(), getTranslations() tikiwiki: 03jonnybradley * r22220 10/trunk/lib/ (jquery_tiki/tiki-jquery.js smarty_tiki/block.textarea.php): tikiwiki: [KIL] Remove textarea pagename autocomplete, as it never worked 100% and was quite hacky. tikiwiki: Use the wiki link dialog instead. tikiwiki: 03chealer * r22221 10/trunk/templates/tiki-minical.tpl: [FIX] HTML special chars encoding jonnyb: using class as selector would you get into trouble on which input do the autocomplete if the same class would be two elements on a page ? hi luciash hi ?) i decided on both :) i mean :) hang on... okay tikiwiki: 03jonnybradley * r22222 10/trunk/templates/messu-compose.tpl: [MOD] Add username autocomplete to recipient fields in messu compose btw, i had trouble with autocomplete in the past on the QuickEdit module... didn't try recently but suggesting me pages to edit and was hard to go out of it and create new page with simmilar name like that - so just adding the class selector on a page that needs it, instead of in an include not had that particular one jonnyb: does nothing on essu-compose oh? no autocompletes on the to field? i started to write a for admin and nope i have only admin user there though must it be other user than myself ? dont think so maybe bug with count = 1 what about others? quick edit fincetance is opera compatible browser ? should be quickedit has no autocplt 2 is the feature on? feature_jquery_autocomplete y, all required is on tikiwiki: 03jonnybradley * r22223 10/trunk/lib/jquery_tiki/tiki-jquery.js: [FIX] feature check tikiwiki: 03jonnybradley * r22224 10/trunk/templates/modules/mod-search_wiki_page_new.tpl: [MOD] autocomplete for search page name (new only, refactoring required) any JS errors? it's problem with opera in shiretoko it works (same annoyance when i want to quick-edit "Home" and hit enter it becomes "HomePage") jonnyb: could you please change it so it behaves like autocomplete in browsers ? when you type url and suggests some, it doesn't change on enter but just when you move down and choose from suggestions) that's settable in the options i think this is annoying for users who are used to quickly fill text and enter that would be great so it's working now? (but annoying?) yes, working in shiretoko, not working in Opera i will try to debug with dragonfly in opera if there's some js error ta i'm going to go and eat (preceded by cooking) oh, weird, now it works in Opera when i go to HomePage... there are CSS and JS errors related to jQuery though messu-compose works now too :-p jonnyb: i understand it now why... i already had the dragonfly debug window open in background and have set break on JS errors ;) jonnyb: so there is an error on line 315 of tiki-jquery.js it says New Forum Posts: Year is displayed as 0000 - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=34907 and jquery.async.js not found (404) ok, only the latter one the previous error seems to be old log jonnyb: sorry for false alarms but if you can find that setting and change to behave more politely that would be great, thx hey guys, what is the syntax to display numbers in {maketoc} and headings ? is it not a # or csomething klike that There is a list of parameters in the doc.tikiwiki.org page for maketoc. I wonder if the admin can define default maketoc parameters, so you don't have to specify it on every call on the site. sylvieg: thank you SEWilco2: if maketoc syntax is also plugin now you could have a plugin alias SEWilco2: but the # go to headings anyway Yup. but sure, anything is possible... there is already preference how to display the +/- to expand/collapse !!+Heading iirc luciash: what was that about jquery.async.js? phantom error? or a real one? omfg I'm so utterly stupid I should probably go to bed... know the feeling, Kissaki ;) jonnyb: it seems it is requested from some 3party jquery package but it is missing jonnyb: gives 404 error in js console luciash: have you svn up'ed with externals? jonnyb: aaah :) jonnyb: --ignore-externals ;) that'll be the one jonnyb: btw, colorbox 1.3.1 is out, do we upgrade ? we have 1.2.9 sounds reasonable it fixes some IE errors i think is it just matter of overwriting files and commit ? or are externals handled differently ? basically - and i've been keeping a readme with info about versions no, it works the same - just commits to the external repo from trunk it handles correctly? ok yy that's nice yep, the file was added, tnx yeah, i had a separate working copy for them, but you don't need to :) yup - connects fine fine :) oO don't joke! discriminating! anyway, gn8 tikiwiki: 03sylvieg * r22225 10/trunk/modules/mod-func-change_category.php: [FIX]category: remove was not working with header tikiwiki: 03marclaporte * r22226 10/trunk/templates/tiki-admin-include-look.tpl: [MOD] Move Pagination links to own tab