database change please help

[mikeh1975]

hi there I currently have a host that's switched off everything apart from php v8.2 & 8.3 so my old presta sits there on a 500 error

I've installed 8.1 on a new sub, and wanted to know if there is a way i can use the old database and sql in 8.1

so for example i have a large sql in presta 1.6 and I want to use that in v8 is that possible without starting all over again?

thanks

 

Edited July 6 by mikeh1975 (see edit history)

[Nickz]

1 hour ago, mikeh1975 said:

and wanted to know if there is a way i can use the old database and sql in 8.1

That would depend on the database you used before. What does the php apache2 errorlog say?

[mikeh1975]

Where would I locate that please in file manager I'm assuming 

[Nickz]

The errorlog you find usually under Linux Debian and Ubuntu distros under var > log > apache2. 
Windows Server: depending on what manages your webserver.

[mikeh1975]

4 minutes ago, Nickz said:

The errorlog you find usually under Linux Debian and Ubuntu distros under var > log > apache2. 
Windows Server: depending on what manages your webserver.

var folder is empty apart from a cpanel folder and one called styled and that sub folder is also empty

 

[mikeh1975]

-- phpMyAdmin SQL Dump -- version 5.2.1 --

https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 05, 2024 at 03:53 AM --

Server version: 5.7.23-23 -- PHP Version: 8.1.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; --

-- Database: `barwellb_pres118` -- -- -------------------------------------------------------- -- -- Table structure for table `o78_access` -- CREATE TABLE `o78_access` ( `id_profile` 

my question is can i edit the config\peramiters.php on the new fresh install of presta 8.1 to use the old sql file

Edited July 7 by mikeh1975 (see edit history)

[Nickz]

On 7/7/2024 at 2:15 PM, mikeh1975 said:

my question is can i edit the config\peramiters.php on the new fresh install of presta 8.1 to use the old sql file

you surely can you just need to act with caution.
Make a copy of the file and have that downloaded on your PC.

the var folder can be on different location closer to you root folder or even in there.
That depends on the configuration the server ẃas set to.
Where do you host?

 

Edited July 24 by Nickz (see edit history)

[mikeh1975]

29 minutes ago, Nickz said:

you surely can you just need to act with caution.
Make a copy of the file and have that downloaded on your PC.

the var folder can be on different location closer to you rool folder or even in there.
That depends on the configuration the server ẃas set to.
Where do you host?

 

So how would I do that could you give me a idea. Thanks

[Nickz]

On 7/7/2024 at 3:51 PM, mikeh1975 said:

So how would I do that could you give me a idea. Thanks 

I currently have a host that's switched off everything apart from php v8.2 & 8.3

You need to move to a different server. Where are your clients sitting at?
Servers come with relatively convenient pricing nowadays. 30 to 50 a year for a shared server. VPS with 8 GB RAM for 70 a year (1st year only)
Its also a question of how fit you are.

[El Patron]

you need to keep old version of ps, then upgrade it  to 8.1

or you need to get new hosting that allows you to have php level for your 1.6 shop

there are no magic bullets, you cannot run 8.1 with 1.6 db as 8.1 will have new tables, changed tables etc