Subject: Export / Import Users from DB

Posted on: 30/12/09 01:11am
By: gdl

I was unable to find the cause of the error that was described in this forum post. I have had to reinstall a clean version of Geeklog 1.6.1, a new database and rebuild the theme from the professional theme. All seems to be working well except for a few custom features that I am working on.

Rather than going through the old installation now and manually entering the 50 or so users that joined the website, is their an easy way to export the Users and their perms from the old Database using phpMyadmin so it may be imported to the new Database? This way all of their passwords are kept and I don't need to notify all users that they will need to retrieve their passwords again.

Thanks for any help you can offer.

Re: Export / Import Users from DB

Posted on: 30/12/09 04:47am
By: Dirk

Tricky. The users / groups / permissions in the database are pretty much intertwined. The IDs from the various tables have to match properly or you'll end up with odd effects and permission problems. To make things even more complicated, a fresh install will probably use different IDs for the default groups, for example, since we renumbered them in recent Geeklog versions (which is not a problem normally, since the Geeklog code identifies groups by name).

I still have no idea what may have caused your original problem. If you can provide me with a copy of your original database (the one that caused the problem with stories and static pages not showing up on the front page), I'll take a look and try if I can spot the problem.

bye, Dirk

Re: Export / Import Users from DB

Posted on: 30/12/09 05:54am
By: gdl

Thanks Dirk.

I sent you a private message with file / login info. It would be great to finally get this resolved.

I appreciate you taking a look.

-gdl

Re: Export / Import Users from DB

Posted on: 30/12/09 07:14am
By: Dirk

Found it: You have multi-language support enabled, but your story IDs don't follow the required convention. I guess that was an accident?

Go to

Configuration > Geeklog > Languages and Locale > Language

and disable both the "Language Files" and "Languages" options by clicking on the (X) behind them.

Should have thought of that sooner, but the fact that the stories showed up in their topics irritated me ...

bye, Dirk

Re: Export / Import Users from DB

Posted on: 30/12/09 08:50am
By: suprsidr

Go to

Configuration > Geeklog > Languages and Locale > Language

and disable both the "Language Files" and "Languages" options by clicking on the (X) behind them.


That fixed it... brilliant thanks.

-s

Re: Export / Import Users from DB

Posted on: 30/12/09 12:12pm
By: gdl

Wow! Thanks to the both of you for helping with this. Looks like all is well again. It's great going to sleep and waking up to an answer.

Thanks again.

-gdl

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=89239