I upgraded from 6.x.1.8 to 6.x.1.9 following all instructions.

I now receive the following errors which also show up in the upgrade log although FAQ appears to be working properly except for the warning displays:

user warning: BLOB/TEXT column 'detailed_question' can't have a default value query: ALTER TABLE faq_questions ADD `detailed_question` TEXT NOT NULL DEFAULT '' in C:\inetpub\wwwroot\WebSites\Mobilogic\includes\database.mysql-common.inc on line 298.
user warning: Table 'drupalmobilogic.faq_questions' doesn't exist query: UPDATE faq_questions SET detailed_question = question in C:\inetpub\wwwroot\WebSites\Mobilogic\sites\all\modules\faq\faq.install on line 166.

I am a relative newbie - what do I do to resolve these issues?

Thanks for your help

Comments

ecsmike’s picture

ecsmike commented

I have confirmed beyond the benefit of any doubt the un-enabling the FAQ 6.x.1.9 module, uninstalling it through drupal, and removing the faq folder from the sites/all/modules folder - then uploading it again and enabling it creates the faq.weight table BUT DOES NOT create the faq.questions table resulting in the error messages I previously reported.

I need some way to install this module that creates (and populates) all of the necessary tables.

Thank you

stella’s picture

stella commented
Status: Active » Fixed

Fix released in 6.x-1.10. I'm not sure what state your database is in, but if you do not have a "faq_questions" table, you will need to run update.php and select update "2" from the drop-down list for the faq module.

ecsmike’s picture

ecsmike commented

Thank you so much for taking the time to respond. I will try your suggestion in a little while.

By the way, the download link for 6.x.1.10 is not working - it is throwing a 404 error.

Thanks again

stella’s picture

stella commented

It can take up to 15mins for a new release to be generated, so it's probably working now.

ecsmike’s picture

ecsmike commented

I followed your instructions and ran update.php selecting update "2" which did create the faq.questions table.

However, I am now recieving the following error in any operation related to FAQ:

user warning: Unknown column 'detailed_question' in 'field list' query: SELECT question, detailed_question FROM faq_questions WHERE nid = 21 AND vid = 21 in C:\inetpub\wwwroot\WebSites\Mobilogic\sites\all\modules\faq\faq.module on line 286.

Regards . . . Mike

stella’s picture

stella commented

You may then need to run update.php with update "6003" selected.

ecsmike’s picture

ecsmike commented

I installed the new version 6.x.1.10 and updated per you instructions. It is now working properly.

Thank you so much!!!

The block functionality in the new version does not appear to be working - I will post a separate issue on that.

Thanks again . . . Mike

Status: Fixed » Closed (fixed)

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