Announcement

Collapse
No announcement yet.

4.2.1 update problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Hartmut
    replied
    Please start a new thread with each of your problem. Please leave detailed error messages etc. in it.

    Leave a comment:


  • Maxtor_
    replied
    Hello, I have a problem. After the last update to the counting stopped working VB4.2.1 views enter the topic. Anyone know how to fix this? This is a global problem that occurs only on my forum?

    Leave a comment:


  • lgnd
    replied
    I have exactly the same problem and I'm unable to run the upgrade script.

    Leave a comment:


  • Adem GENÇ
    replied
    I found the problem
    These files are in the folder /install/ "--.htaccess" and "--.htpasswd" re-name ".htaccess" and ".htpasswd"
    Now doing the update

    Thanks

    Leave a comment:


  • Lynne
    replied
    What was your default tab set to - was it set to a user created navtab or one of the default vbulletin navtabs?

    (Guys, if you go to his upgrade.php script, it has a database error. He *cannot* run the upgrade script yet - it isn't that he isn't aware that he needs to do it.)

    Leave a comment:


  • Trevor Hannant
    replied
    There are two steps to upgrading:

    1. Uploading the files and
    2. Running the upgrade script

    You've only done point 1 - you haven't done point 2 as pointed out in posts 2, 4 and 6.

    Until you do this, you will continue to have this problem. So, login to AdminCP, close your forum then go to:

    Settings > Run Upgrade Script

    ...and follow any on screen prompts.

    Leave a comment:


  • Adem GENÇ
    replied
    Three times I uploded the files via FTP but
    Result See
    http://www.uzayforum.com/install/upgrade.php

    It errors below. (You can not see error details because you are not member of this site)
    Code:
    [COLOR=#000000][COLOR=#0000BB]Database error in vBulletin 4.2.0[/COLOR][COLOR=#007700]:[/COLOR]
    
    [COLOR=#0000BB]Invalid SQL[/COLOR][COLOR=#007700]:
    
            [/COLOR][COLOR=#0000BB]SELECT [/COLOR][COLOR=#007700]*
            [/COLOR][COLOR=#0000BB]FROM navigation
            WHERE state [/COLOR][COLOR=#007700]&  = [/COLOR][COLOR=#0000BB]0
            ORDER BY navtype[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]displayorder[/COLOR][COLOR=#007700];[/COLOR]
    
    [COLOR=#0000BB]MySQL Error   [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]You have an error in your SQL syntax[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#0000BB]check the manual that corresponds to your MySQL server version [/COLOR][COLOR=#007700]for [/COLOR][COLOR=#0000BB]the right syntax to [/COLOR][COLOR=#007700]use [/COLOR][COLOR=#0000BB]near [/COLOR][COLOR=#DD0000]'= 0
            ORDER BY navtype, displayorder' [/COLOR][COLOR=#0000BB]at line 3
    Error Number  [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]1064
    Request Date  [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]Thursday[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]April 18th 2013 [/COLOR][COLOR=#007700]@ [/COLOR][COLOR=#0000BB]05[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#0000BB]26[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#0000BB]15 AM
    Error Date    [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]Thursday[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]April 18th 2013 [/COLOR][COLOR=#007700]@ [/COLOR][COLOR=#0000BB]05[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#0000BB]26[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#0000BB]15 AM
    Script        [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]http[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#FF8000]//www.xxxxxx.com/[/COLOR]
    [COLOR=#0000BB]Referrer      [/COLOR][COLOR=#007700]:[/COLOR]
    [COLOR=#0000BB]IP Address    [/COLOR][COLOR=#007700]: **********[/COLOR]
    [COLOR=#0000BB]Username      [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]Adem GENÇ
    Classname     [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]vB_Database
    MySQL Version [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000BB]5.0.91[/COLOR][COLOR=#007700]-[/COLOR][COLOR=#0000BB]log  [/COLOR][/COLOR]

    Leave a comment:


  • Wayne Luke
    replied
    You need to run the upgrade script so the database changes are made and that will make your forums operational. You're currently trying to use 4.2.1 files against a 4.2.0 database and that isn't going to work. Until you run the upgrade script, re-uploading the files will not fix anything.

    Upgrading has two stages as always...
    1) Upload files.
    2) Run install/upgrade.php

    Leave a comment:


  • Adem GENÇ
    replied
    There is no problem entering to AdminCP.
    Forum Home and "http://www.myforum.com/install/upgrade.php" error about database

    navigation table errors even though I renamed -navigation.
    It errors again even though I installed navigation table to database.
    There is not navigation table but it errors again.

    I just upload all files(4.2.1) via FTP.

    Note: I couldn't start updating yet.

    Forum does not work. Please, could you help me?

    Leave a comment:


  • AliMadkour
    replied
    You should run upgrade script after uploading files

    Code:
    http://www.myforum.com/install/upgrade.php

    Leave a comment:


  • Adem GENÇ
    replied
    update did not do, Only files uploaded via FTP

    Note: Re-uploaded all the files again via FTP

    navigation tables exist

    http://awesomescreenshot.com/0ff16gpm9b

    (You can delete the other topic, I opened the wrong place)
    Last edited by Adem GENÇ; Thu 18 Apr '13, 6:04am.

    Leave a comment:


  • Trevor Hannant
    replied
    Looks like you haven't run the upgrade script or it didn't complete as the error states your database is still on 4.2.0.

    Leave a comment:


  • Adem GENÇ
    started a topic [Forum] 4.2.1 update problem

    4.2.1 update problem

    Hello,
    4.2.0 PL3 =>4.2.1 version upgrade problem

    Upgrade all files, and this problem

    What could be the problem?
    PHP Code:
    Database error in vBulletin 4.2.0:

    Invalid SQL:

            
    SELECT *
            
    FROM navigation
            WHERE state 
    &  = 0
            ORDER BY navtype
    displayorder;

    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 '= 0
            ORDER BY navtype, displayorder' 
    at line 3
    Error Number  
    1064
    Request Date  
    ThursdayApril 18th 2013 05:26:15 AM
    Error Date    
    ThursdayApril 18th 2013 05:26:15 AM
    Script        
    http://www.xxxxxx.com/
    Referrer      :
    IP Address    : **********
    Username      Adem GENÇ
    Classname     
    vB_Database
    MySQL Version 
    5.0.91-log 
    existing in the tables "navigation"

Related Topics

Collapse

Working...
X