Data Base Erro-Can U help

[azan]

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

[Boxy]

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

Run this query to add that column:

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

[azan]

no I did not upgrade recently

[Boxy]

Run the query above to add the missing column back in.

[azan]

how can I run it will explain pz...

[Boxy]

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.

[azan]

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

[Boxy]

You're welcome