SQL error [1146]

Website URL

https://netspy.000.pe

Error Message

# General Error
SQL ERROR [ mysqli ]

Table ‘if0_34443568_netspy_sql.phpbbspy_groups’ doesn’t exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Other Information

I set up my forum all right, it was working until I installed an extension. I removed the extension and tweaked some things, the forum gave me this page as an answer and I can’t find this table. There is a table named “phpBBnetspy_groups”
but I don’t know how to rename it to “phpbbspy_groups”. Would that be the problem? Can you help me please?

1 Like

I believe you can do it here

4 Likes

I really appreciate your help my friend and I’m sure I’ll be able to solve my problem.
But my panel is different, can you help me how to do it… sorry for my ignorance

Thanks

try search all tab, maybe the rename will pop out soon

I didn’t understand, my friend

Right in front of you

1 Like

The contents of the Operations panel depends on what you currently have selected. You’re looking at the Database options, but you’ll want to edit the Table options.

To find the right page:

  1. Click the Structure tab at the top of the screen.
  2. Find the table you want to edit and click it.
  3. Then click the Operations tab again.

Now you should see the option to change the table (not the database).

5 Likes

Hi friends, I don’t know if I’m doing it wrong but I followed the paths that were directed here and the problem persists. Take a look at the procedure I triggered from the attachments below. Thanks!

Hello

You cannot change the name of a database in PHPMyAdmin, you can only change the name of a table.

If you want to change the name of the entire database, you need to export the current DB, then create a new one with the correct name in the control panel. Then you can open the newly created DB with the correct name and import the .SQL file you exported from the old DB into it.

3 Likes

I exported and then imported with the modifications. Now it is giving a new error

I don’t know that error. It seems to me like the database contents may be corrupted.

Where did the database contents come from? Did you migrate the site from another host or is this a fresh installation?

4 Likes

I did what the user above asked, for me to download and export the database, edit it with the name of my missing table and import it again

Does anyone know how to resolve this error?

[phpBB Debug] PHP Warning : in file [ROOT]/phpbb/auth/auth.php on line 75 : count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning : in file [ROOT]/phpbb/auth/auth.php on line 76 : count(): Parameter must be an array or an object that implements Countable

General Error

Could not get style data for user_style and set for user_id 0

When I go to enter the ADM, this other error appears

General Error

SQL ERROR [ mysqli ]

User if0_34443568 already has more than ‘max_user_connections’ active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

See these threads

https://forum.infinityfree.net/search?q=%20more%20than%20%E2%80%98max_user_connections%E2%80%99%20

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.