Log in | Register
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Clicking on [Page Tab/Canvas] results in 500 error

Topic-icon Clicking on [Page Tab/Canvas] results in 500 error

Active Subscriptions:

None
12 years 5 months ago #15533 by jparker3119
Apparently the program is calling for a table in the DB called _templates_menu which does not exist. This table does not exist in any of the other sites in which JFB is installed either.
Why is it being called here?
Thanks,
Jim


=====================================
All Required Extensions Installed with Status Green
All Social Extensions Installed with Status Green
Profile Integration Installed Available Status
JomSocial 4.0.0 4.0.0 This extension is installed and published.
Kunena 4.0.0 4.0.0 This extension is installed and published.
JomSocial - FB Wall 4.0.0 4.0.0 This extension is installed and published.

JDatabaseMySQL::query: 1146 - Table 'snsChaplin.rqpd_templates_menu' doesn't exist SQL=SELECT template FROM rqpd_templates_menu WHERE client_id = 0
====================================
PHP Built On FreeBSD dfiamerica.dfi-japan.com 6.4-RELEASE-p8 FreeBSD 6.4-RELEASE-p8 #1 r101746: Mon Aug 30 10:34:40 MDT 2010 root@fc:/usr/src/sys/i386/compile/VKERN i386
Database Version 5.1.52
Database Collation utf8_general_ci
PHP Version 5.3.6
Web Server Apache/2.2.20 (Unix)
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 1.7.3 Stable [ Ember ] 14-Nov-2011 14:00 GMT
Joomla! Platform Version Joomla Platform 11.2.0 Stable+Modified [ Omar ] 27-Jul-2011 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
The topic has been locked.
Support Specialist
12 years 5 months ago #15540 by alzander
Yup, you found a bug we weren't aware of. That table is from Joomla 1.5 and is different in Joomla 1.7. That query is simply trying to determine what the default template for your site is, so that it's filled in automatically the first time you visit the Page Tab / Canvas configuration section.

We'll be fixing this in the next release, but if you'd like to make the following code change below, it should fix it for you right now.
/administrator/components/com_jfbconnect/views/canvas/view.html.php, a few lines from the very bottom, you'll see:
$query = "SELECT template FROM #__templates_menu WHERE client_id = 0";
Change that to:
$query = "SELECT template FROM #__templates_styles WHERE client_id = 0 AND home = 1";

We'll be testing that change soon for our 4.1 release, but it's a pretty simple change that shouldn't cause any problems. Sorry for the trouble.

Alex
The topic has been locked.
Active Subscriptions:

None
12 years 5 months ago #15578 by jparker3119
Thanks Alzander!!!
Appreciate the quick response. Will implement the patch now.
Cheers!
Jim
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17844 by micrid
Alzander,

I tried this fix on our site however it did not work. here is the complete error message.

500 - An error has occurred.

JDatabaseMySQL::query: 1146 - Table 'mike_jo111.mike_templates_styles' doesn't exist SQL=SELECT template FROM mike_templates_styles WHERE client_id = 0 AND home = 1

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /home/mike/public_html/joomlatest/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/mike/public_html/joomlatest/administrator/includes/application.php:154
3 require_once() /home/mike/public_html/joomlatest/libraries/joomla/application/component/helper.php:152
4 JController->execute() /home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/admin.jfbconnect.php:32
5 JFBConnectControllerCanvas->display() /home/mike/public_html/joomlatest/libraries/joomla/application/component/controller.php:649
6 JFBConnectController->display() /home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/controllers/canvas.php:24
7 JFBConnectViewCanvas->display() /home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/controller.php:34
8 JFBConnectViewCanvas->getDefaultTemplate() /home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/views/canvas/view.html.php:51
9 JDatabaseMySQLi->loadResult() /home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/views/canvas/view.html.php:70
10 JDatabaseMySQLi->query() /home/mike/public_html/joomlatest/libraries/joomla/database/database/mysqli.php:355
11 JError::raiseError() /home/mike/public_html/joomlatest/libraries/joomla/database/database/mysqli.php:230
12 JError::raise() /home/mike/public_html/joomlatest/libraries/joomla/error/error.php:179
The topic has been locked.
Support Specialist
12 years 3 months ago #17847 by alzander
Michael,
What version of JFBConnect are you using? v4.1 definitely shouldn't have this issue. We'd recommend upgrading, if you haven't already.

Additionally, in the v4.1.1 release (due out later this week), we'll be adding the ability to select a specific template style, not just a template (with the default styles). It will be a big improvement to allow more flexibility for your look and feel on Facebook.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17852 by micrid
Alzander,

Can you provide with me a link to update the software. I cannot find the link on the website to update JFBConnect
The topic has been locked.
Support Specialist
12 years 3 months ago #17855 by alzander
To get the newest version, just go to the My Subscriptions area and download the right file for your version of Joomla. Unzip, and install the component. That's about all their is too it.

Hope that helps, but if you run into issues, just let us know.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17857 by micrid
I ran into an issue but my engineer is looking into it.
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17858 by micrid
Alzander,

New issue, probably a broad joomla issue, see below
500 - An error has occurred.

JDatabaseMySQL::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 '' at line 1 SQL=SELECT template FROM #templates_styles WHERE client_id = 0 AND home = 1

Return to Control Panel

Call stack
# 	Function 	Location
1 	JAdministrator->dispatch() 	/home/mike/public_html/joomlatest/administrator/index.php:47
2 	JComponentHelper::renderComponent() 	/home/mike/public_html/joomlatest/administrator/includes/application.php:154
3 	require_once() 	/home/mike/public_html/joomlatest/libraries/joomla/application/component/helper.php:152
4 	JController->execute() 	/home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/admin.jfbconnect.php:32
5 	JFBConnectControllerCanvas->display() 	/home/mike/public_html/joomlatest/libraries/joomla/application/component/controller.php:649
6 	JFBConnectController->display() 	/home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/controllers/canvas.php:24
7 	JFBConnectViewCanvas->display() 	/home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/controller.php:39
8 	JFBConnectViewCanvas->getDefaultTemplate() 	/home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/views/canvas/view.html.php:50
9 	JDatabaseMySQLi->loadResult() 	/home/mike/public_html/joomlatest/administrator/components/com_jfbconnect/views/canvas/view.html.php:73
10 	JDatabaseMySQLi->query() 	/home/mike/public_html/joomlatest/libraries/joomla/database/database/mysqli.php:355
11 	JError::raiseError() 	/home/mike/public_html/joomlatest/libraries/joomla/database/database/mysqli.php:230
12 	JError::raise() 	/home/mike/public_html/joomlatest/libraries/joomla/error/error.php:179

the code line in question:
$query = "SELECT template FROM #templates_styles WHERE client_id = 0 AND home = 1";

Also we are using Joomla 1.6 and installed the 1.7 update, could this be the issue?
The topic has been locked.
Support Specialist
12 years 3 months ago #17862 by alzander
No, that's a stupid issue on our part that looks like is causing you an issue. It's definitely been fixed in the 4.1.1 release (due out Wed). If you want to fix before then, you'll simply need to update that line and change the # to a #__. When done, the line should look like:
$query = "SELECT template FROM #__templates_styles WHERE client_id = 0 AND home = 1";
Again, dumb issue that will be fixed with the next release.

Thanks,
Alex
The topic has been locked.
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Clicking on [Page Tab/Canvas] results in 500 error
From the Blog
Facebook | Twitter | LinkedIn | Blog RSS