InsertViews: Can't open file: 'jos_comprofiler_vie

17 years 3 weeks ago #34766 by FireIslandMan
We just upgraded our 1&1 VPS hosting and started getting this browser pop up error everytime a CB user clicks on another CB user's link (but not when clicks on own profile link):

InsertViews: Can't open file: 'jos_comprofiler_views.MYI' (errno: 145) SQL=INSERT INTO
jos_comprofiler_views (viewer_id, profile_id, lastip, lastview, viewscount)

VALUES (63, 974, '24.44.218.76', NOW(), 1)

Someone posted a similar error at:
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,10/id,8824/#8824

Using Joomla 1.0.12 with CB 1.0.2:

PHP built On: Linux s15242287.onlinehome-server.com 2.6.9-023stab041.3-smp #1 SMP Wed Feb 14 13:13:03 MSK 2007 x86_64
Database Version: 4.1.20
PHP Version: 5.0.4
Web Server: Apache/2.0.54 (Fedora)
WebServer to PHP interface: apache2handler
Joomla! Version: Joomla! 1.0.12 Stable [ Sunfire ] 25 December 2006 01:00 UTC
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11

Relevant PHP Settings:
Joomla! Register Globals Emulation: OFF
Register Globals: OFF
Magic Quotes: ON
Safe Mode: OFF
File Uploads: ON
Session auto start: OFF
Session save path: /var/www/vhosts/website.com/httpdocs/tmp
Short Open Tags: ON
Output Buffering: OFF
Open basedir: none
Display Errors: OFF
XML enabled: Yes
Zlib enabled: Yes
Disabled Functions: none

PLEASE HELP, THIS IS DETERRING OUR USERS FROM USING CB!

Please Log in to join the conversation.

17 years 3 weeks ago #34767 by beat
FireIslandMan wrote:

InsertViews: Can't open file: 'jos_comprofiler_views.MYI' (errno: 145) SQL=INSERT INTO
jos_comprofiler_views (viewer_id, profile_id, lastip, lastview, viewscount)


SQL database structure error...

your sql database is corrupt and needs repair / restore from backup.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

17 years 3 weeks ago #34771 by FireIslandMan
Replied by FireIslandMan on topic Re:InsertViews: Can't open file: 'jos_comprofiler_vie
Thank you Beat! :woohoo: I ran the eBackup component Check and Repair functions which detected and fixed the corrupt table.

Please Log in to join the conversation.

16 years 6 months ago #46944 by cypux
How did you fix this I don't have a back up component. I need help please.

Please Log in to join the conversation.

16 years 6 months ago #47008 by cypux
FireIslandMan wrote:

Thank you Beat! :woohoo: I ran the eBackup component Check and Repair functions which detected and fixed the corrupt table.


I please need help with this error thing. Thank you

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.506 seconds

Facebook Twitter LinkedIn