Website having problems uploading SQL file to the mysql database

Hosting Support
1

Website URL

(https://seguidoresvip.wuaze.com)

Error Message

There is no error message, my website just doesn’t work, the website does not work after placing the sql file in the mysql database

Other Information

before I put the sql file in mysql I only have site files in the file manager and without the file in sql this error appears

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘if0_35396083_seguidoresvip.settings’ doesn’t exist in /home/vol19_1/infinityfree.com/if0_35396083/htdocs/system/abab1214b922f20db86eff2116a12249.php:58 Stack trace: #0 /home/vol19_1/infinityfree.com/if0_35396083/htdocs/system/abab1214b922f20db86eff2116a12249.php(58): PDOStatement->execute(Array) #1 /home/vol19_1/infinityfree.com/if0_35396083/htdocs/index.php(6): require_once(‘/home/vol19_1/i…’) #2 {main} thrown in /home/vol19_1/infinityfree.com/if0_35396083/htdocs/system/abab1214b922f20db86eff2116a12249.php on line 58

But that’s not bad, it means that everything is working according to logic and just add the site’s database in this case, SQL and the site was already supposed to work like this I did on other hostings, one more detail, the PHP version required must be 7.4 but I’ve read on the forum that the standard version of the free plan is already 7.4 so I don’t think that’s the problem

this is the SQL file zeyinsta_teste (1)

2

This example of what my website was supposed to look like but it just won’t load https://www.bombeja.com.br

I have a tutorial that I was using to do this, if you want, I can go through it to get a better idea of ​​the problem

3

It EXACTLY is the problem, all servers of the free hosting use PHP 8.2 now as PHP 7.4 is obsolute.

7 Likes
4

But is there any way I can change to 7.4 without upgrading to the premium version?

5

In short, no

3 Likes
6

No, try to keep the code up to date instead.

2 Likes
7

Hi Sixxxz,

Depending on the software you’re using, you need to update the codebase to follow PHP 8.2 standard, one common factor is to have all mysql_* functions be converted to mysqli_*.

However the issue here seems to be another thing, as your error message suggests the base table is gone and it’s looking for the table settings specifically.
A quick inspect of your SQL file, the table creation statement exists on line 21919.

--
-- Estrutura da tabela `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `site_logo` text DEFAULT NULL,
  `site_name` text DEFAULT NULL,
  `site_title` text NOT NULL,
  `site_description` text NOT NULL,
  `site_keywords` text NOT NULL,
  `site_currency` text NOT NULL,
  `favicon` text DEFAULT NULL,
  `site_language` varchar(225) NOT NULL DEFAULT 'en',
  ...

As you have already suggested that you have imported the SQL file into the MySQL database, would you please help check again if the import has been completed entirely successfully? Chances are the import has not been completed due to max_execution_time or whatever timeout it can be. If you find missing tables, you’ll need to import by part to get everything in there.

Your website has attempted to call the database in order to get this error message, so while PHP version could be a factor, it’s not what’s blocking you here as of what I see now.

Cheers!

3 Likes
8

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