mawby

Following this as I'm hoping it can be used to fix all my tables I had working on vBulletin before I converted to IPS.

Nope. And my old vB forum didn't have facebook logins allowed either. The only clue is this on their account...

Converted from vBulletin 4. Enabled login handlers are Standard and Converter.

Post conversion, I have a few users who cannot login because they've forgotten their password. I tell them to use the reset option but apparently no email comes through. So I just tried the option myself in the admin control panel and get the error: 2C114/13 This user is not currently using a login handler that uses a password. Is it not possible to reset a users password post conversion until after they've logged in? Or I am missing something.

Hi there. Thanks but I've already got the Cron setup. My problem is more that now the conversion is complete I've changed a setting that affects the posts but there's no way to rebuild them for that change to take affect.

After converting my site with 3.5 million posts from vb4 I've just realised that many inline images are now just urls due to the "Allow remote images" setting not being ticked. No worries, I've ticked that now, but now I need a way to rebuild all those posts which are affected. I can't find the option, although I know it exists because it ran for over 24 hours at the end of the conversion process. Any ideas?

Got it working with a value of 1048576.

Of course, it wouldn't actually help in this situation where I was on page one and clicked the last page button.

Just checked and the default is being used. I changed the SQL slightly, so it will used the index instead of doing a table scan, and that's fixed the problem. It would require remembering the album_id of the previous last row returned though. SELECT gallery_albums.*, author.* FROM `gallery_albums` LEFT JOIN `core_members` AS `author` ON author.member_id = gallery_albums.album_owner_id WHERE gallery_albums.album_id > 2650 AND gallery_albums.album_category_id=2 AND album_type<>4 AND ( gallery_albums.album_type IN(1,2) OR ( gallery_albums.album_type=3 AND ( gallery_albums.album_owner_id=1 OR gallery_albums.album_allowed_access IN (0,5,10) ) ) ) AND gallery_albums.album_hidden < 2 AND gallery_albums.album_hidden !=-2 AND gallery_albums.album_hidden !=-3 ORDER BY album_last_img_date DESC LIMIT 25

Any advice on what I should set the sort memory to in order to prevent this error? Alternatively, could an index be added to avoid the sort altogether? SELECT gallery_albums.*, author.* FROM `gallery_albums` LEFT JOIN `core_members` AS `author` ON author.member_id = gallery_albums.album_owner_id WHERE gallery_albums.album_category_id=2 AND album_type<>4 AND ( gallery_albums.album_type IN(1,2) OR ( gallery_albums.album_type=3 AND ( gallery_albums.album_owner_id=1 OR gallery_albums.album_allowed_access IN (0,5,10) ) ) ) AND gallery_albums.album_hidden < 2 AND gallery_albums.album_hidden!=-2 AND gallery_albums.album_hidden !=-3 ORDER BY album_last_img_date desc LIMIT 2650,25 IPS\Db\Exception: Out of sort memory, consider increasing server sort buffer size (1038) #0 /var/www/html/system/Db/Select.php(441): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 [internal function]: IteratorIterator->rewind() #3 /var/www/html/system/Helpers/Table/Content.php(343): iterator_to_array() #4 /var/www/html/system/Helpers/Table/Table.php(489): IPS\Helpers\Table\_Content->getRows() #5 /var/www/html/applications/gallery/modules/front/gallery/browse.php(213): IPS\Helpers\Table\_Table->__toString() #6 /var/www/html/applications/gallery/modules/front/gallery/browse.php(115): IPS\gallery\modules\front\gallery\_browse->_category() #7 /var/www/html/system/Dispatcher/Controller.php(101): IPS\gallery\modules\front\gallery\_browse->manage() #8 /var/www/html/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #9 /var/www/html/applications/gallery/modules/front/gallery/browse.php(49): IPS\Content\_Controller->execute() #10 /var/www/html/system/Dispatcher/Dispatcher.php(152): IPS\gallery\modules\front\gallery\_browse->execute() #11 /var/www/html/index.php(13): IPS\_Dispatcher->run() #12 {main}

I have over 2000 paid subscriptions on my vB4 board that I need converting over to my new Invision site. Having done a couple of test conversions now, I've only just realised that paid subscriptions aren't part of the conversion. :( Looking at how I'd do this manually for a single user, I'd create a "paid" invoice for the user, adding the new subscription to it, then I'd have to edit the purchase to correct the expiry date. I'm not going to be doing that by hand 2000 times! Has anyone else successfully converted paid subscriptions or can offer any advice for writing my own conversion (i.e. what data is needed in which tables)