News Flash:
New Version of ShopClass theme 1.4.0 is Released on 13 JUNE 2018, Please upgrade your installation.

Sphinx error

If you are having general problems with ShopClass theme, post your questions here. This is not the place for customization or feature requests
Post Reply
pureyes
Noob
Posts: 9
Joined: Fri Aug 10, 2018 1:01 am

Sphinx error

Post by pureyes » Mon Aug 27, 2018 2:28 am

Hi, i´m getting the following error

[27-Aug-2018 03:40:21 Europe/Madrid] PHP Warning: mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 115
[27-Aug-2018 03:40:21 Europe/Madrid] PHP Warning: mysqli::query(): invalid object or resource mysqli
in /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 98
[27-Aug-2018 03:40:21 Europe/Madrid] PHP Fatal error: Uncaught Error: Call to a member function fetch_assoc() on null in /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php:156
Stack trace:
#0 /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php(134): SphinxQLClient->fetch(2, NULL, NULL)
#1 /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQL.php(127): SphinxQLClient->fetchAll()
#2 /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphSearch.php(547): SphinxQL->fetchAll()
#3 /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/CWebSphSearch.php(393): SphSearch->doSearch()
#4 /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/CWebSphSearch.php(552): CWebSphSearch->doModel()
#5 /var/www/biciusada.cl/oc-includes/osclass/classes/Plugins.php(34): WebThemes->{closure}()
#6 /var/www/biciusada.cl/oc-includes/osclass/helpers/hPlugins.php(34): Plugins::runHook('before_search')
#7 /var/www/biciusada.cl/oc-includes/osclass/controller/search.php(1 in /var/www/biciusada.cl/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 156

Please help!!

User avatar
tuffadmin
Site Admin
Posts: 1236
Joined: Tue Jan 29, 2013 7:31 pm
Has thanked: 33 times
Been thanked: 111 times

Re: Sphinx error

Post by tuffadmin » Mon Aug 27, 2018 5:02 am

Is sphinx server is installed and configured? Please let me know of configuration details. Error says that sphinx server is not running, remove sphinx from config.php till this get not resolved.
No support for unnecessary PM, use forum for support queries.
Please give us good review if you bought our theme from Osclass Market

pureyes
Noob
Posts: 9
Joined: Fri Aug 10, 2018 1:01 am

Re: Sphinx error

Post by pureyes » Mon Aug 27, 2018 5:54 pm

Thanks!!, the problem was that the sql port was not by default 3306, so i set it in the sphinx.conf.

:D :D

But that is not resolving my principal issue. The category select is not working, and the locations select neither, and i don´t know why. The locations are fine, the sphinx too, the cron too, the theme config too, so i don´t know why it´s not working. I will show you some screenshots.


Here the category select bug
Image


Here the location select bug (when i click, nothing appears)
Image


Thanks for your support!!

User avatar
tuffadmin
Site Admin
Posts: 1236
Joined: Tue Jan 29, 2013 7:31 pm
Has thanked: 33 times
Been thanked: 111 times

Re: Sphinx error

Post by tuffadmin » Tue Aug 28, 2018 12:09 pm

Your site was under maintenance mode. So didn't able to check it. PM osclass credentials so we can check what is the issue.
No support for unnecessary PM, use forum for support queries.
Please give us good review if you bought our theme from Osclass Market

Post Reply