| 
Welcome, Guest
  • Page:
  • 1

TOPIC: Serious issue with database, I not even know where

Serious issue with database, I not even know where 11 months 3 weeks ago #201612

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: 11 months 3 weeks ago by matheusgrafix.
The administrator has disabled public write access.

Re: Serious issue with database, I not even know where 11 months 2 weeks ago #201642

  • nant
  • nant
  • ONLINE
  • Administrator
    Administrator
  • Posts: 19500
  • Karma: 762
Next time please give version numbers.

Upgrade to CB 1.8 and run CB Tools.
The administrator has disabled public write access.

Re: Serious issue with database, I not even know where 11 months 2 weeks ago #201659

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: 11 months 2 weeks ago by matheusgrafix.
The administrator has disabled public write access.

Re: Serious issue with database, I not even know where 11 months 2 weeks ago #201681

  • nant
  • nant
  • ONLINE
  • Administrator
    Administrator
  • Posts: 19500
  • Karma: 762
Run all CB Tools please.
The administrator has disabled public write access.

Re: Serious issue with database, I not even know where 11 months 2 weeks ago #201710

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.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 0.191 seconds