test.php not detecting zend optimizer on xampplite local install?

Hmm, I don't seem to have a tools.php file in that do not upload folder...

Here's the actual error - about date?

Code:

Database error in vBulletin 3.6.4:

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
    (7255, '', 'b|j', FROM_UNIXTIME(1235430029), 'becd53f8d08c6b24cfa32c1e31fdf9f9', 'gabe2@mailinator.com', 'gabe2', 3, 1, 'Member', 0, 0, '', '', '-5', '192.168.1.113', '', 1235430029, 1235430029, 1235430029, 1, 1, 0, 5, 10, 0, -1, 0, -1);

MySQL Error  : Incorrect date value: '' for column 'birthday_search' at row 1
Error Number : 1292
Date         : Monday, February 23rd 2009 @ 06:00:29 PM
Script       : http://192.168.1.113/forums/register.php?do=addmember
Referrer     : http://192.168.1.113/forums/register.php?do=addmember
IP Address   : 192.168.1.113
Username     : gabe2
Classname    : vB_Database

try changing the empty string to a 0

Thanks, Brian. I was able to manually insert a new user with some other tweaks to the insert query, then I updated the password string from the new user for my admin user and tried to login, but still no luck with that method.

However, I did get the reset password email to work this time... and am getting closer, but yet another roadblock.

Now when I try to login as admin into admin CP, I get the redirecting screen (with the click here link) - so the password is working - but I don't actually get logged into the admin CP - just end up back at the login screen.

One time I saw this URL:

http://192.168.1.113/forums/admincp/index.php?nojs=1

...which makes it sound like I don't have JavaScript enabled in my browser, but I do.

Any other ideas?

Thanks again!

check your cookie path and cookie domain settings.

Thanks, Brian. I updated my cookie domain as follows:

Code:

update forums_2006.setting s
set value = '192.168.1.113'
where varname = 'cookiedomain';

And same deal.

So then I updated cookiepath from / to /forums and same deal.

Still no luck.

Hello Gabe ,

Your easiest solution will be : Download vBulletin files ( the same version you are using )
upload tools.php from donot upload directory to your install dir.
Then browse http://192.168.1.113/install/tools.php

and reset every possible solution from there till you'll be succesfully login to admincp.

Also donot forget to disable your hooks.

Thanks, Mert. However, as noted earlier, I don't have a tools.php file. Is there anyway you could email that to me, please?

tools.php is a file that is included in your vbulletin download, not in your vbseo download.

Great! Thanks for clarifying, Michael.

That FINALLY got me in. I just did the [Reset Cookie Domain] option (it was still showing .articulate.com, even though I had manually overridden that in the DB), and that got me in.

Thanks for the help, everyone!

Doing it from the db, it is still cached in the datastore I believe, which was why it did not take affect. Glad everything is sorted now!