Posted on: 09/06/05 01:52pm
By: warren
I am running 3 differant geeklog sites. I have decided that I want to merg all the sites into one site. so here is what I tried to do. I went into phpmyadmin and exported the tables that hold the stories from on site and then imported those tables to another site. everything worked fine at first look But here is my problem now. Any story that was authered by a user other than admin can not be viewed. if you look at the list of stories they are all there but if you click on one that was from someone other than admin it says you don't have permision to view this page.
Is there a way to change the owner of these stories withing phpmyadmin I have installed the change owner script to try and do it that way but I can not view these stories because of the permissions.
I would like to make everything viewable to all users even unregistered but have no idea how to go about this
PHPMyadmin help
Posted on: 09/06/05 02:14pm
By: Dirk
I just hope you're trying this on a test setup. Or have good backups ...
The "uid" and "owner_id" fields in every story hold the author's user id. So of course, when on site #1 user #42 is Frank and on site #2 it's Tom, you get a mix-up. And there are more tables that depend on that uid, like the user's settings, permissions, comments, stuff in plugins, etc. etc.
In other words: It's not nearly as easy as you think. And requires a lot of advance planning and a good idea of what you are doing ...
bye, Dirk
PHPMyadmin help
Posted on: 09/07/05 11:35am
By: Anonymous (warren)
Thanks Dirk
I think at this point I will go back to square one and just copy the stories to the new site so they are all puplished by "admin"