MintJoomlaMintJoomla

Tables are missing

Problem Problem | Open Open | Emerald 9 | Hits: 1054 | Comments: 31 | Bookmarked: 0 | Followers: 0

Guest
18 Oct 2013 19:55

When i try to create the "Subscription History" menu item I get this error: Error 1146 Table 'answerit_jmln15.turf_emerald_plans_groups' doesn't exist SQL=SELECT id AS value, name AS text FROM turf_emerald_plans_groups WHERE published = 1 ORDER BY name

And when I publish the "Restricter" plugin I get this error: 1146 - Table 'answerit_jmln15.turf_emerald_subscriptions' doesn't exist SQL=SELECT us.*,p.name as plan_name FROM turf_emerald_subscriptions AS us LEFT JOIN turf_emerald_plans AS p ON p.id = us.plan_id WHERE us.ctime < NOW() AND us.extime > NOW() AND ((us.access_limit = 0) OR (us.access_limit > 0 AND us.access_count < us.access_limit)) AND us.track_disactive = 0 AND us.activated = 1 AND us.user_id = 0

Last Modified: 02 Mar 2014

Quote

Sergey
Total posts: 13,748
21 Oct 2013 00:42

Looks like Emerald tables was not created at all. Please in extension manager delete anything you find my "emerald" keyword and try to install again.

Quote

Guest
21 Oct 2013 15:26

I already did that, and it didn't work. I try to see if it'll install on a fresh Joomla installation and I'll get back to you...

Quote

Sergey
Total posts: 13,748
22 Oct 2013 00:08

Can you install other extension successfully?

Quote

Guest
22 Oct 2013 12:55

I installed it on a fresh Joomla and the tables did not install

Quote

Sergey
Total posts: 13,748
23 Oct 2013 00:16

Can you install other extension successfully?

Quote

Guest
23 Oct 2013 07:14

What other extension?

Quote

Sergey
Total posts: 13,748
24 Oct 2013 00:54

Any. Download and install any other extension. For example K2. And see if tables are created.

To fix your problem you have to run SQL install script manually. Install Emerald. Then unpack one on your computer. In com_emerald***.zip find admin/sql/install.utf8.sql and use code there to apply to your DB. But change #__ to your table prefix.

Quote

Guest
24 Oct 2013 14:58

I installed it but now it's redirecting my frontpage "thenag.us" to "thenag.us/subscription-plans/list"

Quote

Sergey
Total posts: 13,748
24 Oct 2013 23:19

Please give me admin access to your site in private comment. I'll have a look.

Quote

Guest
28 Oct 2013 09:54

thenag.us/administrator

easyblog

t3$ting)(*

Quote

Sergey
Total posts: 13,748
29 Oct 2013 00:30

What frontpage URL is redirected?

Quote

Sergey
Total posts: 13,748
29 Oct 2013 00:31

I do not even see emerald in backend.

Quote

Guest
29 Oct 2013 12:02

You have to enable the component and plugins. I disabled them because of the redirection problem

Quote

Sergey
Total posts: 13,748
30 Oct 2013 00:05

I do not see Emerald in Joomla components menu. Like it is not installed. And when I type URL manually it say Component is not found.

Quote

Guest
01 Nov 2013 13:57

Go To Extensions > Manage > Type Emerald and enable all plugins and component

Quote

Sergey
Total posts: 13,748
04 Nov 2013 07:47

Please, check now.

Quote

Guest
04 Nov 2013 09:38

All my databases are still redirecting to /subscription-plans/list

Quote

Konstantin
Total posts: 1,113
04 Nov 2013 23:55

For some reasons emerald not create all db tables, we create it. And problem with creating plans and groups is in mijosef, if you disabled it and joomla sef all will work fine. To resolve this problem try exlude emerald links from mijosef.

Quote

Guest
06 Dec 2013 11:14

Sorry it took so long. I have a ton of things to do on the site. I disabled MijoSEF and the problem still exists.

Quote

Konstantin
Total posts: 1,113
09 Dec 2013 10:58

When we checked this, and disable mijosef all works fine. Maybe we need to recheck.

Powered by Cobalt

Login (copy)