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) hi everbody, could you provide me some good meterial for tpl language? tpl? http://www.smarty.net/ marclaporte, Thank you marclaporte: Thanks for answering that. When reading the backscroll, I was trying to figure out how one told good joke material in tpl. :-) polom huh ? nice image but why ? → http://dev.tikiwiki.org/tiki-browse_image.php?galleryId=1&imageId=63 tikiwiki: 03sylvieg * r16750 10/trunk/installer/schema/20090212_forum_tiki.sql: missing forums_queue update anyone going to madrid this weekend? yes 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)? its possible export pages to pdf with head and foot lines? ricks99: it's very nice, go and commit ;) hi @ all !help You can get a more complete list of commands that work with this bot at http://tikiwiki.org/TikiBot . k...on luciash's say so..... :) 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. pls test will do lol 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 kerrnel: hi, i probably did, but i don't remember anymore unfortunatelly :-) You don't recall any errors when running the upgrade script? nope ok this is killin me. :( maybe root needs to be allowed first somewhat ? check the docs once again ;) 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 i'm not sure but maybe even user root must be first created/allowed to use mysql databases first in 5.x tikiwiki: 03ricks99 * r16752 10/trunk/templates/tiki-install.tpl: [FIX] unclosed div There's something about the way 5.0 does something different with sockets and host names gah tikiwiki: 03ricks99 * r16753 10/trunk/templates/tiki-install.tpl: [FIX] validation errors 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 other then actually sending an email, how to test? 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 so u think have prompt first will b ok? 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 how to check? (i dont think the old installer did that) yes, it did i remember that because i did this pretty frequently last days (going to tiki-install.php and testing the installation process) k. ill look tx luciash. other than that, what did u think? 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 ? maybe you have to set the password with OLD_PASSWORD ? the PHP client may be unable to get to mysql. after running the script, on step 6, thres a link to run anotherscript 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 ? there were sine validation errors. i put anew file in a few minutes ago ah, so when i want to upgrade i go directly to step 6 ? some screens reqd, some not. welcome & license always. "review install" can't be accessed directly, only after executing ascript tikiwiki: 03ricks99 * r16754 10/trunk/ (installer/tiki-installer.php templates/tiki-install.tpl): [MOD] mail test now optional thanks ricks99 no. ty 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 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? 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 :) 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. tx. still neds i18n support. cant figure out how to include the switch-lang module it is great that tiki-install.php?lang=cs works y, but id like to have a lang drop list on step 1 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 but user has to know bfore hand to add &lang=xx to the url. not very useful ah, yup, so just include the lang_switch module ? 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 you can also make hardcoded bar of languages flags or dropdown list with the languages which would redirect to ?lang=... flags are bad.... so is hardcoding :) so make a php function which will read all the languages from the lang/ dir ;) don't use the module then 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? 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. @SEWilco2: but theres not even a database built yet (in the case of a brand new install) ricks99: Or instead of copy/paste, yank the common code out into a library so there's only one copy to maintain? enitrely beyond my hack & slash abilities 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. 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. 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 tikiwiki: 03ricks99 * r16757 10/trunk/templates/tiki-install.tpl: [FIX]add missing labels. done? ricks99: good job :) the installer is very nice now ! tx for ur help should also b tested in multitiki -- i have no environment locally no multitiki here either i think we could add Install/Upgrade link in the Admin menu too there's already an upgrade button on admin: general ah, didn't notice that *reworking the admin panels is my next step... 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 ;) woo hoo! 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 uv seen my tpl: http://dev.tikiwiki.org/tiki-index.php?page=Regrouping+the+General+Admin+page i'll download it 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 :( sorry, xertok, no LDAP here ricks99: this is wrong sentence i guess: "This script will populate (or upgrade), to populate the database." the "... to populate.." should b removed and to think that english *is* my first language :) @xertok: sounds like the php ldap exentsion is notloaded i checked php-modules loaded - there only two: mod_authnz_ldap util_ldap dont know. sorry. try posting in the support forum: http://tikiwiki.org/tiki-view_forum.php?forumId=17 ricks99: there's still a little typo on step 3 "to send a test messgae" "my kingdom for a spell checker" bye & nn all 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. hm.. good point.... i guess step should b skipeed for upgrades? or maybe populate from db. would b better ricks99: I think when doing a DB update, the button used to only do the DB update screen and not the entire installation process. 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) Looks like we need some water-cooled keyboards. 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 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? Caches were all cleared I'd say the majority of content is probably trackers, yes. kerrnel: Check if you have munin or some other monitoring tool installed. Maybe you can find something that's overly busy. 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. 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. At this point the db is slowing down the entire system So it wouldn't matter what I used At least you found the piece to examine. If you have phpmyadmin, I think that has a statistics viewing page. Look for red. 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. 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? 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.