vb.org Archive
Page 5 of 7 « First 34 5 67
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Ban Ignored/Specified Users from Replying v2.0 (https://vborg.vbsupport.ru/showthread.php?t=60844)

Allan 02-18-2004 05:13 AM
veiled, always similar, to install on a virgin rc4 and always the same error, to afflict :ermm:

PHP Code:
Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
        SELECT 
        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
            language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
            language.phrasegroup_posting AS phrasegroup_posting,
            language.phrasegroup_postingbans AS phrasegroup_postingbans,
            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
        INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
        INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        WHERE user.userid = 1
    
mysql error: Champ 'language.phrasegroup_postingbans' inconnu dans field list

mysql error number: 1054

Date: Wednesday 18th of February 2004 08:12:40 AM 
I will like that somebody of other tests it because, I have to install it almost 10 times and I ever succeeded has to make it function ! :tired:

magnus 02-18-2004 10:06 AM
Socrate, do me a favor. Run this query:

[SQL]
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
[/SQL]

Tell me what it returns, I have a sneaking feeling this is the culprit..

Allan 02-18-2004 11:18 AM
Quote:
Originally Posted by magnus
Socrate, do me a favor. Run this query:

[SQL]
SELECT * FROM `phrasetype` WHERE phrasetypeid=152;
[/SQL]

Tell me what it returns, I have a sneaking feeling this is the culprit..
veiled, I have executer this request, to install without problem, but the result is the same one, error SQL

Another thing, I have to try to reinstall your hack this morning with the job, even sql error However, if one removes:

PHP Code:
'postingbans' 
to

PHP Code:
// get special phrase groups
$phrasegroups = array('threadmanage', 'posting', 'postingbans'); 
the hack functions put well has share the lack of text has this level (see screen)

magnus 02-18-2004 12:28 PM
Ok, obviously the problem is you haven't created the phrasegroup 'postingbans'. That's what all these errors are telling you.

This SQL query is the one that adds that:
[SQL]INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);[/SQL]

Are you using a prefix for your tables? If so, you may need to adjust the queries. I don't use additional languages on my forum, so I'm not sure if you need to include the "language.*" prefix.

In any event, this is undoubtedly your problem, as I stated before.

Allan 02-18-2004 12:37 PM
not, I do not employ a table prefixed

the request mentions above passed well, it are similar :(

Allan 02-23-2004 01:10 AM
I have to ask has a friend to test your hack, it also has the same problem as me to know the error sql, I am to afflict, but the hack does not function

magnus 02-24-2004 11:11 AM
Wait, are you asking me to have a friend install the hack? Or, are you telling me that you had a friend install the hack?

In any event, there's not really much more I can do to help unless you can create a temporary account on your system so I can check everything for myself. I'm 99.9% sure it's something simple, SQL related. I've installed this on 3 RC4 forums, and it worked fine.

magnus 03-06-2004 11:50 PM
Socrate, it just dawned on me what the problem was.

Run this query:
[SQL]
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
[/SQL]

That will fix your problem. I've gone ahead and updated the .TXT file.

Allan 03-07-2004 07:29 AM
Quote:
Originally Posted by magnus
Socrate, it just dawned on me what the problem was.

Run this query:
[SQL]
ALTER TABLE `language` ADD `phrasegroup_postingbans` MEDIUMINT NOT NULL;
[/SQL]

That will fix your problem. I've gone ahead and updated the .TXT file.
good, that still does not go (see screen1), the text does not appear.

I have thus to add the sentences in ACP STATE manually (via manager language, screen2) and the text appears (your requests sql for the addition of the sentences does not function apparement)

==================================================

a council, to remove these 4 requests :

PHP Code:
INSERT INTO `phrasetype` VALUES (152, 'postingbans', 'User-Defined Posting Bans', 3);

INSERT INTO `phrase` VALUES (17188, 0, 'banned_users', 'Banned Users', 152);

INSERT INTO `phrase` VALUES (17189, 0, 'banned_users_desc', 'List of users, separated by commas,  who cannot reply to this thread. (ie. user1,user2)', 152);

INSERT INTO `phrase` VALUES (17190, 0, 'banned_from_posting', 'You have been prohibited by the thread author from posting in this thread!', 1000); 
who seems to pose problems, and to replace them by manual installation of the sentences in the ACP ;)

magnus 03-12-2004 05:01 PM
UPGRADE FROM 1.0 INSTRUCTIONS

In NEWTHREAD.PHP:

Find:
PHP Code:
    $posticons = construct_icons(intval($newpost['iconid']), $foruminfo['allowicons']); 
Add BELOW:
PHP Code:
    // get ignore ids
    if ($bbuserinfo['ignorelist'])
    {
        $ignore_ids = explode(' ', trim($bbuserinfo['ignorelist']));
    }
    else
    {
    $ignore_ids = array();
    }

    $listusers = array();
    if (!empty($ignore_ids))
    {
        $users = $DB_site->query("
            SELECT userid, username FROM " . TABLE_PREFIX . "user
            WHERE userid IN (" . implode(',', $ignore_ids) . ")
            ORDER BY username
        ");
        while ($userinfo = $DB_site->fetch_array($users))
        {
            if ($userinfo['userid'] != 0)
            {
                if (in_array($userinfo['userid'], $ignore_ids))
                {
                    $listusers['ignore']["$userinfo[userid]"] = $userinfo['username'];
                }
            }
        }
    }

    $ignore_listbits = '';
    if (!empty($listusers['ignore']))
    {
        $_usercount = 0;
        foreach ($listusers['ignore'] AS $userid => $username)
        {
            $_usercount++;
            if ($_usercount > 1)
            {
                eval('$ignore_listbits .= ",$username";');
            } 
            else
            {
                eval('$ignore_listbits .= "$username";');
                }                
        }
    } 
In (template) NEWTHREAD:

Find:
HTML Code:
                                        <input type="text" class="bginput" size="25" name="bannedposters" id="$bannedposters" tabindex="1" /></label></div>
REPLACE with:
HTML Code:
                                        <input type="text" class="bginput" size="25" name="bannedposters" id="$bannedposters" value="$ignore_listbits" tabindex="1" /></label></div>


All times are GMT. The time now is 09:27 PM.
Page 5 of 7 « First 34 5 67
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.01173 seconds
  • Memory Usage 1,798KB
  • 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
  • (2)bbcode_html_printable
  • (6)bbcode_php_printable
  • (2)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
  • (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