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

Active Subscriptions:

None
12 years 3 months ago #17873 by micrid
Alex,

I have implemented that code fix, here is a new issue, it might be the one from much earlier in this thread before I updated
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: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:74
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 #17877 by alzander
Ughh.. None of this is your fault, or a Joomla issue.. it's a stupid fault with JFBConnect. To fix, the statement should use #__template_styles instead of #__templates_styles (the template is singular, not plural).

In v4.1.1, this will all be fixed, as we've changed how we set the Canvas and Page Tab templates completely. Again, with v4.1.1, we'll be adding the ability to select a specific template style, not just a template (with the default styles). It'll be a much improved system, and will be available tomorrow (current plan at least). Feel free to fix the issue as above, but with v4.1.1 it will be fixed, and better, anyways.

Sorry again for all the back and forth and trouble with this one command.

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

None
12 years 3 months ago #17880 by micrid
That definitely fixed it, thank you. I can set up a canvas app now.

But the whole website is now broken. J500 errors on every page, could jfbconnect be a cause of it. This is what i did prior to the errors:

(1) I went to the JFBConnect configuration tab "tickerpickerpro.com/joomlatest/administr...bconnect&view=config"
(2) I clicked on the login/logout tab
(3)clicked yes to "autologin facebook users"
(4) site bricked
(5) disabled it (hours later)
(6) site worsk
(7) hit yes again to confirm the bug
(8) did not re-occur

so I am at a loss to explain it and pinpoint if it was a joomla bug or a jfbconnect bug.
oh well so that odd issue just solved itself
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17881 by micrid
Oh no other issue. I just tried to create an account with the login module, here is the error.
Warning: require_once(/home/mike/public_html/joomlatest/administrator/components/com_comprofiler/plugin.foundation.php) [function.require-once]: failed to open stream: No such file or directory in /home/mike/public_html/joomlatest/plugins/jfbcprofiles/communitybuilder/communitybuilder.php on line 158

Fatal error: require_once() [function.require]: Failed opening required '/home/mike/public_html/joomlatest/administrator/components/com_comprofiler/plugin.foundation.php' (include_path='.:/home/mike/public_html/joomlatest/plugins/system/zend:.:/usr/lib/php:/usr/local/lib/php') in /home/mike/public_html/joomlatest/plugins/jfbcprofiles/communitybuilder/communitybuilder.php on line 158
The topic has been locked.
Support Specialist
12 years 3 months ago #17882 by alzander
It sounds like you have the Community Builder profile plugin enabled, but Community Builder is not installed (or not installed properly). Can you check your Plugins area, and disable any JFBCProfile plugins that are enabled that the corresponding extension isn't installed for?

Hopefully, that will fix your right up.

Not sure otherwise why you'd get 500 errors. We'll never say "it isn't us" without some investigation or a good reason. While I don't think it was, if it comes up again, definitely let us know, and we'll see what we can do. If you know where your PHP error log is, it may also shed some light on the actual cause.

Good luck,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 3 months ago #17883 by micrid
that worked, thank you!
The topic has been locked.
Support Specialist
12 years 3 months ago #17887 by alzander
Thank goodness :)

Hopefully, that's the end of your issues for now. We really hope you don't have any others, but if you do run into problems, or have any questions, just let us know (start a new thread if it's not related to the above though).

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

None
12 years 3 months ago #17894 by micrid
Alex,
I hate to tell you this but see my other thread right above this
The topic has been locked.