Database error

jgold723
9 years, 7 months ago
I just installed Mobile Joomla, free, 2.0.6. on a Joomla 3.3.6 site. No errors on installation. Using the default configuration. When I try to visit the site on my desktop, I get the following error:





1054 - Unknown column 'mj.device' in 'where clause' SQL=SELECT p.folder AS `type`, p.element AS `name` FROM `u47_mj_plugins` AS mj LEFT JOIN `u47_extensions` AS p ON p.extension_id=mj.id WHERE mj.device='desktop'


Can someone tell me what's happening? I've disabled the extension for now.
dryabov
9 years, 7 months ago
What database do you use (MySQL/PostgreSQL/...)?
jgold723
9 years, 7 months ago
Database is MySQL, 5.5.45-MariaDB
dryabov
9 years, 7 months ago
Did you have MJ 1.x installed previously?

Try to uninstall MJ, check that u47_mj_plugins and u47_mj_modules tables are correctly dropped, and then install MJ 2.0 again.
jgold723
9 years, 7 months ago
Thank you, that did it.
skip2000
9 years, 3 months ago
I'm having the same issue and have uninstalled 4 times.
If by "check that u47_mj_plugins and u47_mj_modules tables are correctly dropped" you mean search the plugins and modules for traces of Mobile Joomla then I have done this and nothing there.
Yet Every time I enable it I get same error 1054.

It installs great with no errors.

Thanks for any help,
Carl
john.causing
9 years, 3 months ago
@skip2000

Hi Carl,

I replied to your email.

Best,

John Mark C.
Mobile Joomla! Support
skip2000
9 years, 2 months ago
Thanks so much! Everything is working fine now!
Cheers,
Carl

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.