Back to Easy Shop Support

NEED SUPPORT. "SQLSTATE[42S02]: Base table or view not found: 1146 Table"

Post a reply
189 views
thang28368
thang28368

I don't know why install this get error like this.

"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mytable.pixel_shop_orders' doesn't exist (SQL: select count(*) as aggregate from pixel_shop_orders where is_paid = 1 and status <> completed)"

BUT i install Shopaholic Plugin, don't have any issue like above.

pixeldev
pixeldev

Hi Thang;

Could you send me a screenshot of the list of tables in your database that are prefixed with pixel_? At this moment I give you the support you need.

What version of MySQL do you use?

Last updated

thang28368
thang28368

First thing first, thanks for you quick reply. Actually, when I add Plugin but nothing show in the bar, no icon showup.

  1. After get the notification "Update completed" there is no table of pixel.

  2. MySQL Version information: 4.8.3

pixeldev
pixeldev

Ohh ok, that sounds like the problem comes from the OctoberCMS Updater not finish the installation because the dependencies are needed.

Please uninstall the plugin and install first this dependencies:

RainLab.User RainLab.Location Responsiv.Currency RainLab.Pages (Optional / Recomendable) RainLab.Translate (Optional / Recomendable)

Next, install EasyShop plugin again.

thang28368
thang28368

Thanks for your support. It works now. Appreciate that.

pixeldev
pixeldev

Thanks to you for believing in the project, very soon I will release more updates with improvements. Stay tune

1-6 of 6

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.