Technology Tools for Ministry

Community

Web-Empowered Church User Community
All Categories > Getting Started > Templates > Installing Default Template
Total Posts: 4 - Pages (1): [1]
Author: Scott Lacy
Posted: Jun 06 2008 - 04:10 PM
Subject: Installing Default Template
I have installed the default template on an already existing installation of TYPO3 4.1.
After installing the template, my home page displays the following error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/christ50/public_html/typo3_src/t3lib/class.t3lib_db.php on line 796

and I get the following message in my TYPO3 admin page:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/christ50/public_html/typo3_src/t3lib/class.t3lib_db.php on line 810

Any ideas on what the problem might be?
Thanks,
Scott
Author: Jeff Segars
Posted: Jun 06 2008 - 04:34 PM
Subject: re: Installing Default Template
aim msn
Scott,
I'd suggest enabling sqlDebug from the All Configuration section of the Install Tool. You can find a how-to on this at http://webempoweredchurch.com/support/howtos/single/enable_error_messages/. This will give us a more descriptive error message about what the actual problem is.

Thanks,
Jeff
Author: Scott Lacy
Posted: Jun 07 2008 - 10:57 AM
Subject: re: Installing Default Template
OK. Did that. Here is the initial message I received:
Fatal Error
This module "web_layout" is not enabled in TBE_MODULES


Now if I try to add a page, I get the following:
caller t3lib_DB::exec_SELECTquery
ERROR Table 'christ50_typ31.tx_templavoila_datastructure' doesn't exist
lastBuiltQuery SELECT tx_templavoila_datastructure.uid,tx_templavoila_datastructure.title,tx_templavoila_datastructure.t3ver_id,tx_templavoila_datastructure.t3ver_state,tx_templavoila_datastructure.t3ver_wsid,tx_templavoila_datastructure.t3ver_count,tx_templavoila_datastructure.previewicon
FROM tx_templavoila_datastructure,pages
WHERE
pages.uid=tx_templavoila_datastructure.pid
AND pages.deleted=0 AND tx_templavoila_datastructure.deleted=0 AND 1=1 AND tx_templavoila_datastructure.pid=0 AND tx_templavoila_datastructure.scope IN (1)
ORDER BY tx_templavoila_datastructure.sorting
debug_backtrace SC_alt_doc->main // SC_alt_doc->makeEditForm // t3lib_TCEforms->getMainFields // t3lib_TCEforms->getSingleField // t3lib_TCEforms->getSingleField_SW // t3lib_TCEforms->getSingleField_typeSelect // t3lib_TCEforms->addSelectOptionsToItemArray // t3lib_TCEforms->foreignTable // t3lib_BEfunc->exec_foreign_table_where_query // t3lib_DB->exec_SELECT_queryArray // t3lib_DB->exec_SELECTquery // t3lib_DB->debug

Table 'christ50_typ31.tx_templavoila_datastructure' doesn't exist This may indicate a table defined in tables.php is not existing in the database!
caller t3lib_DB::exec_SELECTquery
ERROR Table 'christ50_typ31.tx_templavoila_datastructure' doesn't exist
lastBuiltQuery SELECT tx_templavoila_datastructure.uid,tx_templavoila_datastructure.title,tx_templavoila_datastructure.t3ver_id,tx_templavoila_datastructure.t3ver_state,tx_templavoila_datastructure.t3ver_wsid,tx_templavoila_datastructure.t3ver_count,tx_templavoila_datastructure.previewicon
FROM tx_templavoila_datastructure,pages
WHERE
pages.uid=tx_templavoila_datastructure.pid
AND pages.deleted=0 AND tx_templavoila_datastructure.deleted=0 AND 1=1 AND tx_templavoila_datastructure.pid=0 AND tx_templavoila_datastructure.scope IN (1)
ORDER BY tx_templavoila_datastructure.sorting
debug_backtrace SC_alt_doc->main // SC_alt_doc->makeEditForm // t3lib_TCEforms->getMainFields // t3lib_TCEforms->getSingleField // t3lib_TCEforms->getSingleField_SW // t3lib_TCEforms->getSingleField_typeSelect // t3lib_TCEforms->addSelectOptionsToItemArray // t3lib_TCEforms->foreignTable // t3lib_BEfunc->exec_foreign_table_where_query // t3lib_DB->exec_SELECT_queryArray // t3lib_DB->exec_SELECTquery // t3lib_DB->debug

Table 'christ50_typ31.tx_templavoila_datastructure' doesn't exist This may indicate a table defined in tables.php is not existing in the database!
caller t3lib_DB::exec_SELECTquery
ERROR Unknown column 'tx_templavoila_ds' in 'field list'
lastBuiltQuery SELECT uid,tx_templavoila_ds,pid,tx_templavoila_next_ds
FROM pages
WHERE
uid=0 AND pages.deleted=0
debug_backtrace SC_alt_doc->main // SC_alt_doc->makeEditForm // t3lib_TCEforms->getMainFields // t3lib_TCEforms->getSingleField // t3lib_TCEforms->getSingleField_SW // t3lib_TCEforms->getSingleField_typeFlex // t3lib_BEfunc->getFlexFormDS // t3lib_DB->exec_SELECTquery // t3lib_DB->debug


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/christ50/public_html/typo3_src/t3lib/class.t3lib_db.php on line 796


This is after a fresh install of the _defaultsetup.t3d. TemplaVoila is showing as an installed extension.

By the way. I have the ability to scrap my TYPO3 installation and reinstall. This is not a problem because this is a new site with no existing content (yet). My hosting service installs TYPO3 using Fantastico De Luxe.

Thanks,
Scott
user picture Author: Calum MacLeod
Posted: Jun 07 2008 - 04:17 PM
Subject: re: re: Installing Default Template
yahoo msn
Scott,

Given that your Fantastico-installed version of typo3 is not the latest (i.e., not 4.2), and you do not mind starting again, I would recommend that you consider installing the WECTypo3 starter-pack rather than Fantastico.

Follow the instructions given on the same page as the download in order to have an installation that works, pretty much out of the box.

That way, you would have the latest Typo3 and also the newly upgraded WEC configurations designed to go with it. (One caveat - Typo3 4.2 requires PHP5, so you would need to check whether your host supports that.) While your site is more or less empty would be the ideal time to make the switch.

Cheers,
Calum
Total Posts: 4 - Pages (1): [1]
Click here for a complete list of threads
You must login to post a message to this conference.