[00:12] DarkCalf joined #tikiwiki [00:15] marclaporte joined #tikiwiki [00:52] fabricius joined #tikiwiki [01:41] chibaguy joined #tikiwiki [02:15] Tiki|bot New Forum Posts: upgrade made all registered users "admins" - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47771 [03:02] dabright joined #tikiwiki [03:20] fabricius joined #tikiwiki [03:26] arildb_ joined #tikiwiki [03:26] goj_killedByISP joined #tikiwiki [03:33] arildb__ joined #tikiwiki [03:47] arildb joined #tikiwiki [03:59] arildb_ joined #tikiwiki [04:02] knatok joined #tikiwiki [04:03] knatok left #tikiwiki [04:40] fabricius joined #tikiwiki [05:09] fabricius joined #tikiwiki [06:04] arildb joined #tikiwiki [06:31] arildb_ joined #tikiwiki [06:33] arildb__ joined #tikiwiki [06:46] PenguinMan98 joined #tikiwiki [06:46] * PenguinMan98 waves to all [06:46] PenguinMan98 Tonight I need to troubleshoot an issue that you all may have run into before [06:47] PenguinMan98 But it's not an issue specific to tikiwiki [06:47] PenguinMan98 When I clone the mysql database to another database, the serialized data gets corrupted and the clone install won't run [06:47] PenguinMan98 It's a known php issue [06:48] PenguinMan98 Have any of you run into this yet? I'm sure you have. How did you solve it? [06:58] arildb joined #tikiwiki [07:03] arildb__ joined #tikiwiki [07:07] arildb_ joined #tikiwiki [07:28] arildb joined #tikiwiki [07:33] arildb_ joined #tikiwiki [07:38] arildb joined #tikiwiki [07:45] arildb_ joined #tikiwiki [07:47] arildb__ joined #tikiwiki [07:50] arildb joined #tikiwiki [07:56] arildb_ joined #tikiwiki [07:59] * PenguinMan98 flicks arildb 's router [08:03] arildb joined #tikiwiki [08:06] arildb_ joined #tikiwiki [08:08] fabricius hi PenguinMan98 -> php mysql issue: use the linux shell dump command [08:09] PenguinMan98 fabricius: thank you for your response. Can you be more clear? [08:09] PenguinMan98 OH, I think I see what you're saying [08:09] fabricius do not use phpMyAdmin, but the Sjhell instead [08:09] fabricius yep [08:10] PenguinMan98 don't use PHPMyAdmin, use the linux shell command to copy the db [08:10] PenguinMan98 gotcha [08:10] PenguinMan98 I actually have that command saved in a text file around here somewheres... [08:11] arildb_ joined #tikiwiki [08:12] arildb joined #tikiwiki [08:15] fabricius take dump from server: [08:15] fabricius mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAME > MYSQL-DUMP_%Y%m%d.SQL [08:17] fabricius upload to a new database: [08:17] fabricius mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAMENEW < MYSQL-DUMP_20130628.SQL [08:18] PenguinMan98 shouldn't that be a >? [08:18] PenguinMan98 oh, oops [08:18] PenguinMan98 read that wrong [08:18] fabricius > takes dump ... < pushes dump up [08:19] * PenguinMan98 tries not to giggle at the quasi poop joke [08:20] fabricius depending on the server settings, the dump file will be saved into the document root / webroot of the webserver ... dump file to be uploaded will be taken from the same directory where the server saves the dump [08:20] arildb_ joined #tikiwiki [08:20] fabricius %Y%m%d -> strftime -> http://php.net/manual/de/function.strftime.php [08:20] fabricius have to go out of the house now [08:20] fabricius bye [08:24] PenguinMan98 kk thanks! [08:33] arildb joined #tikiwiki [09:10] PenguinMan98 pah. It didn't work [09:10] PenguinMan98 *headdesk* [09:13] PenguinMan98 something else is going on here... [09:13] arildb joined #tikiwiki [09:24] arildb joined #tikiwiki [09:26] arildb_ joined #tikiwiki [09:44] PenguinMan98 the import isn't working at all [09:52] PenguinMan98 I imported using sqlyog but got the same errors with unserialization [09:58] Telesight joined #tikiwiki [10:44] redflo joined #tikiwiki [11:12] mikkokoi joined #tikiwiki [11:15] mikkokoi Hey, I have question concerning page versions, Can I assign permissions to a specific version of a wiki page. ie. have multiple versions of usermanual which have version specific instructions and i want to edit them on same wikipage, without showing any unnecessary data to users. [11:15] mikkokoi Can I assign permissions to page version or do I need to use the {GROUP} tags? [11:40] fabricius mikkokoi: permissions to versions: no ... that would be a very hidden secret feature - never heard about it [11:42] fabricius mikkokoi: general permissions: group has a permission [11:42] fabricius mikkokoi: category permission: group has a permission for categorised object - overwrites general permission [11:42] fabricius mikkokoi: object permission: group has a permission for object - overwrites general permission and category permission [11:44] fabricius category permissions you set in the category admin and object permissions at the object [11:44] fabricius group identifies a set of users and category identifies a set of objects [11:44] mikkokoi yea i know about the basic permissions but I was wondering if its possible to have wikipage version specific permissions [11:44] fabricius nope [11:44] mikkokoi yea seems so [11:44] fabricius 99,9% not [11:48] fabricius PenguinMan98: how did you setup the new database before import? did you force a certain collation? which collation has the original one? are you sure, that the original database is not corrupt? [11:48] mikkokoi so I will have to add the {group} tags to hide the unnecessary stuff. In the end it may be even the better solution to this case, so my editors dont have to worry so much about version control and permissions. They have to simply add the tags and content there, [11:50] fabricius mikkokoi: in edit mode, respectively source coe, all users with view/edit permissions see all content of the page -> {GROUP()} is not feasable to hide parts of a page for editors! [11:51] fabricius you could use the plugin {INCLUDE()} and include pages instead with less edit prmissions -> then for this content you only see the plugin in edit/source mode [11:53] mikkokoi Thx for the tip. I will check that out. [11:55] fabricius PenguinMan98: a) are you working on a windows machine? b) does your webserver provides ssh access? [11:56] fabricius PenguinMan98: {if} a) and b) = y {then} putty.exe [11:58] fabricius I always forget that not everybody has a local shell to login to webservers, cause I alway forget that only a small portion of people use Linux for personal work, if they know. Most People use Linux/Unix only on their phones and webservers :-) [13:04] Jyhem_laptop joined #tikiwiki [13:18] Tiki|bot New Forum Posts: Icons on Forums - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=47777 [13:35] rodrigoprimo joined #tikiwiki [13:45] dabright joined #tikiwiki [13:58] Tiki|bot New Forum Posts: Fwd: Smarty 3.1.14 Released - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47778 [14:13] chibaguy joined #tikiwiki [14:31] fabricius joined #tikiwiki [15:08] Tiki|bot New Forum Posts: Tiki pour débutant? - http://tiki.org/tiki-view_forum_thread.php?forumId=7&comments_parentId=47780 [15:10] arildb joined #tikiwiki [15:11] marclaporte1 joined #tikiwiki [15:23] zaki[] joined #tikiwiki [15:34] dhazel joined #tikiwiki [16:22] dabright joined #tikiwiki [16:31] chibaguy joined #tikiwiki [16:36] PenguinMan98 fabricius: both servers are on the same windows machine. Using the same server actually, just different folders. One is for my live server which I host out of this machine, and the other is for development [16:36] PenguinMan98 win 7 [16:37] PenguinMan98 live: www.mlpnwrp.org [16:37] PenguinMan98 testing: www.mlpnwrp.org:8080 [16:38] PenguinMan98 All I want to do is copy the database over so I can test on data that isn't live [16:38] PenguinMan98 I'll double check collations [17:15] PenguinMan98 joined #tikiwiki [17:22] chibaguy joined #tikiwiki [17:27] PenguinMan98 I went to the #mysql channel for help and they were very helpful but I still don't have a solution [17:29] arildb PenguinMan98: If you would like to move your live db to your test installation. Why don't you backup the live db and restore it in the test database? [17:30] PenguinMan98 That's exactly what I've done three different ways now [17:30] PenguinMan98 First through phpmyadmin [17:30] PenguinMan98 Then through SQLYog [17:30] PenguinMan98 lastly through linux shell mysqldump commands [17:30] PenguinMan98 except that the linux dump import command didn't work and I ended up importing with sqlyog [17:31] PenguinMan98 someone suggested that if this information is cached anyway, that I should just wipe the table clean [17:32] PenguinMan98 I don't have much to lose from trying it [17:36] fabricius . [17:38] fabricius PenguinMan98: you did write, that you are on a windows machine and so are your site(s) ... I recon your databases aswell [17:38] PenguinMan98 yes [17:38] PenguinMan98 all running on a wampserver on a windows 7 machine [17:38] fabricius PenguinMan98: if so, Linux shell commands will not be any use for you, as they are for Linux and not for Windows [17:39] PenguinMan98 It made the dump just fine using the git bash [17:39] PenguinMan98 It just wouldn't import it [17:39] fabricius so you have a nice uncorupted dump now? [17:39] fabricius ah maybe too big [17:39] PenguinMan98 too big? [17:39] PenguinMan98 No, it's not that big [17:39] fabricius where do you store your images and files? [17:40] fabricius how big it is? [17:40] PenguinMan98 in the db for now but I'm gonna change that [17:40] fabricius more 4MB or more 40MB? [17:40] * PenguinMan98 shrugs. Can't tell from here. I'm at work now [17:40] PenguinMan98 but Text Pad opens it without any hesitation [17:40] fabricius you should change from database to directory on the life site [17:40] PenguinMan98 I know [17:41] PenguinMan98 Just haven't done it yet [17:41] PenguinMan98 nobody is using that feature yet [17:41] fabricius then copy the file directories and dump the smaller database -> then import should be no problem (if not any hidden further problem) [17:42] PenguinMan98 size isn't the issue [17:42] fabricius you should NOT have the tikisite installed in the webroot [17:42] fabricius I do it with containers: [17:42] PenguinMan98 what do you mean? [17:42] fabricius webroot/tikiwebsites/mysite.com [17:43] fabricius from there: [17:43] fabricius mysite.com/tikiroot and mysite.com/files [17:43] fabricius there: [17:43] PenguinMan98 d:/wamp/www/mlpnwrp/site1webroot [17:44] fabricius files/wiki files/tracker files/batch files/gallery etc. [17:44] * PenguinMan98 is confused [17:44] fabricius site1webroot is you unpacked Tiki = Tikiroot? [17:45] PenguinMan98 Pretty much, yes [17:45] fabricius I shoulkd make up a grafic about that ... frequently I confuse pople with that until they get it [17:45] PenguinMan98 the files are in a public cirectory [17:45] fabricius in a public directory? [17:46] fabricius so not in the database? [17:46] PenguinMan98 wait, what? [17:46] fabricius and how you mean "public"? [17:47] PenguinMan98 On my sites I set it up so in the root www/mlpnwrp/ there is a /public folder. That's where the public webroot is. The docroot is back at /mlpnwrp . The tiki install sits in the /public folder. [17:49] Telesight joined #tikiwiki [17:53] PenguinMan98 doh [17:54] fabricius joined #tikiwiki [17:54] PenguinMan98 eb [17:54] PenguinMan98 wb* [18:51] PenguinMan98 On my sites I set it up so in the root www/mlpnwrp/ there is a /public folder. That's where the public webroot is. The docroot is back at /mlpnwrp . The tiki install sits in the /public folder. [19:15] fabricius anyway PenguinMan98 ... you should have set it up in a way, that you keep the webroot "clean", not to apply a domain directlly to the webroot, be able to install different cms besides each other, be able to install different Tikis besides each other, have the files directories of each Tiki "besides" the Tiki and NOT in the tikiroot -> in my setup the poath for the features(Linux based installation) would be ../files/feature - for ex.. [19:15] fabricius I believe PenguinMan98 you know what you do anyway [19:19] PenguinMan98 Well, my reasoning is that Tiki is meant to manage the whole website as a self-contained unit. Anything you add to the site you interface with the tikiwiki. [19:20] PenguinMan98 Are you arguing to move the tiki files out of the public directory and use redirects to access them? [19:20] fabricius no [19:21] fabricius there is a feature "filegallery" in Tiki, you know? [19:21] PenguinMan98 yes [19:21] PenguinMan98 one I haven't spent much time learning and configuring [19:23] fabricius moving them outside the public by applying a different path to the feature seems to be feasible ... could make sense depending on the setup of the server and the control panel ... would not make sense with the control panel my provider uses and no sense on my local server [19:24] fabricius what you mean with "redirects" PenguinMan98 ? [19:25] PenguinMan98 Use .htaccess to map all requests to the public directory to files in another directory. [19:25] PenguinMan98 That would allow me to move all my tiki files into a directory that cannot be downloaded [19:30] fabricius you have a field in the tiki-admin.php?page=fgal, where you can set the path to the directory [19:31] fabricius I never did it with Windows, but should be similar to Linux anyway [19:31] fabricius in Linux ../ means one level up .. something similar must exist for windows aswell? [19:32] PenguinMan98 same thing [19:34] fabricius so in my setup I have the path ../files/gallery and my files all are out of the tikiroot - and not directly accessible by a domain [19:35] fabricius no htaccess or manual redirect for that [19:45] PenguinMan98 joined #tikiwiki [19:47] PenguinMan98 Well, thanks. I'll look into that [19:47] PenguinMan98 It's good security practice [19:48] PenguinMan98 However, I'm still stuck with a dead database. [20:12] fabricius Ican just recommend to get the files out and to dump again [20:13] fabricius no idea if there is a way with kind of a windows shell [20:19] * PenguinMan98 shruggies [20:30] PenguinMan98 I can't really fuss with it until I get home tonight [20:38] Jyhem_laptop_ joined #tikiwiki [20:51] arildb_ joined #tikiwiki [20:54] arildb__ joined #tikiwiki [22:31] marclaporte joined #tikiwiki [22:33] Caarrie|away joined #tikiwiki [22:53] dabright joined #tikiwiki [23:25] Telesight joined #tikiwiki