[imc-sf-active] patch_094_092_validation_removed_from_webcast.sql failed

[Brett Nelson]

This patch file failed to run for me, I added a column
into the first insert statement so that it matched the
3 columns existing in the validation table and it
appeared to work fine. All the rest of the scripts
have been working good :)

ERROR 1136 at line 4: Column count doesn't match value
count at row 1

I just inserted a ,''  to the first insert statement
to make it match the 3 columns in validation table.

now it reads:

# use this patch if you used patch_email_validation
for version 092
# now we store the validation info in its own table,
not in webcast

INSERT INTO validation SELECT id as article_id, 't' as
validated,'' FROM webcast WHERE validate =
'validated';

INSERT INTO validation SELECT id as article_id, 'f' as
validated, RIGHT(validate,32) as hash FROM 

webcast WHERE validate like '%hash%';

# say bye bye to that old text column

ALTER TABLE webcast DROP COLUMN validate;


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250