<!-- Some styling for better description lists --><style type='text/css'>dt { font-weight: bold;float: left;display:inline;margin-right: 1em} dd { display:block; margin-left: 2em}</style>
redflo: joined #tikiwiki
Tiki|bot: joined #tikiwiki
dabright: joined #tikiwiki
<br> joined #tikiwiki
<br> joined #tikiwiki
chibaguy: joined #tikiwiki
Gwayne: joined #tikiwiki
dabright: joined #tikiwiki
<br> joined #tikiwiki
redflo: joined #tikiwiki
<br> joined #tikiwiki
mepg: joined #tikiwiki
<br> Hey guys, I'm having some issues with 12.0
<br> I have ported an old version (3.1) to a brand new server
<br> The target was getting the latest version, so far everything works aside of the most important thing!
<br> Nobody can login with his pw.
<br> When I do a password recovery, use the recovery URL, set a new pw, then I am logged in.
<br> However the moment I logout, I cannot login anymore!
<br> After entering the password I keep getting redirected to tiki-login_scr.php
<br> with no error message
<br> Doing a new pw recovery leads to the same result
Odarys: joined #tikiwiki
<br> it's me mepg, figured it makes more sense to join with a irc client istead of web.
<br> i'm assuming that it has something todo with the encoding
<br> the orginal db was latin1_swedich
<br> tho all the old articles, posts, comments are getting displayed just fine
<br> (btw it also doesn't seem to matter to which version I upgrade, also tested 9.7)
xavi: hi Odarys. I suggest that you follow all the steps indicated here in the way they are indicated: http://doc.tiki.org/Upgrade#If_you_need_to_fix_the_encoding_issue
<br> just to be sure that you discard the option of an encoding issue
<br> also ensure that you ugprade in a new directory, not placing the new files over the old ones
<br> and ensure that you use a brand new .htaccess file, and not an old one from 3.x
<br> hth
<br> bbl
redflo: joined #tikiwiki
Tiki-KGB: 03gezzzan r51319 10trunk/templates/tiki-view_articles.tpl * [MOD] adding bootstrap classes to buttons
<br> 03gezzzan r51320 04trunk/templates/layouts/application
<br> [DEL] removing application layout (commited earlier by me), it is too experimental for Tiki13
Odarys: xavi, okay so that wasn't neccessary.
<br> I've found out that I couldn't login, because my httpd server settings were forcing https
<br> while https was disabled within the tikiwiki settings
<br> meaning, after removing the "force https" from httpd, I can login just fine!
<br> However, there is another issues.
<br> Even thought I am in the Admins group and see all the settings
<br> I can change them in the form, apply, it tells me that they were applied
<br> but when I relogin, they are back to what they were
<br> (after I click apply, it gives me the notice that everything was applied, eg https_login, feature_show_stay_in_ssl_mode or rememberme etc. (any settings)
<br> ideas?
<br> can I somehow change those manually?
<br> basicially I can't even set error_reporting_level to show all errors :/
<br> or each time I login I get the "Tiki Setup" page display, even after I unchecked the "Show on admin login" or clicked "Skip setup and don't show again"
xavi: <u>Odarys</u>: if you didn't do this beforehand in your upgrade from 3.x to 9.x or 12.x, please, do so once:
<br> "I suggest that you follow all the steps indicated here in the way they are indicated: http://doc.tiki.org/Upgrade#If_you_need_to_fix_the_encoding_issue "
jonnyb: joined #tikiwiki
<br> pompompom
chibaguy: joined #tikiwiki
jonnyb: hey chibaguy - going to do the menu module thing now, may have questions...
Odarys: <u>xavi</u>: i've dumped the db with default encoding latin1, do I also have to use such a param while importing on the new serv?
<br> well when I do it as stated in that doc, I get "Something is wrong with the database encoding"
<br> "The schema has UTF-8 as default encoding but some tables in the schema have a different collation, latin1_swedish_ci. "
<br> I exported with --default-character-set=latin1, created the new db as latin1_swedich, importet without any extra params
<br> imported*
<br> then ran the installer, force UTF8.. and convert..
<br> i'll try to important with the same param as export..
<br> import*
xavi: <u>Odarys</u>: nope, create the db with utf8
<br> that should be indicated in that doc page
<br> oh well, mmmm, yes, import (if it's a different server) with same enconding, you are right. The installer tiki-install.php should do the conversion
<br> s/enconding/encoding
Tiki-KGB: 03jonnybradley r51321 10trunk/lib/smarty_tiki/function.html_body_attributes.php * [FIX] notice: undefined constant layout_
Odarys: xavi well it doesn't work
xavi: why not?
Odarys: even when importing with --default-character-set=latin1
<br> I still get that error ?
xavi: which one?
Odarys: 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. Converting to UTF-8 may solve this but may also make matters worse. You should investigate what happened or only proceed with backups.
<br> (when trying to convert via the installer)
xavi: check which tables are still latin1_swedish_ci
<br> through phpmyadmin or similar
<br> and in case the process was stopped due to timeouts or similar, run that conversion again through the tiki-install.php script
Odarys: tiki_searchindex
<br> tiki_searchwords
<br> those two..
xavi: ok, no problem, you can convert those 2 manually with phpmyadmin if needed (if the installer doesn't for some misterious reason)
Odarys: yeah the installer gives the same error over and over again
xavi: ok, phpmyadmin then to fix
<br> go to the table, then options (I think), and convert encoding of the table
<br> in a later step, tiki will convert the content also to utf8 (but this will be later)
Odarys: yeah I did that..
<br> the upgrade to 12.1 gives one sql error
<br> UPDATE `tiki_file_galleries` SET `parentId` = (SELECT * FROM (SELECT `galleryId` FROM `tiki_file_galleries` WHERE `type` = 'system') AS t) WHERE `parentId` = -1 AND `type` != 'system'
<br> You can't specify target table 'tiki_file_galleries' for update in FROM clause
jonnyb: hi Odarys - which version of mysql are you on? i seem to remember that update script fails on some old versions...
Odarys: <u>jonnyb</u>: it's as up to date as it comes, this is a brand new server running Fedora 20.
<br> Software-Version: 5.5.37-MariaDB - MariaDB Server
<br> Apache/2.4.9 (Fedora) OpenSSL/1.0.1e-fips PHP/5.5.12 mod_perl/2.0.9-dev Perl/v5.18.2
jonnyb: ah, don't know about MariaDB - maybe that's not allowed in that
<br> that was an update script from 2009
Odarys: so, do you maybe have an idea how we could restructure the query I pasted, so that it works on a modern db?
jonnyb: do you have file galleries?
Odarys: tbh. I was asking myself the same questions, I don't really remember :P
jonnyb: well, do you have any row in that table?
Odarys: yeah I just checked.. I do
jonnyb: rows
<br> and do any of them have parentId = -1 and type != system?
Odarys: yes.. 3
<br> ohh.. != system.. no
jonnyb: probably easiest to fix them by hand
Odarys: the only ones with -1 as parentID are system
jonnyb: so all galleries with parentId = -1 (i.e. no parent) are system galleries?
Odarys: so it's fine I guess
<br> yeah
jonnyb: you're probably ok then
<br> but if some galleries have disappeared that will be the reason - before that script parent -1 counted as a "root" gallery, i.e. top level
<br> you should be able to mark that schema as "ignore" or whatever it is
biginnertoblende: joined #tikiwiki
Tiki-KGB: 03jonnybradley r51322 10trunk/lib/smarty_tiki/function.button.php * [FIX] buttons: Missing underscore
Odarys: okay so, everything seems to work, but when I go into the admin panel it tells me "Database Version Problem"
<br> Your database requires an update to match the the Tiki version; use the installer. Using Tiki with an incorrect database version will cause errors. If you have shell (SSH) access, you can also use the following, on the command line, from the root of your Tiki installation: php installer/shell.php
<br> when I use the installer to upgrade again, it gives 2 errors related to the galleries
<br> and the admin panel keeps showing me the same error notification
jonnyb: don't you get a checkbox next to the errors in the installer? (the browser one)
Odarys: jonnyb had to click "show all" :P
<br> thanks for the great support, I really appriciate it!
jonnyb: aha, super
Odarys: I guess that's it for me, everything seems to work as expected :)
jonnyb: nice
<br> if you can add anything to the documentation that would be great (i'll carry on fixing bugs ;)
luciash: polom
jonnyb: moloq luciash
Tiki|bot: joined #tikiwiki
jonnyb: is tiki-admin_modules.php broekn in 12.x for anyone else? or just a local thing for me?
luciash: <u>jonnyb</u>: lemme check my local up-to-date copy
jonnyb: i'm getting my app menu ending up in the topbar if i drag & drop then save (say a trivial change in the right col) - well weird...
luciash: right col ? lemme try
<br> <u>jonnyb</u>: works for me (dragged from left col to right col and saved)
jonnyb: aha, think i've got it - i have some category plugins inside my topbar menu (testing for a certain client of ours ;) ) and they're messing things up
<br> can fix...
luciash: :)
Tiki-KGB: 03jonnybradley r51323 10trunk/lib/modules/tiki-admin_modules.js * [FIX] modules: Ignore modules nested in other modules when saving layout
luciash: ah u mean those fluffies ?! ;-)
Tiki-KGB: 03jonnybradley r51324 10branches/ 1012.x/lib/modules/tiki-admin_modules.js 1012.x
<br> [bp/r51323][FIX] modules: Ignore modules nested in other modules when saving layout
jonnyb: :)
<br> fluffies within fluffies... dangerous!
<br> ok, off to get some air/sun/food - bbl
ricks99: joined #tikiwiki
Tiki|bot: New Forum Posts: Beta character - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=52211
<br> Recent Bug: - An option to display comments with PluginArticles - http://dev.tiki.org/item5243
Jyhem_: joined #tikiwiki
nelsonko: joined #tikiwiki
jonnyb: joined #tikiwiki
<br> left #tikiwiki
<br> joined #tikiwiki
<br> repolom
luciash: wb
arildb: joined #tikiwiki
Tiki-KGB: 03fmg-sf r51325 10trunk/permissioncheck/.htaccess
<br> [FIX] default password protection disabled, it prevents PHP HTTP request for TPC model check
<br> 03fmg-sf r51326 10branches/12.x/permissioncheck/.htaccess
<br> [bp/r51325] [FIX] default password protection disabled, it prevents PHP HTTP request for TPC model check
diggy: joined #tikiwiki
Tiki-KGB: joined #tikiwiki
<br> 03jonnybradley r51327 10trunk/ 10modules/mod-func-menu.php 10templates/modules/mod-menu.tpl 10lib/smarty_tiki/function.menu.php
<br> [ENH] menus: Make bootstrap menu modules configurable, adding bootstrap and navbar_toggle params
<br> 03jonnybradley r51328 10trunk/ 10lib/modules/tiki-admin_modules.js 10templates/tiki-admin_modules.tpl
<br> [FIX] modules: Fix save button and remove redundant button param (did nothing anyway)
chibaguy: joined #tikiwiki
Tiki-KGB: 03jonnybradley r51329 10trunk/lib/tikilib.php * [FIX] Update TikiLib::lib phpdoc (phpStorm uses it for code completion etc)
<br> 03jonnybradley r51330 10branches/ 1012.x 1012.x/lib/tikilib.php
<br> [bp/r51329][FIX] Update TikiLib::lib phpdoc (phpStorm uses it for code completion etc)
<br> Not quite a backport, rebuilt as 12.x libs are slightly different but still had several missing
<br> 03arildb r51331 10trunk/tiki-view_blog_post.php * [FIX] Make sure categlib exists
<br> 03arildb r51332 10branches/12.x/tiki-view_blog_post.php * [bp/r51331][FIX] Make sure categlib exists
<br> 03jonnybradley r51333 10trunk/templates/admin/admin_navbar_menu.tpl * [FIX] typo
<br> 03jonnybradley r51334 10trunk/templates/admin/include_payment.tpl * [FIX] bootstrap casualty: missing > on closing tag breaking admin form
<br> 03jonnybradley r51335 10trunk/templates/footer.tpl
<br> [FIX] antibot: Trailing comma not allowed in JS (not sure this JS is really needed here, just looks wrong...)
<br> 03jonnybradley r51336 10trunk/ 10lib/payment/cartlib.php 10templates/admin/include_payment.tpl 10lib/prefs/payment.php * [ENH] cart: Make the payment heading a pref
<br> 03jonnybradley r51337 10trunk/lib/prefslib.php
<br> [FIX] prefs: Use single quotes in onclick attributes as double quotes were getting escaped and showing up as validation errors
<br> 03lphuberdeau r51338 10branches/12.x/lib/core/Search/ContentSource/TrackerItemSource.php * [ENH] Indexing the item creation date
<br> 03jonnybradley r51339 10branches/ 1012.x 1012.x/templates/admin/include_payment.tpl 1012.x/lib/prefs/payment.php 1012.x/lib/payment/cartlib.php * [bp/r51336][ENH] cart: Make the payment heading a pref
Telesight: joined #tikiwiki
Tiki-KGB: 03jonnybradley r51340 10branches/ 1012.x/templates/footer.tpl 1012.x 1012.x/lib/prefslib.php
<br> [bp/r51335][FIX] antibot: Trailing comma not allowed in JS (not sure this JS is really needed here, just looks wrong...)
<br> [bp/r51337][FIX] prefs: Use single quotes in onclick attributes as double quotes were getting escaped and showing up as validation errors
ricks99: left #tikiwiki
Tiki-KGB: 03nkoth r51341 10trunk/lib/wiki-plugins/wikiplugin_customsearch.php
<br> [FIX] Search should be sorted by search relevance where there is a text search query present (even if there is sort mode set, unless overridden
<br> 03jonnybradley r51342 10branches/12.x/ 10templates/tiki-adminusers.tpl 10tiki-adminusers.php
<br> [FIX] user admin: Restore long lost feature to force a user to re-validate their account via email (thanks Xavi for the clue!)
<br> 03jonnybradley r51343 10trunk/templates/tiki-adminusers.tpl
<br> [FIX] bootstrap casualty: Repair user admin form login input (no such var as $userlogin in adminusers)
<br> 03jonnybradley r51344 10trunk/templates/tiki-adminusers.tpl 10trunk/tiki-adminusers.php 10trunk
<br> [bp/r51342][FIX] user admin: Restore long lost feature to force a user to re-validate their account via email (thanks Xavi for the clue!)
jonnyb: hi nelsonko - how's it going?
nelsonko: hi jonny
jonnyb: i did the changes to mod-menu earlier on, have you had a chance to have a look?
nelsonko: not yet
<br> I
<br> I have conference call from 3 to 5, and then on the road
jonnyb: sometime i'll add some upgrade scripts and a little bit more js to make positioning more automatic, but that main enhancement is now in
nelsonko: how much left is there to go? shall we touch base Monday morning?
jonnyb: i tihnk everything else counts as [FIX]es imho, but Monday would be fine for branching too
<br> (i'm knackered ;) )
nelsonko: ok, I'll have a look Sunday afternoon (between tonight and Sunday morning, my wife is taking me to a mysterious location for our anniversary)
jonnyb: i've also done the critical fixes for 12.2 (i think)
<br> oooooh! :)
<br> have a nice weekend, see you monday if not before
nelsonko: alright. I do want to add a notications bell module
jonnyb: oh, (sorry) i think the git repo is stuck again, could you kick it if you have time?
nelsonko: oh, ok I will look now
jonnyb: oh yes, that would be good too
nelsonko: git updated again
jonnyb: super, thanks!
<br> was it a new contributor again?
nelsonko: <u>jonnyb</u>: no, unknown reason
jonnyb: hmm, flakey
<br> must say i'm sort of getting into git - so quick to do some stuff like history etc
<br> anyway, many thanks :)
Tiki-KGB: 03lphuberdeau r51345 10trunk/ 10lib/jquery_tiki/tiki-jquery.js 10templates/monitor/notification_link.tpl 10lib/smarty_tiki/function.favorite.php
<br> [ENH] Move the local storage expiry logic from the unread count into the base local storage component, apply expiry to favorites so it refreshes once in a while (multi-browser edge case), include the user in the key names so that it does not conflict between sessions
nelsonko: <u>jonnyb</u>: do you think this is back portable? ^
jonnyb: do you mean r51345? no idea, not looked at it yet
nelsonko: i'm trying it now, basically the favourite buttons show on or off depending on the stuff stored in the local storage (favoriteList)
<br> and if you switch users th buttons show in the wrong state, because you have some other user's list
jonnyb: i'm not too familiar with local storage - sounds like the work of the devil :)
nelsonko: also, if you use different browsers/devices, they don't look right either
jonnyb: but 12.x has favourites to probably relevant there
nelsonko: I'm sure it's broken on 12 as well
jonnyb: sounds likely
<br> ok, i've had enough friday for this week - more soon later...
Tiki-KGB: 03lphuberdeau r51346 10trunk/lib/rss/pagecontentlib.php
<br> [FIX] Expand relative paths when importing the content, ensure the URL used follows the redirects
<br> 03xavidp r51347 10trunk/ 10templates/tracker/replace.tpl 10lang/ca/language.php 10templates/wizard/upgrade_trackers.tpl
<br> [FIX]Typo in English string, split equivalent match in a longer string to match previous ones (separated), and fix in the only language.php with that string translated
<br> 03xavidp r51348 10branches/12.x/ 10templates/tracker/replace.tpl 10lang/ca/language.php
<br> [bp/r51347][FIX]Typo in English string, split equivalent match in a longer string to match previous ones (separated), and fix in the only language.php with that string translated. Only one tpl fixed in 12.x since the other tpl has been backported yet.
xavi: left #tikiwiki
nelsonko: joined #tikiwiki