I just installed the module and keep getting the following errors:

•user warning: Table 'ttecommerce.support_client' doesn't exist query: SELECT COUNT(*) FROM support_client jc in C:\Websites\Apache2.2\www\ttecommerce\modules\support\support.admin.inc on line 21.
•user warning: Table 'ttecommerce.support_client' doesn't exist query: SELECT clid, name, status, integrate_email, mailfrom FROM support_client jc ORDER BY jc.name ASC LIMIT 0, 50 in C:\Websites\Apache2.2\www\ttecommerce\modules\support\support.admin.inc on line 21.
•user warning: Table 'ttecommerce.support_client' doesn't exist query: SELECT name FROM support_client WHERE status = 1 in C:\Websites\Apache2.2\www\ttecommerce\modules\support\support.module on line 2284.

Comments

jeremy’s picture

jeremy commented
Status: Active » Postponed (maintainer needs more info)

This suggests that something went wrong when you enabled the module. Did you get any errors? The support_client table should have been created, but wasn't. Review your Apache log and Drupal watchdog log for errors. Also, try disabling and then uninstalling the support module and reinstalling it to see if it properly creates your table the second time around.

TeamThunder’s picture

TeamThunder commented

I've attempted multiple time to install and uninstall and I get the same error messages. This table does not appear to be getting created in the database as you observed. I then deleted the database, created a new database, deleted my drupal installation and reinstalled this module only. The problm returned. It would seem to me an error in the module database system. This is the first error message that I recieved:
BLOB/TEXT column 'domains' can't have a default value query: CREATE TABLE support_client ( `clid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(128) NOT NULL DEFAULT '', `path` VARCHAR(32) NOT NULL DEFAULT '', `status` TINYINT NOT NULL DEFAULT 0, `integrate_email` TINYINT NOT NULL DEFAULT 0, `server_name` VARCHAR(64) NOT NULL DEFAULT '', `server_username` VARCHAR(64) NOT NULL DEFAULT '', `server_password` VARCHAR(64) NOT NULL DEFAULT '', `mailfrom` VARCHAR(64) NOT NULL DEFAULT '', `mailbox` VARCHAR(64) NOT NULL DEFAULT '', `protocol` SMALLINT unsigned NOT NULL DEFAULT 0, `extra` VARCHAR(128) NOT NULL DEFAULT '', `port` SMALLINT unsigned NOT NULL DEFAULT 0, `autosubscribe` TEXT DEFAULT NULL, `domains` LONGTEXT DEFAULT '', `notes` LONGTEXT DEFAULT '', PRIMARY KEY (clid), UNIQUE KEY name (name), INDEX status (status) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Websites\Apache2.2\www\ttecommerce\includes\database.inc on line 517.

TeamThunder’s picture

TeamThunder commented
Status: Postponed (maintainer needs more info) » Active

status update?

jeremy’s picture

jeremy commented
Status: Active » Fixed

Fix committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.