+ Reply to Thread
Results 1 to 3 of 3

Thread: can someone help...

  1. #1
    Member kevnj has disabled reputation
    Join Date
    Nov 2005
    Posts
    78

    can someone help...

    i tried to edit my forumhome_welcomepanel and unsuccessfully as you can tell since im asking for help.

    can someone post an unedit version of what is supposed to be included in "stock vbulletin" format.

    heres the error im getting

    PHP Code:
    Database error in vBulletin 3.5.1:
    Invalid SQL:
    select count(*) as newposts from jelsoft_post where dateline >= 05:47 PM08-08-2006 and visible 1;
    MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ':47 PM, 08-08-2006 and visible = 1' at line 1
    Error Number 
    1064
    Date         
    TuesdayAugust 8th 2006 04:42:32 PM
    Script       
    http://www.jerseyparties.com/forums/index.php?
    Referrer     
    IP Address   XXXXXXXXX
    Username     
    Kevin
    Classname    
    vb_database 

    I upgraded from 3.5.1. to version 3.6.0 in hopes that would solve the problem... nope.. never upgraded before so maybe this could be another problem?

  2. #2
    Customer Support Manager Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol is a name known to all Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    142,702
    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  3. #3
    Member kevnj has disabled reputation
    Join Date
    Nov 2005
    Posts
    78
    fixed!!

    perfect.... thanks

+ Reply to Thread

Bookmarks

Posting Permissions

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