Support Online : 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)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 115
Toufiq

Toufiq

Total Accepted Answers: 100
Mehtaz Afsana Borsha

Mehtaz Afsana Borsha

Total Accepted Answers: 60
Ofi Khan

Ofi Khan

Total Accepted Answers: 50
Rashida Rahman

Rashida Rahman

Total Accepted Answers: 32

121

Templates

314583

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