***: stripmind has quit IRC (Read error: 104 (Connection reset by peer)) CIA-71: tikiwiki: 03jonnybradley * r16749 10/branches/experimental/jquery/ (4 files in 4 dirs):
tikiwiki: [NEW] mod-webmail_inbox v0.1 - module showing contents of webmail account
tikiwiki: Early days... (experimental jquery branch only for now) ***: Caarrie|away is now known as Caarrie
rpg has joined #tikiwiki
Amorphous has quit IRC (Connection timed out)
Amorphous has joined #tikiwiki
Lucymoz has joined #tikiwiki
Caarrie is now known as Caarrie|sleeping
mlaporte1 has quit IRC (Read error: 104 (Connection reset by peer))
kutti has joined #tikiwiki kutti: hi everbody, could you provide me some good meterial for tpl language? ***: uSlacker has quit IRC (Remote closed the connection)
uSlacker has joined #tikiwiki marclaporte: tpl?
http://www.smarty.net/ kutti: marclaporte, Thank you ***: rpg has quit IRC ()
kutti has quit IRC ("CGI:IRC (EOF)") SEWilco2: marclaporte: Thanks for answering that. When reading the backscroll, I was trying to figure out how one told good joke material in tpl. :-) ***: SEWilco2 has quit IRC (Remote closed the connection)
franck has quit IRC ()
nkoth3 has joined #tikiwiki
Lucymoz has quit IRC (Read error: 110 (Connection timed out))
Amorphous has quit IRC (verne.freenode.net irc.freenode.net)
Amorphous has joined #tikiwiki luciash: polom
huh ? nice image but why ? → http://dev.tikiwiki.org/tiki-browse_image.php?galleryId=1&imageId=63 ***: cnd_ has left CIA-71: tikiwiki: 03sylvieg * r16750 10/trunk/installer/schema/20090212_forum_tiki.sql: missing forums_queue update ***: kutti has joined #tikiwiki
Iramon has joined #tikiwiki
kutti has quit IRC ("CGI:IRC") Iramon: anyone going to madrid this weekend? marclaporte: yes ***: Caarrie|sleeping has quit IRC (verne.freenode.net irc.freenode.net)
niclone has quit IRC (verne.freenode.net irc.freenode.net)
Caarrie|sleeping has joined #tikiwiki
niclone has joined #tikiwiki
Caarrie|sleeping has quit IRC (Excess Flood)
nkoth3_ has joined #tikiwiki
Gazz1617 has joined #tikiwiki
Gazz1617 has quit IRC (Client Quit)
Caarrie has joined #tikiwiki
nkoth3 has quit IRC (Read error: 110 (Connection timed out))
ricks99 has joined #tikiwiki ricks99: hi all
i have a completely revamped installer. seems ok, but really needs more testing though, ok to check into head?
q: is there a setting to treat singular/plural tags the same (like we do with wiki words)? ***: marclaporte has quit IRC (Read error: 60 (Operation timed out))
Simmi has joined #tikiwiki
Simmi has quit IRC (Client Quit)
ricks99 has quit IRC (Read error: 104 (Connection reset by peer))
ricks99 has joined #tikiwiki
TheRedFox has joined #tikiwiki
TheRedFox is now known as philippeback
navster has joined #tikiwiki
Caarrie is now known as Caarrie|away
nkoth3 has joined #tikiwiki
nkoth3_ has quit IRC (Read error: 110 (Connection timed out))
zauber3r has joined #tikiwiki zauber3r: its possible export pages to pdf with head and foot lines? ***: SEWilco2 has joined #tikiwiki
zauber3r has quit IRC ("Tiki PJIRC Integrator") luciash: ricks99: it's very nice, go and commit ;) ***: xertok has joined #tikiwiki xertok: hi @ all
!help Tikiwiki|bot: You can get a more complete list of commands that work with this bot at http://tikiwiki.org/TikiBot . ricks99: k...on luciash's say so..... :) CIA-71: tikiwiki: 03ricks99 * r16751 10/trunk/ (installer/tiki-installer.php templates/tiki-install.tpl): [MOD]revamped installer. new ui. installation steps. performs some basic checks. allows for some configuration. ricks99: pls test philippeback: will do -: SEWilco2 finds the new installer is so shiny, he has to wear shades. ricks99: lol ***: tomb__ has quit IRC (Remote closed the connection)
tomb_ has joined #tikiwiki
fantoms has joined #tikiwiki
kerrnel has joined #tikiwiki kerrnel: Howdy
Anyone ever upgraded mysql from 4.1 to 5.0? Ever have problems running the mysql_upgrade script? I'm running it as root with correct password but it keeps telling me I don't have permission luciash: kerrnel: hi, i probably did, but i don't remember anymore unfortunatelly :-) kerrnel: You don't recall any errors when running the upgrade script? luciash: nope kerrnel: ok
this is killin me. :( luciash: maybe root needs to be allowed first somewhat ?
check the docs once again ;) kerrnel: root has universal privs on my 4.1 install. So I'm upgrading to 5.0 and now running the mysqlcheck to go from 4.1 to 5.0 but now root can't access it ***: fantoms has quit IRC ("Leaving.")
Lucymoz has joined #tikiwiki luciash: i'm not sure but maybe even user root must be first created/allowed to use mysql databases first ***: fantoms has joined #tikiwiki luciash: in 5.x ***: navster has quit IRC (Connection timed out) CIA-71: tikiwiki: 03ricks99 * r16752 10/trunk/templates/tiki-install.tpl: [FIX] unclosed div ***: marclaporte has joined #tikiwiki kerrnel: There's something about the way 5.0 does something different with sockets and host names
gah ***: fantoms has quit IRC (Read error: 110 (Connection timed out)) CIA-71: tikiwiki: 03ricks99 * r16753 10/trunk/templates/tiki-install.tpl: [FIX] validation errors luciash: ricks99: this is very controversal: "Tiki was able to send a test message to info@tikiwiki.org"
ricks99: i think it shouldn't do eutomatically without user's permission in the installer ricks99: other then actually sending an email, how to test? luciash: it could be considered as a privacy breach without knowing what is going on in the background
ricks99: when it's necessary it should be explained before sending and it should be optional on user's will [Yes/No] to send it to info@tw.o or email specified by user ricks99: so u think have prompt first will b ok? luciash: yes
next step, now there's a bug it seems: "Tiki cannot find a database connection. This is normal for a new installation."
but i didn't delete my db/local.php
it should say there's connection found if i want to upgrade or reinstall
*and ask if i want to upgrade or reinstall
o the left menu disappeared at this step
s/o/also ricks99: how to check? (i dont think the old installer did that) luciash: yes, it did
i remember that because i did this pretty frequently last days
(going to tiki-install.php and testing the installation process) ricks99: k. ill look
tx luciash. other than that, what did u think? luciash: i didn't go further than to the step "Reset database connection"
i don't see a way how to upgrade/run another install script now ? philippeback: maybe you have to set the password with OLD_PASSWORD ?
the PHP client may be unable to get to mysql. ricks99: after running the script, on step 6, thres a link to run anotherscript luciash: also in tiki-install.php?install_step=6 there's no menu on left side in FF
and why some links in the menu are accessible and some not ? ricks99: there were sine validation errors. i put anew file in a few minutes ago luciash: ah, so when i want to upgrade i go directly to step 6 ? ricks99: some screens reqd, some not. welcome & license always.
"review install" can't be accessed directly, only after executing ascript CIA-71: tikiwiki: 03ricks99 * r16754 10/trunk/ (installer/tiki-installer.php templates/tiki-install.tpl): [MOD] mail test now optional luciash: thanks ricks99 ricks99: no. ty luciash: so the only major bug now is that user cannot upgrade database without going through the all steps and filling all db connection data again even when he has to confirm current database username and password (at least that is what i had to) to access the installer ricks99: y, but imho step 1 & 2 (welcome & licesne) shoud always b requried (upgrade or new install)
i can see skipping system requirements, but should user be allowed to confrim (or change) their db connection? luciash: yes
maybe in the beginning make a choic "do you want new install or upgrade ?"
*choice
otherwise it looks much better than what we have had before imho, thy ricks99
i mean thank you ricks99 :) CIA-71: tikiwiki: 03ricks99 * r16755 10/trunk/templates/tiki-install.tpl: [MOD]tell user if existing db connection found, and allow to keep it or create a new connection. ricks99: tx. still neds i18n support. cant figure out how to include the switch-lang module luciash: it is great that tiki-install.php?lang=cs works ricks99: y, but id like to have a lang drop list on step 1 luciash: would be cool if it worked for tiki.install.php in case of "Tiki Installer Security Precaution" too
ricks99: it is already working ! :)
i18n
just the precaution cases were hardcoded in english ricks99: but user has to know bfore hand to add &lang=xx to the url. not very useful luciash: ah, yup, so just include the lang_switch module ? ricks99: i did but got blank drop list. i think the problem is thtat the installer does not fully load all the stuff. plus, the module requires that feature_multi = y and that user_can_swithc=y, both of which are not yet set
i dont know how to get these things to work even before populating the db luciash: you can also make hardcoded bar of languages flags or dropdown list with the languages which would redirect to ?lang=... ricks99: flags are bad.... so is hardcoding :) luciash: so make a php function which will read all the languages from the lang/ dir ;)
don't use the module then ricks99: u mean copy/paste from the existing module's php? i guessthat would work, but seems like a lot of work.
is there a way to "temporarily" set a prefernce? SEWilco2: Grr. Blank screen on my copy of trunk. Is it my last edit or someone else?
ricks99: Can't you just set the global preference's variable in order to make it be set during the current request? Won't be set for next interaction without a parameter or something. ricks99: @SEWilco2: but theres not even a database built yet (in the case of a brand new install) SEWilco2: ricks99: Or instead of copy/paste, yank the common code out into a library so there's only one copy to maintain? ricks99: enitrely beyond my hack & slash abilities SEWilco2: ricks99: For temp setting a preference, I think you could force the global tiki_p_whatever at the start of the install php code, so all the rest of the code sees that preference variable as being set.
ricks99: The true setting of the variable won't appear until the program being called is no longer the install program, and prefs read from DB. ***: Simmi has joined #tikiwiki CIA-71: tikiwiki: 03ricks99 * r16756 10/trunk/ (installer/tiki-installer.php templates/tiki-install.tpl): [MOD]Now checks for upgrade and allows user to jump directly to the install/upgrade script page. SEWilco2: In trunk I tried to upgrade my DB. Error looks like missing ').
Oh, no, there is the ')'. Hmm.
INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) SELECT 42,'o','Content Templates','tiki-admin_content_templates.php',1256,'','tiki_p_edit_content_templates','',0 WHERE @fgcant = 0;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE @fgcant = 0' at line 1 CIA-71: tikiwiki: 03ricks99 * r16757 10/trunk/templates/tiki-install.tpl: [FIX]add missing labels. done? luciash: ricks99: good job :) the installer is very nice now ! ricks99: tx for ur help
should also b tested in multitiki -- i have no environment locally luciash: no multitiki here either
i think we could add Install/Upgrade link in the Admin menu too ricks99: there's already an upgrade button on admin: general luciash: ah, didn't notice that ricks99: *reworking the admin panels is my next step... luciash: i've just made both, upgrade and re-populate database with default installation profile and both went flawlessly
ricks99: i'm already working on it if you can wait a bit ;) ricks99: woo hoo! luciash: i'll commit my changes/fixes tonight i hope and i'll try to respect your ideas of the revamp pages
i'd like to move the checkboxes left and avoid tables ricks99: uv seen my tpl: http://dev.tikiwiki.org/tiki-index.php?page=Regrouping+the+General+Admin+page luciash: i'll download it xertok: hello everybody - can someone help me with the error-msg 'Auth_Container_LDAP: LDAP Extension not loaded' - i had no idea, already checked the whole settings :( luciash: sorry, xertok, no LDAP here
ricks99: this is wrong sentence i guess: "This script will populate (or upgrade), to populate the database." ricks99: the "... to populate.." should b removed
<sheesh> and to think that english *is* my first language luciash: :) ricks99: @xertok: sounds like the php ldap exentsion is notloaded xertok: i checked php-modules loaded - there only two: mod_authnz_ldap util_ldap ricks99: dont know. sorry. try posting in the support forum: http://tikiwiki.org/tiki-view_forum.php?forumId=17 luciash: ricks99: there's still a little typo on step 3 "to send a test messgae" ricks99: "my kingdom for a spell checker" -: SEWilco2 prefers messgae when battered and lightly fried in canola oil. xertok: bye & nn all ***: xertok has quit IRC ()
mycomputer has joined #tikiwiki SEWilco2: When trying to do a DB update, should the install script step 6 be run, where it asks for site name and admin email address? Looks like it's going to initialize what already exists. ricks99: hm.. good point....
i guess step should b skipeed for upgrades?
or maybe populate from db. would b better SEWilco2: ricks99: I think when doing a DB update, the button used to only do the DB update screen and not the entire installation process. ***: Iramon has quit IRC ()
mycomputer has quit IRC ("Quitte")
Simmi has quit IRC ("Leaving.") CIA-71: tikiwiki: 03ricks99 * r16758 10/trunk/templates/tiki-install.tpl: [FIX]typos. installer will now skip general settings for upgrades
tikiwiki: 03sylvieg * r16759 10/trunk/ (10 files in 6 dirs):
tikiwiki: [MOD]poll: from sumo: each poll can have a vote consideration span= last days nb
tikiwiki: for which statitics are computed + can choose the time span results are
tikiwiki: displayed + perm to see the poll voters (REPLACE THE FEATURE POLL IS PUBLIC +
tikiwiki: DISABLE LOCAL VOTERS LIST (as the option was already there - rollback 15708)
tikiwiki: 03sylvieg * r16760 10/trunk/ (db/tiki.sql tiki-poll_results.php):
tikiwiki: [MOD]poll: from sumo: each poll can have a vote consideration span= last days nb
tikiwiki: for which statitics are computed + can choose the time span results are
tikiwiki: displayed + perm to see the poll voters (REPLACE THE FEATURE POLL IS PUBLIC +
tikiwiki: DISABLE LOCAL VOTERS LIST (as the option was already there - rollback 15708) SEWilco2: Looks like we need some water-cooled keyboards. ***: franck has joined #tikiwiki
ricks99_ has joined #tikiwiki
ricks99 has quit IRC (Read error: 60 (Operation timed out)) kerrnel: I'm still running into mysql database sluggishness
Didn't have the problem in 1.9 but upgrading to 2.x just kills the system. I have upgraded to mysql5.0 and php5. Am I missing something? Our largest tracker has 2800 entries. Our tiki_tracker_field_items contains 180,000 records. An I doing something fundamentally wrong?
performance gets so bad that load hits 30+ and even ssh becomes slow SEWilco2: kerrnel: Flush your tiki caches?
kerrnel: Were you storing your images and files in files, and are you still configured to store them there?
kerrnel: I'm wondering if a database table needs to have an index rebuilt, but don't know the database well enough to know if that is relevant.
kerrnel: I'm out of suggestions. Let's see if someone else has ideas. Most of your content is in trackers, then? What kind of data? kerrnel: Caches were all cleared ***: philippeback has quit IRC ("Did anyone see my lost carrier?") kerrnel: I'd say the majority of content is probably trackers, yes. SEWilco2: kerrnel: Check if you have munin or some other monitoring tool installed. Maybe you can find something that's overly busy. kerrnel: Not to my knowledge. I run this server and I didn't install any db monitoring software.
Specifically the queries that are slowing everything down are the ones that build the first page for each individual tracker. SEWilco2: kerrnel: Actually, munin can monitor a bunch of stuff. It can show some DB summary also. It's more of a system tool than DB. kerrnel: At this point the db is slowing down the entire system
So it wouldn't matter what I used SEWilco2: At least you found the piece to examine. If you have phpmyadmin, I think that has a statistics viewing page. Look for red. kerrnel: I turned on the sql debug in tiki which created another table, and that tells me which queries are hogging up the resources, but it doesn't really tell me how to fix it. Not even sure its fixable unless the query is rewritten. ***: ricks99_ has quit IRC ("Trillian (http://www.ceruleanstudios.com") SEWilco2: kerrnel: Because it slowed so dramatically, I suspect the DB update rendered some indexes invalid.
kerrnel: I don't know if restarting the DB server would help. Do I remember an option to clear execution plan cache? ***: danopia has quit IRC (Excess Flood)
danopia has joined #tikiwiki SEWilco2: In phpmyadmin, at bottom of Operations tab for a table are several maintenance options. Check, Analyze, Repair, Optimize, Flush. Optimize might help. That's a MySQL command.
There are several tracker_* tables. Don't know which have your kind of data.