big problem on events list

**GK User** Wed Apr 29, 2015 1:22 am

hi
if I set in "events list Portal Mode setting" amount of rows 2 (instead of 3) the site does not work anymore, and I have to restore the db to return the online site.

how do I fix?

Code: Select all: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC LIMIT 0,4' at line 21 SQL=SELECT content.id AS id FROM sbal0_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-04-29 02:15:43' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-04-29 02:15:43' ) AND ( content.catid = 27 ) ORDER BY content. DESC LIMIT 0,4;

It appears the page you were looking for doesn't exist. Sorry about that.

**GK User** Wed Apr 29, 2015 11:25 am

now I have the same problem also on news in home page if I disable the module site work

how fix it?

It appears the page you were looking for doesn't exist. Sorry about that.

**GK User** Thu Apr 30, 2015 8:45 am

nobody can help me?

**GK User** Thu Apr 30, 2015 3:22 pm

Please do not bump your questions - it makes you wait longer.

Looks like an issue with NSP.
Please follow this list:
0) Install new current version of NSP GK5 (re-install)
1) Open module in edit mode
2) Click Refresh button in your browser
3) Change data source to another from list
4) Change order of showing items
5) Save changes - check on front page
6) If okey, change data source back to option which you have at the beginning

**GK User** Thu May 07, 2015 9:20 am

perfect!

**GK User** Fri May 08, 2015 4:21 pm

Is there anything else I can help you with regarding this topic?

**GK User** Fri May 08, 2015 8:33 pm

Yes thanks,
my client is too complex management module using script.
Let me know if you can use this module as attached picture.

that is simply showing four recent articles in two columns without reference to the event (except the date in the box) ... too complicated? :-)

**GK User** Sun May 10, 2015 9:26 am

That would require NSP module rewrite and is beyond our technical support scope. But if you know php and js - you can easily do that.

**GK User** Mon May 11, 2015 8:22 am

okay, it does not matter ...
I only say that NSP is too complicated to independently manage customer ... use the code ... joomla that removes it when he goes to write the article ... and I was hoping to simplify it so that he could use it ...

**GK User** Mon May 11, 2015 7:55 pm

Sometimes eyecandy solutions require something more than Joomla allows. Sadly - this requires custom html code.