vb.org Archive
Page 41 of 64 « First 313940 41 424351 Last »
Show 40 post(s) from this thread on one page

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?


All times are GMT. The time now is 07:36 PM.
Page 41 of 64 « First 313940 41 424351 Last »
Show 40 post(s) from this thread on one page

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.01598 seconds
  • Memory Usage 1,748KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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