Problem With Template and ADS Google

Hi, i have a problem with my website i have installed the plugin JomSocial Adsense Author Revenue Sharing PLUGIN For Content and Advanced JomSocial Adsense Profile Plugin. Every time I enable JomSocial Author Adsense Revenue Sharing Content PLUGIN For me the template returns this error:

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 'AND `apps` =' GoogleAds 'LIMIT 1' at line 1 SQL = SELECT `params` FROM `_community_apps `WHERE` userid `= AND` apps `= 'GoogleAds' LIMIT 1

testing with the default template of joomla site works correctly as I could solve?

Thank You and sorry my english

Hi,

Can you please let me check the issue for you? I would need backend and FTP access to debug the site so please send them via a PM.

Thanks,

Hi,

Can you please let me check the issue for you? I would need backend and FTP access to debug the site so please send them via a PM.

Thanks,

ok Thank you sended you PM

Thanks, can you let me know where I can see the error message, I have just enabled the plugin and don't see any such error.

Cheers,

Thanks, can you let me know where I can see the error message, I have just enabled the plugin and don't see any such error.

Cheers,

Click on article and follow link

Thanks, can you let me know where I can see the error message, I have just enabled the plugin and don't see any such error.

Cheers,

Click on article and follow link

link to see http://www.imperoweb.it/BIM/index.php/m ... ebook.html

When debugging I tried to edit file /plugins/content/JomSocialAdsense4Content/JomSocialAdsense4Content.php but I couldn't save it, can you please grant permission then I can do that?

Thanks,

When debugging I tried to edit file /plugins/content/JomSocialAdsense4Content/JomSocialAdsense4Content.php but I couldn't save it, can you please grant permission then I can do that?

Thanks,

Don Lee Thanks for the great support, it is very strange because we have all the permits you may download the file to edit it and reload it via FTP would be the easiest solution please

Hi,

I fixed for you.

Change log::

File: /plugins/content/JomSocialAdsense4Content/JomSocialAdsense4Content.php

Changed:

Code: Select all

$sql = "SELECT " . $this->db->nameQuote("params") . " "
          . "FROM " . $this->db->nameQuote("#__community_apps") . " "
          . "WHERE " . $this->db->nameQuote("userid") . " = " . $article->created_by . " AND " . $this->db->nameQuote("apps") . " = " . $this->db->quote("googleads") . " "
          . "LIMIT 1 ";


To:

Code: Select all

$sql = "SELECT " . $this->db->nameQuote("params") . " "
          . "FROM " . $this->db->nameQuote("#__community_apps") . " "
          . "WHERE " . $this->db->nameQuote("userid") . " = " . $this->db->quote($article->created_by) . " AND " . $this->db->nameQuote("apps") . " = " . $this->db->quote("googleads") . " "
          . "LIMIT 1 ";


As you can see, I fixed it in the plugin's file, however the issue didn't happen with other templates so I really don't know which party caused the problem, template nor plugin. Anyways, we fixed it.

Cheers,

When debugging I tried to edit file /plugins/content/JomSocialAdsense4Content/JomSocialAdsense4Content.php but I couldn't save it, can you please grant permission then I can do that?

Thanks,

Don Lee Thanks for the great support, it is very strange because we have all the permits you may download the file to edit it and reload it via FTP would be the easiest solution please

Wonderfull support Thank you very Mutch Don Lee

No problem at all buddy, you are most welcome, just feel free to let me know if you need any other helps.

Have a nice day,

No problem at all buddy, you are most welcome, just feel free to let me know if you need any other helps.

Have a nice day,

Sorry DonLee but am having many problems still associated with Jomsocial by now if I view the home page as superadmin invalid token but if I go into the menu item, and community feedback I login problems, but if I make login as a normal user instead of 403 error response I leave all visible errors activated, by testing with the default template I have no problem

Hi,

I don't think the problem is related to template but your login module setting, I have just changed "Login Redirection Page" from "Profile" to "Home" and the issue is gone now, please check and confirm the same.

http://easycaptures.com/fs/uploaded/532/0122231666.png

Cheers,

Hi,

I don't think the problem is related to template but your login module setting, I have just changed "Login Redirection Page" from "Profile" to "Home" and the issue is gone now, please check and confirm the same.

http://easycaptures.com/fs/uploaded/532/0122231666.png

Cheers,

Thank You Don for your support i sended you PM, but the problem with simple user registration persist i have this error:
500
JDatabaseMySQLi::query: 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 ') ORDER BY a.`created` DESC LIMIT 3' at line 2 SQL=SELECT a.*, b.`name` AS groupname, b.`thumb` AS thumbnail FROM `g9c8g_community_activities` AS a INNER JOIN `g9c8g_community_groups` AS b ON b.`id`=a.`groupid` WHERE a.`app`='groups.wall' AND a.`groupid` IN () ORDER BY a.`created` DESC LIMIT 3

Debug Error:

JDatabaseMySQLi::query: 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 ') ORDER BY a.`created` DESC LIMIT 3' at line 2 SQL=SELECT a.*, b.`name` AS groupname, b.`thumb` AS thumbnail FROM `g9c8g_community_activities` AS a INNER JOIN `g9c8g_community_groups` AS b ON b.`id`=a.`groupid` WHERE a.`app`='groups.wall' AND a.`groupid` IN () ORDER BY a.`created` DESC LIMIT 3
Call stack
# Function Location
1 JSite->render() JROOT/index.php:48
2 JDocumentHTML->render() JROOT/includes/application.php:272
3 JDocumentHTML->_renderTemplate() JROOT/libraries/joomla/document/html/html.php:433
4 JDocumentHTML->getBuffer() JROOT/libraries/joomla/document/html/html.php:655
5 JDocumentRendererModules->render() JROOT/libraries/joomla/document/html/html.php:371
6 JDocumentRendererModule->render() JROOT/libraries/joomla/document/html/renderer/modules.php:39
7 JModuleHelper::renderModule() JROOT/libraries/joomla/document/html/renderer/module.php:106
8 include() JROOT/libraries/joomla/application/module/helper.php:175
9 modGroupPosthelper::getStream() JROOT/modules/mod_latestgrouppost/mod_latestgrouppost.php:17
10 JDatabase->loadObjectList() JROOT/modules/mod_latestgrouppost/helper.php:49
11 JDatabaseMySQLi->query() JROOT/libraries/joomla/database/database.php:1071
12 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
13 JError::raise() JROOT/libraries/joomla/error/error.php:251

I have tested with template default and i dont have problem

Sorry me

Hi,

By looking at the Call Stack I can be very sure that that problem is not related to any GK products because there was no GK file called:

Code: Select all

1 JSite->render() JROOT/index.php:48
2 JDocumentHTML->render() JROOT/includes/application.php:272
3 JDocumentHTML->_renderTemplate() JROOT/libraries/joomla/document/html/html.php:433
4 JDocumentHTML->getBuffer() JROOT/libraries/joomla/document/html/html.php:655
5 JDocumentRendererModules->render() JROOT/libraries/joomla/document/html/html.php:371
6 JDocumentRendererModule->render() JROOT/libraries/joomla/document/html/renderer/modules.php:39
7 JModuleHelper::renderModule() JROOT/libraries/joomla/document/html/renderer/module.php:106
8 include() JROOT/libraries/joomla/application/module/helper.php:175
9 modGroupPosthelper::getStream() JROOT/modules/mod_latestgrouppost/mod_latestgrouppost.php:17
10 JDatabase->loadObjectList() JROOT/modules/mod_latestgrouppost/helper.php:49
11 JDatabaseMySQLi->query() JROOT/libraries/joomla/database/database.php:1071
12 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
13 JError::raise() JROOT/libraries/joomla/error/error.php:251


You didn't see the problem occurring with other template because maybe some extensions are not used with that layout. Anyways, I can't see the problem myself, I have created an account "Don Lee" and tried to login with success.

Hello Don Lee, I have solved all previous problems was related to adsense plugins but now happens to me a similar problem, if I go to my site as superadmin, and I go to my profile by clicking the toolbar JomSocial profile I can see clearly the profile , but if I run the same procedure as a normal user gives me error:
500
JDatabaseMySQLi :: query: 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 ') ORDER BY a. `Created` DESC LIMIT 3' at line 2 SQL = SELECT a. *, b. `name` AS groupname, b. thumbnail `thumb` AS `FROM` g9c8g_community_activities AS a INNER JOIN `g9c8g_community_groups` AS b ON b. `id` = a. `groupid` WHERE a. `app `= 'groups.wall' AND a.` groupid `iN () ORDER BY a.` created `DESC LIMIT 3

I checked with other templates including the default and the default template I access regularly and visualize it correctly reflected above all a problem with the plugin that gavick facebook homepage does not open pop-ups on other pages instead says:

An error occurred with that fire. Please try again later.

Please Help

It's some problem from module "Ultime Discussioni Gruppi", I've disabled it and the site works properly now.

It's some problem from module "Ultime Discussioni Gruppi", I've disabled it and the site works properly now.

Thank you don lee for your great support, but the ploblem with facebook connect has remained not open and in other page error An error occurred with GKF. Please try again later.

I have been restricted accessing to FB in our country so I can't check that problem for you, I'm sorry about that. I've seen that problem before, I asked those users to upgrade template and GK FB Auth plugin to latest version and it helped, please try the same.

Thanks,

I have been restricted accessing to FB in our country so I can't check that problem for you, I'm sorry about that. I've seen that problem before, I asked those users to upgrade template and GK FB Auth plugin to latest version and it helped, please try the same.

Thanks,

Ok Thank you DonLee, you are the best support

No problem at all, don't hesitate to ask me if you need any other helps.

Have a nice day,