←Prev date Next date→ Show only urls(Click on time to select a line by its url)

WhoWhatWhen
DarkCalfjoined #tikiwiki [00:12]
marclaportejoined #tikiwiki [00:15]
........ (idle for 37mn)
fabriciusjoined #tikiwiki [00:52]
.......... (idle for 49mn)
chibaguyjoined #tikiwiki [01:41]
....... (idle for 34mn)
Tiki|botNew Forum Posts: upgrade made all registered users "admins" - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47771 [02:15]
.......... (idle for 47mn)
dabrightjoined #tikiwiki [03:02]
.... (idle for 18mn)
fabriciusjoined #tikiwiki [03:20]
arildb_joined #tikiwiki [03:26]
goj_killedByISPjoined #tikiwiki [03:26]
arildb__joined #tikiwiki [03:33]
arildbjoined #tikiwiki [03:47]
arildb_joined #tikiwiki [03:59]
knatokjoined #tikiwiki
left #tikiwiki
[04:02]
........ (idle for 37mn)
fabriciusjoined #tikiwiki [04:40]
...... (idle for 29mn)
joined #tikiwiki [05:09]
............ (idle for 55mn)
arildbjoined #tikiwiki [06:04]
...... (idle for 27mn)
arildb_joined #tikiwiki [06:31]
arildb__joined #tikiwiki [06:33]
PenguinMan98joined #tikiwiki
PenguinMan98 waves to all
Tonight I need to troubleshoot an issue that you all may have run into before
But it's not an issue specific to tikiwiki
When I clone the mysql database to another database, the serialized data gets corrupted and the clone install won't run
It's a known php issue
Have any of you run into this yet? I'm sure you have. How did you solve it?
[06:46]
arildbjoined #tikiwiki [06:58]
arildb__joined #tikiwiki [07:03]
arildb_joined #tikiwiki [07:07]
..... (idle for 21mn)
arildbjoined #tikiwiki [07:28]
arildb_joined #tikiwiki [07:33]
arildbjoined #tikiwiki [07:38]
arildb_joined #tikiwiki [07:45]
arildb__joined #tikiwiki [07:47]
arildbjoined #tikiwiki [07:50]
arildb_joined #tikiwiki [07:56]
PenguinMan98PenguinMan98 flicks arildb 's router [07:59]
arildbjoined #tikiwiki [08:03]
arildb_joined #tikiwiki [08:06]
fabriciushi PenguinMan98 -> php mysql issue: use the linux shell dump command [08:08]
PenguinMan98fabricius: thank you for your response. Can you be more clear?
OH, I think I see what you're saying
[08:09]
fabriciusdo not use phpMyAdmin, but the Sjhell instead
yep
[08:09]
PenguinMan98don't use PHPMyAdmin, use the linux shell command to copy the db
gotcha
I actually have that command saved in a text file around here somewheres...
[08:10]
arildb_joined #tikiwiki [08:11]
arildbjoined #tikiwiki [08:12]
fabriciustake dump from server:
mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAME > MYSQL-DUMP_%Y%m%d.SQL
upload to a new database:
mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAMENEW < MYSQL-DUMP_20130628.SQL
[08:15]
PenguinMan98shouldn't that be a >?
oh, oops
read that wrong
[08:18]
fabricius> takes dump ... < pushes dump up [08:18]
PenguinMan98PenguinMan98 tries not to giggle at the quasi poop joke [08:19]
fabriciusdepending 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
have to go out of the house now
bye
[08:20]
PenguinMan98kk thanks! [08:24]
arildbjoined #tikiwiki [08:33]
........ (idle for 37mn)
PenguinMan98pah. It didn't work
*headdesk*
something else is going on here...
[09:10]
arildbjoined #tikiwiki [09:13]
joined #tikiwiki [09:24]
arildb_joined #tikiwiki [09:26]
.... (idle for 18mn)
PenguinMan98the import isn't working at all [09:44]
I imported using sqlyog but got the same errors with unserialization [09:52]
Telesightjoined #tikiwiki [09:58]
.......... (idle for 46mn)
redflojoined #tikiwiki [10:44]
...... (idle for 28mn)
mikkokoijoined #tikiwiki
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.
Can I assign permissions to page version or do I need to use the {GROUP} tags?
[11:12]
...... (idle for 25mn)
fabriciusmikkokoi: permissions to versions: no ... that would be a very hidden secret feature - never heard about it
mikkokoi: general permissions: group has a permission
mikkokoi: category permission: group has a permission for categorised object - overwrites general permission
mikkokoi: object permission: group has a permission for object - overwrites general permission and category permission
category permissions you set in the category admin and object permissions at the object
group identifies a set of users and category identifies a set of objects
[11:40]
mikkokoiyea i know about the basic permissions but I was wondering if its possible to have wikipage version specific permissions [11:44]
fabriciusnope [11:44]
mikkokoiyea seems so [11:44]
fabricius99,9% not
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:44]
mikkokoiso 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:48]
fabriciusmikkokoi: 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!
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:50]
mikkokoiThx for the tip. I will check that out. [11:53]
fabriciusPenguinMan98: a) are you working on a windows machine? b) does your webserver provides ssh access?
PenguinMan98: {if} a) and b) = y {then} putty.exe
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 :-)
[11:55]
.............. (idle for 1h6mn)
Jyhem_laptopjoined #tikiwiki [13:04]
Tiki|botNew Forum Posts: Icons on Forums - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=47777 [13:18]
.... (idle for 17mn)
rodrigoprimojoined #tikiwiki [13:35]
dabrightjoined #tikiwiki [13:45]
Tiki|botNew Forum Posts: Fwd: Smarty 3.1.14 Released - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47778 [13:58]
.... (idle for 15mn)
chibaguyjoined #tikiwiki [14:13]
.... (idle for 18mn)
fabriciusjoined #tikiwiki [14:31]
........ (idle for 37mn)
Tiki|botNew Forum Posts: Tiki pour débutant? - http://tiki.org/tiki-view_forum_thread.php?forumId=7&comments_parentId=47780 [15:08]
arildbjoined #tikiwiki [15:10]
marclaporte1joined #tikiwiki [15:11]
zaki[]joined #tikiwiki [15:23]
dhazeljoined #tikiwiki [15:34]
.......... (idle for 48mn)
dabrightjoined #tikiwiki [16:22]
chibaguyjoined #tikiwiki [16:31]
PenguinMan98fabricius: 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
win 7
live: www.mlpnwrp.org
testing: www.mlpnwrp.org:8080
All I want to do is copy the database over so I can test on data that isn't live
I'll double check collations
[16:36]
........ (idle for 37mn)
joined #tikiwiki [17:15]
chibaguyjoined #tikiwiki [17:22]
PenguinMan98I went to the #mysql channel for help and they were very helpful but I still don't have a solution [17:27]
arildbPenguinMan98: 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:29]
PenguinMan98That's exactly what I've done three different ways now
First through phpmyadmin
Then through SQLYog
lastly through linux shell mysqldump commands
except that the linux dump import command didn't work and I ended up importing with sqlyog
someone suggested that if this information is cached anyway, that I should just wipe the table clean
I don't have much to lose from trying it
[17:30]
fabricius.
PenguinMan98: you did write, that you are on a windows machine and so are your site(s) ... I recon your databases aswell
[17:36]
PenguinMan98yes
all running on a wampserver on a windows 7 machine
[17:38]
fabriciusPenguinMan98: if so, Linux shell commands will not be any use for you, as they are for Linux and not for Windows [17:38]
PenguinMan98It made the dump just fine using the git bash
It just wouldn't import it
[17:39]
fabriciusso you have a nice uncorupted dump now?
ah maybe too big
[17:39]
PenguinMan98too big?
No, it's not that big
[17:39]
fabriciuswhere do you store your images and files?
how big it is?
[17:39]
PenguinMan98in the db for now but I'm gonna change that [17:40]
fabriciusmore 4MB or more 40MB? [17:40]
PenguinMan98PenguinMan98 shrugs. Can't tell from here. I'm at work now
but Text Pad opens it without any hesitation
[17:40]
fabriciusyou should change from database to directory on the life site [17:40]
PenguinMan98I know
Just haven't done it yet
nobody is using that feature yet
[17:40]
fabriciusthen copy the file directories and dump the smaller database -> then import should be no problem (if not any hidden further problem) [17:41]
PenguinMan98size isn't the issue [17:42]
fabriciusyou should NOT have the tikisite installed in the webroot
I do it with containers:
[17:42]
PenguinMan98what do you mean? [17:42]
fabriciuswebroot/tikiwebsites/mysite.com
from there:
mysite.com/tikiroot and mysite.com/files
there:
[17:42]
PenguinMan98d:/wamp/www/mlpnwrp/site1webroot [17:43]
fabriciusfiles/wiki files/tracker files/batch files/gallery etc. [17:44]
PenguinMan98PenguinMan98 is confused [17:44]
fabriciussite1webroot is you unpacked Tiki = Tikiroot? [17:44]
PenguinMan98Pretty much, yes [17:45]
fabriciusI shoulkd make up a grafic about that ... frequently I confuse pople with that until they get it [17:45]
PenguinMan98the files are in a public cirectory [17:45]
fabriciusin a public directory?
so not in the database?
[17:45]
PenguinMan98wait, what? [17:46]
fabriciusand how you mean "public"? [17:46]
PenguinMan98On 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:47]
Telesightjoined #tikiwiki [17:49]
PenguinMan98doh [17:53]
fabriciusjoined #tikiwiki [17:54]
PenguinMan98eb
wb*
[17:54]
............ (idle for 57mn)
<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. [18:51]
..... (idle for 24mn)
fabriciusanyway 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..
I believe PenguinMan98 you know what you do anyway
[19:15]
PenguinMan98Well, 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.
Are you arguing to move the tiki files out of the public directory and use redirects to access them?
[19:19]
fabriciusno
there is a feature "filegallery" in Tiki, you know?
[19:20]
PenguinMan98yes
one I haven't spent much time learning and configuring
[19:21]
fabriciusmoving 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
what you mean with "redirects" PenguinMan98 ?
[19:23]
PenguinMan98Use .htaccess to map all requests to the public directory to files in another directory.
That would allow me to move all my tiki files into a directory that cannot be downloaded
[19:25]
fabriciusyou have a field in the tiki-admin.php?page=fgal, where you can set the path to the directory
I never did it with Windows, but should be similar to Linux anyway
in Linux ../ means one level up .. something similar must exist for windows aswell?
[19:30]
PenguinMan98same thing [19:32]
fabriciusso 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
no htaccess or manual redirect for that
[19:34]
PenguinMan98joined #tikiwiki
Well, thanks. I'll look into that
It's good security practice
However, I'm still stuck with a dead database.
[19:45]
..... (idle for 24mn)
fabriciusIcan just recommend to get the files out and to dump again
no idea if there is a way with kind of a windows shell
[20:12]
PenguinMan98PenguinMan98 shruggies [20:19]
I can't really fuss with it until I get home tonight [20:30]
Jyhem_laptop_joined #tikiwiki [20:38]
arildb_joined #tikiwiki [20:51]
arildb__joined #tikiwiki [20:54]
.................... (idle for 1h37mn)
marclaportejoined #tikiwiki [22:31]
Caarrie|awayjoined #tikiwiki [22:33]
..... (idle for 20mn)
dabrightjoined #tikiwiki [22:53]
....... (idle for 32mn)
Telesightjoined #tikiwiki [23:25]

←Prev date Next date→ Show only urls(Click on time to select a line by its url)