Run Query?

[Tipi]

How do I do that? :nervous:

[Dean C]

You can find a lot out just by reading the manual

http://www.vbulletin.com/docs/html/maintenance_query

[Borgs8472]

You'll have to log onto your SQL manager. It's scary for newbie. Just do what the hacks tell you and don't press any other buttons....

[Tipi]

Cheezes! I think I'll just use the modules that don't require any Run Query. :surprised:

Thanks for you're help!

[peterska2]

You can edit your config.php file to allow you to run queries directly from your ACP. This is the way that I usually do it.

Find the line that says $canrunquery = '' and add your userid number between the ''.

Then in your ACP in the Maintanence section you will see a section entitled 'Execute SQL Query' Go into there and simply put the query text that you have been given into the box that comes up. Keep clicking OK on each step. If there is any problems it tells you.

I don't think you will find many mods that don't involve extra queries as they all require different things.

[Tipi]

Sweet! I'll try it. Thanks peterska2!

[Tipi]

Yahoo, you are the best peterska! *jumping up and down*

[Xenon]

more help on that topic:

[sql]-[/sql]

[peterska2]

Originally Posted by Tipi

Yahoo, you are the best peterska! *jumping up and down*

[high] * peterska2 takes a bow[/high]

Your welcome

[Tipi]

Here I am again. :nervous:

I'm going to install Who was online today-mod, and I have to run query.

This is what the textfile says

******************************
RUN THIS QUERY (IF YOU HAVEN'T RAN
THE INSTALLER.PHP FILE BEFORE)
******************************
INSERT INTO datastore (title, data) VALUES ('todaymaxonline', 'a:2:{s:14:\"todaymaxonline\";i:1;s:18:\"todaymaxo nlinedate\";i:1070000000;}')

"RUN THIS QUERY".. What query? "Insert into datastore.." etc?? Is that the query? Oh dear lord, I don't know why I even bother to try, I'm not cut out for this.