user warning: Unknown column 'b.vid' in 'on clause' query: SELECT COUNT(*) FROM node n INNER JOIN banner b ON n.vid=b.vid WHERE n.uid=1 in /var/www/html/drupal-4.7.4/includes/database.mysql.inc on line 121.
user warning: Unknown column 'b.vid' in 'on clause' query: SELECT n.nid FROM node n INNER JOIN banner b ON n.vid=b.vid WHERE n.uid=1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 15 in /var/www/html/drupal-4.7.4/includes/database.mysql.inc on line 121.

CommentFileSizeAuthor
#1 banner.mysql.txt1.6 KBjhutchins

Comments

jhutchins’s picture

jhutchins commented
Title: No provision for upgrading from earlier version, errors in database. » Error creating database for banners
StatusFileSize
new banner.mysql.txt1.6 KB

Sorry, this appears to be an error in the install script that does not create all of the fields.

The install script appears to be an unconverted DOS format file, which causes errors in the creation of the database in MySQL.

I stripped the MySQL code out of the banners.install file, then converted the file using the dos2unix utility.

Having the seperate mysql file makes repair/recreation easy; there appears to be no way to re-trigger the install script.

mr700’s picture

mr700 commented

banner.css and banner.install are in DOS format, but I missed this problem because I always 'dos2unix' and 'chmod' any new modules. (OT: can't the drupal release system dos2unix and chmod all .module, .css, .*sql and so on files automatically?)
To re-trigger maybe you can by disabling the module, deleting the dictionary and removing all related records from system and variable tables (select * from variable where name like '%banner%'; select * from system where name like '%banner%';). After this reenabling it should (I think) re-trigger it.

rseiser’s picture

rseiser commented

I also had an error message regarding the SQL statement from the install file. After removing the last section
/*!40100 DEFAULT CHARACTER SET utf8 */;
it worked.