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 -

https://vborg.vbsupport.ru/external/2008/07/9.jpg

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 !

https://vborg.vbsupport.ru/external/2008/07/10.jpg

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/showthread.php?t=278219&highlight=incorrect+file+format
and http://www.vbulletin.com/forum/showthread.php?t=275458&highlight=incorrect+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 1217346815 at 1217346815 ---------------

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"):
$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 ?

https://vborg.vbsupport.ru/external/2008/07/8.jpg

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.

https://vborg.vbsupport.ru/external/2008/07/7.jpg

[Lynne]

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

[fedorama]

Oh I see now !

USERID is just a numerical chronological figure for registrations.

In that case, I'm sure I'm "1" as I'm Admin and first registration .... I have vbSEO on my site, so clicking on member profiles doesn't show the "userid" like here.

--------------- Added 1217351214 at 1217351214 ---------------

BINGO !

Now have access to Queries by adding "1".

Thanks lynne !

Now to go bother vb.com with their "Query" commands !

[Lynne]

Glad you got it figured out! You can also see the userids by going to your Admin CP and searching on the user. When the user screen comes up, the userid is listed at the top.

[Nocturnal222]

Glad you got it figured out! You can also see the userids by going to your Admin CP and searching on the user. When the user screen comes up, the userid is listed at the top.

is this applicable to version 4.x.x?

[Lynne]

is this applicable to version 4.x.x?
Viewing the userid in the User panel of the Admincp? Yes.