Page 3 of 3 FirstFirst 1 2 3
Results 31 to 40 of 40

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

This is a discussion on test.php not detecting zend optimizer on xampplite local install? within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Hmm, I don't seem to have a tools.php file in that do not upload folder... Here's the actual error - ...

  1. #31
    Member
    Real Name
    Gabe Anderson
    Join Date
    Mar 2006
    Posts
    34
    Liked
    0 times
    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

  2. #32
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    try changing the empty string to a 0

  3. #33
    Member
    Real Name
    Gabe Anderson
    Join Date
    Mar 2006
    Posts
    34
    Liked
    0 times
    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!

  4. #34
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    check your cookie path and cookie domain settings.

  5. #35
    Member
    Real Name
    Gabe Anderson
    Join Date
    Mar 2006
    Posts
    34
    Liked
    0 times
    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.

  6. #36
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    23,111
    Liked
    622 times
    Blog Entries
    4
    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.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  7. #37
    Member
    Real Name
    Gabe Anderson
    Join Date
    Mar 2006
    Posts
    34
    Liked
    0 times
    Thanks, Mert. However, as noted earlier, I don't have a tools.php file. Is there anyway you could email that to me, please?

  8. #38
    Senior Member
    Real Name
    Michael Biddle
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    7,097
    Liked
    5 times
    tools.php is a file that is included in your vbulletin download, not in your vbseo download.
    The Forum Hosting - Forum Hosting from the Forum Experts

  9. #39
    Member
    Real Name
    Gabe Anderson
    Join Date
    Mar 2006
    Posts
    34
    Liked
    0 times
    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!

  10. #40
    Senior Member
    Real Name
    Michael Biddle
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    7,097
    Liked
    5 times
    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!
    The Forum Hosting - Forum Hosting from the Forum Experts

Page 3 of 3 FirstFirst 1 2 3

Similar Threads

  1. zend Optimizer vs. Ion Cube and test.php
    By Chewie in forum Troubleshooting
    Replies: 1
    Last Post: 12-14-2006, 11:55 AM
  2. Which Zend Optimizer Linux version to install?
    By PageUp in forum Troubleshooting
    Replies: 4
    Last Post: 05-01-2006, 03:33 PM
  3. Replies: 6
    Last Post: 04-28-2006, 08:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •