Error need help please.

Hey guys and gals...

I'm new to this stuff, but I learn quick.

everything is installed, admin set up, but small problem in the database.

Here's more info...

Running Apache 2.0.54 with PHP 5.0.5 and MySQL 5.0

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO user
(username, salt, password, passworddate, email, styleid, parentemail,
showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset, options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid, reputationlevelid, reputation, autosubscribe, birthday, birthday_search)

The problem is with the Values:
- the joindate is 1129842188 (what format is that?)
- the lastvisit & lastactivity are 1129842188 (the same)

The main error is; '' no input value for bithday_search...

mysql error: Incorrect date value: '' for column 'birthday_search' at row 1

mysql error number: 1292

Thanks In advance, could use some guidance here.

Frost.

Is this custom code? did you copy bithday_search because it should be birthday_search... or is that typo introduced when copying to the post?

bithday was typo...

Here's the full report...

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO user
(username, salt, password, passworddate, email, styleid, parentemail,
showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset,
options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid,
reputationlevelid, reputation, autosubscribe, birthday, birthday_search)
VALUES
('XXXXXXX',
'_X]',
'09ad7b96b3b634f7330e153b51c7c088',
NOW(),
'XXXXX@XXXXX.COM',
1,
'',
1,
'Junior Member',
1129842188,
-1,
1129842188,
1129842188,
3,
'-5',
3415,
-1,
0,
1,
'24.150.xxx.xxx',
0,
1,
5,
10,
-1,
'',
''
)

mysql error: Incorrect date value: '' for column 'birthday_search' at row 1

mysql error number: 1292

Date: Thursday 20th of October 2005 05:03:08 PM

So does this happen when a user tries to register?

So does this happen when a user tries to register?

yes, i've even tried to create a user in myadmin manually.
yes, tried to add a user though admin control panel.

I also have this error...

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT thread.threadid, thread.forumid
FROM thread AS thread, subscribethread AS subscribethread
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = 1
AND thread.visible = 1
AND lastpost > 1129856784
AND deletionlog.primaryid IS NULL

mysql error: Unknown column 'thread.threadid' in 'on clause'

mysql error number: 1054

thanks for any help.

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO user
(options, parentemail, salt, passworddate, password, email, username, usergroupid, languageid, usertitle, customtitle, showbirthday, birthday_search, birthday, timezoneoffset, ipaddress, displaygroupid, joindate, lastvisit, lastactivity, autosubscribe, showvbcode, threadedmode, reputationlevelid, reputation, pmpopup, maxposts, daysprune, startofweek) VALUES
(3159, '', '/Vz', FROM_UNIXTIME(1130911210), 'c16847234c4c3c314f8906a0976f188d', , 3, 1, 'Registered User', 0, 0, '', '', '-6', , '', 1130911210, 1130911210, 1130911210, -1, 2, 0, 5, 10, 0, -1, 0, -1);

MySQL Error : Incorrect date value: '' for column 'birthday_search' at row 1 Error Number : 1292

(User name and email have been removed from error)

I dropped mysql 5.0 and ran 4.14, i think this helped with some minor adjustments.

Hey what exactly is the salt value used for ???

Thanks,
Frost.

I do not know what the salt is.