Announcement

Collapse
No announcement yet.

Data Base Erro-Can U help

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

  • Data Base Erro-Can U help

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
    FROM session AS session
    LEFT JOIN user AS user USING (userid)
    WHERE session.lastactivity > 1169641600

    ORDER BY user.username asc;

    MySQL Error : Unknown column 'user.skype' in 'field list'
    Error Number : 1054
    Date : Wednesday, January 24th 2007 @ 04:41:45 AM
    Script : http://www.mashm.com/vb/online.php
    Referrer : http://www.mashm.com/vb/
    IP Address : 213.166.130.78
    Username : Eng.Hawari
    Classname : vb_database

  • #2
    Have you upgraded recently? The error suggests the upgrade didn't run completely.

    Run this query to add that column:

    Code:
    ALTER TABLE user ADD skype CHAR(32) NOT NULL DEFAULT '';

    Comment


    • #3
      no I did not upgrade recently

      Comment


      • #4
        Run the query above to add the missing column back in.

        Comment


        • #5
          how can I run it will explain pz...

          Comment


          • #6
            You can either run the query in phpMyAdmin or via the AdminCP.


            To run queries from the Admin CP:

            Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

            Then enter your query in the Manual Query box and click on 'Continue'.

            To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of includes/config.php:

            //****** USERS WITH QUERY RUNNING PERMISSIONS ******
            // The users specified here will be allowed to run queries from the control panel.
            // See the above entries for more information on the format.
            // Please note that the ability to run queries is quite powerful. You may wish
            // to remove all user IDs from this list for security reasons.
            $config['SpecialUsers']['canrunqueries'] = 'x';

            ...with x being your userid number.

            Comment


            • #7
              wooooooooooooooow many thanks.. I did it...it is goood now...let me kiss you

              Comment


              • #8
                You're welcome

                Comment

                Loading...
                Working...
                X