[00:43] nelsonko joined #tikiwiki [01:37] jonnyb joined #tikiwiki [02:23] Tiki|bot New Forum Posts: Broken Images - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=61440 [02:23] Tiki|bot New Forum Posts: https://dev.tiki.org/Tiki16 is just a white screen - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61429 [02:23] Tiki|bot New Forum Posts: JS Minify [was [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[59865] trunk/lib/codemirror_tiki/tiki_codemirror.php] - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61426 [02:33] Tiki|bot New Forum Posts: Broken Images - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=61440 [02:33] Tiki|bot New Forum Posts: https://dev.tiki.org/Tiki16 is just a white screen - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61429 [02:33] Tiki|bot New Forum Posts: JS Minify [was [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[59865] trunk/lib/codemirror_tiki/tiki_codemirror.php] - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61426 [03:34] rpg joined #tikiwiki [04:22] panamaus joined #tikiwiki [07:34] Tiki-KGB 03amnabilal r59913 10trunk/ 10lib/wiki-plugins/wikiplugin_pivottable.php 10lib/core/Services/Pivot/Controller.php 10templates/wiki-plugins/pivottable.tpl [07:34] Tiki-KGB [ENH][Fix]Pivottable plugin fixes, get default column and rows if parameters is not passed. Modified plugin shortcode, fixed js files loading in tpl,multiple fixes in controller.php. [08:08] NoteOn joined #tikiwiki [09:59] fabricius joined #tikiwiki [10:05] olinuxx joined #tikiwiki [10:24] MMax joined #tikiwiki [10:24] MMax Hi! [10:25] MMax i want to upgrade tiki 12.2 to 15.2 [10:25] MMax but i have an Error [10:26] MMax Fatal error: Uncaught exception 'TikiDb_Exception' with message 'Data too long for column 'pageSlug' at row 1' in tiki-15.2/lib/core/TikiDb/Exception.php:15 [10:26] MMax any idea what i have to do!? [10:31] MMax php console.php -n database:update -> [TikiDb_Exception] Data too long for column 'pageSlug' at row 1 [10:40] luciash hi MMax [10:41] luciash can you check what you have in pageSlug in db? iirc it is used for slugs to be filled in SEFURLs like my-fancy-page - the page slug is the "-" character here - should be just one char maybe? [10:44] luciash MMax: or "_" [10:47] NoteOn hi [10:48] NoteOn for update, ie. 15.1 to 15.2 = minor update, [10:50] luciash NoteOn: hi, yep [10:50] NoteOn installer ask setup value not in db, so we must re input setup? [10:51] luciash NoteOn: not sure I understand what you mean [10:51] NoteOn I didn't check installer php yet, values are in file. [10:51] NoteOn sorry, again;)... [10:51] luciash np :) [10:52] luciash you just run php console.php d:u [10:52] luciash and it should do it [10:52] luciash or the database upgrade step in tiki installer via browser [10:52] NoteOn when update, val are in db, such as site name, slogan etc. so we can use old val, but some are in file. setup php file that not in new version'ts zip. [10:53] NoteOn so in normal step, we need re input setup val then installer write to file. [10:53] luciash ah, yes, you need to copy them over if you had modified files [10:53] NoteOn is there way to use val that in file, [10:54] luciash there is tiki.ini possible [10:55] luciash but that is for new sites migrations i think [10:55] luciash not necessary for minor site upgrades [10:55] MMax hi luciash - thx for your answer [10:55] MMax i cant find a table with the name paheSlug [10:55] MMax pageSlug [10:56] luciash MMax: it is not db table name [10:56] luciash it is column [10:56] MMax and in which table? [10:56] luciash maybe in tiki_preferences table? [10:57] NoteOn luciash: huum, i will check, doing test update, [10:57] NoteOn in doc says, after update, do copy extra files... but its good to keep old val that in file while update process [10:58] MMax nope - there is no column pageSlug [11:00] MMax https://sourceforge.net/p/tikiwiki/mailman/tikiwiki-cvs/?viewmonth=201407&viewday=14 [11:00] MMax tiki_pages [11:02] NoteOn MMax: //CREATE TABLE `tiki_pages` ( [11:02] MMax there are many values [11:02] NoteOn its in `pageSlug` varchar(160) COLLATE utf8_unicode_ci DEFAULT NULL, [11:03] NoteOn ah u mean there is no data? [11:03] MMax the column pageSlug is in use [11:03] luciash no, I mean it is trying to put there more than 160 characters for some reason [11:03] NoteOn ic [11:03] luciash when MMax doing site upgrade from 12.x [11:04] NoteOn ah 12x to 15.3? huum [11:04] MMax the column has 160 chars, charset utf8, collation utf8_unicode_ci [11:04] MMax should i try 180 chars? [11:04] luciash actually it might be putting more than the slug character [11:05] luciash MMax: you can try to increase it but it would be better if we find out why it does not fit in there while doing the upgrade - it should not happen [11:06] luciash can you see what values it contains in 12.x ? [11:06] luciash MMax: do you have very long page names? [11:06] MMax yes [11:07] MMax there are long [11:07] MMax they [11:07] luciash pageName is also limited to 160 chars? [11:07] luciash column [11:07] MMax yes, 160 chars [11:08] luciash ah, so i wonder if it adds some more characters for the pageSlug as opposed to pageName... hmm [11:08] MMax pageName is also limited to 160 chars [11:08] luciash i thought it just replaces some spaces with the slug (underscore) [11:09] MMax but default is "empty string" [11:09] MMax pageSlug has default "null" [11:10] luciash in 12.x you have "Page Foo Bar" and pageSlug "Page_Foo_Bar" ? or pageSlug values are empty/null there? [11:11] MMax "Page+Foo+Bar" [11:11] MMax !? [11:11] redflo joined #tikiwiki [11:12] MMax PageName "Page Foo" [11:12] MMax PageSlug "Page+Foo" [11:12] NoteOn huum, I used old version before, very old,, 1.7x or so, so [11:13] NoteOn and re started 15x [11:13] NoteOn so not for me but let me know, how installer does, dev do good job but we need care big changes? [11:14] NoteOn such as version upgrade 14 to 15 or 14 to 16 [11:16] luciash MMax: looks good, so the slug character seems to be "+" by default, i see [11:16] MMax yes [11:17] luciash MMax: so I wonder why it yells "data too long" when actually the length is the same as pageName [11:18] luciash MMax: do you have any pages with special characters (nonascii)? [11:18] luciash in name i mean [11:18] MMax yes - i think we have pages with nonascii characters [11:19] luciash can you check what they have in there for pageSlug pls? [11:19] MMax give me a second [11:21] MMax like this "Best_l%C3%B6schbar" [11:21] luciash aah, i see the issue now! [11:22] MMax or "Bios+%E2%80%93+Ein..." [11:22] luciash the problem is it uses urlencode function on the strings inserted in pageSlug and that makes them longer than the pageName string [11:23] MMax what does this mean :-)!? [11:24] luciash so quick fix for you is to increase the 160 chars to something more, e.g. 3-times more (to be safe) [11:24] MMax 480 chars !? [11:25] luciash and we need to fix this in Tiki - either increase it too or do not use the urlencode for pageSlug but do something else on it, which does not increase the number of chars [11:25] luciash yep [11:26] MMax i try to increase it [11:27] luciash thanks for the report! if you have time pls add bug report to https://dev.tiki.org/file+a+bug [11:27] MMax hmmm "error: 1071 - Specified key was to long, max key length is 767 bytes" [11:28] luciash eh, ok, double then? [11:28] luciash :D [11:28] luciash not sure, maybe varchar has limit of 255 [11:28] luciash iirc [11:29] luciash try 255 [11:29] MMax 255 chars works [11:29] MMax should i try to upgrade again? [11:30] luciash yep [11:31] MMax it works :D [11:31] NoteOn huum utf-8 issue, that good point fo me also. [11:32] NoteOn im japanese, and we japanese need some job for utf-8 [11:32] NoteOn not only tiki [11:32] MMax thx for your support [11:33] NoteOn MMax: in my case, I setup test site and pre-test site if need, [11:33] NoteOn using Adminer is raid, dump and restore = backup, [11:34] NoteOn then check db by Adminer etc.. thats safe way.. [11:34] NoteOn in local test and pre-test, then production's test, and last production site, [11:35] NoteOn tiki is smart, just change local.php 's db info then all connect to other db, its simple. good dev [11:36] NoteOn ie. $dbs_tiki='dbname'; [11:36] MMax but one warning is still there: ALTER TABLE `tiki_pages` ADD COLUMN `pageSlug` VARCHAR(160) NULL AFTER `pageName`, ADD UNIQUE `pageSlug` (`pageSlug`) Duplicate column name 'pageSlug' [11:38] NoteOn ? error only in tiki_pages when update all? [11:38] luciash MMax: that is because you already have it added once by the upgrade script [11:39] luciash just ignore that warning [11:39] luciash NoteOn: good workflow, I agree it is better to pre-test ;) [11:40] NoteOn MMax: if only at tiki_pages, so ....... try only that tables fresh install, [11:40] luciash NoteOn: where from in japan? we have a developer in Chiba ;) [11:40] NoteOn maybe now its ok but if you have same next time, [11:41] NoteOn all dump xxxx.sql and edit by part or just dump tables, maybe all and edit part (pick up part) is better [11:41] NoteOn then import only table data, tiki_pages, by mysql tool, [11:42] NoteOn adminer is rapid only one file php, [11:43] NoteOn problem is tiki is big, so we can't see all part easy, such as update process [11:44] NoteOn luciash: where? in japan [11:44] NoteOn Chiba? ah, not Chiba, but [11:45] NoteOn I never know,, whats nick? [11:45] NoteOn japanese? or not? [11:47] luciash chibaguy - he is our main theme guy ;) [11:47] NoteOn ic [11:48] luciash he is american, but living in japan for many years [11:48] NoteOn so we can off line meeting;) even 2 ppls; [11:48] NoteOn ha ha [11:49] luciash yeah! little tikifest meetup :) [11:50] luciash actually i think we should not do urlencode the pageSlug but convert to ascii instead to keep the same number of characters [11:50] luciash (just thinking out loud) [11:51] luciash but how do you convert japanese characters to ascii :D [11:51] NoteOn ? [11:52] luciash do you use japanese characters in urls for google friendly urls? [11:52] NoteOn in utf-8 jp chars are same as all other langs, but problem is tool not tiki, and also some old db such as not utf-8 [11:52] NoteOn yes, it works and google indexed so no problem [11:53] NoteOn so in tiki, there is no japanse specifed issue I think. [11:54] NoteOn luciash: I re-started to use tiki and some support [11:54] NoteOn wait, my info [11:55] luciash hmm, then we should probably not url-encode them but keep them in utf-8 and just add dashes instead of spaces (or underscores) for the pageSlugs [11:55] luciash NoteOn: be aware [11:55] luciash NoteOn: this is public channel ;) [11:55] luciash NoteOn: logged [11:55] NoteOn ah ic private [12:01] NoteOn I didn't check pageSlugs, I will check, [12:01] NoteOn in normal use, no problem, [12:02] NoteOn not tested when update [12:07] jonnyb joined #tikiwiki [12:09] luciash hi jonnyb ! [12:10] jonnyb polom luciash [12:15] NoteOn fast check in my db, leng 160 is short. [12:16] NoteOn in englsih : FaceBook removed stored images [12:16] NoteOn its just news tile like [12:16] NoteOn in japanse char leng 144 [12:17] NoteOn so it needs more [12:18] NoteOn ie. pageSlug [12:28] luciash NoteOn: yeah, pageSlug should not be stored urlencoded [12:28] NoteOn pageName varchar(160) [] is OK. not short. [12:28] NoteOn pageSlug must have 3x cause 1char to 3 chars as 1char to %E5% [12:28] NoteOn if Name is all 2bytes chars, it needs 160x3=480 when pageName is 160 [12:29] NoteOn not sure way to not encorded. [12:29] luciash yep, but it would need to be changed from varchar to longtext or something else but i still think it is not good idea to store it urlencoded [12:30] luciash because we can use utf-8 nowadays easily and the slug (for google) in japanese should be utf-8 anyway - browsers can handle that just fine [12:30] NoteOn https://news.google.co.jp/ [12:31] NoteOn in this news, tile leng ave is 50 to 70? so it needs 150 to 210 [12:31] NoteOn ah ic I will check. [12:33] luciash the pageSlug should be just dashed or underscored or _optionally_ ascii (but that would not work with japanese characters in page names) [12:34] luciash and with any ' or " replaced of course [12:42] NoteOn luciash: im not sure pageSlug is for, so starting grep now;) [12:45] Tiki|bot New Forum Posts: Broken Images - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=61440 [12:45] Tiki|bot New Forum Posts: https://dev.tiki.org/Tiki16 is just a white screen - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61429 [12:45] Tiki|bot New Forum Posts: JS Minify [was [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[59865] trunk/lib/codemirror_tiki/tiki_codemirror.php] - http://translation.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61426 [12:47] NoteOn function get_page_by_slug($slug) is a main part? [12:49] NoteOn other part are maint lib, wikilib.php Controller.php [12:55] Tiki|bot New Forum Posts: Broken Images - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=61440 [12:55] Tiki|bot New Forum Posts: https://dev.tiki.org/Tiki16 is just a white screen - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61429 [12:55] Tiki|bot New Forum Posts: JS Minify [was [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[59865] trunk/lib/codemirror_tiki/tiki_codemirror.php] - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61426 [12:57] luciash NoteOn: it is meant for URLs mainly so a page name like "Foo Foo Bar" with spaces becomes yoursite/Foo+Foo+Bar [12:57] luciash NoteOn: when you have SEFURLs enabled [12:58] luciash NoteOn: if you have some extra preferences enabled you can choose if you want the "+" replaced by dashes "-" or other character like "_" [12:59] luciash NoteOn: and if you enable even more prefs, you can have special characters in page names replaced too [13:00] luciash the problem is by default if you do not enable anything it stores the pageSlug as url-encoded value now and that causes issues with non-latin characters becoming longer string than pageName [13:01] luciash so if you have many non-ascii charactres (like japanese) it does not fit in the database table varchar column [13:02] NoteOn ok so function get_page_by_slug($slug) only used it? [13:02] luciash jonnyb: what do you think? should be strored pageSlug as urlencoded or no? [13:03] luciash NoteOn: nope [13:03] NoteOn ie other words when tiki needs pageSlug [13:03] jonnyb sorry, in a meeting [13:04] luciash NoteOn: for better Google SEO, for page URLs in emails, etc. [13:05] NoteOn ah ic [13:05] luciash NoteOn: or if you just want to paste a page link with spaces anywhere and be sure it is not broken [13:06] NoteOn yes, only browser does job for text to encorded so other case encorded text needs [13:07] NoteOn and SEFURL is .. I think normal in 2byte use, with rewriteURL. [13:08] NoteOn so just simple extend long, [13:09] luciash ok, thanks for your opinion [13:13] luciash for reference: https://en.wikipedia.org/wiki/Semantic_URL#Slug [13:17] NoteOn thanks [13:18] NoteOn huum code seems if short then tiki shows slug as key even its shorted, (such like shorted url) so [13:19] NoteOn its not a prpblem now? only happend upate from old version? [13:19] NoteOn anyway I do test max and over input then how it gose [13:52] nelsonko joined #tikiwiki [13:54] luciash howdy nelsonko [13:55] NoteOn luciash: found 2byte issue, after register org.. I will post [13:55] NoteOn in simple here, POC is [14:00] arildb joined #tikiwiki [14:00] rpg joined #tikiwiki [14:00] nelsonko hi luciash [14:01] chibaguy joined #tikiwiki [14:01] chibaguy polom [14:24] jonnyb polom [14:25] jonnyb sorry, long meeting - luciash, what was the question? [14:25] * jonnyb reads [14:26] NoteOn s/156/159 [14:35] Tiki|bot New Forum Posts: strikes again! Please kill it! - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=61447 [14:35] Tiki|bot Recent Bug: - http://dev.tiki.org/item6127 [14:45] Tiki|bot Recent Bug: - http://dev.tiki.org/item6128 [15:02] Tiki-KGB 03kroky6 r59914 10branches/16.x/ 10lib/core/Services/Tracker/Controller.php 10templates/trackerinput/itemlink.tpl * [FIX] ItemLink table format add new item modal display and update of fancytable [15:03] Corey_ joined #tikiwiki [15:05] Corey_ Can someone inform me how change or modify the layout of tiki? Im trying to make my homepage look like this http://demo.zukathemes.com/Shapely [15:06] Tiki-KGB 03kroky6 r59915 10trunk/templates 10trunk/templates/trackerinput/itemlink.tpl 10trunk/lib/core/Services/Tracker/Controller.php 10trunk * [MRG] Automatic merge, branches/16.x 59909 to 59914 [15:06] Corey_ Im currently using this theme but cant seem to figure out how to customize [15:07] Corey_ can you elaborate more please? [15:12] kostas_ joined #tikiwiki [15:12] kostas_ hello, anyone here? [15:12] chibaguy Hi Corey_ . What customization do you want to do? [15:13] luciash hi Corey_ kostas_ chibaguy [15:13] kostas_ hi luciash [15:13] Corey_ Well... [15:13] Corey_ To put it basic, i want it to look very similar to that demo page [15:14] kostas_ luciash: my question is the same as yesterday, ldap binding error, i also installed the latest tiki wiki from svn (16) [15:15] Corey_ Im wondering if there is other ways to change the theme/layout rather than customise the css/html/js [15:16] chibaguy Corey_, in general, you need to customize those to change the way things look. [15:16] Tiki|bot Recent Bug: - http://dev.tiki.org/item6129 [15:17] chibaguy Let me turn on "view page source" for that page. [15:17] Corey_ there is no way to use pre exsisting code? [15:19] chibaguy What do you mean by pre-existing code? [15:20] NoteOn ho yo [15:20] chibaguy Corey_, did you download the Shapely theme files, and install them in your Tiki site? [15:21] Corey_ i downloaded it and uploaded to FTP theme dir [15:21] chibaguy Ok, then you selected the theme in your Look and Feel admin page? [15:22] Corey_ yup [15:22] Corey_ nothing changes really [15:22] Corey_ the theme file doesnt even have much meat to it [15:23] chibaguy Um, something's not right, then. I'll check the theme file again. [15:25] chibaguy I just downloaded Shapely.zip and unpacked it - it seems to be normal, that is, a complete Bootstrap-equivalent style sheet. [15:25] chibaguy Plus sample content, including images, etc. [15:27] chibaguy Shapely.zip is about 815 KB. Unpacked, it's 922 KB. Did everything get uploaded to your site ok? [15:27] Corey_ yeah [15:27] luciash Corey_: what layout do you have selected on Look and feel? [15:28] Corey_ just checked again too [15:28] Corey_ i have classic layout [15:28] luciash ah, maybe change that to... what do you suggest chibaguy ? [15:29] Corey_ ive tired many things, and different themes. Nothing dramtically changes the look to it [15:29] luciash different themes? should change the look of the site to that theme [15:30] chibaguy Ah, for Shapely a fixed top navbar should be used, to replicate the original Shapely appearance. [15:30] chibaguy Corey_, is your site public? [15:30] Corey_ hudsonq.club [15:31] luciash Corey_: you sure the theme on the ftp is readable by the webserver? [15:32] luciash Corey_: it says you are using default theme [15:32] Corey_ really! [15:32] Corey_ ? [15:32] Corey_ hold on [15:34] Tiki-KGB 03kroky6 r59916 10branches/16.x/tiki-tracker_http_request.php * [FIX] DynamicList fix to properly show dropdown type of field [15:34] Tiki-KGB 03kroky6 r59917 10trunk/tiki-tracker_http_request.php 10trunk * [MRG] Automatic merge, branches/16.x 59914 to 59916 [15:34] NoteOn hi [15:35] Corey_ What about now? [15:36] NoteOn that theme? wait... [15:36] NoteOn http://demo.zukathemes.com/ this site use that theme. Shapely [15:36] luciash Corey_: it says the same [15:37] luciash Corey_: in the page source [15:37] chibaguy Corey_, the Shapely demo uses the "Fixed top navbar 2" layout template, FYI. I think this is in the theme docs. [15:37] NoteOn so download and setup theme folder then you can use [15:37] chibaguy Corey_, the default theme is still being used at your site. [15:37] luciash Corey_: i suspect the theme folder is not readable so it fallbacks to the default theme [15:37] NoteOn and if you see not same even that theme its a botstrap part, not tiki's theme. [15:37] NoteOn you need setup responsive part at wiki page and .... well... [15:38] NoteOn for top page,home, no menu at left and right, then code resonsive inside to home wiki page [15:39] luciash Corey_: if you uploaded via FTP, can you check the folder and files have the proper permissions as the other themes? [15:39] Corey_ i did [15:40] chibaguy But Corey_ said *no* theme changes made any difference, right? [15:40] jonnyb joined #tikiwiki [15:40] Corey_ no theme changes that i have personally downloaded [15:41] Corey_ im changing all file permissions [15:41] Corey_ hold on [15:41] luciash Corey_: hmm, http://www.hudsonq.club/themes/fivealive/css/fivealive.css seems readable [15:41] NoteOn Corey_: windows? its better to test in local using such as xampp [15:41] luciash Corey_: but http://www.hudsonq.club/themes/Shapely/css/Shapely.css is not found [15:41] NoteOn cause editing theme and keep backup1 back2 .. you need while editing to fit [15:42] Corey_ omg.... got it [15:42] luciash Corey_: yay! :) [15:43] Corey_ theme dir was not capitaized [15:43] jonnyb repolom [15:43] chibaguy cool, the theme is changed. [15:43] Corey_ thanks for the help yall [15:43] jonnyb luciash: what's going on with https://dev.tiki.org/item6129 ? ;) [15:44] luciash jonnyb: nothing special ;) [15:44] NoteOn add module "switch theme" [15:44] chibaguy Corey_ , about the Shapely front page, check the example content and so on, if you want the scrolling backgrounds. [15:44] Corey_ yeah where do i find that? [15:44] NoteOn and copy folder Shapely-test-1, Shapely-test-2, Shapely-test-3 ... [15:45] NoteOn and direct edit in local env(if you can), with CSS editor etc. [15:46] Corey_ Noteon, that for possible errors> [15:46] Corey_ ? [15:46] chibaguy Corey_ , the Shapely package includes Shapely_home.html, which you can copy and edit; there are example content images, so basically you can replicate http://demo.zukathemes.com/Shapely at your site. [15:47] Corey_ oh nice! [15:47] NoteOn errors? [15:47] chibaguy NoteOn, I think your instructions might be too difficult, at this stage. Simple is best. [15:47] NoteOn ok, [15:47] chibaguy But thanks for input. [15:48] NoteOn but huum after theme gose, you need lost of time to fight responsive degain.. [15:48] NoteOn so its save dev's life;;; [15:48] chibaguy :-) [15:48] NoteOn and you need to know, now mobile user are maybe around 50% and over, [15:49] chibaguy It should stay responsive, if the theme isn't modified, and if there is care about page content. [15:49] NoteOn so 50% user never see your left and right part. [15:49] NoteOn so maybe basic tiki theme is most ok. [15:49] chibaguy True, but Tiki is bootstrap-based now, so should be responsive by default. [15:49] NoteOn ya, but we need to fight inside of wiki page [15:50] NoteOn using