Issue: SQL-Errors after Upgrade to 2.2.0

Issue Tools
- View Changes

February 1, 2009 4:37 PM

Storyteller Storyteller is offline

Junior Member

SQL-Errors after Upgrade to 2.2.0

Hi,

after upgrading V.2.1.3 to V.2.2.0 i only get SQL-Errors when opening an article. For example:

Code:

Invalid SQL:

			SELECT rev.userid, rev.dateline AS dateadded, rev.ipaddress,
				user.username, user.usergroupid, user.membergroupids,
				user.email, user.homepage,
				IF(user.displaygroupid > 0, user.displaygroupid, user.usergroupid) AS displaygroupid
				
			FROM vb_3vault_revision AS rev
			LEFT JOIN vb_3user AS user ON (user.userid = rev.userid)
			
			WHERE rev.threadid = 73
				AND rev.pending = 0
			GROUP BY rev.userid	
			ORDER BY dateadded ASC;

MySQL-Fehler  : Unknown column 'rev.ipaddress' in 'field list'
Fehler-Nr.    : 1054

Code:

Invalid SQL:

			SELECT rev.userid, rev.dateline AS dateadded, rev.ipaddress,
				user.username, user.usergroupid, user.membergroupids,
				user.email, user.homepage,
				IF(user.displaygroupid > 0, user.displaygroupid, user.usergroupid) AS displaygroupid
				
			FROM vb_3vault_revision AS rev
			LEFT JOIN vb_3user AS user ON (user.userid = rev.userid)
			
			WHERE rev.threadid = 73
				AND rev.pending = 0
			GROUP BY rev.userid	
			ORDER BY dateadded ASC;

MySQL-Fehler  : Unknown column 'rev.ipaddress' in 'field list'
Fehler-Nr.    : 1054

Greetings
Storyteller

Issue Details

Issue Number 377

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 2.2.0

Fixed Version 2.2.0

Milestone (none)

Software DependencyAny

Users able to reproduce bug 1

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 1, 2009 6:58 PM
pegasus

VaultWiki Team
This happened earlier today as well. In phpmyadmin, or AdminCP -> Maintenance -> Execute SQL Query -> Manual Query, run the following code. Remember to replace {prefix} with your forum's TABLE_PREFIX (in your case "vb_3")

Code:

ALTER TABLE {prefix}vault_revision ADD COLUMN ipaddress VARCHAR(15) NOT NULL DEFAULT ''

ZIP updated.
Reply
February 2, 2009 1:01 AM

Storyteller

Junior Member

That solved it. Many Thanks!

Greetings
Storyteller

Reply

+ Reply

All times are GMT -4. The time now is 10:33 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: SQL-Errors after Upgrade to 2.2.0

Issue Tools