I accidentally deleted the wrong files when I downgraded with XAMPP, can I still solve it?

[Steve]

So I wanted to go to PHP 7.1, I copied the MySQL folder, but I forgot to also copy the htdocs folder. Stupid I know.

Now I do have a backup htdocs from a few weeks back. And I only changed stuff a few days ago, so the files should be still relevant. I also still have the mysql data folder from a few hours back.

When I tried to copy the old htdocs folder and the new DB backup, I got on the homepage with all content wihtout problems, but when I tried to access other pages, I got a 404 error. Can I still solve it this way or should I do something else?

Thanks!

Edit: I also tried using the old htdocs and mysql from a few weeks back (the same ones), but I get these errors:

``` [ThirtyBeesDatabaseException] Table 'webshop.tbsmartylazy_cache' doesn't exist in engine

DELETE FROM tb_smarty_lazy_cache WHERE template_hash='19e2980ce3d69dd779f122109efef95d'

at line 849 in file classes/db/Db.php 844. if ($webserviceCall && $errno) { 845. $dbg = debugbacktrace(); 846. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 847. } elseif (PSDEBUGSQL_ && $errno && !defined('TBINSTALLATIONINPROGRESS')) { 848. if ($sql) { 849. throw new PrestaShopDatabaseException($this->getMsgError().'

'.$sql.'

'); 850. } 851. 852. throw new PrestaShopDatabaseException($this->getMsgError()); 853. } 854. } DbCore->displayError - [line 488 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 675 - classes/db/Db.php] - [1 Arguments] DbCore->execute - [line 128 - classes/SmartyCustom.php] - [2 Arguments] SmartyCustomCore->deletefromlazycache - [line 150 - classes/SmartyCustom.php] - [3 Arguments] SmartyCustomCore->clearCache - [line 3906 - classes/Tools.php] - [3 Arguments] ToolsCore::clearCache - [line 309 - modules/blocknewproducts/blocknewproducts.php] - [3 Arguments] BlockNewProducts->clearCache - [line 68 - modules/blocknewproducts/blocknewproducts.php] BlockNewProducts->__construct - [line - ] ReflectionClass->newInstance - [line 189 - Core/Foundation/IoC/CoreFoundationIoCContainer.php] CoreFoundationIoCContainer->makeInstanceFromClassName - [line 232 - Core/Foundation/IoC/CoreFoundationIoCContainer.php] - [2 Arguments] CoreFoundationIoCContainer->doMake - [line 253 - Core/Foundation/IoC/CoreFoundationIoCContainer.php] - [2 Arguments] CoreFoundationIoCContainer->make - [line 71 - Adapter/AdapterServiceLocator.php] - [1 Arguments] AdapterServiceLocator::get - [line 510 - classes/module/Module.php] - [1 Arguments] ModuleCore::coreLoadModule - [line 461 - classes/module/Module.php] - [1 Arguments] ModuleCore::getInstanceByName - [line 464 - classes/Hook.php] - [1 Arguments] HookCore::execWithoutCache - [line 288 - classes/Hook.php] - [7 Arguments] HookCore::exec - [line 339 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 11 - override/classes/controller/FrontController.php] FrontController->initContent - [line 121 - controllers/front/PageNotFoundController.php] PageNotFoundControllerCore->initContent - [line 262 - classes/controller/Controller.php] ControllerCore->run - [line 253 - classes/controller/FrontController.php] FrontControllerCore->run - [line 837 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 33 - index.php] ``` I think it has to do with the old version of panda but I can't update it because I also can't access the backoffice.

[musicmaster]

You might copy the three smarty tables from a fresh install. You can also import the file I attached that contains those three tables. Anyway, clean the cache as soon as possible. 01546953434158lazy.zip

[Steve]

@musicmaster

I can't download your attachment.

[musicmaster]

@steve said in I accidentally deleted the wrong files when I downgraded with XAMPP, can I still solve it?:

@musicmaster

I can't download your attachment.

I have replaced the file with a zip.

[Steve]

Getting these errors when I used the import feature in phpmyadmin:

``` INSERT INTO tb_smarty_lazy_cache (template_hash, cache_id, compile_id, filepath, last_update) VALUES ('0c901a72da3276e174f98f86d9e3a580', 'blocktopmenu|1|1|13|category|3', '', 'blocktopmenu\1\1\13\category\3\fe\db\6e\fedb6e39db59c00f4dd62abe25cebaffb1279681.blocktopmenu.tpl.php', '2018-10-20 12:47:10'), ('0c901a72da3276e174f98f86d9e3a580', 'blocktopmenu|1|1|13|index', '', 'blocktopmenu\1\1\13\index\fe\db\6e\fedb6e39db59c00f4dd62abe25cebaffb1279681.blocktopmenu.tpl.php', '2018-10-20 12:46:24'), ('25d060db3bb982f2b9d1ce53e39e4f16', 'blocksocial|1|1|13', '', 'blocksocial\1\1\13\34\b7\f7\34b7f7d27e1f3c69ca4b4bd75c5c240456454893.blocksocial.tpl.php', '2018-10-20 12:46:36'), ('2a8001dc73cbcfdde2617a2a9eed9df0', 'blocktags|1|1|13', '', '', '2018-10-20 12:47:16'), ('2d6ae983a572f8fb8da18e50d5dbf79e', 'blockbanner|1|1|13', '', 'blockbanner\1\1\13\ec\c3\d1\ecc3d1040e5314151811222174902ff491d6fab2.b[...] MySQL meldt: Documentatie

1932 - Table 'webshop.tbsmartylazy_cache' doesn't exist in engine

```

It does say that the import was succesful though. I still have the same error on my site.

[musicmaster]

The sql I sent contains a create command for this table. So you might have a look in phpmyadmin whether there is such a table or not. And if there isn't you might try in the SQL console of phpmyadmin whether you can create a table from there. If you aren't one possibility is that you don't have writing in the mysql/data directory. Of course it might also be another rights problem.

[Steve]

I do still have some files from the latest htdocs from my site (xammp didn't delete eveything). The weird thing is that I have all files starting at the config folder. Can I get the old files from above the config folder? Or are these unique?

[musicmaster]

Nothing unique. You can copy all those directories from a fresh install of TB of the same version.

[Steve]

Alright I added all the files above config from my old site to the new one. Now I get this error:

``` [ThirtyBeesDatabaseException] Table 'webshop.tb_configuration' doesn't exist in engine

SELECT c.name, cl.id_lang, IFNULL(cl.value, c.value) AS value, c.id_shop_group, c.id_shop FROM tb_configuration c LEFT JOIN tb_configuration_lang cl ON c.id_configuration = cl.id_configuration

at line 849 in file classes/db/Db.php 844. if ($webserviceCall && $errno) { 845. $dbg = debugbacktrace(); 846. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 847. } elseif (PSDEBUGSQL_ && $errno && !defined('TBINSTALLATIONIN_PROGRESS')) { 848. if ($sql) { 849. throw new PrestaShopDatabaseException($this->getMsgError().'

'.$sql.'

'); 850. } 851. 852. throw new PrestaShopDatabaseException($this->getMsgError()); 853. } 854. } DbCore->displayError - [line 488 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 709 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 439 - classes/Configuration.php] - [1 Arguments] ConfigurationCore::loadConfigurationFromDB - [line 271 - classes/db/Db.php] - [1 Arguments] DbCore::getInstance - [line 338 - classes/shop/Shop.php] - [1 Arguments] ShopCore::initialize - [line 123 - config/config.inc.php] require - [line 32 - index.php] - [1 Arguments] ```

Is there something wrong with my database or my core files? Or maybe my config folder.

01546968003646config.zip

[musicmaster]

configuration is usually the first table consulted. So I doubt that there is any table at all. Did you do the tests in phpmyadmin I asked?

[Steve]

In phpmyadmin I see that I get this error on every table that I choose: #1932 - Table ['EXAMPLE_TABLE'] doesn't exist in engine

The database does contain lazy cache now.

I see possible solutions like here: https://stackoverflow.com/questions/33839569/mysql-error-1932-table-phpmyadmin-pma-user-config-doesnt-exist-in-engine

``` Finally, I find the solution. We can find there really exists the table 'pma__tracking' when we expand the phpmyadmin database.

But the system error call on #1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine.

So just try to remove the old pma__* database first and reconfig them later.

1.Remove the wrong tables in xampp's installation path and remove all the files in var/mysql/phpmyadmin/, which are similar like pmabookmark.frm/pmabookmark.ibd...

2.Reinstall the sql of phpmyadmin, which located in phpmyadmin/sql/, something like 'createtables.sql', run them with mysql < createtable.sql, etc.

Then it works. ```

But I have no idea if that has anything to do with my problem.

If you still don't have the information that you need about the 'tests' please let me know.

[Steve]

Here are the privileges from my DB:

[musicmaster]

My impression is that it has something to with the way you transported the database. Normally you should transport databases by exporting and importing an sql file. Instead you transported the files. Probably something has gone wrong there. You can try mysql's repair functions. But I am afraid the problem lies deeper.

[Steve]

Just found a .sql file from 2 days ago, doesn't do anything when I import it though. A few successes but no new tables

01547022680135webshop_sql.zip

[Steve]

Just tried to repair all tables, it says operation failed at every table.

[musicmaster]

Did you have a look at the content of the file? Some 200 times this comment:

-- Tabelstructuur voor tabel tb_access

-- Fout bij lezen van tabelstructuur van tabel webshop.tbaccess: #1932 - Table 'webshop.tbaccess' doesn't exist in engine -- Fout bij het lezen van gegevens voor tabel webshop.tb_access: #1064 - Er is iets fout in de gebruikte syntax bij 'FROM webshop.tb_access' in regel 1

You will need an older sql file to achieve anything.

[Steve]

Okay, I now copied the whole data folder, and not only the 'webshop' DB folder inside the data folder. I can now click on all tables without any problems.

However my website is now completely black without any css. Just some HTML.

[musicmaster]

Try deleting .htacces (you can regenerate it later).

If that doesn't help: delete the cache.

[Steve]

Which one should I delete? I see more of them.

And I don't think I can delete the cache, I can't even get on my admin panel. When I click/navigate anywhere but the homepage I get the object not found error from xammp.

[musicmaster]

The .htaccess in the root of your shop.

You can use Prestools to delete the cache (under Shop Rescue).

[Steve]

Ah I see that I don't have a .htaccess yet.

I'll try using Prestools now.

[Steve]

I also can't access that login page. (I navigate to http://webshop/admin169x8dwpn/rescue/login1.php) Does TB know what admin folder I'm using if I copied it from an older store like I said before?

[Steve]

Can I install a fresh copy of TB and copy all the unique files (my theme, modules etc) And then also copy over the DB again? Are my settings in those files or is eveything on default again?

[musicmaster]

@steve said in I accidentally deleted the wrong files when I downgraded with XAMPP, can I still solve it?:

I also can't access that login page. (I navigate to http://webshop/admin169x8dwpn/rescue/login1.php) Does TB know what admin folder I'm using if I copied it from an older store like I said before?

What do you mean "can't access"? What do you get? You should always be able to have access as long as the database connection is good.

@steve said in I accidentally deleted the wrong files when I downgraded with XAMPP, can I still solve it?:

Can I install a fresh copy of TB and copy all the unique files (my theme, modules etc) And then also copy over the DB again? Are my settings in those files or is eveything on default again?

See my previous question. You are "repairing" things that most likely aren't broke and may in the process introduce new problems.

[Steve]

@musicmaster said in I accidentally deleted the wrong files when I downgraded with XAMPP, can I still solve it?:

What do you mean “can’t access”? What do you get?

My directory:

But my admin folder has been copied by my older shop, so I don't know if that maybe that has to do with it?

See my previous question. You are “repairing” things that most likely aren’t broke and may in the process introduce new problems.

Okay I'll wait with installing again.

[musicmaster]

As far as I know there are only three options that can produce this result: - something is wrong with your setting for "webhost". You have added your own settings in addition to "localhost" and something there may be wrong - an .htaccess is redirecting the link so that it doesn't work. It might be on any level. - some anti-malware program is blocking Prestools.

Put some textfile (example.txt) i the root of your shop and see if you can access that with the browser.