vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Moderators Functions - Force Users to Read a Thread (https://vborg.vbsupport.ru/showthread.php?t=151737)

mc0676 03-05-2008 12:08 PM

OK, than it's not a mine problem.

Saviour 03-05-2008 12:15 PM

Abe...

Just uninstalled and installed the new version. I'm getting a database error page when clicking on the Force Read Thread link in the ACP.

Any idea what's causing this?

I have vB 3.6.8 PL2 installed.

Saviour 03-05-2008 12:26 PM

Just made sure...went over everything twice...same issue.

Still getting the Database error page.

Here's the error:

Code:

Database error in vBulletin 3.6.8:
 
Invalid SQL:
 
  SELECT  administrator.*,
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_thread AS phrasegroup_thread,
    language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
    language.phrasegroup_prefix AS phrasegroup_prefix,
    language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
    language.phrasegroup_global AS phrasegroup_global,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep
 
  FROM user AS user
  LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
 
  WHERE user.userid = 1;
 
MySQL Error  : Unknown column 'language.phrasegroup_prefix' in 'field list'
Error Number : 1054
Date        : Wednesday, March 5th 2008 @ 08:06:59 AM
Script      : http://www.xxxxxx.com/forums/admincp/force_read_thread.php
Referrer    : http://www.xxxxxx.com/forums/admincp/index.php?do=nav
IP Address  :
Username    :
Classname    : vb_database


Abe1 03-05-2008 12:32 PM

Quote:

Originally Posted by Saviour (Post 1457560)
Just made sure...went over everything twice...same issue.

Still getting the Database error page.

Anyone can post the query and error? Right click and show source.

Biggles 03-05-2008 12:34 PM

I'm getting the same error too, Abe1. I am also running vB 3.6.8 PL2.

Database error message reads as follows:

MySQL Error : Unknown column 'language.phrasegroup_prefix' in 'field list'
Error Number : 1054
Date : Wednesday, March 5th 2008 @ 09:21:29 AM
Script : http://www.xxxxxxxxxxxxxx.com/forums...ead_thread.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...dex.php?do=nav
IP Address : 81.153.66.74
Username :
Classname : vB_Database


Please advise. I like the concept but can't use it yet. :(

Biggles

Saviour 03-05-2008 12:38 PM

Abe...look at my previous post.

Abe1 03-05-2008 12:48 PM

I think i got it. Just a file change. Will update in a few min. Only effects vb3.6.x users.

mc0676 03-05-2008 12:57 PM

Abe1 i've uninstalled this mod and i attend correction of the error but WHY i receive THIS error after i've unistalled ?!?!!?!?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_thread AS thread
LEFT JOIN vb_force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '418')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1204728706') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-25-%' OR force_read_usergroups LIKE '%-26-%' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table 'vwgolfcommunity_com_vb.vb_force_read_users' doesn't exist
Error Number : 1146
Date : Wednesday, March 5th 2008 @ 03:51:46 PM
Script : http://www.vwgolfcommunity.com/vbull...gc_chatbox.php
Referrer : http://www.vwgolfcommunity.com/vbulletin/index.php
IP Address : 79.7.143.76
Username : diac82
Classname : vB_Database

Abe1 03-05-2008 01:01 PM

Zip file updated. admincp/force_read_thread.php file updated to fix error for vb3.6.x users.

Abe1 03-05-2008 01:03 PM

Quote:

Originally Posted by mc0676 (Post 1457586)
Abe1 i've uninstalled this mod and i attend correction of the error but WHY i receive THIS error after i've unistalled ?!?!!?!?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_thread AS thread
LEFT JOIN vb_force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '418')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1204728706') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-25-%' OR force_read_usergroups LIKE '%-26-%' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table 'vwgolfcommunity_com_vb.vb_force_read_users' doesn't exist
Error Number : 1146
Date : Wednesday, March 5th 2008 @ 03:51:46 PM
Script : http://www.vwgolfcommunity.com/vbull...gc_chatbox.php
Referrer : http://www.vwgolfcommunity.com/vbulletin/index.php
IP Address : 79.7.143.76
Username : diac82
Classname : vB_Database

Do you have some hack that caches plug-ins?

Saviour 03-05-2008 01:12 PM

Abe...seems to be working now.

Question...

Only Aministrators have permissions? How about Moderators, or Super Mods? Where is this permission set?

Abe1 03-05-2008 01:12 PM

Quote:

Originally Posted by Saviour (Post 1457597)
Abe...seems to be working now.

Question...

Only Aministrators have permissions? How about Moderators, or Super Mods? Where is this permission set?

No option for them now. Only admins.

Saviour 03-05-2008 01:29 PM

Okay...thanks.

Biggles 03-05-2008 01:38 PM

The update has now enabled me to overcome the database error, Abe1, but I can't seem to add a thread.

I tried using thread ID '1' for all usergroups, etcetera. The system said the addition was successful but it doesn't show up as displayed in your second image above and, if I go back to Force Users link in Threads and Posts I just get the empty file page without any listed threads shown.

I also tried re-installing the product, selecting overwrite, but that did not fix this problem.

Biggles

DannyITR 03-05-2008 02:09 PM

Any chance of getting an answer to this problem?

https://vborg.vbsupport.ru/showpost....&postcount=371

rob4448585 03-05-2008 02:15 PM

does it still work with VBadvanvced?

Thank you for a great hack

and when unistalling, do i need to go and undo the template changes?

Abe1 03-05-2008 02:18 PM

Quote:

Originally Posted by Biggles (Post 1457608)
The update has now enabled me to overcome the database error, Abe1, but I can't seem to add a thread.

I tried using thread ID '1' for all usergroups, etcetera. The system said the addition was successful but it doesn't show up as displayed in your second image above and, if I go back to Force Users link in Threads and Posts I just get the empty file page without any listed threads shown.

I also tried re-installing the product, selecting overwrite, but that did not fix this problem.

Biggles

Interesting. Would I be able to look at your ACP?

Also, the link in the thread should have been removed when you uninstall. The link page it not suppose to work.

Abe1 03-05-2008 02:19 PM

Quote:

Originally Posted by rob4448585 (Post 1457633)
does it still work with VBadvanvced?

Thank you for a great hack


and when unistalling, do i need to go and undo the template changes?

Yes to the template removal.

You can set in the ACP settings what to exclude.

Abe1 03-05-2008 02:20 PM

Quote:

Originally Posted by DannyITR (Post 1457622)
Any chance of getting an answer to this problem?

https://vborg.vbsupport.ru/showpost....&postcount=371

First should not happen any more.

Second, not if you dont reset also.

luckid 03-05-2008 02:21 PM

not work for me ... when add New Thread and save not compare on list !!!!

VB 3.6.8

Whi???

Abe1 03-05-2008 02:25 PM

Quote:

Originally Posted by luckid (Post 1457640)
azzz. dont not unistall old version

https://vborg.vbsupport.ru/

How tu remove this line????

Tnx in advance

Search for "force" in templates and it should bring you to the template edit that you have to remove when uninstalling the old version.

DannyITR 03-05-2008 02:27 PM

Quote:

Originally Posted by Abe1 (Post 1457638)
First should not happen any more.

Second, not if you dont reset also.

Thanks so much. I will upgrade.

Biggles 03-05-2008 02:28 PM

Quote:

Originally Posted by Abe1 (Post 1457635)
Interesting. Would I be able to look at your ACP?

Also, the link in the thread should have been removed when you uninstall. The link page it not suppose to work.

I have completely uninstalled the hack and am about to try a complete new install, Abe.

I have no problem at all with you looking at my ACP, of course, but let me try a new install first. If that doesn't work, I'll PM you with details of how to access the ACP. Back soon.

Thanks for your interest, btw. :up:

Biggles

luckid 03-05-2008 02:41 PM

this ok remove ;)

but not work for me ... when add New Thread and save not compare on list !!!!

VB 3.6.8

Whi???

Biggles 03-05-2008 02:45 PM

Hi Abe

I tried a complete new install and that didn't fix the prob, unfortunately. I've PMed you with ACP access details.

Thanks

Biggles

rob4448585 03-05-2008 02:47 PM

Quote:

Originally Posted by luckid (Post 1457657)
this ok remove ;)

but not work for me ... when add New Thread and save not compare on list !!!!

VB 3.6.8

Whi???

correct, i just tried it too, and when you go ahead and add a new thread, it doesnt save it on the admin cp so you cant remove it,

and also the thread wont be forced to read :(

Abe1 03-05-2008 03:13 PM

Zip file updated (again). admincp/force_read_thread.php file updated to fix error of not adding the force read.

odeezie 03-05-2008 03:18 PM

Quote:

Originally Posted by Abe1 (Post 1457641)
Search for "force" in templates and it should bring you to the template edit that you have to remove when uninstalling the old version.

Thanks Abe! That was my problem, and searching "force" in the Showthread template took me right to the code. I removed it, and the radio button is gone.

Thanks again, that was very simple, even for someone who does not know anything about code. :)

mariocaz 03-05-2008 03:25 PM

Wow thank you for the update!!

and the update works in 3.6.8 pl2 ??

also how can I uninstall the mod ???, to update to the new version.

Thank you in advance!

Mario

Biggles 03-05-2008 03:41 PM

Abe, I tried uploading just the amended admincp file but it hasn't fixed the problem. Should I uninstall again and try yet another new install - or just give up? :eek:

Biggles

Abe1 03-05-2008 04:18 PM

Quote:

Originally Posted by Biggles (Post 1457715)
Abe, I tried uploading just the amended admincp file but it hasn't fixed the problem. Should I uninstall again and try yet another new install - or just give up? :eek:

Biggles

I just tried again but it seems like you took the permission away.

BigDog56 03-05-2008 04:21 PM

Just updated, checked it, seems to work just fine. Thank you!

Sierra Oscar 03-05-2008 04:22 PM

Thanks for the update Abe1 - will install later.:)

mariocaz 03-05-2008 04:24 PM

Quote:

Originally Posted by mariocaz (Post 1457700)
Wow thank you for the update!!

and the update works in 3.6.8 pl2 ??

also how can I uninstall the mod ???, to update to the new version.

Thank you in advance!

Mario

Please. :)

rob4448585 03-05-2008 05:06 PM

works fine now, i uploaded the two files again

then uninstalled the product and then installed the newer version again

works fine with 3.6.8

thanks abe

great mod!!!

Biggles 03-05-2008 05:11 PM

Quote:

Originally Posted by Abe1 (Post 1457750)
I just tried again but it seems like you took the permission away.

Sorry Abe. I thought you had finished. I am resetting your username as I speak.

Biggles

360junkie 03-05-2008 07:52 PM

Quote:

Originally Posted by Digital Jedi (Post 1457354)
Yes, there's quite a few warnings in this thread that warn not to delete Force Read threads.

Well i still need help

Abe1 03-05-2008 09:10 PM

Quote:

Originally Posted by 360junkie (Post 1457893)
Well i still need help

What do you mean need help?

There in no more a threat to delete threads in the latest version.

360junkie 03-05-2008 09:30 PM

Quote:

Originally Posted by Abe1 (Post 1457935)
What do you mean need help?

There in no more a threat to delete threads in the latest version.

ok how do i make people have 2 look at it on the new one

Abe1 03-05-2008 10:00 PM

Quote:

Originally Posted by 360junkie (Post 1457950)
ok how do i make people have 2 look at it on the new one

In your ACP, under threads and posts.


All times are GMT. The time now is 03:03 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01968 seconds
  • Memory Usage 1,839KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete