Announcement

Collapse
No announcement yet.

Activation Error? - Database Error

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

  • Activation Error? - Database Error

    I hae had the forum up and running for a few months now but new users cannot acitvate thier accounts it just shows a database error??

    How would i solve this???

    my Forum: http://www.back2bowlers.co.uk/forum/

  • #2
    Can you post what the exact error is, by viewing the Page Source from your browser?

    Or if you have it set to e-mail you, post the contents of the DB Error E-mail.

    Also, at what point of the Activation Process does the error appear?

    http://www.back2bowlers.co.uk/forum/register.php?a=ver
    Regards,
    Nick

    Comment


    • #3
      Here you go nick:

      Database error in vBulletin 3.7.2:
      Invalid SQL:
      INSERT INTO userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
      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 ' 1, 'buddy', 'yes')' at line 1
      Error Number : 1064
      Request Date : Thursday, July 24th 2008 @ 10:57:26 PM
      Error Date : Thursday, July 24th 2008 @ 10:57:26 PM
      Script : http://www.back2bowlers.co.uk/forum/...amp;i=81425930
      Referrer : http://bl137w.blu137.mail.live.com/m...mp;n=146793825
      IP Address : 92.234.205.132
      Username : Test 2
      Classname : vB_Database
      MySQL Version :
      -->

      Comment


      • #4
        I would this down to modfied code. Please disable the plugin/hook system. To temporarily disable the plugin system, edit config.php and add this line right under <?php

        define('DISABLE_HOOKS', true);

        Comment


        • #5
          Right done that mate but does this disable all plugins????

          Comment


          • #6
            Yes, temporarily.

            vBulletin does not support modified code, so the only way to see what exactly the problem is, is to temporarily disable all plugins.

            To temporarily disable the plugin system, edit */includes/config.php and find:
            Code:
            <?php
            Add this directly below it:
            Code:
            define('DISABLE_HOOKS', true);
            Regards,
            Nick

            Comment


            • #7
              I see right i have disabled them now.... what next???

              Comment


              • #8
                Do you still get the error?
                Regards,
                Nick

                Comment


                • #9
                  No mate so this means it is a plugin that is causing the issue..... how do i determine which it could be??

                  Comment


                  • #10
                    First, you un-do the edit that you did (as described in Post #6) and then manually disable each plugin one-by-one to determine which one it is.
                    See if you get the error after disabling each one. If you don't then the latest one you disabled is the culprit.
                    Disable them in:
                    AdminCP -> Plugins and Products -> Manage Products -> Disable (for each plugin on the drop-down menu).
                    Regards,
                    Nick

                    Comment


                    • #11
                      Sorted i disabled the last couple which seemed to cause the error. I have uninstalled them now!!!

                      Comment


                      • #12
                        ok it helped me also

                        Comment

                        Loading...
                        Working...
                        X