If you run Invision Power Board (IPB) forum software on your website, you may run into the notorious “ibf_profile_portal_views.myi not found” or “missing” error… This is a bug related to the IPB Portal system and I’ve seen it creep up a few times since version 2.1.
While the recommended solution is obviously to submit a ticket with IPS support, this is what we’ve used as a solution for this problem.
Use at your own risk, and make sure everything is backed up first!
- Connect to your forums’ IPB MySQL database using phpMyAdmin or your favourite MySQL management tool.
- Drop the ibf_profile_portal_views table (if it exists) from your IPB MySQL database
- Run the following SQL statement:
CREATE TABLE ibf_profile_portal_views (
views_member_id int(10) NOT NULL default ‘0′
);
That should do the trick. Feel free to add comments or questions below.
Note that this has been tested on about 10-12 IPB 2.3.x forum systems that we manage.
3 Comments
Hello Everybody
Just wanted to share my new experience.
If your system fails to run due to an error corresponding to lost HAL.DLL, invalid Boot.ini or any other important system boot files you can fix this by using the XP installation CD. Simply boot from your XP Setup CD and enter the Recovery Console. Then launch “attrib -H -R -S” on the C:\Boot.ini file and remove it. Run “Bootcfg /Rebuild” and then Fixboot
Regards,
Carl
Thanks for contributing Carl, although that fix is for an issue completely unrelated to the IPB forum software bug in the article above … ?
Hi Folks!
Windows vista is also causing lots of boot issues, so I often get questions like this:
I have a Dell Dimension, which won’t boot to Windows (Vista), and none the repair variants work:
Startup repair: Reports fix fail due to problem with registry
System Restore: Reports no restore points available
Windows Complete PC Restore: Reports no backups available
Windows Memory Diagnostic Tool: No memory problems
Command Prompt.
Can’t think of any appropriate command to use here.
So I booted with the system DVD (as one would with XP) but the upgrade
option has been greyed don’t want to do a clean setup. I want to restore existing
installation.
What should I do?
————————————————————
And here is the answer:
You can’t do a ‘repair install’ because you need to launch the Vista DVD
from within Windows, not, as you have been doing, booting straight from the
DVD; that is why the ‘upgrade’ is greyed out.
If you cannot launch Vista and none of the fix options will work a new
install is the only other option.
To save problems in future it is actually a good idea to image the hard
drive, using program like True Image. What I do is install operating system, download all updates, check system I working okay for a day or two, activate system, then image the drive/partition. Any time I get a problem I can re-image the drive/partition quickly and be up and running without much inconvenience. And minor repairs are done by using any registry fix software, there are plenty of them on the market today.
Cheers,
Carl