the only one I have found is "threadsread_users", would that be it?
^ no. there should be something else before
threadsread_users (eg.
xyz_threadsread_users)
or you can see the database tables prefix in ~/inc/config.php file (around line 12)
$config['database']['table_prefix'] = 'mybb_';
you may be having something else instead of
mybb_
(2015-01-09, 09:58 AM).m. Wrote: [ -> ]^ no. there should be something else before threadsread_users (eg. xyz_threadsread_users)
or you can see the database tables prefix in ~/inc/config.php file (around line 12)
$config['database']['table_prefix'] = 'mybb_';
you may be having something else instead of mybb_
In config.php i see this:
$config['database']['table_prefix'] = '';
Does this mean that the table I am looking for is "users"? I have searched for all the tables containing "user" in the name and I got this:
Threadsread_users
Userfileds
usergroups
users
usertitles
^ hmm., no prefix is used for your forum database tables. so your required SQL queries will be like below
ALTER TABLE `users` CHANGE `showimages` `showimages` tinyint(1) NOT NULL default '1';
UPDATE `users` SET `showimages` = '1' WHERE `showimages` = '0';
ALTER TABLE `users` CHANGE `showvideos` `showvideos` tinyint(1) NOT NULL default '1';
UPDATE `users` SET `showvideos` = '1' WHERE `showvideos` = '0';
HURRAH!!!! It worked!!! Thanks very much
(2015-01-03, 12:54 PM).m. Wrote: [ -> ]SQL queries if required
ALTER TABLE `mybb_users` CHANGE `showimages` `showimages` tinyint(1) NOT NULL default '1';
UPDATE `mybb_users` SET `showimages` = '1' WHERE `showimages` = '0';
common SQL queries
I ran both above displayed queries succesfully. But still no image shown
(
(2016-11-04, 04:10 PM)trebe Wrote: [ -> ] (2015-01-03, 12:54 PM).m. Wrote: [ -> ]SQL queries if required
ALTER TABLE `mybb_users` CHANGE `showimages` `showimages` tinyint(1) NOT NULL default '1';
UPDATE `mybb_users` SET `showimages` = '1' WHERE `showimages` = '0';
common SQL queries
I ran both above displayed queries succesfully. But still no image shown (
Me either. Didn't work at all. Please help.
Nevermind. I figured it out.