I would like to check the order history in DB.

I'm a beginner using EC-CUBE for the first time.
I installed EC-CUBE4 using Cloud9.

Once you shop locally, you can even confirm your order.
When I tried to check in DB, I got an error without the dtb_order table.

I installed it while starting mysql which is included by default in Cloud9.
The EC-CUBE was also applied to sqlite 3.7.17 by default.

I found the file ec-cube.db in /ec-cube/var/sessions, and when I opened it, I found the purchase history.
From now on, I would like to use CUI to change the information, so I would like to withdraw the table from sqlite and check the information, but I don't understand what's going on right now.

Are cloud 9 sqlite and EC-CUBE not adapting well?
If so, please let me know the solution.
I'm sorry if the question was off the mark.

sqlite ec-cube

2022-09-30 21:39

1 Answers

The questionnaire provides the following information:

EC-CUBE is properly installed and running with SQLite settings for the database
SQLite files use /ec-cube/var/sessions/ecube.db
Questioner wants to use MySQL, but an error occurred because EC-CUBE is not configured to use MySQL.

Therefore, we would like to retrieve and change the contents of the database in the future, so we have the following options:

Reseat MySQL as the EC-CUBE database
Learn how to work with SQLite and be able to work with SQLite while keeping the EC-CUBE configuration intact

If your current system is for commercial use, I recommend the former (I will not discuss the difference between MySQL and SQLite this time as it will derail).

2022-09-30 21:39

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656