solved Error on count table

Hello i have see that we become this error on activity log

See image

Is this an error in the core

Each on the chart we see audio songs on the top ten with 0 plays?
Each on the profile we have image display errors
www.r-m-n.com
updated by @amwproductions: 04/23/15 10:13:50AM

Here other error when i are logged in as admin i see the user metal4ever with image
updated by @amwproductions: 03/22/15 02:20:28PM

When i log in as user metal4ever i see none image me comes this, see image attached

Please fix this
updated by @amwproductions: 03/22/15 02:21:47PM

Something is wrong - that error you are getting indicates MySQL is failing to create the necessary UNIQUE index on the hit counter table - without that your hits are not going to work.

Are you out of disk space on your server? What version of MySQL are you running? DO any of your tables show crashed? Try running an integrity check with the repair tables option checked.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
updated by @brian: 11/02/15 12:31:08PM

[rock-metal-network]: jrCore_db_verify_table() unable to create missing table unique index: count_hit in table: jr_jrcore_count_ip

[rock-metal-network]: Query Error: Duplicate entry '199.58.86.209-175-0-profile_view_count' for key 'count_hit' - check debug log


same error

Current PHP version: 5.5
mysql (5.5.42-cll)
Disk Usage 73%

Go to the Debug Log tab and show me the MySQL error you are getting.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

23 Mar 2015 18:52:12 78.134.65.29 [rock-metal-network]: integrity check completed
23 Mar 2015 18:52:02 78.134.65.29 [rock-metal-network]: jrCore_db_verify_table() unable to create missing table unique index: count_hit in table: jr_jrcore_count_ip
23 Mar 2015 18:52:02 78.134.65.29 [rock-metal-network]: Query Error: Duplicate entry '199.58.86.209-175-0-profile_view_count' for key 'count_hit' - check debug log
23 Mar 2015 18:52:01 78.134.65.29 [rock-metal-network]: integrity check started
23 Mar 2015 18:48:25 78.134.65.29 [rock-metal-network]: integrity check completed
23 Mar 2015 18:48:05 78.134.65.29 [rock-metal-network]: integrity check started
23 Mar 2015 18:47:52 78.134.65.29 [rock-metal-network]: jrCore_db_verify_table() unable to create missing table unique index: count_hit in table: jr_jrcore_count_ip
23 Mar 2015 18:47:52 78.134.65.29 [rock-metal-network]: Query Error: Duplicate entry '199.58.86.209-175-0-profile_view_count' for key 'count_hit' - check debug log
23 Mar 2015 18:47:51 78.134.65.29 [rock-metal-network]: successfully updated module jrEmbed from version 1.2.0 to 1.2.1
23 Mar 2015 17:47:00 5.157.127.12 [rock-metal-network]: integrity check completed
23 Mar 2015 17:41:49 5.157.127.12 [rock-metal-network]: added comment_thread_id to 8 comments
23 Mar 2015 17:41:41 5.157.127.12 [rock-metal-network]: jrCore_db_verify_table() unable to create missing table unique index: count_hit in table: jr_jrcore_count_ip
23 Mar 2015 17:41:41 5.157.127.12 [rock-metal-network]: Query Error: Duplicate entry '199.58.86.209-175-0-profile_view_count' for key 'count_hit' - check debug log

That's your Activity Log. I need you to click on the "Debug Log" tab and show me the actual MySQL error.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

snipped

[19-Mar-2015 18:54:12 Europe/Dublin] PHP Fatal error: Call to undefined function jrForum_update_active_time() in /home/rmncom/public_html/modules/jrForum-release-1.5.2/profile.php on line 1127 [x 1]

[21-Mar-2015 16:34:03 Europe/Dublin] PHP Strict Standards: Only variables should be passed by reference in /home/rmncom/public_html/modules/jrMarket-release-1.2.11/index.php on line 2274 [x 1]

Please don't cut and paste that much text into the forum here - that just about locked my browser - I removed your post.

I don't need entries from the Error log.

Send me your admin login and password to support [at] jamroom [dot] net.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

i have send the mail

I have fixed this for you - root cause was there were some bad entries in the hit counter table that were keeping the new UNIQUE index from being created. I removed those and it is fixed.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thx for the fast support great service