vB Licence number

[silvermerc]

Okay so I own a forum thats currently using someone else's licence, Now im wanting to use my own im going to upgrade how do I change it?
Ross

[ForceHSS]

Just upload your files then run upgrade using you number

[silvermerc]

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM navigation
WHERE state & = 0
ORDER BY navtype, displayorder;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0
ORDER BY navtype, displayorder' at line 3
Error Number : 1064
Request Date : Saturday, May 25th 2013 @ 08:25:28 AM
Error Date : Saturday, May 25th 2013 @ 08:25:29 AM
Script : http://www.&&&.net/forum.php
Referrer : http://www.&&&.net/news-announcement...ownership.html
IP Address : ***
Username : irRoss
Classname : vB_Database
MySQL Version : 5.5.30-cll-lve

error atm, 78% and 630 files left to do.

[ForceHSS]

<a href="http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-installations-and-upgrades/3963131-mysql-error-vb-4-2-0-upgrade" target="_blank">http://www.vbulletin.com/forum/forum...-4-2-0-upgrade</a>

[silvermerc]

Okay, I upgraded it and half way through I got this error;

Action Required

An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: vbcms, Step 30 Database Error:1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

Query:

INSERT IGNORE INTO cms_widgettype
(class, packageid)
VALUES
('ActivityStream', )

I left it though and everything worked fine, but now the followings gone wrong;

Users are being logged out, its like cookies just arent storing? They stay for some time, but then log them out.

Also mod move thread isnt working, When you tick a thread to move it, The forum destination dropdown doesnt work, Its just blank?