I seem to get the following error on the staff page:

0 Table 'northp2_wectypo3.C' doesn't exist

1 SELECT *, A.uid as staff_uid FROM tx_wecstaffdirectory_info AS A, (tx_wecstaffdirectory_department AS C LEFT JOIN tx_wecstaffdirectory_department_mm AS D ON C.uid = D.uid_foreign) WHERE A.pid in (31) AND D.uid_local = A.uid AND A.deleted=0 AND A.t3ver_state<=0 AND A.hidden=0 AND (C.department_name LIKE 'Pastoral Staff' OR C.department_name LIKE 'Worship & Music' OR C.department_name LIKE 'Administration') AND A.sys_language_uid IN (0,-1) GROUP by A.uid ORDER BY A.display_order ASC

Thanks,
Dudley

Hi Dudley,

It appears the wec_staffdirectory_department table does not exist in the mySQL database. What likely happened is after you installed the wec_staffdirectory extension, it said it needed to create a database table. If you did not click on Update button, it does not create it.

So what you can do is go back to Admin Tools->Ext Manager. Select Loaded Extensions. Then choose the WEC Staff Directory. Then click on the Update button. That should do it.

-Dave

Thank you!

Dudley

I am once again getting the following message in the staff directory:

0 Table 'northp2_wectypo3.B' doesn't exist
1 SELECT *, A.uid as staff_uid FROM tx_wecstaffdirectory_info AS A, fe_users AS B, tx_wecstaffdirectory_department AS C, tx_wecstaffdirectory_department_mm AS D WHERE A.feuser_id = B.uid AND A.pid in (31) AND C.uid = D.uid_foreign AND D.uid_local = A.uid AND A.deleted=0 AND A.t3ver_state<=0 AND A.hidden=0 AND (C.department_name LIKE 'Pastoral Staff' OR C.department_name LIKE 'Worship & Music' OR C.department_name LIKE 'Administration') AND A.sys_language_uid IN (0,-1) ORDER BY A.display_order ASC

I've uninstalled, reinstalled, updated the database, etc, but can't seem to get around the problem.

Dudley

Never mind. this seems somehow related to Firefox. It doesn't happen in IE.

Dudley

Hi Dudley,

Please see this thread and the last entry. It details your problem. The issue is not the browser, but the admPanel section at the bottom.

http://webempoweredchurch.com/index.php?id=333&no_cache=1&view=single_thread&thread_uid=3587&flag=last

-Dave

Hi Dave,

Thanks for help. Here is the relevant info from the referenced post:
It is a TYPO3 bug with the admin Panel. When the admin Panel is open, AND the TypoScript section is open AND the Explain Select Queries is checked, then it causes problems with mySQL alias calls (tx_wecstaffdirectory_info AS A). I will be reporting this bug to them.
I'm not exactly sure what these instructions mean. When I logon to the backend, is that the Admin panel? I don't know where to find the Explain Select Queries box, either. Sorry to be so dense.

thanks,
Dudley

Hi Dudley,

The Admin Panel is the box at the very bottom of the screen in the Frontend when you view a page. It is shown when you are in the Backend and view a page in the frontend.

If you uncheck the Explain Select Queries...and it should then fix this. Or if you close the admin panel. Why you see it on Firefox but not IE is that you are most likely logged into the Backend on Firefox and just using IE as a testing browser.

-Dave