Technology Tools for Ministry

Community

Web-Empowered Church User Community
All Categories > Ministry Tools > Devotional Journal Extension > Version 1.5 TER-Download
Total Posts: 5 - Pages (1): [1]
Author: Andi Becker
Posted: Mar 16 2006 - 02:19 AM
Subject: Version 1.5 TER-Download
Hi Dave

The download from TER results in the following error message:
SQL engine parse ERROR: Field type unknown!: near "date NOT NULL default '0000-00-00' "

All other downloads worked fine like Connector or Discussion

Greetings Andi
Author: Jeff Segars
Posted: Mar 16 2006 - 10:47 AM
Subject: re: Version 1.5 TER-Download
Hey Dave,
Just wanted to add some more info for your debugging efforts.

When I upgraded to the the latest version of wec_devo with TYPO3 4.0RC1 I did not get any errors. I'm using MySQL 4.0.25 and I had a previous version of the wec_devo installed.

Hope that helps narrow it down a bit

Jeff
Author: Dave Slayback
Posted: Mar 16 2006 - 11:21 AM
Subject: re: Version 1.5 TER-Download
Hey Andi,

I tried installing the latest wec_devo from TER, and found it worked fine in v3.8.1 and 4.0RC1. I am suspecting that either:

a) bad download of the extension -- you could try to get it again and re-install.

b) mySQL version -- let me know what mySQL version you have and PHP on your server?

Another thing you could try, if you have know and have access to phpMyAdmin on your server, is to grab the contents of ext_tables.sql under the wec_devo folder. Just grab that and put it in a mySQL query call in phpMyAdmin.

Hope this helps. Let me know the version numbers if the re-install does not work and I can try that. Also, let me know which Typo3 version you are running.

-Dave
Author: Andi Becker
Posted: Mar 16 2006 - 11:59 AM
Subject: re: Version 1.5 TER-Download
Hi Dave

I am working with 3.81 still.
The problem occurs, when you try to update. Interesting is, that the extension will be updated afterwards but still this error appears. I checked both: Updating via TER, Updating Via download and upload from PC and Upload via TER update extension - always the same message.

I am working with:

PHP Version 4.3.11
MySQL Version 4.0.25
I had a previous version of the wec_devo installed

Backend is working but frontend is loading endlessly
http://lisandi.com/tsunami/memorial/family_demo/?devo_dt=031606&devo_sec=0

Thanks ANDI
Author: Dave Slayback
Posted: Mar 16 2006 - 01:25 PM
Subject: re: Version 1.5 TER-Download
Hi Andi,

Thanks for checking all that. If the problem is with the Devotional, I cannot tell what it is unless I could place some debug code. I can either send a special extension (may take a day to get to you), or if you allow me temporary access to your backend so I can change the code for the extension, then I could debug that way.

However, I am not convinced it is wec_devo, but I would like to find if this is the case.

I did notice though in the error in IE7 that came up (the Firefox errors were not helpful) after 4-5 minutes of waiting:

-----------------------------------------------------------------
Warning: mysql_connect(): User lisandi_typ3LA has already more than 'max_user_connections' active connections in /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php on line 43

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php on line 68

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php on line 69

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php on line 71

Warning: Cannot modify header information - headers already sent by (output started at /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php:43) in /home/lisandi/public_html/typo3_src-3.8.0/t3lib/class.t3lib_userauth.php on line 258

Warning: Cannot modify header information - headers already sent by (output started at /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php:43) in /home/lisandi/public_html/typo3conf/ext/wec_devo/pi1/class.tx_wecdevo_pi1.php on line 2611

Warning: Cannot modify header information - headers already sent by (output started at /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php:43) in /home/lisandi/public_html/typo3conf/ext/wec_devo/pi1/class.tx_wecdevo_pi1.php on line 307

Warning: Cannot modify header information - headers already sent by (output started at /home/lisandi/public_html/typo3conf/ext/de_custom_tags/pi1/class.tx_decustomtags_pi1.php:43) in /home/lisandi/public_html/typo3_src-3.8.0/typo3/sysext/cms/tslib/class.tslib_fe.php on line 2614

---------------------------------------------------

This appears to be a problem with the de_custom_tags extension. I am not familiar with this, but I talked to another developer who said that he thinks there is a database lookup for every tag and this may cause additional problems. Yet, if it worked for wec_devo v1.4 and NOT v1.5, that does not make sense because there was no database additions.

So you can email me directly at dave@webempoweredchurch.org if you would like. We would like to find out what the problem is and if it is with the wec_devo extension.

-Dave
Total Posts: 5 - Pages (1): [1]
You must login to post a message to this conference.