Skip to Content Skip to Menu

Serious issue with database, I not even know where

12 years 6 months ago - 12 years 6 months ago #201612 by matheusgrafix
Serious issue with database, I not even know where to begin from.

Let me explain it. Suddenly I started getting error 130 inside users management area, at community builder, also the frontend users list sometimes disapear.

I dont have any clue on how to solve this.

Here:

Função do Banco de Dados falhou. Número do erro 1030
Got error 28 from storage engine SQL=SELECT u.*, GROUP_CONCAT( DISTINCT g.title ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation FROM hwkix_users AS u LEFT JOIN hwkix_comprofiler AS ue ON u.id = ue.id INNER JOIN hwkix_user_usergroup_map AS aro ON aro.user_id = u.id INNER JOIN hwkix_usergroups AS g ON g.id = aro.group_id GROUP BY u.id LIMIT 0, 20
Last edit: 12 years 6 months ago by matheusgrafix.

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
12 years 6 months ago #201642 by nant
Next time please give version numbers.

Upgrade to CB 1.8 and run CB Tools.

Please Log in or Create an account to join the conversation.

12 years 6 months ago - 12 years 6 months ago #201659 by matheusgrafix
Replied by matheusgrafix on topic Re: Serious issue with database, I not even know where
Sorry, I thought I was already using the version 1.8 because my version is too recent (downloaded it 1 month ago, or less).

Just updated to 1.8 and I'm still getting the same error. Synchronized the users, got an error on the top saying it wasn't possible to sync users with ID 43, 44 and 45. Now, Tried to sync again, said it was successful.

But still getting the same error when I open the users management. By the way, sometimes it appears, sometimes it disappears. The List issue still happens, and there is another thing I forgot to say, every user has a street view loaded in the top of their profile, sometimes it disappears too.
Last edit: 12 years 6 months ago by matheusgrafix.

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
12 years 6 months ago #201681 by nant

Please Log in or Create an account to join the conversation.

12 years 6 months ago #201710 by matheusgrafix
Replied by matheusgrafix on topic Re: Serious issue with database, I not even know where
Did it, nothing helped. Also contacted my server, they said there was a problem in cpanel and they fixed it, but I'm still getting the same errors.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum