Error 1064 and 1146

Hello,
After updating my site www.pmapiscinas.com me the following errors appear:

1. Changing the Catalan language from the home page 1064 error appears.
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,15' at line 21 SQL=SELECT content.id AS iid FROM smp_content AS content WHERE content.state = 1 AND content.access IN (1,1,5) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-09-16 13:57:28' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-09-16 13:57:28' ) AND ( content.catid = 21 ) AND content.language in ('ca-ES','*') ORDER BY content. DESC LIMIT 0,15;
It appears the page you were looking for doesn't exist. Sorry about that.

2. Paragraph "News" links to read more than the first two items do not work

3. When I try to create a new module News Show Pro GK5 1146 error appears.

Please help!

1046:
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

1146:
https://www.gavick.com/documentation/jo ... quickstart

Thank you,

After step 2 does not like following. This screen appears (attached image)

Can you explain please?

I followed the steps to resolve error 1064 but works. Language (CA) is still not working.
What else can I do?

Install missing language via VM configuration panel.

I have never installed Virtuemart on this site

Perhaps there is some strange issue with any other module... 1146 usually means that there is something wrong with database (missing tables).

Hello,
I was able to restore a backup and fix several bugs that appeared.

I still have to settle a pending error.

As you can see here: http://www.pmapiscinas.com/es/mantenimi ... elona.html have created a new blog news section configured type. Three articles on each page displayed and only the first displayed correctly.

The button Read more the second article is not displayed with the correct style.

The third article is overwhelmed from left to right and the Read more button is not displayed with the correct style.

Please can you help me with this, thanks.

It looks like somewhere in your articles you might have unclosed or additionally closed html tag causing this issue.

In "Descubre c&oacute;mo prevenir las infecciones por hongos en piscinas" article you are closing div that was not opened before.

Hello,
I still do not understand why this error occurs.
No </ div> does not appear in my article.
What I can do to fix this?
Regards,

Please send me a PM with:
1. URL to your website
2. login and password of user with admin/super-admin privileges (please create one for me)
3. link to this thread

Hello,
I sent you the access data a few days ago. Some news?

Thank you!

I didn't receive it, could you please send it again?

Sent again

Could you also please send me ftp data (so I can access the template files itself)?

I've sent

I got the message, I have asked our devteam to take a look into the issue. I'll let you know when I'll get an answer.

Thanks

Ok, the problem is not only for me... like I decribed in my topic...
There is no solution!
Please fix this bug

Hi there,
I think they have all the information about the problem and access.
No solution for this?
Regards,

hello anyone?

Hi

ERROR 1146 - Missing table in database.
In 90% cases happens when using quickstart with virtuemart. Our demo is prepared for English (United Kingdom) only, so if during installation a different language will be selected this error will be displayed. To fix it easiest is to reinstall while selecting English (United Kingdom) or use solution to add this tables after installation: https://www.gavick.com/documentation/jo ... quickstart

Error 1064 - Wrong database query (in short).
Please edit each News Show Pro GK5 module and simply save it again. There were a change in order options in joomla and most likely Your site is still using old names in order.
If above will not help than You need to change source settings in NSP because there can be an ID of a none existing category or article called.

Ok thanks for your help. These problems and have solved.
It only remains to fix one:

In the last paragraph news item is always displayed wrong, it does not have the same margins as the other items and is aligned to the width of the screen.

Can you help me solve this and all items are displayed with the same margin please.
http://www.pmapiscinas.com/es/mantenimi ... elona.html
Thank you.

Hi

I think this issue is a validation one: https://validator.w3.org/nu/?doc=http%3 ... elona.html

Please check if intortext of those articles has all HTML tags closed correctly.

Check also if renaming /html/com_content to /html/_com_content shows it correctly.