Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Resetting thread views to zero
#1
Not Solved
Hello guys

Novice user here.

I have my installation at http://hardwaremana.com/

This is a relatively new installation but I don't know how but some threads are showing over 12K views which is unrealistic (the thread is a test thread).

I referred to this thread for my concerns - https://community.mybb.com/thread-65893.html

But when I execute the command on my cPanel, it gives the following error -
#1146 - Table 'hardware_mybb600.mybb_threads' doesn't exist

Here's what I actually did-

login to cPanel
go to myPHPadmin and selected the first database from the lest column
go to SQL tab and paste the command mentioned in the above-mentioned thread.
getting the error

I want to know how can I reset the thread views to zero.

Also, I cannot find the rebuild/recount thread views in the maintenance section.

Hoping for an explanatory reply. Thanks in advance.
Reply
#2
Not Solved
can you check database name & database tables prefix from config.php file in inc folder of your forum files server

$config['database']['database'] = 'XXXXXXXX';
$config['database']['table_prefix'] = 'YYYYYY_';
Reply
#3
Not Solved
(01-06-2018, 01:04 PM).m. Wrote: can you check database name & database tables prefix from config.php file in inc folder of your forum files server

$config['database']['database'] = 'XXXXXXXX';
$config['database']['table_prefix'] = 'YYYYYY_';

Here are the lines in the file-

$config['database']['database'] = 'hardware_mybb600';
$config['database']['table_prefix'] = 'mybbqq_';

I also have another question. Why does the system logs me out whenever I close the browser. I have selected the "remember me" option. Doesn't it mean it should store my login? Or is it normal. If not, how can I correct it? Thanks again. You are awesome!
Reply
#4
Not Solved
in the SQL queries ,
you have to replace mybb_ with mybbqq_ as later is the tables prefix used for your forum.

UPDATE `mybb_threads` SET `views` = '0'; 
needs to be changed to
UPDATE `mybbqq_threads` SET `views` = '0'; 

see also Common SQL Queries guidance
..............................................................
Reg. Remember Me related issue
in general which browser you use for working with your forum ?
Reply
#5
Not Solved
(01-07-2018, 06:23 AM).m. Wrote: in the SQL queries ,
you have to replace mybb_ with mybbqq_ as later is the tables prefix used for your forum.

UPDATE `mybb_threads` SET `views` = '0'; 
needs to be changed to
UPDATE `mybbqq_threads` SET `views` = '0'; 

see also Common SQL Queries guidance
..............................................................
Reg. Remember Me related issue
in general which browser you use for working with your forum ?

Thanks for the update.

I use both opera and firefox for the forum. Both are up to date and configured to accept cookies.
Reply
#6
Not Solved
Bump. Please help me here. The initial users are making complaints about it.
Reply
#7
Not Solved
^ does Remember Me work fine if you use MyBB's stock theme ?

can you provide a test user account ..
or you may PM me temporary access to forum admin panel
Reply
#8
Not Solved
I have not tried with the stock theme.

PM sent.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)