Threadviews-Incorrect file format

[fedorama]

Hi ,

I backed up my database via SSH before, but when trying to back up again I got this message in my SSH client -



Confused, i then wandered into my admin panel and into the "Repair and Optimize" section and ran it, and, lo and behold, the first time I saw an error and it is the same problem that prevented me from backing up !



What caused this, how can I fix this, and continue backing up ?

I haven't done anything to the server, not sure why there is a problem with threadviews ...

HELP ME !

[Lynne]

This may help - http://www.vbulletin.com/forum/showt...ct+file+format
and http://www.vbulletin.com/forum/showt...ct+file+format

[fedorama]

Why, thank you Lynne.

Your assistance is most appreciated, guess I'll have to go to the boys at vb.com and read up on it !

--------------- Added [DATE]1217346815[/DATE] at [TIME]1217346815[/TIME] ---------------

Hi Lynne .. one more thing if you don;t mind !

I read the thread you mentioned, and looks like I have to run some Queries.

I logged in as Admin and tried executing a query and got a "You are not authorized to run mySQL queries" message.

How can this be when I'm Admin >?

[Lynne]

You actually need to put your userid into the config file to allow you to run queries (put in your userid in place of the "1"):

PHP Code:

 $config['SpecialUsers']['canrunqueries'] = '1'; 


[fedorama]

Hi lynne, sorry to badger !

Here is the line and how it appears in my config file .. apparently there is no "1", is this odd ?



Should I put my Admin username in between the apostrophes ?

[Lynne]

"1" is my userid on my site - I copied that line from my config file. You need to put your own userid inbetween those two apostophes.

[fedorama]

I also have "1" in other fields in my config file, like for "canviewadminlog" and "canpruneadminlog", they have "1" instead of an nothing.

So "1" is the Admin usergroup number right ? In the Usergroup section of my admin cp Admin usergroup is "id=6"

So by userid .. .a bit confused.

[Lynne]

No, you don't put in the usergroup id, you put in your actual userid. I am user number 1 on my site, so I have a 1 in all those fields so I can do anything. You should put your own userid into those fields (perhaps you are user number 1 also?).

[fedorama]

By User ID , is that User Name ?

Like Fedorama here ?

I had vBulletin install it on my server, so didn't set it up myself.

You can see in the below how some have "1" while the runquery field is empty.

[Lynne]

Originally Posted by fedorama

By User ID , is that User Name ?

Like Fedorama here ?

No, userid is your user number. Here is a link to your member page here:
https://vborg.vbsupport.ru/member.php?u=258484

You are user 258484, so that is your userid.

Mine is https://vborg.vbsupport.ru/member.php?u=65230

So my userid is 65230