Please help >>> Database error

[MGRO7YN]

How er you first >>> I was not able to develop objective of this Section problems ... I do not know why ... And that's here. Please warm you find me a solution to the problem of search engine Forum ... And this is wrong. Please help

http://00op.com/up/uploads06-12-16/453c594a65.png



Database error in vBulletin 3.6.4:Invalid SQL: SELECT * FROM search AS search
WHERE searchhash = '4dd9278c41b471abb15fec899f6f6886'
AND userid = 1
AND completed = 1;MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Tuesday, January 2nd 2007 @ 09:42:52 PM
Script : http://www.XXXXX.com/vb/search.php?do=process
Referrer : http://www.XXXXX.com/vb/search.php
IP Address : XXXXXUsername : XXXXXClassname : vb_database

:( :( Please help >>>

[Steve Machol]

Run this query to add that field to the search table:

ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1'

[MGRO7YN]

Run this query to add that field to the search table:

ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1'


Thank you very rapid response ... But I am gun :o :( ... Where can I find what you spoke to :o ... Please give me the steps in detail ... Thank you

[Steve Machol]

You can run queries in the SQL tab in phpMyAdmin, or 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 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.
$canrunqueries = 'x';

...with x being your userid number.

[MGRO7YN]

I will try and tell you what happened ...

[MGRO7YN]

:mad: I am sorry ... I can not apply what you wrote to me ... I am very beginning:o :confused: ... If you had pictures of the application of the solution:( ... I would be very grateful to you ... I am waiting for you ...?

[MGRO7YN]

:( :o :( :o :confused: :confused: :o :( :o :(

[Mazinger]

Avoid useless posts and post in the appropriate support forum for your version, please. :)

[Steve Machol]

To get vB support on these forums you first need to be a licensed customer and register for Priority Forum Support. To do this, please go here:

http://members.vbulletin.com/membersupport_priority.php

...and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page.

Once you've done this, please post in the appropriate support forum for your version.