Support Forums

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

SP Simple Portfolip 1064 SQL error

Featured Lock Resolved
Hi,

I installed the Tixon template and also a Slovenian language. The language was installed from the Joomla administrator...in the Extensions -> Install Languages

Joomla 3.5.1

After I enabled "System - Language Filter" plugin the error in the attachment occured. I suspect the problem is with Joomla 3.5, since some other components had similar errors and have new updates.

Now, I also tested a fresh installation on localhost. I didn't install any languages and enabled only the "System - Language Filter" plugin. The same Error occurs. (Portfolio main menu in Tixon template)

Could you please provide a solution? Thanks

Regards

Attachments (1)

  • error.jpg
    error.jpg 41.3 KB

5 Answers

Altius

More than a month ago #Permalink
The changed file is components\com_spsimpleportfolio\models\items.php

Chages
			//Enabled
$query->where($db->qn('enabled')." = ".$db->quote('1'));


+$query->where($db->quoteName('language')." IN (" . $db->quote(JFactory::getLanguage()->getTag()) . ',' . $db->quote('*') . ")");

//Access
$query->where($db->quoteName('access')." IN (" . implode( ',', JFactory::getUser()->getAuthorisedViewLevels() ) . ")");




+if(!FOFPlatform::getInstance()->isFrontend()) {
// Call the behaviors
$this->modelDispatcher->trigger('onAfterBuildQuery', array(&$this, &$query));
+}



Thanks for the fix

Rifat Wahid Alif - Staff

More than a month ago #Permalink
HI,
Could you please pm me your FTP access i will fix it.

- Thanks

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Fixed, I just change some codes in components/com_spsimpleportfolio/views/items/tmpl/default.php.

- Thanks

WAD

More than a month ago #Permalink
Hi there how did you fix this as I have the same issue :(

Altius

More than a month ago #Permalink
Debi wrote:

Hi there how did you fix this as I have the same issue :(


Change the file components\com_spsimpleportfolio\models\items.php as stated above


There are no replies made for this post yet.
Be one of the first to reply to this post!
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.

Leaderboard (30 days)

Sifat

Sifat

Total Accepted Answers: 119
Paul Frankowski

Paul Frankowski

Total Accepted Answers: 110
Toufiq

Toufiq

Total Accepted Answers: 89
Kamruzzaman Alam

Kamruzzaman Alam

Total Accepted Answers: 4
FUTURECLIENT

FUTURECLIENT

Total Accepted Answers: 2

115

Templates

296161

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us