Hi, I installed this module and I thought it went fine until I saw that I needed to run update.php so I ran it and there was an update for Invite, and the update said '7' so I clicked continue and it showed the little progress bar then I got a bunch of 'Fails' so I was hoping someone could come up with some kind of sql query I can run on my database to fix this. Aparently it forgot to add an entire table when i installed this module so yea here are the errors:



    * Please note that invite now depends on the token module.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite CHANGE message `data` TEXT NOT NULL DEFAULT '' in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 520.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: SELECT reg_code, data FROM invite WHERE data <> '' in /home/xolur/public_html/bzc/sites/all/modules/invite/invite.install on line 192.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite DROP PRIMARY KEY in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 386.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite ADD INDEX email (email) in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 434.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite CHANGE mid `invitee` INT unsigned NOT NULL DEFAULT 0 in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 520.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite CHANGE timestamp `joined` INT unsigned NOT NULL DEFAULT 0 in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 520.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite ADD `created` INT unsigned NOT NULL DEFAULT 0 in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 298.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite ADD `canceled` TINYINT unsigned NOT NULL DEFAULT 0 in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 298.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite ADD `resent` TINYINT unsigned NOT NULL DEFAULT 0 in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 298.
    * user warning: Table 'invite_notifications' already exists query: CREATE TABLE invite_notifications ( `uid` INT unsigned NOT NULL DEFAULT 0, `invitee` INT unsigned NOT NULL DEFAULT 0, INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/xolur/public_html/bzc/includes/database.inc on line 514.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: INSERT INTO invite_notifications (uid, invitee) SELECT uid, invitee FROM invite WHERE joined <> 0 AND received = 0 in /home/xolur/public_html/bzc/sites/all/modules/invite/invite.install on line 344.
    * user warning: Table 'xolur_drpl1.invite' doesn't exist query: ALTER TABLE invite DROP received in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 322.
    * user warning: Can't DROP 'uid'; check that column/key exists query: ALTER TABLE invite_notifications DROP INDEX uid in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 448.
    * user warning: Duplicate key name 'uid_invitee' query: ALTER TABLE invite_notifications ADD UNIQUE KEY uid_invitee (uid, invitee) in /home/xolur/public_html/bzc/includes/database.mysql-common.inc on line 403.

Comments

smk-ka’s picture

Since the whole invite table is missing it means that nothing has ever installed. I've just completely uninstalled the invite module and installed it again in an attempt to reprocude this behavior, but I can't, all is working as expected. Honestly, I have no idea what went wrong on your side, the only thing I can recommend to you is uninstalling and reinstalling the module again.

smk-ka’s picture

Status: Active » Closed (won't fix)

No further response, clearing out the issue queue.