Announcement

Collapse
No announcement yet.

i keep getting database errors in the CP

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

  • i keep getting database errors in the CP

    i accidentally updated everyones post counts after doing a mass prune and most of their posts were lost. so now im updating everyones counts through the control panel...but everytime i try to update it i get this error:

    -----------------------------------------
    There seems to have been a slight problem with the KAOS Entertainment database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Database error in vBulletin Control Panel 2.2.5:

    Invalid SQL: SELECT userid
    FROM user
    WHERE username='invid'
    AND userid <>
    mysql error: You have an error in your SQL syntax near '' at line 4

    mysql error number: 1064

    Date: Friday 12th of July 2002 02:34:52 PM
    Script: http://www.purekaos.com/board/board/admin/user.php
    Referer: http://purekaos.com/board/admin/user...edit&userid=13
    ---------------------------------------------

    what does this mean and how can i fix it?

  • #2
    Your host has recently upgraded to PHP 4.2.x. To fix this:

    1. Upgrade to 2.2.6 (highly recommended), or

    2. Apply the patched files in freddie's post in this thread:

    http://www.vbulletin.com/forum/showt...threadid=44820
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      anyone interested in helping me with an upgrade? =)

      Comment


      • #4
        the upgrade process isn't very hard. see - http://www.vbulletin.com/members/upgrade.html

        you can also purchase an upgrade service where a vBulletin support person will perform the upgrade for you = http://www.vbulletin.com/order.php

        Comment


        • #5
          Originally posted by Jakeman
          the upgrade process isn't very hard. see - http://www.vbulletin.com/members/upgrade.html

          you can also purchase an upgrade service where a vBulletin support person will perform the upgrade for you = http://www.vbulletin.com/order.php
          ok, i started doing the upgrade myself and ran into a problem, this is what the instructions said:

          ------------------------------
          1) Upload all the files except install.php
          2) Load up the following web pages in your web browser.
          3) When you are done, be sure to delete all the upgradex.php scripts.

          From 2.2.5
          http://your.site/forums/admin/upgrade19.php
          ------------------------------

          in the .zip file the upgrade.php files only went up to upgrade13.php .....so how do i run the upgrade if there is no upgrade19.php ?

          Comment


          • #6
            The upgrade.zip file is only for versions 2.0.3 and earlier. The upgrade14-19 files are in the vbulletin226.zip file.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Originally posted by smachol
              The upgrade.zip file is only for versions 2.0.3 and earlier. The upgrade14-19 files are in the vbulletin226.zip file.
              ok thanks!! i successfully upgraded it.

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X