[wp-hackers] Sharing Users/authentication

[Chris Lott]

More info on the problem blog. When I install the plugin and activate
it, I receive the errors below. In the DB for that blog there are two
entries with an option_name of sm2wp_options.

The first has this value:
s:244:"a:4:{s:15:"sm2wp_master_db";s:14:"allenher_wrdp2";s:19:"sm2wp_master_prefix";s:3:"wp_";s:16:"sm2wp_USERCOOKIE";s:46:"wordpressuser_4260ef7ca4396b000b1537058c2340c2";s:16:"sm2wp_PASSCOOKIE";s:46:"wordpresspass_4260ef7ca4396b000b1537058c2340c2";}";

The second has this value:
s:162:"a:2:{s:16:"sm2wp_USERCOOKIE";s:46:"wordpressuser_d41d8cd98f00b204e9800998ecf8427e";s:16:"sm2wp_PASSCOOKIE";s:46:"wordpresspass_d41d8cd98f00b204e9800998ecf8427e";}";

c

On 8/30/07, Chris Lott <chris.lott at gmail.com> wrote:
> Stephen:
>
> I'm trying this on a faculty blog and it worked fine on the first
> blog... but on the second it gives this when I try to activate the
> plugin:
>
>
>
> WordPress database error: [Incorrect table name 'usermeta']
> SELECT * FROM ``.usermeta WHERE user_id = '1' AND meta_key LIKE 'wp_%'
>
> WordPress database error: [Incorrect table name 'usermeta']
> INSERT INTO ``.usermeta (user_id, meta_key, meta_value) VALUES ('1',
> 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}')
>
> WordPress database error: [Incorrect table name 'usermeta']
> INSERT INTO ``.usermeta (user_id, meta_key, meta_value) VALUES ('1',
> 'wp_user_level', '10')
>
> WordPress database error: [Incorrect table name 'usermeta']
> INSERT INTO ``.usermeta (user_id, meta_key, meta_value) VALUES ('1',
> 'wp_autosave_draft_ids',
> 'a:19:{i:-1185495985;i:15;i:-1185931550;i:18;i:-1185932215;i:0;i:-1185933060;i:19;i:-1185992168;i:20;i:-1186000987;i:21;i:-1186001017;i:22;i:-1186100153;i:0;i:-1186433684;i:23;i:-1186438291;i:24;i:-1186532307;i:25;i:-1187633121;i:26;i:-1187717710;i:27;i:-1187729770;i:28;i:-1187820579;i:29;i:-1188254466;i:30;i:-1188329160;i:31;i:-1188336443;i:32;i:-1188446299;i:33;}')
>
> WordPress database error: [Incorrect table name 'options']
> SELECT option_value FROM ``.options WHERE option_name='siteurl'
>
> WordPress database error: [Incorrect table name 'usermeta']
> SELECT user_id FROM ``.usermeta WHERE meta_key LIKE 'wp_%'
>
> WordPress database error: [Incorrect table name 'users']
> SELECT ID FROM ``.users
>


-- 
Chris Lott