[wp-testers] A post migration issue

[Andrew Nacin]

On Apr 14, 2011 1:49 PM, "Azizur Rahman" <prodevstudio+deviantART at gmail.com>
wrote:
>
> Hi All,
>
> If this is not right place to post this kind of issue please let me know.
>
> I just migrated a site using a script I wrote myself (see:
> https://github.com/azizur/wordpress-oneclick-migration).
>
> As part of the migration the Database Table Prefix also changed.
>
> Now every time I login I am getting:
>
> "You do not have sufficient permissions to access this page."
>
> Strangely the Menubar show up when I visit the normal site but can't
> get into dashboard.
>
> I know that usermeta table has '{database_prefix}_capabilities'  and
> other related keys. I have updated them all with the new Database
> Prefix and still no luck.
>
> I am wondering if this a bug or I need to look somewhere else. I am
> just trying to find out where should I be looking to resolve this
> issue.
>

My guess would be definitely not a bug. I would double-check everything
including a possible off-by-underscore issue when it comes to usermeta
capabilities keys. Did you update the capabilities key in the options table
too?

As this isn't a bug in alpha/beta versions, this isn't really the venue. I'd
try wp-hackers or the forums.

Also, a cursory glance of your migration script leads me to two
observations:

- you don't look one level up for wp-config

- post GUIDs should never be modified. If you're moving from dev to
production, it's fine, but if you're migrating a live site and redirecting
the old domain, you really want to keep the old GUIDs. they are *not* URLs
and might as well be a hash or 36-char GUID.

Nacin