search

kirilkirkov / Ecommerce-CodeIgniter-Bootstrap

Responsive, Multi-Vendor, MultiLanguage Online Store Platform (shopping cart solution)
MIT License
1.26k stars 942 forks source link

A Database Error Occurred. Error Number: 1146 #228

Closed jessicana closed 2 years ago

jessicana commented 2 years ago

I am sure about the database credentials but I get the below error. How can I fix that?

A Database Error Occurred
Error Number: 1146

Table 's1b.value_store' doesn't exist

SELECT value FROM value_store WHERE thekey = 'outOfStock' LIMIT 1

Filename: modules/admin/models/Home_admin_model.php

Line Number: 128

Could this error be linked to the first step: Import database.sql to your mysql? What does the documentation mean by Importing database.sql to my mysql? Can you please elaborate more about this and how I can solve it?

kirilkirkov commented 2 years ago

@jessicana Your table value_store is missing. The database.sql file is the default structure of the platform, so you need to import this file to yours database and the website should work.

jessicana commented 2 years ago

Thanks! How can I import the table value_store file to the database?

kirilkirkov commented 2 years ago

This table exsits in the database,sql file. When you import this file, the table will exist