Announcement

Collapse
No announcement yet.

The board just emailed me this MySQL Error????

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

  • #16
    repair is weird on this

    I run

    http://www.myplace.com/bb/admin/extr...html=1&check=1

    and I receive a blank page, no output.

    trying to troubleshoot this problem on php 4.2.0

    i tried adding forum=vbulletin as well, same deal, blank page

    I am on IE 6.0
    Database error in vBulletin Control Panel 2.2.5:

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

    Comment


    • #17
      Error

      I also received this one;

      Database error in vBulletin :

      cannot use database wassellforum
      mysql error: Unknown database 'wassellforum'

      mysql error number: 1049

      Date: Wednesday 24th of April 2002 07:52:30 PM
      Script: /vblite/register.php?a=act&u=6&i=92171813
      Referer:

      Comment


      • #18
        Re: repair is weird on this

        Originally posted by taubin
        I run

        http://www.myplace.com/bb/admin/extr...html=1&check=1
        Don't run repair.php from the extras directory. Upload it to the admin directory and run it from there.

        trying to troubleshoot this problem on php 4.2.0
        There are known issues between vB and PHP 4.20. Make sure the register_globals in 'On' in your phpinfo.php page.
        Steve Machol
        Former Customer Support Manager
        Last edited by Steve Machol; Thu 2 May '02, 8:10am.
        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


        • #19
          Re: Error

          Originally posted by lawnmowerman
          I also received this one;
          You'll need to submit a support ticket atL:

          http://www.vbulletin.com/members/support.php

          Be sure to include the login info to access your Admin CP and FTP.
          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


          • #20
            thanks

            sm:

            the phpinfo.php file is not on my system. I looked in the main area and under admin.
            sorry.
            I ran repair the correct way and it did process, I will test and get back to you asap.

            Comment


            • #21
              same error

              even after the repair I am receiving the same error when I try to modify a user's group.

              I saw freddie's reply to me regarding changes the error message code in the db class to be fully quoted. that did not fix it either.

              other than doing what freddie asked I have not other hacks or anything on this system.

              Comment


              • #22
                not to be dense

                I reread over my notes. if you mean do the results of phpinfo.php ( a test program) show the globals as being on or off in the php.ini, then I can answer that. the host has the globals off for security reasons and does not intend to change it.

                I was told to get an upgraded copy of my software that was compatible with php 4.2.0

                Comment


                • #23
                  As I said there are known problems with PHP 4.20. In addition to register_globals sSee this thread for several fixes posted by freddie, including user.php, template.php and db_mysql.php replacements made for PHP 4.2.0:

                  http://www.vbulletin.com/forum/showt...threadid=42414

                  For phpinfo.php, create a new file with that name and this content:

                  PHP Code:
                  <?php
                  phpinfo
                  ();
                  ?>
                  Upload it to your forums directory and post the URL here.
                  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


                  • #24
                    Re: not to be dense

                    Originally posted by taubin
                    I reread over my notes. if you mean do the results of phpinfo.php ( a test program) show the globals as being on or off in the php.ini, then I can answer that. the host has the globals off for security reasons and does not intend to change it.

                    I was told to get an upgraded copy of my software that was compatible with php 4.2.0
                    Yikes! Unfortunately all current versions of vB require register_globals to be on. If they are unwilling to cooperate your only option may be to find another host. Good luck!
                    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


                    • #25
                      will do

                      I just bought vbulletin from you you 3 weeks ago, its strange to think I have to do all those code changes, but I will try.

                      I don't see a specific list of modules to change and what lines to change listed in that thread you pointed me to.

                      if did a search on the one piece of code I could see marked as "change this" "to this" and it found one occurrenc, in the db class module in admin. that change did not help it.
                      where are the other changes referring to.

                      do you have an update to the source, it seems with so many people have this issue you could mark up your 2.2.5 code far easier and more reliably than all of us.

                      when will 2.2.6 or a fix be out?

                      - updated --

                      I ran the phpinfo, but couldn't I send the path to you instead of posting here, it has a lot of personal information and paths in there I cannot let be public.
                      I ran it and here is the line you wan to see

                      register_globals
                      On On

                      it looks like it is on, the host made a typo in their response.

                      its not the register_globals that is the problem here.
                      taubin
                      New Member
                      Last edited by taubin; Thu 2 May '02, 8:30am.

                      Comment


                      • #26
                        If you look at my posts in that thread you will find 3 attachments, user.php, template.php and db_mysql.php

                        All of these files are replacements that go in your admin directory. Since we are still trying to work out all of the oddities that php 4.2.0 has introduced, I don't have a date for a v2.2.6 release.
                        It will resolve this problem:
                        PHP Code:
                        Invalid SQLSELECT userid 
                        FROM user 
                        WHERE username
                        ='sdfvsv' 
                        AND userid <> 
                        mysql errorYou have an error in your SQL syntax near '' at line 4 
                        That being said, if register_globals is indeed off than vBulletin will not work until we release v3 which is still a few months away.

                        Comment


                        • #27
                          Unfortunately the 'fixed' files will not help you because your host will not set register_globals to on, and as I said all versions of vB require this to be on. AFAIK there is no easy fix or patch for this.

                          If you host does decide to relent and set this on, then all you need to do is download and reupload the user.php, template.php and db_mysql.php files posted by freddie. No code editing is required.
                          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


                          • #28
                            okay okay 8-)

                            we have a crossing in the mail problem here.

                            Understood and have read your latest posts.

                            The host has the

                            register_globals On On

                            Misunderstanding of my question on their part, the phpinfo was helpfull.

                            I will now gladly download his attachments and perform the upload, thus replacing those files.

                            Will get back to you as soon as I can.

                            thanks, I will stay on this.

                            thank you for your great support.

                            Comment


                            • #29
                              its WORKING!!!! (users can be changed)

                              Very nice and easy fix. I uploaded those files.
                              I went into the List Users, found my test person,
                              and changed him from Registered to Moderator and Saved.

                              THIS PROBLEM IS FIXED!!!!!!!

                              suggesstion, can you put all three of those attachments in Freddie's post right in the php 4.2.0 announcement? may be easier so you can point people with one line.

                              I missed the attachments several times through that post.

                              But all is fine and wonderful now.

                              rock on!

                              Comment

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