Announcement

Collapse
No announcement yet.

SQL error 1064 in database

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

  • SQL error 1064 in database

    After I added a large list of e-mail domains to not accept registration from, I can no longer access the vBulletin Options in my Control Panel. Everything else seems to be fine.

    What should I do? The error message is below ::


    Database error in vBulletin :

    Invalid SQL:
    ### GET USER INFO query(userid:1 option:16) ###
    SELECT administrator.*,
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS
    passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS
    displaygroupid, language.phrasegroup_timezone AS phrasegroup_timezone,
    language.phrasegroup_cpoption AS phrasegroup_cpoption,
    language.phrasegroup_cpglobal AS phrasegroup_cpglobal, language.phrasegroup_global AS phrasegroup_global,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.decimalsep AS lang_decimalsep,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.thousandsep AS lang_thousandsep
    FROM user AS user
    INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
    INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid =
    user.userid) LEFT JOIN administrator AS administrator ON
    (administrator.userid = user.userid) INNER JOIN language AS language ON
    (language.languageid = IF(user.languageid = 0, , user.languageid))
    WHERE user.userid = 1

    mysql error: You have an error in your SQL syntax near '
    user.languageid))
    WHERE user.userid = 1
    ' at line 14

    mysql error number: 1064

    Date: Wednesday 17th of September 2003 02:50:07 PM
    Script: http://www.signalresource.com/forums...ons.php?null=0
    Referer: http://www.signalresource.com/forums/admincp/index.php
    Last edited by tylast; Wed 17 Sep '03, 8:18am.

  • #2
    I've ran the repair.php script & nothing is different. I can't get into my options.

    Comment


    • #3
      Originally posted by tylast
      I've ran the repair.php script & nothing is different. I can't get into my options.
      You will have to run it again and again until the errors disappear.

      Comment


      • #4
        I've run it like 10 times...no luck

        Comment


        • #5
          How did you add this list of email addresses and what format were they? They needed to be separated by spaces instead of lines feeds in order to work.

          I think you are going to need to clear out this setting in the database but unfortunately I don't know how to do this with vB3 yet. Hopefully one of the Devs will be able to help.
          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


          • #6
            Hmmm...do you know which table I should clear out in my database? I copied the e-mail domain list from http://i4net.tv/marticle/get.php?act...e&articleid=30

            I didn't edit what was there.

            Comment


            • #7
              It's not as table - it's a field in one of the tables. In fact, it's the banemail field in the datastore template. You should be able clear this in phpMyAdmin.

              Also copying and inserting that list probably included line feeds.
              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


              • #8
                I keep getting this:

                Error

                SQL-query :

                SELECT *
                FROM `datastore`
                WHERE 1
                LIMIT 0 , 30

                MySQL said:

                Lost connection to MySQL server during query
                Back


                Is there a query that I can run that will clear that field directly?

                Comment


                • #9
                  I tried this:

                  Error

                  SQL-query :

                  UPDATE datastore SET banemail = ''

                  MySQL said:

                  Unknown column 'banemail' in 'field list'


                  Is the banemail field under datastore?

                  Comment


                  • #10
                    Originally posted by tylast
                    I tried this:

                    Error

                    SQL-query :

                    UPDATE datastore SET banemail = ''

                    MySQL said:

                    Unknown column 'banemail' in 'field list'


                    Is the banemail field under datastore?
                    I think the query should be:


                    UPDATE datastore SET data = '' WHERE title = 'banemail';
                    Sig? What sig?

                    Comment


                    • #11
                      That totally worked! Many thanks!

                      Comment


                      • #12
                        Originally posted by tylast
                        That totally worked! Many thanks!
                        Glad to help.
                        Sig? What sig?

                        Comment

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