Joomla Templates Club 406,261 posts

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1048392

Hi,

I have a problem with the JA Nuevo template on Joomla 3.7 with a postgresql database. Clicking some menu items gives this error message:

ERROR: invalid input syntax for integer: "" LINE 3: WHERE id = '' ^

does anyone know how this can be fixed?

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#1049128

Hi,

In which page I can see the issue?

You can make a test by switching default template to a standard template of Joomla like Beez / Protostar and see how it goes. It will narrow down where the problem comes from.

Regards

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049449

Yes, I did do this. I set up a Joomla 3.7 clean installation with default templates it works fine. When you add nuevo some of the menu options throw back an error similar to the one above. This doesn’t happen with the default joomla templates.

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049456

I made a demo site: https://demo.lsltd.org

You can check here. Click the sample sites menu, error appears. Click the site-map menu, error appears. Some menu works some don’t.

If I then change back to the previous default protostar template, then it’s fine. I’m contemplating migrating my site to postgres, but only if I can get the templates working.

It should work fine, but it’s not.

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049458

And the error from apache logs, if it helps:

[Tue Jul 18 10:50:48.151036 2017] [proxy_fcgi:error] [pid 19030:tid 140355747956480] [client 91.224.118.77:19498] AH01071: Got error 'PHP message: PHP Notice:  Undefined variable: item in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 47\nPHP message: PHP Notice:  Trying to get property of non-object in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 47\nPHP message: PHP Notice:  Undefined variable: item in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 47\nPHP message: PHP Notice:  Trying to get property of non-object in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 47\nPHP message: PHP Notice:  Undefined variable: item in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 48\nPHP message: PHP Notice:  Trying to get property of non-object in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 48\nPHP message: PHP Notice:  Undefined variable: item in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 48\nPHP message: PHP Notice:  Trying to get property of non-object in /var/www/lsltd-demo/templates/ja_nuevo/html/com_content/article/default.php on line 48\n', referer: https://demo.lsltd.org/

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#1049470

You can share the credentials of your site: Admin + FTP account and tell me the pages which are not working.

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049495

OK, but where can I share that information without it being public?

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049498

Practically all pages don’t work. But here is a collection of the ones I’ve found so far, otherwise I’ll be there all day working through the rest. The only others under "Using Joomla!" relating to components, etc, etc, I’ve not gone through yet, but some of them also don’t work, but some links work.

https://demo.lsltd.org/site-map
https://demo.lsltd.org/sample-sites
https://demo.lsltd.org/parks-home
https://demo.lsltd.org/welcome
https://demo.lsltd.org/using-joomla
https://demo.lsltd.org/getting-started
https://demo.lsltd.org/the-joomla-community
https://demo.lsltd.org/the-joomla-project
https://demo.lsltd.org/using-joomla/parameters
https://demo.lsltd.org/using-joomla/getting-help

I expect fixing the errors generated via PHP in relation to the template would fix pretty much most of them.

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049499

This reply has been marked as private.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#1049696

Could you share the FTP account also?

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1049698

I dont have ftp. I dont use it and dont have a requirement for it. I use only the joomla interface.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#1050075

I need to check the code and debug.

Could you create a FTP account and send me the info?

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1050136

This reply has been marked as private.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#1050375

I use FileZilla ftp client with several settings for connection but can’t access. Could you check again?

[ianw1974 Friend ianw1974Join date: January 2016Posts: 15Downloads:18Uploads:0]

#1050376

I use filezilla also, and checked and tested. You need to go to transfer settings tab, and change from default to active, like i said in previous post.

• This reply was modified 7 years, 4 months ago by  ianw1974.

[Author]

Posts