I am using I just installed Vbulletin 3.6.8 P2 in a Windows Server and everything seems to work fine except the registration.
When i register a new user i get the following message:
Database error
The forum.com database has encountered a problem.
Please try the following:
* Load the page again by clicking the Refresh button in your web browser.
* Open the forum.com home page, then try to open another page.
* Click the Back button to try another link.
The forum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
And when i try to add a user via CP, i get the following error:
Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO user
(salt, passworddate, password, options, adminoptions, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, referrerid, ipaddress, posts, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
VALUES
('*J7', FROM_UNIXTIME(1197729393), 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 35927, 0, 'Junior Member', 0, 'user', '[email protected]', 0, '', '1975-07-14', '07-14-1975', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, -1, 0, 1, 0, '0', -1, 1197729300, 1197729300, 0, '', '', 1197729393, -1, -1);
MySQL Error : Incorrect integer value: '' for column 'displaygroupid' at row 1
Error Number : 1366
Date : Saturday, December 15th 2007 @ 09:36:33 AM
Script : http://forum.com/forums/admincp/user.php?do=update
Referrer : http://forum.com/forums/admincp/user.php?do=add
IP Address : x.x.x.x
Username : Admin
Classname : vB_Database_MySQLi
When i register a new user i get the following message:
Database error
The forum.com database has encountered a problem.
Please try the following:
* Load the page again by clicking the Refresh button in your web browser.
* Open the forum.com home page, then try to open another page.
* Click the Back button to try another link.
The forum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
And when i try to add a user via CP, i get the following error:
Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO user
(salt, passworddate, password, options, adminoptions, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, referrerid, ipaddress, posts, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
VALUES
('*J7', FROM_UNIXTIME(1197729393), 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 35927, 0, 'Junior Member', 0, 'user', '[email protected]', 0, '', '1975-07-14', '07-14-1975', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, -1, 0, 1, 0, '0', -1, 1197729300, 1197729300, 0, '', '', 1197729393, -1, -1);
MySQL Error : Incorrect integer value: '' for column 'displaygroupid' at row 1
Error Number : 1366
Date : Saturday, December 15th 2007 @ 09:36:33 AM
Script : http://forum.com/forums/admincp/user.php?do=update
Referrer : http://forum.com/forums/admincp/user.php?do=add
IP Address : x.x.x.x
Username : Admin
Classname : vB_Database_MySQLi