Database error in vBulletin 3.6.2:

Discussion in 'vBulletin' started by xox, Oct 25, 2006.

0
  1. #1
    UPDATE post SET
    parentid = CASE WHEN parentid = 15862 THEN WHEN parentid = 15872 THEN WHEN parentid = 15894 THEN WHEN parentid = 15904 THEN WHEN parentid = 15905 THEN WHEN parentid = 15945 THEN WHEN parentid = 15994 THEN WHEN parentid = 16196 THEN WHEN parentid = 16199 THEN WHEN parentid = 16200 THEN WHEN parentid = 16201 THEN WHEN parentid = 16202 THEN WHEN parentid = 16203 THEN WHEN parentid = 16205 THEN WHEN parentid = 16656 THEN WHEN parentid = 16748 THEN WHEN parentid = 16754 THEN WHEN parentid = 25029 THEN ELSE parentid END
    WHERE threadid = 3102 AND parentid IN (0,15862,15872,15894,15904,15905,15945,15994,16196,16199,16200,16201,16202,16203,16205,16656,16748,16754,25029);

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHEN parentid = 15872 THEN WHEN parentid = 15894 THEN WHEN parentid = 15904 TH' at line 2
    Error Number : 1064
    Date : Monday, October 16th 2006 @ 09:11:37 PM
    Script : http://www.XXXX.net/vb/postings.php?do=domovethread&t=1197
    Referrer : http://www.XXXX.net/vb/postings.php?t=1197&pollid=
    IP Address : xxx.xxx.xxx.xxx
    Username : admin
    Classname : bbfrom_database




    Please help.
    I talked this problem When used copies of the Thread
    The problem occurred when the Forum was upgraded to the latest version
    I did not find a solution to this moment, I am very frustrating.:(
     
    xox, Oct 25, 2006 IP
  2. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Oh my God..........


    Salvation..... salvation..... salvation.....


    no solution....


    Will Kill Myself.....

    I am very frustrating.....
     
    xox, Oct 26, 2006 IP
  3. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Will not kill myself. I will continue the struggle :p


    But actually the problem is very strange ..

    I did not have any solutions at all forums, including forums John (vBulletin)..

    I heard some experts say that the problem of version MySQL Located on the servers..

    But I do not know whether Charkonhm opinion..


    Any word or any opinion you will often advising me.. :rolleyes:
     
    xox, Oct 26, 2006 IP
  4. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hope abides; therefore I abide.
    Countless frustrations have not cowed me.
    I am still alive, vibrant with life.
    The black cloud will disappear,
    The morning sun will appear once again
    In all its supernal glory.



    :p​
     
    xox, Oct 26, 2006 IP
  5. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #5
    What version of MySQL are you using? Your best option would be to open a support ticket with vBulletin directly.
     
    digitalpoint, Oct 26, 2006 IP
  6. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    MySQL version 4.1.21-standard ...

    The assistance of technical support did not succeed

    All it said was that (disable all plugins) ..


    Thank you for your reply.


    Could it be that the problem of databases..?​
     
    xox, Oct 26, 2006 IP
  7. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #7
    Did you do that? (disable all plug-ins and make sure all your PHP files are stock)
     
    digitalpoint, Oct 26, 2006 IP
  8. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Yes, but did not succeed solutions.
     
    xox, Oct 26, 2006 IP
  9. xox

    xox Guest

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Well....

    Advise you strongly .

    To change the jurisdiction of this section..

    To

    Digital Administration sex

    This seems preferable that no one understands nothing

    Let them creativity in sex

    Fack You
     
    xox, Oct 28, 2006 IP