marclaporte: joined #tikiwiki
fabricius: joined #tikiwiki
chibaguy: joined #tikiwiki
Tiki|bot: New Forum Posts: upgrade made all registered users "admins" - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47771
dabright: joined #tikiwiki
fabricius: joined #tikiwiki
arildb_: joined #tikiwiki
goj_killedByISP: joined #tikiwiki
arildb__: joined #tikiwiki
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
knatok: joined #tikiwiki
left #tikiwiki
fabricius: joined #tikiwiki
joined #tikiwiki
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
arildb__: joined #tikiwiki
PenguinMan98: joined #tikiwiki
-: PenguinMan98 waves to all
PenguinMan98: 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?
arildb: joined #tikiwiki
arildb__: joined #tikiwiki
arildb_: joined #tikiwiki
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
arildb__: joined #tikiwiki
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
-: PenguinMan98 flicks arildb 's router
arildb: joined #tikiwiki
arildb_: joined #tikiwiki
fabricius: hi PenguinMan98 -> php mysql issue: use the linux shell dump command
PenguinMan98: fabricius: thank you for your response. Can you be more clear?
OH, I think I see what you're saying
fabricius: do not use phpMyAdmin, but the Sjhell instead
yep
PenguinMan98: don'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...
arildb_: joined #tikiwiki
arildb: joined #tikiwiki
fabricius: take 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
PenguinMan98: shouldn't that be a >?
oh, oops
read that wrong
fabricius: > takes dump ... < pushes dump up
-: PenguinMan98 tries not to giggle at the quasi poop joke
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
arildb_: joined #tikiwiki
fabricius: %Y%m%d -> strftime -> http://php.net/manual/de/function.strftime.php
have to go out of the house now
bye
PenguinMan98: kk thanks!
arildb: joined #tikiwiki
PenguinMan98: pah. It didn't work
*headdesk*
something else is going on here...
arildb: joined #tikiwiki
joined #tikiwiki
arildb_: joined #tikiwiki
PenguinMan98: the import isn't working at all
I imported using sqlyog but got the same errors with unserialization
Telesight: joined #tikiwiki
redflo: joined #tikiwiki
mikkokoi: joined #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?
fabricius: mikkokoi: 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
mikkokoi: yea i know about the basic permissions but I was wondering if its possible to have wikipage version specific permissions
fabricius: nope
mikkokoi: yea seems so
fabricius: 99,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?
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,
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!
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
mikkokoi: Thx for the tip. I will check that out.
fabricius: PenguinMan98: 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 :-)
Jyhem_laptop: joined #tikiwiki
Tiki|bot: New Forum Posts: Icons on Forums - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=47777
rodrigoprimo: joined #tikiwiki
dabright: joined #tikiwiki
Tiki|bot: New Forum Posts: Fwd: Smarty 3.1.14 Released - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47778
chibaguy: joined #tikiwiki
fabricius: joined #tikiwiki
Tiki|bot: New Forum Posts: Tiki pour débutant? - http://tiki.org/tiki-view_forum_thread.php?forumId=7&comments_parentId=47780
arildb: joined #tikiwiki
marclaporte1: joined #tikiwiki
zaki[]: joined #tikiwiki
dhazel: joined #tikiwiki
dabright: joined #tikiwiki
chibaguy: joined #tikiwiki
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
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
joined #tikiwiki
chibaguy: joined #tikiwiki
PenguinMan98: I went to the #mysql channel for help and they were very helpful but I still don't have a solution
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?
PenguinMan98: That'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
fabricius: .
PenguinMan98: you did write, that you are on a windows machine and so are your site(s) ... I recon your databases aswell
PenguinMan98: yes
all running on a wampserver on a windows 7 machine
fabricius: PenguinMan98: if so, Linux shell commands will not be any use for you, as they are for Linux and not for Windows
PenguinMan98: It made the dump just fine using the git bash
It just wouldn't import it
fabricius: so you have a nice uncorupted dump now?
ah maybe too big
PenguinMan98: too big?
No, it's not that big
fabricius: where do you store your images and files?
how big it is?
PenguinMan98: in the db for now but I'm gonna change that
fabricius: more 4MB or more 40MB?
-: PenguinMan98 shrugs. Can't tell from here. I'm at work now
PenguinMan98: but Text Pad opens it without any hesitation
fabricius: you should change from database to directory on the life site
PenguinMan98: I know
Just haven't done it yet
nobody is using that feature yet
fabricius: then copy the file directories and dump the smaller database -> then import should be no problem (if not any hidden further problem)
PenguinMan98: size isn't the issue
fabricius: you should NOT have the tikisite installed in the webroot
I do it with containers:
PenguinMan98: what do you mean?
fabricius: webroot/tikiwebsites/mysite.com
from there:
mysite.com/tikiroot and mysite.com/files
there:
PenguinMan98: d:/wamp/www/mlpnwrp/site1webroot
fabricius: files/wiki files/tracker files/batch files/gallery etc.
-: PenguinMan98 is confused
fabricius: site1webroot is you unpacked Tiki = Tikiroot?
PenguinMan98: Pretty much, yes
fabricius: I shoulkd make up a grafic about that ... frequently I confuse pople with that until they get it
PenguinMan98: the files are in a public cirectory
fabricius: in a public directory?
so not in the database?
PenguinMan98: wait, what?
fabricius: and how you mean "public"?
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.
Telesight: joined #tikiwiki
PenguinMan98: doh
fabricius: joined #tikiwiki
PenguinMan98: eb
wb*
<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.
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..
I believe PenguinMan98 you know what you do anyway
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.
Are you arguing to move the tiki files out of the public directory and use redirects to access them?
fabricius: no
there is a feature "filegallery" in Tiki, you know?
PenguinMan98: yes
one I haven't spent much time learning and configuring
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
what you mean with "redirects" PenguinMan98 ?
PenguinMan98: Use .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
fabricius: you 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?
PenguinMan98: same thing
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
no htaccess or manual redirect for that
PenguinMan98: joined #tikiwiki
Well, thanks. I'll look into that
It's good security practice
However, I'm still stuck with a dead database.
fabricius: Ican just recommend to get the files out and to dump again
no idea if there is a way with kind of a windows shell
-: PenguinMan98 shruggies
PenguinMan98: I can't really fuss with it until I get home tonight
Jyhem_laptop_: joined #tikiwiki
arildb_: joined #tikiwiki
arildb__: joined #tikiwiki
marclaporte: joined #tikiwiki
Caarrie|away: joined #tikiwiki
dabright: joined #tikiwiki
Telesight: joined #tikiwiki