Component Create error on Xampp 1.7.4 / Win7

[sbinnie]

I've run it a few times, and get the following:

500 - An error has occurred.

JDatabaseMySQL::query: 0 - SQL=

Return to Control Panel
Call stack

Function Location

1 JAdministrator->dispatch() C:\xampp\htdocs\j17\administrator\index.php:47
2 JComponentHelper::renderComponent() C:\xampp\htdocs\j17\administrator\includes\application.php:153
3 require_once() C:\xampp\htdocs\j17\libraries\joomla\application\component\helper.php:156
4 InstallerModelCreate->create() C:\xampp\htdocs\j17\administrator\components\com_jfoobar\jfoobar.php:36
5 InstallerModelCreate->_createComponent() C:\xampp\htdocs\j17\administrator\components\com_jfoobar\media\create.php:85
6 InstallerModelCreate->_installExtension() C:\xampp\htdocs\j17\administrator\components\com_jfoobar\media\create.php:141
7 JDatabase->loadResult() C:\xampp\htdocs\j17\administrator\components\com_jfoobar\media\create.php:208
8 JDatabaseMySQLi->query() C:\xampp\htdocs\j17\libraries\joomla\database\database.php:1008
9 JError::raiseError() C:\xampp\htdocs\j17\libraries\joomla\database\database\mysqli.php:535
10 JError::raise() C:\xampp\htdocs\j17\libraries\joomla\error\error.php:215

Environment:
Windows 7 Home Premium
Xampp 1.7.4

• Apache/2.2.17
• PHP Version 5.3.5
• MySQL/MySQLi - mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $.

I seem to get the component working in spite of the error... but haven't fully tested yet.

THought you should know,

[c2mw4]

JFoobar Team,

This is a great concept and just what I need to get started writing my first Component! Thanks!!!!

As a novice, I might have made a dumb mistake, yet with Joomla 2.5, I get a very similar result to sbinnie. The "mostly" working component is created despite the error, yet the component fails while reviewing "Out of Box" function of the created component as follows.
works on http://192.168.17.125/index.php/catitem (item shown)
fails on http://192.168.17.125/index.php/catlist (no list shown)

fails on http://192.168.17.125/index.php/catformcreatearticle (errors as below)

#403 You are not authorised to view this resource.

Call stack

Function Location

1 JSite->dispatch() C:\webdev\public_html\joomlazz\index.php:42
2 JComponentHelper::renderComponent() C:\webdev\public_html\joomlazz\includes\application.php:187
3 JComponentHelper::executeComponent() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\helper.php:357
4 require_once() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\helper.php:388
5 JController->execute() C:\webdev\public_html\joomlazz\components\com_cats\cats.php:15
6 CatsController->display() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\controller.php:754
7 JController->display() C:\webdev\public_html\joomlazz\components\com_cats\controller.php:61
8 CatsViewForm->display() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\controller.php:715
9 JError::raiseError() C:\webdev\public_html\joomlazz\components\com_cats\views\form\view.html.php:47

10 JError::raise() C:\webdev\public_html\joomlazz\libraries\joomla\error\error.php:251

During component creation, the errors are:

500 - An error has occurred.

JDatabaseMySQL::query: 1065 - Query was empty SQL=

Return to Control Panel

Call stack

Function Location

1 JAdministrator->dispatch() C:\webdev\public_html\joomlazz\administrator\index.php:46
2 JComponentHelper::renderComponent() C:\webdev\public_html\joomlazz\administrator\includes\application.php:152
3 JComponentHelper::executeComponent() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\helper.php:357
4 require_once() C:\webdev\public_html\joomlazz\libraries\joomla\application\component\helper.php:388
5 InstallerModelCreate->create() C:\webdev\public_html\joomlazz\administrator\components\com_jfoobar\jfoobar.php:36
6 InstallerModelCreate->_createComponent() C:\webdev\public_html\joomlazz\administrator\components\com_jfoobar\media\create.php:85
7 InstallerModelCreate->_installExtension() C:\webdev\public_html\joomlazz\administrator\components\com_jfoobar\media\create.php:141
8 JDatabase->loadResult() C:\webdev\public_html\joomlazz\administrator\components\com_jfoobar\media\create.php:245
9 JDatabaseMySQL->query() C:\webdev\public_html\joomlazz\libraries\joomla\database\database.php:1109
10 JError::raiseError() C:\webdev\public_html\joomlazz\libraries\joomla\database\database\mysql.php:542

11 JError::raise() C:\webdev\public_html\joomlazz\libraries\joomla\error\error.php:251

System info:

PHP Built On Windows NT CHAMONIX 5.1 build 2600
Database Version 5.0.51b-community-nt
Database Collation utf8_general_ci
PHP Version 5.2.6
Web Server Apache/2.2.8 (Win32) PHP/5.2.6
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.2 Stable [ Ember ] 5-March-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1

Hope my varied system environment compared with the previous post may give some hints about what it's not!

Thanks,
/george

[c2mw4]

I've since re-installed Joomla on a fesh XAMPP Win7 development platform, with no other Joomla extensions, and JFoobar SEEMS TO WORK PERFECTLY Thanks for creating this :)