tikiwiki: 03obnoxxx * r16787 10/trunk/lib/userslib.php: [FIX] fix intentation/tabbing of confirm_user() tikiwiki: 03obnoxxx * r16788 10/trunk/tiki-information.php: [FIX] fix id tag of tiki-information.php to have the proper file name tikiwiki: 03obnoxxx * r16789 10/trunk/lib/userslib.php: tikiwiki: [MOD] update registrationDate upon user confirmation tikiwiki: This allows to distinguish between the creation date (stored in `created`) tikiwiki: and the date of the completed registration. tikiwiki: 03obnoxxx * r16790 10/trunk/lib/tikilib.php: tikiwiki: [MOD] make the since-last-visit module only show the users that have tikiwiki: completed the registration by confirming their email. tikiwiki: 03obnoxxx * r16791 10/trunk/modules/mod-since_last_visit_new.php: tikiwiki: [MOD] make the sinc-last-visit-new module only show the new users that tikiwiki: have completed their registration. Hi Everybody, i want change my tikiwiki database? can you help me where can i change my tikiwiki database? is ther anybody? Be more specific about the kind of change. i would like to connect to newly created database or there tikiwiki back up database, did you got it? If you're trying to say you want to alter your database definitions, they are in file db/local.php I don't know what backup database you are referring to, as TikiWiki does not create a backup database. Backup of the database has to be done through methods separate from TikiWiki. backup database is mean, i have taken the backup(Export) manual, then i want to be a new backuped database is my new database, i want to know which place can i change the current database? example: i have 2 database (1, old_tikiwiki 2,Curr_tikiwiki , now my tikiwiki working on the 2nd database(curr_tikiwiki), some problem/ crash was happend, now i want point my tikiwiki database is 1st one. how to change this? any idea do you have SEWilco2 Kutti: Edit the file db/local.php with the info for the desired database. But back it up, in case this database also gets damaged. I mean back up the databases, not only the local.php file. SEWilco2,thank you hello tikis! Today we are going to continue with the TikiFest in Madrid (broadcasting from the Univerity of Alcalá) http://tikiwiki.org/TikiFestMadrid we wait for you there we were using yesterday a ustream.tv channel that seems to work, so around 10 AM it will be on air again see you there hey rlopez :) greetings to tikifest madrid ! thanks! we are waiting for marc and the rest of the team they were yesterday night with us eating tapas and drinking beer it was kind of funny to open my opera restoring the previous session and suddenly hearing marc talking from my speakers ;) nice oh, such a pity i didn't managed to come :-p yes, it's a pity we will make it to other one we have to go to test the lab in which we are going to work today i hope so see you later cool, see you at 10:00 I accidently deleted the group "Registered" and now none of my Users can log in...what should I do to restore Registered? lq_939: recreate the group as admin thanks...what permissions should the Registered group have? can anyone help me regarding how to use the mirror server in tikiwiki 2.2? any idea luciash? Does anyone know what permissions the default Registered group should have? lq_939,defalut 'Registered - Group ' does not belong to any group and any permision ? 04 04 lq_939,defalut 'Registered - Group ' does not belong to any group and any permision 05 can anyone help me regarding how to use the mirror server in tikiwiki 2.2? 05 Actually i already configured tikiwiki for my requirement ,it is ready to pilot. My question is 05 After piloted the my tikiwiki, i need to add some new extra requirement which i have developed after pilaoted, how to solve this kind of problem?  05 can anyone help me?05 how to add the newly configured feature without losing the data? is there anyone? polom meeting at tikifestmadrid just started... htt://tikiwiki.org/TikiFestMadrid oups... http://tikiwiki.org/TikiFestMadrid#Live Hi guys, I'm looking some method for create a mirror of my tikiwiki site, the idea is if my primary site is die I can redirect my users to my mirror site while i fix the problem... any ideas? is there anybody ? Kutti: dump the db? and re-import it in the mirror site? (regularly) then i need to use the 2 tikiwiki.. tikiwiki: 03jonnybradley * r16792 10/branches/experimental/jquery/ (131 files in 24 dirs): [MRG] Automatic merge, trunk 16726 to 16791 #jme hi, its possible to produce pdf, with a head and footline, which isnt visible on the site? no help here? @mib_d909gq: i think pdf bundled support was removed from tiki in 2.x (due to license issues). maybe try a browser-based solution instead? i wont work with it i have a huge document with like 80 pages i need a pdf build function, that produces a pdf with foot and headline don't know. sorry. :( thx i think, its not possible in tikiwiki then i googled around polom polom we recently came back to the tikifestmadrid after lunch :) ah, xavi editing :) xavi: you can now add "IRC_log" module where it should be ;) Howdy What is the difference config-wise between mysql and mysqli ? I've upgraded my server to mysql5.0.75 and using php5.2.8 and I just had recollection of the install script asking to choose between mysql and mysqli. As this is an existing database, what do I need to change in the tiki config to use mysqlo? mysqli? oups, luciash... I'll edit again :-) hi kerrnel. no idea, sorry kerrnel: lph says: "just change it in the local.php" I did and it craps out not even an http error log message, just a white screen Do I need to compile something with --mysqli ? polombit yeah, I didn't recompile php5 with mysqli. Doing that now. Maybe that's my performance hit. please god luci, sorry, I'm slow at doing things... xavi: np, done :) I see that you (orothers) already put that module in place yes. now i have to find out if the chat log text size can be smaller via CSS ;) and why images are being displayed now? what images ? the ones that I uploaded just before our luch, the ones (too big, I know) about the whiteboard because i played with it to put them in shadowbox is it ok like that ? I cannot see them in shadowbox nor anywhere. That's what I mean oh, they're hidden because too big... when you open the first image you can browse them all like in gallery it takes your tw.o login as parameter to be used as a nick for IRC :) xavi: do you see the images when you click "next" ? Unfortunately, I'm behind a firewall and they don't let us connect to 6667 :( Can you zoom in on the whiteboard? :) kerrnel: try 8001 or 9001 ;) luci ... kerrnel: no, we can't zoom in with the webcam kerrnel: so you cannot use the ustream chat too i think, right ? kerrnel: but we uploaded some pictures of the whiteboard to the tikifestmadrid page no, can't use the chat luci: it happens the same to me from my home university kerrnel: right, because they use their own IRC server too ok cool. Are you streaming live, or putting clips up? when I'm there, I can use the cgiirc solution kerrnel: live I'm using linux-quebec cgi:irc ah, so i'll put an alternative link for the rest of us ;) hmm, it says it's off air kerrnel: yes, that's a nice alternative for us when underfirewalls Do I need to sign in to be able to get live feeds? It says "Off Air" and has a picture of a sailing ship. kerrnel, no, when it says "off air" there is no live feed. a pity Ustream.tv irc chat doesn't let to connect with freenode but i think best is we can use irc to chat anyway Hello? hello I'm supposed to come on here and ask about The Ceremony Y'know, for commit access. luci: I agree Ah... xavi. A name I know. and it will be even better to use minichat module , whenever it allows logging days also at the time stamp hi UnorthodoxJeremy xavi: maybe we can later remove the ustream chat ? Jo. I'm all ready to commit wikiplugin_dbreport xavi: it doesn't keep long chat log, does it ? yes, luci, no problem for me Or better yet, a ustream plugin for Tiki with an IRC module... LOL no idea. chibaguy suffered from that chat log being lost somewhere.... and I don't even know how to get that back, so +1 to use only irc chatlog for now and +1 to use minichat (when improved) for later tikifests (after those minor improvements are done) xavi, btw, i "stream-back" but don't know how to let you see it :-p luci: about images,... streamback: :-) xavi: +1 for minichat when it gets improved Jo, marc. Another name I know. Anyone here got admin for SVN? UnorthodoxJeremy: marc is already putting on a ceremony hat i believe ;) Excellent. marclaporte: you could make it live streamed ;) yes, and marc dit put the hat on my head.... :-) hold on.... xavi: LOL Damn it's been a while since I used IRC. UnorthodoxJeremy: : hope we won't scare you away... UnorthodoxJeremy: ... Did you read the 3 rules? I don't scare easy. Except for Zombies. I did read the three rules. And they are good rules. what's your sourceforge nickname? jeremy_lee "good rules": they worked so far, at least... :-) and the last question (and harder, I guess....) are you ready to receive many users and developers thanking you for all your nice code and lovely work for the Community? :-) UnorthodoxJeremy: ^ Us that dbreport thing essentially the same thing as the mods I requested to tikisheet? Hmmm. I'm not sure. I hope so. :-) That was a hard question. If we're talking the same thing, then I'd much rather put resources on tikisheet because IMO it has WAY more upside. So then, welcome to the group with commit access! :-) we are opening a cava/champaign bottle for you here in the TikiFest! ;-) Woot. wikiplugin_dbreport and wikiplugin_html committed. ow Doco at http://doc.tikiwiki.org/PluginDBReport all up to date. UnorthodoxJeremy: welcome and thanks! Glad to help. UnorthodoxJeremy: welcome :) And now, alas, it's 2am local time, and I'm supposed to work tomorrow. My work here is done... see you all in the dev mailing list. I might just check the respository to make sure I didn't delete everything... and then it's off to bed for me,. ok, g'night mate, UnorthodoxJeremy which part of Australia are you from? UnorthodoxJeremy: : do you have time for a few questions about the Plugin? Yup.. fire away. I see you built a simple language which is more accessible to power users xavi: Brisbane, Queensland. The middle bit of the east coast. so you have lowered the technical level necessary to extract data. excellent Some choices, I am wondering why syntax X or Y. Is it based on something of just from your feeling/experience marc: Tried to. Used SQL as a basis I've written a lot of parsers/micro languages. Normally I'd have written an XML based language, but I thought something that's as forgiving as possible was the way to go. UnorthodoxJeremy: I was long ago living for some months in Perth (WA), and went up to Broome, Derby, visiting some friends.... (nice and HUGE country :-) ) Since the aim was to wrap formatting around an SQL statement, I borrowed SQL's style of the next keyword terminating the previous one Things got complicated with styles, so there's more than a dash of CSS syntax. luci: about images at tikifestmadrid, people are not seeing the images of the whiteboard because they don't know that they are there... Links were originally going to be set with a LINK keyword followed by the URL... I saw that < was used for URLs but in Tiki [ are used Yup, since '<>' is more a HTML thing, which the links are more closely related to. I'd already made the decision to use [ ] for fields, partially because of the Microsoft Access background of my initial user base. And links get composed from a series of elements. <"http://google/search?q="[field]> just looked more right, somehow, than ["http://google/search?q="] Although it's not too late to convince me otherwise. However, I find it's better to use a different syntax for what is essentially a different concept. Links act differently in wiki and dbreport, so mapping them to the same keywords might actually be more confusing. I am not convinced either way, I am just wondering :-) I actually wanted to leave '< >' for embedded HTML, but there weren't any other brackets left. The other thing I was wondering is variable names. There is already variable use in tiki as %dynamicvariable% [ ] for fields. ( ) already used by SQL. { } used by CSS (and overloaded to enclose SQL) " " for fields. I read earlier versions of the doc. Maybe you covered this. How would I get current page name in DBreport? $page (since it's a Wiki global variable) +1 to concern of making forgiving variables are really a special case of fields. Internally they're treated as [$var], but the $var form is allowed in places where it's unambiguous. You obviously put a lot of thought into this. I look forward to seeing how it will be used :-) Did you put any thought into how to use for complex reports on tracker data? I was driven mostly by necessity. I wrote it to solve some specific reporting needs where I'm working. But tried to make it as general as possible. yes, I can totally see the vast possibilities. Thank you for this. This is neat... bit hard to read but neat. Actually, impossible to read in the column :( hi hello Not so sure about tracker... I actually removed the 'local' DSN access that the SQL plugin does... I considered it too much of a security risk for anyone to go messing with the wiki tables with no user/pass So you'd have to connect to the wiki database using a specific DSN. That would limit it's portability. But theoretically, as long as you can write the SQL, and the parameters you need are available in global variables (or passed in the URL) then you can get anything out of the database you need with sufficiently complicated SQL. super we'll let you go to sleep :-) and hope to see you back often I'm sure you will... 'Night all. If there isn't a warning label on 2.x by now, there should be one that explicitly states that php4 cannot be supported. mysqli is a requirement, especially if you're using trackers with a lot of records. I've got a situation with php4 and mysql4.1 and a tracker with 2700+ records that is hitting mysql so hard that its causing upwards of 50 pairs of temp files to get queued up for execution, server loads of 120+ (!!!!) and unable to even log into the server at times. kerrnel: Did you try doing maintenance on your tracker tables after your update? SEWilco2: like what? I did run the 1.9 to 2.0 thing kerrnel: There are some MySQL commands for doing things like rebuilding the index on a table. kerrnel: If you have phpmyadmin, they're listed at the bottom of the page for a table. I haven't tried that, but my mysql dba guy said that normally there is an indication by mysql that a repair needs to be done, so we didn't do anything hi all, how's it in madrid? ;) kerrnel: I don't know why your DB is slow. I don't know if you have more tracker items than dev.tw.o or other sites. kerrnel: All that is apparent is that your problem happened when you upgraded, so either a code or DB problem could exist. kerrnel: You might try loading a backup of your DB into a DB of a different name, and point TW at it to see if the freshly built DB works better. does anyone know how to move calendar items between different calendars in tiki? kerrnel: Note that if your site is being used, you could install a second copy of TW on a different URL for this test. I do have more than dev, that I'm sure of. but yeah, the slowdown started after the upgrade. kerrnel: We also have no idea of your data. If you're storing videos in tracker items then we'd expect problems. yeah, I've got a couple of options of running the server in parallel somewhere, either on the same site different directory or on a different server entirely, and trying to troubleshoot. Not storing videos. :) kerrnel: Too bad. Then we still don't know what kind of problem there is. :-) Would it be possible to list the entries of a file gallery as a tracker ? (I mean TRACKERLIST) Because you say TRACKERLIST in that way, do you refer to a plugin called TRACKERLIST? I'm sure such a plugin is only for tracker data. See if there is a file gallery plugin of some kind. philippeback: Or if you want the recent changes, you can list the RSS feed for the file gallery. no I wanted to display a filegallery content with a kind of template. I did a silly set of links to the filegallery for now. But I will have to update the page everytime I touch the gallery content ... :-( Did anybody ever figure out the url thing? things like javascript ? this is the XSS protection filter yeah, is there workaround? I hadn't paid much attention because I didn't have the problem. sadly now I do well, to be honest, I had the issue for a goback kind of link. I put the stuff in a plugin... it is the goback plugin in the source code I think that's lame but the only way I've found to evade the XSS. lib\wiki-plugins wikiplugin_back.php {BACK()}{BACK} and I had the link without the damn philippeback: You can define a custom style, and define a different .tpl and .css for showing the file gallery in a different way. kerrnel: As your site uses a lot of trackers, the URL which you're having problems with might be in a tracker entry, and should it be trusted? yes, that's a good idea. Gotta work on that. Busy typing wiki content by now, case studies... kerrnel: TikiWiki does have a web directory tool for storing URLs, but I don't know of a way to connect it to tracker entries. "This is a fine alligator leather case, with brass fittings from 1812 which required much study." tikiwiki: 03marclaporte * r16795 10/trunk/ (installer/tiki-installer.php templates/tiki-install.tpl): [ENH] Changing to the new amazing profiles system in the installer. Tks LP. SEWilco2: I think I figured out what was hammering the site. Still need to upgrade for performance enhancements, but we've got a corporate crawler that was hammering the trackers every 30 seconds. It would queue up a request before one was completed and just snowballed. Didn't realize we had any corporate cralers, but there ya go. Updated robots.txt and it seems a little quieter now. see you guys :-) back