Bug New update not altering "user" table, causing db error when downloading any file

[bzcomputers]

New update not altering "user" table, causing db error when downloading any file

Noticed I was getting lots of db errors for unknown column after the update released tonight (2.3.0).

Found the install/230.php file was suppose to alter the database but after importing the xml multiple times the database was still not showing the new column. Manually altering database with info contained in 230.php fixed the error.

Not sure how you have it coded to check if a db alteration file should run but I noticed both the current vb4 and vb3 xml files for version 2.3.0 still refer to version 2.2.4 and that maybe why the file wasn't running when importing the new xml. Maybe just as easy as updating the version number in the xml to fix the issue.

Not that you need it but here is the db error:

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE user SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`dbtech_downloads_downloadamount` = '955653'
WHERE userid = 0;

MySQL Error   : Unknown column 'dbtech_downloads_downloadamount' in 'field list'
Error Number  : 1054
Request Date  : Monday, July 14th 2014 @ 10:44:30 PM
Error Date    : Monday, July 14th 2014 @ 10:44:30 PM
Script        : http://www.xxx.com/forum/downloads.php?do=file&fileid=69
Referrer      : http://www.xxx.com/forum/downloads/carnival-cruise-lines-2/carnival-bar-menu-indoor-30.html
IP Address    : xx.xxx.xxx.xx
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

 

[Fillip H.]

This has now been fixed, if you re-download the mod and re-run the XML, it'll do the alters