[0:4] benoitg joined #tikiwiki [0:21] ricks99 joined #tikiwiki [0:23] CIA-36 tikiwiki: 03yonixxx * r40253 10/trunk/lang/he/language.php: [TRA] hebrew translation progress [1:31] RobertPlummer joined #tikiwiki [1:48] benoitg joined #tikiwiki [2:47] benoitg1 joined #tikiwiki [2:51] benoitg1 joined #tikiwiki [3:4] goj_killedByISP joined #tikiwiki [3:23] benoitg joined #tikiwiki [3:27] supergreg joined #tikiwiki [6:0] Bernard1 joined #tikiwiki [8:25] fabricius joined #tikiwiki [8:51] Jenser joined #tikiwiki [9:2] Bernard1 joined #tikiwiki [9:5] Jenser left #tikiwiki [9:24] Bernard1 joined #tikiwiki [9:49] xavi1 joined #tikiwiki [10:16] blackbird_ joined #tikiwiki [10:17] blackbird_ g'morning [10:26] xavi joined #tikiwiki [10:33] blackbird_ is there a way to include pages (or parts of it) into other pages? e.g. I created a page about sparrows and now want to create a page about birds and include the page about sparrows? [10:53] xavi blackbird_: see http://doc.tiki.org/PluginInclude [10:55] blackbird_ thnx [11:0] xavi you are welcome [11:6] blast_hardcheese joined #tikiwiki [11:19] Bernard1 Hi blackbird_, xavi ! [11:20] blackbird_ hi Bernard1 [11:20] blackbird_ or as I learned to say: polom! .-) [11:51] xavi hi Bernard1 [11:53] Bernard1 polom blackbird_ [11:53] Bernard1 :) [11:53] Bernard1 Xavi have you ever use mail notification in another language than en ? [11:53] xavi Bernard1: yes [11:55] Bernard1 do you have an sample of use that work, i need some ref. i'm trying to check why i can't get "he" messages [11:59] Bernard1 I mean i use article submission, post and wiki editing = no translation :( [12:6] xavi I'm using proposals/6x... [12:6] xavi let me check... [12:6] Bernard1 tks [12:8] xavi Bernard1: emails from wiki page monitoring just works (the strings that are translated in language.php come translated in the email) [12:9] xavi Bernard1: just play with the tiki settings under "Admin home > multilingual", and ensure that your user has selected the right language preferences under his user preferences, etc. [12:10] Bernard1 ok… that's give me some direction. [12:10] Bernard1 (never used notification b4r) [12:16] xavi read this: http://doc.tiki.org/i18n [12:16] xavi and http://doc.tiki.org/Watch [12:21] rodrigoprimo joined #tikiwiki [12:21] jonnyb joined #tikiwiki [12:22] jonnyb polom [12:22] xavi pom-pom [12:22] xavi how are you jonnyb? [12:22] * jonnyb is glad to finally be back at home [12:22] jonnyb :) [12:22] xavi still somewhere up north uk? [12:23] xavi ah, ok [12:23] jonnyb no, back [12:23] * xavi should read all messages before writing on irc [12:23] ricks99 joined #tikiwiki [12:23] CIA-36 tikiwiki: 03jonnybradley * r40254 10/trunk/lib/smarty_tiki/function.icon.php: [FIX] icons: Tidier reporting of smarty security errors [12:23] jonnyb hi ricks99 too [12:24] ricks99 polom y'all [12:24] jonnyb xavi: did you get a chance to re-check the structures admin fixes? [12:24] xavi btw, jonnyb, after more than 2 years looking around, I finally found something like the usb device you showed me in 2009 (?) to plug an external mic to a macbook* laptop [12:24] xavi hi ricks99 [12:24] ricks99 hi xavi & jonnyb [12:24] xavi jonnyb: re-check, nope, I'll do today [12:25] jonnyb i'm going to try and do the same to menu admin before we branch... [12:25] xavi ricks99: I saw a few days ago that there is a copy of tiki for smarties on scribd [12:25] xavi is that right, or was I dreaming? [12:25] xavi oups, ricks99 dissapeared [12:26] xavi jonnyb: btw, did you see the work I did identifying the mysql tables that need (deserve) and search&replace for pics/icons into img/icons at the upgrade process? [12:26] xavi I reported everything in http://dev.tiki.org/Tiki9 [12:26] jonnyb no sorry, missed that [12:26] xavi and started searching for the mysql commands to replace those paths with a sql script [12:27] xavi but I'm not sure (newbie here, yet) if this also applied to BLOB fields in mysql tables, etc. [12:27] jonnyb i tihnk the fix to the icon object should make most WSoD's go away now [12:27] xavi jonnyb: and JSmin issues? [12:27] jonnyb you can't do the toolbar patth fixes with sql - needs to be php [12:28] xavi producing WSOD still a few days ago for me in a few different servers when attempting upgrades from 6x [12:28] jonnyb not seen them, so can't reproduce i'm afraid [12:28] xavi toolbar fixes: the path to the icon was stored in tiki_preferences table, for what I saw [12:28] xavi why not using just sql? [12:28] xavi ^newbie question for sure [12:28] jonnyb http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=40232&view=rev [12:29] jonnyb cos they are serialized php objects (well, you did ask!) [12:29] jonnyb it stores the length of the string as well in there, so if you change a value you have to recalculate that [12:30] xavi ah, ok, thanks (slowly learning) [12:30] xavi however, beyond my skills, I presume.... so I hope that my work identifying those tables would help to others to make that php fix [12:39] ricks99 joined #tikiwiki [12:39] ricks99 back :-) [12:42] rodrigoprimo1 joined #tikiwiki [12:42] xavi hi ricks99-back :-) [12:42] xavi ricks99: I saw a few days ago that there is a copy of tiki for smarties on scribd [12:42] xavi was I dreaming? [12:44] xavi I tried to log in scribd to download it, but then it requested my facebook credentials, and I was informed that I would be granting too many permissions to scribd to do in my facebook account, etc. , so I disabled all those extra permissions granted, ... the result is that I couldn't see the download link of the tiki for smarties book.... [12:44] ricks99 y. i refreshed the scribd versions of "Smarties" and "Essentials" a few weeks ago [12:45] xavi the fact if that I scanned a couple of chapters for my users, so that whan we have some workshop teaching our users about tiki trackers, then I give them a copy of those chapters, as scanned-and-printed again (in black and white) [12:45] ricks99 hm... *supposed* to be public/free.... let me check [12:45] xavi and some of them just want to read them every now and then online... [12:45] xavi and they would appreciate to have that in color, or course (the books I bought are in black and white) [12:45] ricks99 The quality of the Scribd PDF is so-so... it is a straight dump from Tiki [12:46] xavi and so are the scanned pages, of course [12:46] ricks99 I can make color books avaialable, if you're interested... not sure of the pricing [12:46] xavi quality of Scribd pdf would be probably be fine. If they want a better quality document, they can buy your books :-) [12:46] ricks99 :-) [12:47] ricks99 Ahh... I see Scribd changed their TOS... you must have an account and log in (either Scribd or Facebook) to download the PDF [12:48] xavi mmmm, ok. I did have some account on scribd years ago... I 'll see if I can recover the username and password [12:48] ricks99 you can always just make a Scribd account, instead of using FB login [12:48] ricks99 sorry about that... do you know of any better/other alternatives? [12:49] xavi yes, thanks, I'll try something like that, for the next time I have to organize another workshop (last one was yesterday with a bunch of my co-workers) [12:49] Bernard1 joined #tikiwiki [12:49] xavi jquery media plugin, to display pdf's online? [12:49] xavi that used to work in the past with tiki something.... [12:49] xavi but stopped working afaik [12:50] ricks99 can simply use HTML plugin.. [12:50] ricks99 requires Acro Reader on the user's PC though [12:51] ricks99 .... or just tell your co-workers to buy the book. :-) [12:54] Bernard1 polom back [12:56] ricks99 hi Bernard1 [12:59] jonnyb can anyone suggest the "best" irc client for Windoze? [12:59] ricks99 i like trillian [12:59] Bernard1 i used pidgin, was fine [12:59] RobertPlummer jonnyb: pidgin. [13:0] jonnyb hi RobertPlummer [13:1] NachoMahma FileZilla works well for me [13:2] jonnyb thanks all [13:10] sandroandrade joined #tikiwiki [13:10] RobertPlummer hi jonnyb [13:10] frumplete joined #tikiwiki [13:10] RobertPlummer We are all pretty active today, aye? [13:10] jonnyb hi RobertPlummer [13:10] RobertPlummer Time for a branch everybody? [13:10] jonnyb and hi frumplete [13:10] jonnyb no, not yet pls RobertPlummer [13:11] frumplete hi Jonny - this is well old school [13:11] RobertPlummer :) [13:11] jonnyb on a call with frumplete (who really i called Simon) introducing him to you all [13:11] jonnyb he's reading ricks99's book(s) [13:11] RobertPlummer Hey frumplete [13:12] * ricks99 happy to be the best-selling tiki author of ALL TIME. [13:12] jonnyb :D [13:12] RobertPlummer ricks99: How many books thus far? [13:12] ricks99 2. with 1 German translation under way, and an entire "series" of guides planned [13:12] frumplete Hi Robert - Jonny is just holding my hand through this [13:12] ricks99 hiya frumplete [13:13] RobertPlummer frumplete: Tiki admins are great at that. [13:13] frumplete hi ricks99 [13:13] RobertPlummer frumplete: You will be an avid Tiki-er be for long. [13:13] frumplete Jonny thought this would be a good place to come if i WAS LOSt and he wasn't arouind [13:14] RobertPlummer frumplete: Yea, the thing about Tiki is that it has so many sides, and there are experts of all of them. [13:14] blackbird_ I can't upload files ("cannot write to this file") – but I have correctly set chmod/chown and my php.ini max file size vars. anyone any idea what still might be wrong? [13:15] ricks99 blackbird_: you're saving the files in a file directory, right? did you include the "/" ? [13:17] xavi back [13:17] blackbird_ ricks99: yes, in directory. you mean the trailing slash? [13:17] ricks99 correct [13:18] xavi ricks99: that's what I always say: buy the book. :-) and in the mean time, where you have a low-quality version in pdf of thoese chapter, etc. [13:19] ricks99 xavi: curious... where does the shipping originate when you ordered? UK? [13:20] blackbird_ ricks99: yes, included the trailing slash [13:21] xavi ricks99: no idea.... months ago [13:21] xavi ricks99: I first ordered one copy of each, just after you publised them [13:21] ricks99 blackbird_: is the directory outside your tiki root? [13:22] xavi and a few months ago (9?) I ordered 3 copies of each [13:22] blackbird_ ricks99: no, it's inside [13:22] blackbird_ and I am using the relative path "files/uploads/" [13:23] blackbird_ occuring error: "[...] file_put_contents(/files/uploads/f170542cb6fd2f68d5e3e7298af73377): failed to open stream: No such file or directory" [13:23] xavi blackbird_: check the path [13:23] xavi if this is supposed to be a subfolder from your tiki install , you need to add a dot infront [13:23] ricks99 " / files / uploads" is valid? And correct perms? [13:24] xavi or as ricjks says, absolute path [13:24] ricks99 on your file admin page, is your path "/files/upload/" or "files/upload/" ? [13:24] xavi for relative, you might try with: "./files/uploads" [13:25] blackbird_ no, it is a subfolder from my tiki folder. I have correct rights (777) and it is "files/uploads/" in my tiki admin [13:25] blackbird_ I'll try the dot variant [13:26] xavi and check perms on both folders (files and uploads) [13:27] CIA-36 tikiwiki: 03robertplummer * r40255 10/trunk/lib/wiki-plugins/wikiplugin_convene.php: [ENH] Added convene-ok and convene-no classes for styling convene plugin [13:27] blackbird_ yeah, perms are 775 (not 777) for files/ and files/uploads [13:28] ricks99 if path is relative, nees to *NOT* have "/" in front [13:28] blackbird_ ./files/uploads does not work either, but curiously it still says: "file_put_contents(/files/uploads/f170542cb6fd2f68d5e3e7298af73377): failed to open stream: No such file or directory" – what tells me that it still uses the /files/uploads what is not relative but absolute [13:28] blackbird_ ricks99: yeah, that's clear. /files/uploads is absolute, beginning from root (/) [13:29] ricks99 this is tiki 8.3? [13:30] blackbird_ ricks99: yes [13:31] ricks99 and your 1000% sure no typos in directory name? and 7-7-5 for FILES and UPLOADS [13:31] * ricks99 *always* makes typos :( [13:33] Hammer joined #tikiwiki [13:33] Hammer someone availabale ? [13:33] Hammer I am goignt o upgrade from 2.2 to 8.2 , what should I proceed ? 3.8 then 5.x then 6.x then 8.x ? [13:33] luciash joined #tikiwiki [13:34] Bernard1 joined #tikiwiki [13:35] blackbird_ joined #tikiwiki [13:35] blackbird_ re. had conprobs [13:35] Hammer_ joined #tikiwiki [13:35] Hammer_ ricks99 [13:36] ricks99 Hammer: you can upgrade directly, but be aware of *many* changes. review all release notes [13:36] blackbird_ so back to topic, still doesn't work. I was using "files/uploads" and "./files/uploads" but it always tells me it can't upload to "/files/uploads" [13:36] Hammer_ if i wanna go [13:36] blackbird_ I'll try using an absolut path [13:36] Hammer_ through old ones [13:36] Hammer_ what do u recommend [13:36] Hammer_ ? [13:37] ricks99 Hammer_: I see no reason to go through all the old ones. Again, be sure to review the release noetes. There were *many* important changes (perms, plugins, etc.) from 2.x -> 8.x [13:37] ricks99 blackbird_: you're 1000% sure that there is no typo in folder name and that perm is 7-7-5? [13:37] blackbird_ yes, sure on both [13:38] Hammer_ i dotn really use many plugins in my pages-----most likely : maketoc , div, BOX, Split [13:38] Hammer_ that's all [13:38] Hammer_ and table of course [13:38] ricks99 blackbird_: when you creaed the tiki gallery, are you using any special options? (such as require regex match, etc.?) [13:39] ricks99 Hammer_: run a test... be sure to backup first! [13:39] Hammer_ ok [13:39] Hammer_ I will [13:39] blackbird_ no, I haven't [13:40] Hammer_ is there a procedue on how to export my DATABASE using PHPmyADMIN [13:40] Hammer_ ? [13:40] Hammer_ can I export it while wiki running ? [13:43] ricks99 Hammer_: see http://bit.ly/GBbqRs [13:44] ricks99 blackbird_: for a test, can you switch to saving in db and try a quick upload. if it works, then i'm 99.99% sure it is a setup issue -- not a tiki failure, per se [13:45] blackbird_ ricks99: ok [13:48] CIA-36 tikiwiki: 03robertplummer * r40256 10/trunk/lib/core/Feed/ForwardLink.php: [FIX] Added trim for selected text, so that suggestion and selection work the same [13:48] blackbird_ ricks99, xavi: this is weird. I changed to the absolute path but it still says "file_put_contents(/files/uploads/f170542cb6fd2f68d5e3e7298af73377): failed to open stream: No such file or directory" [13:50] blackbird_ ricks99: even more weird: I changed to saving in db and it still has the same error...?! [13:50] ricks99 did you clear tiki cache? [13:54] blackbird_ hmmm, no... ;) [13:56] ricks99 ah ha! [14:0] Hammer_ ricks [14:0] Hammer_ ? [14:0] Hammer_ my database is 40 MB [14:0] Hammer_ i will import it manually [14:1] Hammer_ but u think i should change php.ini\ [14:1] Hammer_ ? [14:1] Hammer_ max_exuction_time [14:1] Hammer_ ? [14:1] ricks99 ok [14:2] Hammer_ should i do anything with php.ini ? [14:3] Hammer_ or no [14:4] ricks99 for recommended php.ini settings, see docs: http://doc.tiki.org/requirements [14:7] radek82 joined #tikiwiki [14:12] Hammer_ ricks last question [14:12] Hammer_ 8.2 or 8.3 should i use [14:12] Hammer_ :) ? [14:12] Hammer_ 2.2 to 8.3 is good ? [14:12] Hammer_ dont worry about the changes in between ...i ll take care of that [14:13] ricks99 current release is 8.3 see http://tiki.org/download [14:14] Hammer_ i know [14:14] Hammer_ but upgarde to this from 2.2. [14:14] ricks99 use 8.3 -- not 8.2 ^^^ [14:14] Hammer_ is also good workable [14:14] Hammer_ right ? [14:14] Hammer_ ok :) [14:14] Hammer_ :) [14:17] benoitg joined #tikiwiki [14:27] Jyhem_laptop polom [14:28] jonnyb hi Jyhem_laptop [14:28] Jyhem_laptop hi jonnyb [14:37] blackbird_ joined #tikiwiki [14:38] blackbird_ ricks99: even after clearing cache no satisfactory result. [14:38] blackbird_ :/ [14:39] ricks99 blackbird_: can you review server logs? I'm at a loss -- should work [14:41] blackbird_ np, I'll check the logs [14:54] jonnyb bbl [14:54] CIA-36 tikiwiki: 03jonnybradley * r40257 10/trunk/lib/smarty_tiki/function.icon.php: [FIX] icons: Another improvement of reporting of smarty security errors (keep link, size etc from intended icon) [15:0] benoitg joined #tikiwiki [15:2] CIA-36 tikiwiki: 03robertplummer * r40258 10/trunk/ (16 files in 9 dirs): [15:2] CIA-36 tikiwiki: [ENH] TrackerQueryLib becomes Tracker_Query, and is now included as part of the Zend class system [15:2] CIA-36 tikiwiki: [ENH] Before TrackerQueryLib was initiated at startup, but now needed to change a few methods to static to ensure loading correctly [15:10] Bernard1 i had to change a text string for clarification in a .tpl file. What is the right process then for the lang files ? (i can commit en, fr and he) but i want to be sure it is ok. [15:14] RobertPlummer Xavi and I are talking about using folders/not using folders for tiki "apps", one example is invoice and another is admin. [15:14] RobertPlummer What do you guys think? [15:14] RobertPlummer I'd like to move anything to do with tiki invoice to it's own folder, so that it makes developing faster. [15:14] blackbird_ Bernard1: please commit de as well .-) [15:14] RobertPlummer I don't have to find all the files when I start developing. [15:15] blackbird_ RobertPlummer: I personally support the approach of putting app files into an app specific folder [15:16] RobertPlummer We already did it with admin, lets to it with others. [15:16] Bernard1 blackbird_: i should have spoke german for that [15:16] Bernard1 :) [15:16] xavi RobertPlummer: maybe the devel list is needed for this discussion, if you don't get enough feedback for long standing developers of tiki with this change you propose [15:16] blackbird_ Bernard1: can you /msg me the parts so I can translate? [15:17] RobertPlummer xavi, I have enough +1's for tiki/invoice, I guess the question comes down to should we make a folder for just apps? [15:17] xavi for the sake of completeness to be included in the irc log, I copy here the arguments from jyhem in skype: [15:17] RobertPlummer ok [15:17] xavi jyhem: If pages have urls like /apps/something I guess nobody knows how the images and css will react, especially for third party included stuff, like ckeditor [15:17] xavi jyhem: not to mention sefurls [15:18] Bernard1 blackbird_: wait i get confirmation this is ok. [15:18] RobertPlummer But we already have tiki/admin, why not follow that same approach. [15:18] xavi Robert, regarding speed (in life), there is a quote I like a lot from the grass-roots movements in Spain from this last year: [15:18] xavi "we are slow, because we go far away" [15:19] xavi kind of ("vamos lentos porque vamos lejos") [15:19] xavi keep it in mind, I would say, when you are worried about "speed" [15:19] xavi my 2 cents [15:20] * xavi back to urgent work for today [15:21] Jyhem_laptop I see that the admin directory only has include files in it, so my concern about urls like /apps/something is void [15:23] * Jyhem_laptop wonders if xavi's quote is like "today's problems are yesterday's solutions" :-) [15:25] Jyhem_laptop Remaining concern: what happens on a Tiki site with sefurls active and someone creates the wiki page "apps" and there is a "apps" directory ? Trouble ? No trouble ? One more line in .htaccess ? [15:25] * Jyhem_laptop avoids sefurls, so I have no ready site to test that [15:26] ricks99 Jyhem_laptop: handled by htaccess. compare http://doc.tiki.org/Modules with http://doc.tiki.org/modules [15:30] NachoMahma joined #tikiwiki [15:31] * Jyhem_laptop sees no reference to modules in _htaccess. So apparently, no issue on that side either [15:33] Jyhem_laptop oh, http://doc.tiki.org/modules gets an error :-( [15:34] NachoMahma Capital-M and singular [15:34] NachoMahma http://doc.tiki.org/Module [15:40] * Jyhem_laptop wonders if features would not convey the meaning better than apps. Definitely a conversation for he mailing list [15:41] Jyhem_laptop NachoMahma: my point was not to access the doc page, I was looking at the consequences of having a "modules" directory in the Tiki root folder [15:42] NachoMahma Oh. http://doc.tiki.org/modules/ [16:8] Hammer_ question [16:8] Hammer_ question [16:9] Hammer_ Urgent [16:9] Hammer_ when I am imnporting my databse [16:9] Hammer_ i get an error [16:9] blackbird_ joined #tikiwiki [16:10] Hammer_ Error 1062 (23000) at line 365 Duplicate entry 1 for key PRIMARY [16:10] blackbird_ And http://doc.tiki.org/Structure is also not found (linked from tiki admin) [16:12] Hammer_ ? [16:17] Jyhem Hammer_: the db importing stuff must be a collation or encoding change [16:18] Hammer_ what do u mean [16:18] Hammer_ ? [16:18] Hammer_ i already set my db to be UTF [16:18] Jyhem what were collation and encoding before you exported ? [16:18] Jyhem OK, that's the new encoding [16:19] Jyhem where does the db come from ? [16:19] Hammer_ Phpmuyadmin [16:19] Hammer_ i export it from there [16:19] Hammer_ when I forst login into phpmyadmin [16:19] Jyhem same site ? [16:19] Hammer_ i see [16:19] Hammer_ MySQL charset: UTF-8 Unicode (utf8) [16:20] Hammer_ when i click on my database [16:20] Jyhem sorry, encoding == charset [16:20] Hammer_ i see collation : latin swedish [16:21] Jyhem is that the origin db (fro which you exported the db) ? [16:21] Hammer_ yes [16:21] Hammer_ origin [16:21] Jyhem and the destination db ? [16:21] Hammer_ i set it up using [16:21] Hammer_ Webmin [16:21] Hammer_ on redhat [16:22] Hammer_ utf 8 as encosing [16:22] Hammer_ and collation = tuf 8 general [16:23] Jyhem oh, wait... the origin db is inconsistent :-( [16:24] Hammer_ what does thart mean ? [16:24] Hammer_ lol [16:25] Jyhem You have UTF8 content, but it believes you have latin content for the collaton rules [16:25] Hammer_ yes [16:25] Hammer_ how i fix that ? [16:25] Hammer_ they set it up in 2008 by default [16:25] Hammer_ i guess [16:25] Jyhem collation rules are the rules which say what is the order of letters in alphabet, and also, which letter is the same as the other [16:25] Hammer_ so it took latin swedish [16:26] Jyhem do you have accents in your db ? [16:27] Hammer_ yes [16:27] Hammer_ i think [16:27] Jyhem you might have one page named "test" and one named "tést". [16:28] Hammer_ umm no [16:28] Jyhem with correct collation, this is impossible (same key) [16:28] Hammer_ OH shitttt i imported it to a database [16:28] Hammer_ that the use has no access to [16:28] Hammer_ lol [16:28] Hammer_ i have wikitest and testwiki [16:29] Hammer_ i choose the incorret one that's running [16:29] Jyhem Ahhh, then it already had content ? [16:29] Hammer_ no first dababase has 0 conetent [16:30] Hammer_ i should overite the one [16:30] Hammer_ that tiki use [16:30] Hammer_ what's the link for the installer again ? [16:30] Jyhem tiki-installer.php [16:31] Hammer_ i deleted it my databse [16:31] Hammer_ how can I overstart [16:31] Jyhem sorry tiki-install.php [16:32] Hammer_ yea [16:32] Hammer_ but it is asking me if databse is running LOL [16:32] Hammer_ my databse is nio longer there [16:33] Jyhem what, restart from srcatch ? rename db/local.php [16:34] blackbird_ I am still wondering, why my file upload does not work properly. I set up the path relatively ("files/uploads/") but it always gives me the error that it couldn't find the path "/files/uploads/" (which is an absolute path) [16:34] Hammer_ Cool [16:35] blackbird_ any1 any idea what is wrong here? perms correct (775) on files/ and on files/uploads/ – and cache already cleared... [16:36] Jyhem no idea [16:45] Hammer_ mysql -u username -p --default-character-set=latin1 database < backup.sql\ [16:45] Hammer_ did not work also [16:45] Hammer_ mysql -u username -p --default-character-set=latin1 database < backup.sql [17:2] Jyhem_laptop I suggest exporting with mysqldump -u username -p -Qqf --skip-extended-insert db > backup.sql [17:3] Jyhem_laptop then mysql --force --user=username-p db < backup.sql [17:3] Jyhem_laptop Then collect the lines with issues and look at them [17:4] Jyhem_laptop with --skip-extended-insert you have an insert per line, so you know what is wrong [17:4] Jyhem_laptop with --force, you don't die at the first error, so you still get all correct data in the db [17:26] Bernard1 joined #tikiwiki [17:36] CIA-36 tikiwiki: 03robertplummer * r40259 10/trunk/lib/core/Tracker/Query.php: [ENH] Moved tracker id to method, working on replace item [17:44] Hammer_ Jym can I run this command [17:44] Hammer_ on phpmyadmin [17:44] Hammer_ or it has to be on the server ? [17:49] CIA-36 tikiwiki: 03jonnybradley * r40260 10/trunk/ (lib/smarty_tiki/function.menu.php modules/mod-func-menu.php): [FIX] menu module: Handle structure "name" as well as numeric id and process title properly [17:54] xavi RobertPlummer: fyi: I clicked at "edit sheet" button for http://dev.tiki.org/sheet11 and I got a never ending loop in a white page [17:54] CIA-36 tikiwiki: 03yonixxx * r40261 10/trunk/lang/he/language.php: [TRA] hebrew translation progress [17:55] CIA-36 tikiwiki: 03yonixxx * r40262 10/trunk/lang/fr/language.php: [TRA] minor strings correction [17:55] CIA-36 tikiwiki: 03yonixxx * r40263 10/trunk/lang/en/language.php: [TRA] minor strings correction [17:56] CIA-36 tikiwiki: 03yonixxx * r40264 10/trunk/templates/tiki-edit_article.tpl: [FIX]String correction [17:58] CIA-36 tikiwiki: 03yonixxx * r40265 10/trunk/templates/mail/user_watch_article_post_subject.tpl: [FIX]TR tag correction [18:1] Hammer_ Jyhem [18:1] Hammer_ ? [18:2] Jyhem_laptop sorry, busy elsewhere. [18:2] Jyhem_laptop that's command line [18:3] Jyhem_laptop --default-character-set=latin1 looks like a big step backwards [18:3] Hammer_ line 4532 duplaicate entry "Created tiki-page' for key" [18:3] Hammer_ i got like 10 errors [18:3] Hammer_ 10 lines [18:5] Jyhem_laptop what's one of the lines? [18:5] Hammer_ could because I am over wiriting into the current empty databse ? [18:5] Jyhem_laptop say, line 4532 ? [18:6] Hammer_ INSERT INTO `tiki_actionlog_conf` (`id`, `action`, `objectType`, `status`) VALUES [18:6] Hammer_ this is the line [18:6] Tiki|bot New Forum Posts: user access to their preferences - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=43620 [18:7] Jyhem_laptop does not look like it "Created tiki-page' [18:7] Hammer_ could be because I am over writing the current database ? [18:7] Jyhem_laptop are you sure it's line 4532 of backup.sql ? [18:8] Hammer_ yea [18:8] Hammer_ i run 8.3 with the current databse [18:8] Hammer_ like empty databse [18:9] Hammer_ u know what i mean [18:9] Hammer_ then i impiorting this old databse to it [18:9] Hammer_ ? [18:9] Hammer_ importing [18:9] Hammer_ could be the reason ? [18:10] Jyhem_laptop the old database is in backup.sql and you got this error doing mysql --force --user=username-p db < backup.sql ? [18:11] Hammer_ yes [18:11] Hammer_ of course db in my case is tikitest [18:11] Hammer_ is called tikitest [18:12] Jyhem_laptop are all the 10 errors about tiki_actionlog_conf ? [18:13] Hammer_ no [18:13] Hammer_ i got [18:13] Jyhem_laptop because I don't think anyone cares about a missing line in tiki_actionlog_conf [18:13] Hammer_ duplicate entry '1' for key primary [18:13] Hammer_ duplicate entry '6' [18:14] Hammer_ duplicate entry '1' for key primary : there 4 lines of this [18:14] Jyhem_laptop what is the corresponding line ? [18:15] Hammer_ INSERT INTO `tiki_integrator_reps` (`repID`, `name`, `path`, `start_page`, `css_file`, `visibility`, `cacheable`, `expiration`, `description`) VALUES [18:15] Hammer_ weird eh [18:16] Jyhem_laptop wow, no idea about that line. [18:16] Jyhem_laptop did you say that you imported over an existing database ? [18:16] Hammer_ yes [18:16] Hammer_ the one [18:16] Hammer_ by default i crreated [18:16] Jyhem_laptop ohhhh [18:16] Hammer_ when i indtalled [18:17] Hammer_ installed [18:17] Hammer_ 8.3 [18:17] Hammer_ u know ? the on that has only [18:17] Hammer_ user Admin [18:17] Hammer_ in users [18:17] Jyhem_laptop and the previous one is also 8.3 ? [18:17] Hammer_ lol [18:17] Hammer_ no [18:17] Hammer_ 2.2 [18:19] Jyhem_laptop :-( [18:19] Hammer_ could be the reason ? [18:19] Jyhem_laptop I thought you had trouble migrating a tiki db from site to site. [18:20] Hammer_ No man [18:20] Jyhem_laptop Yes, that could be the reason. [18:20] Hammer_ upgrade from 2.2 to 8.2 [18:20] Hammer_ 8.3 [18:20] Hammer_ should I go 3.x then 6.x [18:20] Hammer_ first ? [18:20] Hammer_ or what ? [18:21] Hammer_ how do I proceed [18:22] Jyhem_laptop not sure [18:22] Jyhem_laptop http://doc.tiki.org/Upgrade [18:23] Hammer_ btw why when i exported sql using dump [18:23] Hammer_ thefile is almost half the size [18:23] Hammer_ when u use phpmyadmin [18:23] Hammer_ ? [18:24] Jyhem_laptop Anyway, even if direct 2.2 → 8.3 works, you need to import backup.sql into an empty database (really empty, just created, no tables in it), then go to tiki-install.php not create a 8.3 somewhat empty database [18:25] Jyhem_laptop phpmyadmin probably uses a more complete syntax. No worry. [18:26] Hammer_ ok i am gonna create one empty database [18:26] Hammer_ utf8 [18:27] Jyhem_laptop so I suggest you empty the database from phpmyadmin (or recreate it) and then mysql --force --user=username-p db < backup.sql should not show errors [18:27] Jyhem_laptop utf8, yes [18:27] Hammer_ what collation order [18:27] Hammer_ ? [18:28] Hammer_ utf_general_Ci ? [18:28] Jyhem_laptop yes, or utf_unicode_ci [18:30] Hammer_ ok and i gace the user all the permission [18:30] Hammer_ i gave the user [18:30] Hammer_ now i am gonna use phpmyadmin databse [18:30] Hammer_ first [18:30] Hammer_ ok ? [18:32] Hammer_ well done :) [18:32] Hammer_ now I have to re run the insallater [18:33] Hammer_ i ll rename the db/local first 1 sec [18:34] Jyhem did you do mysql --force --user=username-p db < backup.sql ? [18:34] Hammer_ no mysql -u username -p db < backup.sql [18:34] Jyhem so you start with a tiki 2.2 database on tiki 8.3 source code ? [18:34] Hammer_ just normal command [18:35] Hammer_ yes [18:35] Hammer_ i will have to run the installer [18:35] Hammer_ i did not run it yet [18:35] Jyhem what normal command ? [18:35] Hammer_ mysql -u username -p db < backup.sql [18:35] Hammer_ i did not use --force [18:35] Jyhem ok, of there is no error, it is the same [18:35] Hammer_ no errors [18:36] Hammer_ now the insllter [18:36] Hammer_ ready ? [18:36] Hammer_ LOL ? [18:36] Jyhem then --force is useless :-) [18:36] Jyhem yes [18:36] Hammer_ there is some php erroes at the bottome [18:36] Hammer_ should i ignore them ? [18:37] Hammer_ warnings [18:37] Hammer_ ype: strftime(): It is not safe to rely on the system's timezone settings. Y [18:37] Hammer_ i can ignore these [18:37] Hammer_ i gues [18:37] Jyhem ignore [18:37] Jyhem they are for developpers [18:39] Hammer_ Tiki cannot find a database connection. This is normal for a new installation. [18:39] Hammer_ i will write the new databse name [18:39] Jyhem well, you remved local.php [18:39] Jyhem go ahead [18:39] Jyhem well, you removed local.php [18:39] Hammer_ Always force connection to use UTF-8 [18:39] Hammer_ check this ? [18:39] Hammer_ by default it is [18:40] Jyhem yes [18:40] Hammer_ Something is wrong with the database encoding. The schema has UTF-8 as default encoding but some tables in the schema have a different collation, latin1_swedish_ci. Co [18:40] Hammer_ Converting to UTF-8 may solve this but may also make matters worse. You should investigate what happened or only proceed with backups. [18:40] Hammer_ i will click convert [18:41] Jyhem hmmm no [18:41] Hammer_ ? [18:41] Jyhem chances are, the encoding really is good [18:41] Hammer_ so go with the upgrade button ? [18:41] Jyhem so don't fix unti you verified that there is a problem to fix [18:42] Jyhem you can always come back to the installer [18:42] Jyhem yes [18:42] Hammer_ Upgrade operations executed successfully: 2288 SQL queries. [18:42] Hammer_ Operations failed: 1 SQL queries. Display details. [18:42] Hammer_ let me check that one [18:42] Jyhem neat [18:42] Jyhem sure [18:43] Hammer_ 20090206_content_tpl_menu_tiki [18:43] Hammer_ it is this [18:43] Hammer_ INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) SELECT 42,'o','Content Templates','tiki- [18:43] Hammer_ admin_content_templates.php',1256,'','tiki_p_edit_content_templates','',0 FROM `tiki_menu_options` WHERE @fgcant = 0 [18:44] Hammer_ Duplicate entry '42-Content Templates-tiki-admin_content_templates.php-1256--tiki' for key 'uniq_menu [18:44] Hammer_ that s about it [18:45] Jyhem I'd ignore that. Really [18:45] Jyhem go ahead [18:45] Hammer_ configure general settings page now [18:46] Hammer_ some PHp notices at the bottom , should i ignore ? [18:46] Jyhem yes, always [18:46] Hammer_ Logging and Reporting [18:46] Hammer_ i m gonna check [18:46] Hammer_ visible to admin only [18:46] Hammer_ and select report all errors expect notices [18:47] Hammer_ cool ? [18:47] Jyhem yes, otherwise other people wonder about notices and warnnings [18:47] Jyhem "visible to admin only" is important. he rest is as uyou like [18:47] Hammer_ cool [18:47] Hammer_ done [18:47] Hammer_ i got the first page [18:47] Hammer_ :) [18:48] Hammer_ what s the admin password though ? [18:48] Hammer_ i can use any user from previous databse [18:48] Hammer_ I am in [18:49] Jyhem no encoding issues ? [18:49] Hammer_ yes i have [18:49] Hammer_ only the first page [18:50] Hammer_ but could be plugin [18:50] Hammer_ i used DIV [18:50] Hammer_ BOX [18:50] Hammer_ let me check the plugin [18:50] Jyhem I meant character encoding [18:50] Jyhem like accented characters [18:50] Hammer_ no [18:50] Hammer_ :) [18:50] Hammer_ it looks good [18:51] Hammer_ very good actually [18:51] Jyhem wow, nice ! I never participated in a 2.2 → 8.3 direct upgrade :-) [18:51] Hammer_ ummm [18:51] Hammer_ got something weird [18:51] Hammer_ wait [18:52] Hammer_ lol [18:52] Jyhem You might still have a look at http://doc.tiki.org/Upgrade :-) [18:53] Hammer_ Logging and Reporting [18:53] arildb joined #tikiwiki [18:53] Hammer_ i cannot paste it [18:53] Hammer_ wth [18:53] Hammer_ lol [18:57] Hammer_ ummmm [18:57] Hammer_ the ' is giving an encoding problem [18:57] Hammer_ and - too [18:58] Hammer_ othe rthan that it looks great [18:58] xavi left #tikiwiki [19:2] radek82 joined #tikiwiki [19:5] Hammer_ It shows on my first page some icons for plugin [19:5] Hammer_ it is asking me to edit them when i click on it [19:7] Hammer_ Search index could not be updated. The site is misconfigured. Contact an administrator. [19:7] Hammer_ Utf8 compatible lower case filter needs mbstring extension to be enabled. [19:7] Hammer_ how do i fix this ? [19:15] ricks99 Q: when using the carousel plugin.. how do i make each slide clickable? im using a specific file gallery. tried coding link in each item desc. no go :( [19:18] Hammer_ i wish i know [19:18] Hammer_ :) [19:20] ricks99 checked the code... dont see how to assign links from file gallery descriptions? [19:26] Hammer_ Ricks [19:26] Hammer_ how do i fix the plugins ? [19:26] Hammer_ i checked already [19:26] CIA-36 tikiwiki: 03robertplummer * r40266 10/trunk/lib/core/Tracker/Query.php: [FIX] Need to check if numeric if not empty [19:26] Hammer_ they are enabled [19:27] ricks99 sorry... what's the issue with your plugins? [19:28] Hammer_ when i upgraded [19:28] Hammer_ 2.2 to 8.2 [19:28] Hammer_ no proble expect [19:28] Hammer_ fist page [19:29] Hammer_ with some plugins [19:29] Hammer_ like i can see the icon it says Edit [19:29] Hammer_ i see my line as characters [19:29] ricks99 look at the relnotes, i recall this... in some instances you'll need to re-approve all your plugings. there was a script that you could run before the upgrade in order to fix the issue [19:29] Hammer_ b234dfr4565666666&&34fgtght [19:30] ricks99 did u look at the release notes? [19:30] Hammer_ not at everything [19:30] CIA-36 tikiwiki: 03chealer * r40267 10/trunk/tiki-admin_trackers.php: Trackers: save some stuff from List Trackers before getting rid of it [19:30] Hammer_ because i went direclty from 2.2 to 8.3 [19:31] Hammer_ plus i have only one problem with this --> ' [19:31] Hammer_ the encoding [19:32] Hammer_ of it [19:32] CIA-36 tikiwiki: 03chealer * r40268 10/trunk/tiki-admin_trackers.php: [REF] Admin Trackers: Remove apparently unused uses_tabs and urlquery definitions [19:32] ricks99 did you check the encoding specified in your db.local file? does it match the encoding of your dump file? [19:33] Hammer_ no [19:34] Hammer_ going now to see [19:34] Hammer_ the db.local [19:34] Hammer_ under db/ ? [19:35] ricks99 Hammer_: you reallyou should review all the relnotes 2.x -> 8.x. For example, the encoding issue is fully documented: http://tiki.org/ReleaseNotes5.1#Database_Encoding [19:35] Hammer_ yea but i went directly to 8.3..............does that mean i have to go lower first ? [19:38] CIA-36 tikiwiki: 03sampaioprimo * r40269 10/trunk/lib/articles/artlib.php: remove unused variables [19:38] ricks99 no. but you need to review all the notes between to be aware of all the changes. [19:38] ricks99 2.x -> 8.x is a *BIG* jump [19:38] Hammer_ u asked me to test it out :) [19:38] CIA-36 tikiwiki: 03sampaioprimo * r40270 10/trunk/ (6 files in 6 dirs): [ENH] add preference to display related articles at the bottom of a article page [19:39] ricks99 y. it works (i've dont it 1.9.x -> 8.x) but there are many things you need to know first [19:39] Hammer_ if i tell u the error it is giving me [19:39] Hammer_ u might know ? [19:40] ricks99 i will try [19:40] Hammer_ when i click edit plugin [19:40] Hammer_ then sumbit [19:40] Hammer_ even though if i dont want to edit it [19:41] Hammer_ i get this error : [19:41] Hammer_ Search index could not be updated. The site is misconfigured. Contact an administrator. [19:41] Hammer_ Utf8 compatible lower case filter needs mbstring extension to be enabled. [19:41] ricks99 is the mbstring extension enabled on your site? [19:41] Hammer_ i dunno [19:41] Hammer_ is that plugin ? [19:42] ricks99 no. it is an apache extension [19:42] Hammer_ ah [19:42] ricks99 if you're going to use the new search index instead of old mysql, there's a bunch of requirements. [19:42] ricks99 need to review the search index feature doc if you're going to use it [19:43] Hammer_ how is this related to DIV SPLIT BOX plugins [19:43] Hammer_ ? [19:43] ricks99 again, i highly recommend that you review the changes. for example: http://doc.tiki.org/Search+Index [19:44] ricks99 any time you change a page's content, it affects the search [19:46] Hammer_ yea but my error is not related [19:46] Hammer_ to what u r saying [19:46] Hammer_ maybe i am wring [19:46] ricks99 sorry, but i don't understand [19:46] Hammer_ wrong [19:47] Hammer_ that error i get only [19:47] Hammer_ when i try to edit [19:47] Hammer_ my plugin [19:47] ricks99 if you are editing a plugin, you are changing the page. that kicks off the search index [19:47] ricks99 issue 1: make sure your encoding is correct [19:47] ricks99 issue 2: confirm that your server supports the search index [19:47] ricks99 requirements [19:48] Hammer_ ok [19:48] ricks99 I'd start with those 2, if i were u [19:48] Hammer_ i just did a search [19:48] Hammer_ did not work [19:48] Hammer_ ok iw ill [19:48] Hammer_ i will [19:49] ricks99 and, if you're not going to use the 8.x features, you might consider using Tiki 6 LTS instead [19:49] Hammer_ Yea [19:49] Hammer_ i am gonna go 3.8 then 6 LTS [19:50] Hammer_ then 8.3 [19:50] Hammer_ maybe that would fix my [19:50] Hammer_ encoding problem [19:52] ricks99 bbl [20:4] CIA-36 tikiwiki: 03tikii18nbot * r40271 10/trunk/lang/fr/language.php: French translations done on i18n.tiki.org [20:10] RobertPlummer joined #tikiwiki [20:15] CIA-36 tikiwiki: 03chealer * r40272 10/trunk/ (16 files in 9 dirs): [20:15] CIA-36 tikiwiki: [ENH] Trackers: Merge tiki-list_trackers and tiki-admin_trackers, using the generalized tiki-admin_trackers. The new interface is tiki-list_trackers. [20:15] CIA-36 tikiwiki: Reference: http://article.gmane.org/gmane.comp.cms.tiki.devel/25367 [20:15] CIA-36 tikiwiki: In list_trackers, creation and last modification dates do not show the time anymore (could be useful, but too noisy in current presentation) [20:15] CIA-36 tikiwiki: The new interface is generally called "Trackers", sometimes "List Trackers" [20:21] CIA-36 tikiwiki: 03chealer * r40273 10/trunk/templates/tracker_actions.tpl: Fix svn:keywords (Id) [20:28] WSD joined #tikiwiki [20:28] WSD !help [20:28] WSD LoL [20:34] WSD Sorry if this was asked before, I thougt I found how to resolve,but the resolution didn't fix the issue. Installed v8.1 and tried to install profile "Company_Intranet_8x" but received "An error occured during the profile validation. This profile cannot be applied. Message: Invalid URI supplied.". Chat post recommended to upgrade to v8.2 and I noticed v8.3 is out so I bypassed v8.2 and went [20:34] WSD straight to v8.3. Still receiving the error after upgrade. Running tikiwiki on Windows 2008 with IIS 7. [20:36] WSD_ joined #tikiwiki [20:55] CosmeFC joined #tikiwiki [20:55] CosmeFC Hi! [20:56] CosmeFC I am having problens with LDAP, openldap, and groups. [20:56] CosmeFC Can anyone help me? [20:56] CosmeFC There are some exemples? [21:28] Tiki|bot joined #tikiwiki [21:42] CosmeFC hI? [22:10] CIA-36 tikiwiki: 03robertplummer * r40274 10/trunk/lib/core/Tracker/Query.php: [ENH] Added function fieldInputs to get field inputs for custom applications [22:28] benoitg joined #tikiwiki [22:52] Bernard1 joined #tikiwiki [22:57] CosmeFC Hi? [22:58] CosmeFC !help [22:58] Tiki|bot You can get a more complete list of commands that work with this bot at http://tiki.org/TikiBot .