bbPress support forums User Favorites: ebotunes

bbPress support forums User Favorites: ebotunes http://bbpress.org/forums/ bbPress support forums User Favorites: ebotunes en Thu, 04 Dec 2008 05:55:00 +0000 cweb on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-6078 Wed, 28 Mar 2007 20:16:15 +0000 cweb 6078@http://bbpress.org/forums/ Ok this worked for me, here's how I actually reset the auto_increment counter. NOTE: If you've already integrated WP and bbpress and/or if you've already had a bunch of new users register, this wont be so easy for you. If however, you've performed a fresh installation and conversion then this will be simple. 1. make sure one of my existing users in the normal ID range is a Key_Master (this is very important). For me, I made one of my users with ID =5 the Key Master. 2. login with the new Key Master, and delete all the users who are registered with a number => 999999999. For me this wasn't a problem because "admin" was the only user, I haven't had any new user registrations. If you do have new users in the 1000000000 range you'll need to reset their ID's (I'm not a MySQL guy so I dunno how) 3. Once all users in the ugly high number range are deleted, you can run the command to reset the counter on your *_users table, for me it was: <code>ALTER TABLE bb_users AUTO_INCREMENT = 400</code> I just added a few new users and they indeed started at ID 400. BTW, here's the code in the phpbbtobbpress.php converter that sets this very high ID: <pre><code>//Let's clean up the trash. //Your admin user will be given the biggest possible ID (I tried the biggest BIGINT but it didn't work inside bbPress) //If you have more than 999999999 users on your forum, you may have problems... ;-) @mysql_query ("UPDATE " . $bbpress_tables['users'] . " SET ID=999999999 WHERE ID=1"); @mysql_query ("UPDATE " . $bbpress_tables['usermeta'] . " SET user_id=999999999 WHERE user_id=1"); @mysql_query("TRUNCATE TABLE " . $bbpress_tables['forums']);</code></pre> cweb on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-6076 Wed, 28 Mar 2007 19:42:46 +0000 cweb 6076@http://bbpress.org/forums/ I'll confirm that I have this problem as well, from a phpbb to bbpress conversion. I actually tried to reset the auto_increment like chrishajer said: ALTER TABLE bb_users AUTO_INCREMENT = 400 Since my original ID's stopped at around 350. It didn't work though, still incrementing in the billions. MySQL documentation says: <blockquote>"You cannot reset the counter to a value less than or equal to any that have already been used." </blockquote> <a href="http://dev.mysql.com/doc/refman/5.0/en/alter-table.html">http://dev.mysql.com/doc/refman/5.0/en/alter-table.html</a> So to me that reads I need to delete the admin user 999999999 first, am I correct? chrishajer on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5521 Wed, 14 Mar 2007 15:06:23 +0000 chrishajer 5521@http://bbpress.org/forums/ So, it sounds like this is related to the conversion from phpBB. At least that narrows it down. In phpMyAdmin, select the table (be that bb_users or wp_users) and then select the "operations" tab up top. On that page, near the bottom are "Table options:" and in there is a field that says [ xxx ] auto_increment where the xxx is the next auto_increment value that will be used. That's where you would change it. You should first figure out what that value should be, and you should also fix the other high numbered users. But that's where you reset it with phpMyAdmin. *** Perform at your own risk. *** You can also just do it with SQL: <code>ALTER TABLE 'wp_users' AUTO_INCREMENT =whatever-number</code> The wp_users tablename might be bb_users or something else in your install. Also, the table name should be backticked, but you can't do that in a block of code that's already backticked here :D wittmania on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5519 Wed, 14 Mar 2007 14:14:02 +0000 wittmania 5519@http://bbpress.org/forums/ Can anyone enlighten me/us as to how to reset that auto increment using phpmyadmin or something similar? I doubt it is causing any real problems, but it still is kind of ugly. flaerpen on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5517 Wed, 14 Mar 2007 14:00:56 +0000 flaerpen 5517@http://bbpress.org/forums/ I have exactly the same "problem". It all started after converting my phpBB to bbPress so I think thats the problem. wittmania on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5516 Wed, 14 Mar 2007 13:53:51 +0000 wittmania 5516@http://bbpress.org/forums/ I did run the conversion, but it didn't work very well because I ended up with duplicate IDs, and therefore posts from phpbb were attributed to the wrong authors in cases where their IDs conflicted. Now that you mention it, I wonder if the phpbb importer makes a change so that all new registrations would start at 999999999 just so there couldn't possibly be any conflicts. I don't know enough about mysql to know if that's the case (or if it is, how to "fix" it), but if I were the one building the importer, I would probably add a feature like that, though I think a number around one billion might be a bit of overkill! ebotunes on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5514 Wed, 14 Mar 2007 12:57:07 +0000 ebotunes 5514@http://bbpress.org/forums/ this has happened to me as well. Two new users have registered and have IDs 99999999 and 1000000000. They appear to be spam though so I was very worried that they'd somehow managed to hack their user id from the front end??? Highly unlikely though. I am wondering if the conversion from phpBB to bbpress has anything to do with it? ( <a href="http://bbpress.org/forums/topic/47?replies=12" rel="nofollow">http://bbpress.org/forums/topic/47?replies=12</a> ) Did you use this wittmania? I did, and these are the first users to register since the migration. I will investigate a bit further over the next few days when i get the chance.... wittmania on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5446 Mon, 12 Mar 2007 22:29:18 +0000 wittmania 5446@http://bbpress.org/forums/ I looked at the tables in another WP install and fixed this one so that it matched. We'll see if I run into any trouble... Trent on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5445 Mon, 12 Mar 2007 22:15:45 +0000 Trent 5445@http://bbpress.org/forums/ I wish I could help you on that one.....you don't remember what you changed? Do you have a backup? Trent wittmania on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5440 Mon, 12 Mar 2007 21:02:39 +0000 wittmania 5440@http://bbpress.org/forums/ OK... so I do have access to phpMyAdmin, which may not be such a good thing. Somehow I got some things crossed up so I am now getting these messages from within the wp_users table: !!! PRIMARY and INDEX keys should not both be set for column <code>ID</code> !!!More than one INDEX key was created for column <code>ID</code> !!!UNIQUE and INDEX keys should not both be set for column <code>user_login</code> Here is the raw text of the indexes from that page: Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 5 Edit Drop ID user_login UNIQUE 5 Edit Drop user_login user_login_key INDEX None Edit Drop user_login ID_2 INDEX None Edit Drop ID ID_3 INDEX None Edit Drop ID ID_4 INDEX None Edit Drop ID This is a longshot, but can you tell what I messed up, and how I should fix it? Sorry. I really appreciate the help. While I wait for a response I will be banging my head against my desk for not backing up the DB before I started messing around with it. :( chrishajer on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5439 Mon, 12 Mar 2007 20:45:13 +0000 chrishajer 5439@http://bbpress.org/forums/ If you have access to phpMyAdmin, you can reset the auto_increment field to start over at 6 or wherever you are right now. I've never seen this one either, but somehow the auto_increment appears to have gotten messed up. Trent on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5435 Mon, 12 Mar 2007 20:22:19 +0000 Trent 5435@http://bbpress.org/forums/ When you are integrated with bbPress, it uses the wp_user table for users. It shouldn't have done anything to your WP install just integrating with bbPress. That is strange. I don't think I have ever seen this one. Even with both integration plugins, registering in either program I can't replicate this. Anyone else seeing this as well? Trent wittmania on "User ID = 999999999?" http://bbpress.org/forums/topic/user-id-999999999#post-5429 Mon, 12 Mar 2007 18:28:00 +0000 wittmania 5429@http://bbpress.org/forums/ I have recently integrated a bbpress install with an existing wordpress blog/site. The WP blog had three users prior to the integration, and all three made it over to the bbpress install with no problems. However, today a new user registered on the WP side and her ID defaulted to 999999999. I proceeded to register a "dummy" user, just to see what happened. The next registration ticked up to user ID #1000000000. While I doubt that this will lead to any serious problems, it seems silly to me to have user IDs starting around ONE BILLION, when even 1,000 would be plenty high enough for my <a href="http://www.lne97.com">lil' ol' site</a>. Having McDonald's-esque "XX billions served" sized numbers seems to fly in the face of the "Code is poetry" mantra. Any ideas as to what's going on here? ebotunes on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4686 Tue, 20 Feb 2007 14:40:30 +0000 ebotunes 4686@http://bbpress.org/forums/ Yes, I encountered this problem last night. I had to manually add the topic_resolved field to the bb_topics table then it worked fine. other than that - superb script - worked a treat - thanks very much!! ebo Trent on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4273 Fri, 09 Feb 2007 18:35:09 +0000 Trent 4273@http://bbpress.org/forums/ The support forum functions were removed with 0.8 and so10 placed these functions into a plugin. I am sure there is only a few small changes that will not take very long. Trent ljhardy on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4272 Fri, 09 Feb 2007 18:31:13 +0000 ljhardy 4272@http://bbpress.org/forums/ Trent - I'll post the errors when I get home tonight. I think that it probably had to do with changes in the database, if I remember correctly I think it was with the "topic resolved" field? Len Trent on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4265 Fri, 09 Feb 2007 16:31:05 +0000 Trent 4265@http://bbpress.org/forums/ That is a good question. I have yet to test it on the most recent version of bbPress. I guess if nothing else you can run it on an install of 0.74 and get it working and then upgrade bbPress to 0.8 afterwards if nothing else. What were the errors? Trent ljhardy on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4264 Fri, 09 Feb 2007 16:28:48 +0000 ljhardy 4264@http://bbpress.org/forums/ Does anybody know if this script is supposed to work with the latest release of bbpress (.8)? I ran into some problems importing some of the tables. Thanks, Len lingmiester on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4241 Fri, 09 Feb 2007 05:33:41 +0000 lingmiester 4241@http://bbpress.org/forums/ PHEW! I'm so sorry. I so nieve with such things. Thanks for the check thru. Trent on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4238 Fri, 09 Feb 2007 05:23:49 +0000 Trent 4238@http://bbpress.org/forums/ I have looked over the code of this plugin and it doesn't send your email to spammers. Jaim3 even put this in the code: <pre><code> // DISCLAIMER: This is a joke echo "<li><h3>Sending all your database e-mails to all major world-wide spam sending mafias...</h3></li>";</code></pre> If someone else wants to look to confirm, but it does what it is intended to as far as I am concerned. Trent lingmiester on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-4234 Fri, 09 Feb 2007 05:16:02 +0000 lingmiester 4234@http://bbpress.org/forums/ Watch out! I think this script by jaim3 sends all your emails to spammers! jaim3 on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-2135 Sat, 09 Dec 2006 01:08:08 +0000 jaim3 2135@http://bbpress.org/forums/ Have a look at this: <a href="http://bbpress.org/forums/topic/402" rel="nofollow">http://bbpress.org/forums/topic/402</a> spencerp on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-264 Fri, 20 Oct 2006 05:37:47 +0000 spencerp 264@http://bbpress.org/forums/ You might want to follow this thread maybe? ;) <a href="http://bbpress.org/forums/topic/3?replies=6" rel="nofollow">http://bbpress.org/forums/topic/3?replies=6</a> spencerp marky on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-246 Thu, 19 Oct 2006 16:56:28 +0000 marky 246@http://bbpress.org/forums/ Not yet, from what I can gather. But hopefully someone will work on an importer script soon. erikcw on "Import phpBB posts into bbPress?" http://bbpress.org/forums/topic/import-phpbb-posts-into-bbpress#post-227 Thu, 19 Oct 2006 03:14:42 +0000 erikcw 227@http://bbpress.org/forums/ Hi all, Is there an easy way to import a phpBB forum into bbPress? Thanks! kyte on "Akismet key" http://bbpress.org/forums/topic/akismet-key#post-59 Sun, 15 Oct 2006 02:39:55 +0000 kyte 59@http://bbpress.org/forums/ Ahhhh so it actually requires quote marks. Well I am no php person so I did not realise that. Thanks, Jeremy :) JeremyVisser on "Akismet key" http://bbpress.org/forums/topic/akismet-key#post-56 Sun, 15 Oct 2006 02:03:51 +0000 JeremyVisser 56@http://bbpress.org/forums/ This is due to a PHP syntax error. My Akismet line looks like this: <code>$bb->akismet_key = "12345678";</code> (key censored) kyte on "Akismet key" http://bbpress.org/forums/topic/akismet-key#post-54 Sun, 15 Oct 2006 00:52:42 +0000 kyte 54@http://bbpress.org/forums/ I tried to use my WP.com key so's I can utilise akismet but it kept throwing an unexpected T-STRING error at Line 40. I gave up in the end. Any suggestions? Parse error: syntax error, unexpected T_STRING in /home/kyte/public_html/forums/config.php on line 40