mkonline

  •  ·  Premium
  • 1636 views
Friends
Empty
Add new...
 
 
·
Added a discussion
·

I am getting emails every few hours from my UNA server about the following error

Any solution to this ?

Thanks

Query:
 SELECT `bx_photos_entries`.`id` as `id`, `bx_photos_entries`.`title` as `title`, `bx_photos_entries`.`text` as `text`, `bx_photos_entries`.`thumb`, `bx_photos_entries`.`author` as `author`, `bx_photos_entries`.`added` as `added`, `bx_photos_entries`.`views` FROM `bx_photos_entries` WHERE 1 AND `bx_photos_entries`.`status` ='active' AND `bx_photos_entries`.`status_admin` ='active' AND `bx_photos_entries`.`allow_view_to` IN(3) ORDER BY `date` DESC LIMIT 0, 12

Mysql error:
 Unknown column 'date' in 'order clause'

Location:
 The error was found in getAll function in the file home/path_to_una/inc/classes/BxDolSearch.php at line 684.

collation_connection:
 utf8mb4_unicode_ci

  • 1565
·
Added a discussion
·

When you install SSL certificate and start using UNA with h t t p s :// , by clicking to storefront or purchases in Apps Market is no longer redirected or recognized.. since the value is changed from h t t p ://     to       h t t p s ://

I have a power license registered as h t t p :// www . makedonijaonline . com and after transition to SSL (h t t p s ://)  i had to generate new key & secret... in order to get to the storefront... but then... power license does not work anymore...(THE REDIRECT URI PROVIDED IS MISSING OR DOES NOT MATCH ) since the domain key shown in LICENCES (which is the same as the KEY) is different)

Any solution to this ? Can you add also h t t p s :// in licenses ?

What will happen if I reset the license in Dashboard ?

P.S. Sorry for the links but. standard membership is not allowed to add URL's ?

  • 1455
mkonline Discussions
Database error UNA 9.0.0-RC11 Unknown column 'date' in 'order clause'
SSL Certificates and Transition to h t t p s : / /