MyBB Community Forums

Full Version: Resetting thread views to zero
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
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_';
(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!
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 ?
(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.
Bump. Please help me here. The initial users are making complaints about it.
^ 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
I have not tried with the stock theme.

PM sent.