John template is showing the MySQL Error

Good day

I am experincing a problemin the Dear John template whenever I try to edit the front page gallery modules (the images link to the K2 articles in the back end).

Whenever I make even the slightest change, as in trying to display 2 rows and 3 colums instead of 3 rows and 3 colums, I recieve an error message and the website becomes unviewable from the front end. Putting the settings back the way they were does not seem to fix the solution. I am working off a localhost and will only upload the website once it is completed.

The error message is:

Code: Select all

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0,12' at line 21 SQL=SELECT content.id AS id FROM sawun_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1,2,3) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-04-30 10:35:07' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-04-30 10:35:07' ) AND ( content.catid = 31 OR content.catid = 38 OR content.catid = 40 ) ORDER BY content. DESC LIMIT 0,12;
It appears the page you were looking for doesn't exist. Sorry about that.

I do no know MySQL coding, so cannot figure out how to ammend this.

First of all:
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

Thanks very much, the new version has resolved the problem.

I did have just one other question regarding the image quality within the module.
The image I upload for an article will then display on the home page (under the Portfolio II display setting).

As I am sure you know it displays thumbnails and once the thumbnail is clicked on, it brings up a small window that shows the image in a slightly larger format, but not as big as in the article.

I am trying to maintain a constant level of image quality, but due to the image being scaled down for the thumbnails and slightly larger thumbnails, image quality is lost.

Is there a size that is recommended?

Additionally I encounted a small oddity with the pop-up section when a thumbnail is clicked. I unpublished the module that displayed the Team Members and then suddenly whenever I clicked on the thumbnail icon in the portfolio module, it took me straight through to the article, without showing the larger thumbnail and its information. Is there a way to rectify this? Can the pop-up function without the Team Member section?

You can select in module settings which size is used basing on k2 settings.