vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBug Tracker 1.0.3 (https://vborg.vbsupport.ru/showthread.php?t=69600)

Mattius 09-21-2004 01:26 AM

that b good question indeed

Scutter 09-21-2004 03:53 AM

Nice work dark, that got it. I now have the following problem, it displays fine when logged on as admin, but when logged on as a user with view and add permissions only, the screen looks like this...

d3f 09-21-2004 04:11 AM

Installed 1.0.1 had some errors followed the instructions to get to 1.0.2 but had a db error on each step, now im getting lots of..

PHP Code:

WarningDivision by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 123

Warning
Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 1730

Invalid SQL

    
SELECT DISTINCT vbug_severity.severitynamevbug_type.typenamevbug_version.versionnamevbug_status.statusnamevbugs.*, admin.username AS adminnameuser.usernameuser.usertitlelastreply.username AS lastreplyname 
    FROM vbugs
    LEFT JOIN vbug_status ON 
(vbugs.vbug_statusid vbug_status.vbug_statusid)
    
LEFT JOIN user AS admin ON (vbugs.adminid admin.userid)
    
LEFT JOIN user ON (vbugs.userid user.userid)
    
LEFT JOIN user AS lastreply ON (vbugs.lastreplyuid lastreply.userid)
    
LEFT JOIN vbug_type ON (vbugs.vbug_typeid vbug_type.vbug_typeid)
    
LEFT JOIN vbug_version ON (vbugs.vbug_versionid vbug_version.vbug_versionid)
    
LEFT JOIN vbug_severity ON (vbugs.vbug_severityid vbug_severity.vbug_severityid)
    
    
WHERE 1
    ORDER BY lastedit desc
    LIMIT 0

    
mysql errorYou have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13

mysql error number
1064 

and

PHP Code:

WarningDivision by zero in /home/methlabs/domains/methlabs.org/public_html/forums/admincp/vbugs_admin.php on line 177 

ect, any help would be really apreciated.

Dark_Wizard 09-21-2004 09:49 AM

Quote:

Originally Posted by sinclac
To upgrade to 1.0.2 do we need to do all the edits and every thing in the install text?

In the install.txt file are instructions to upgrade from earlier versions.

Dark_Wizard 09-21-2004 09:51 AM

Quote:

Originally Posted by d3f
Installed 1.0.1 had some errors followed the instructions to get to 1.0.2 but had a db error on each step, now im getting lots of..

PHP Code:

WarningDivision by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 123

Warning
Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 1730

Invalid SQL

    
SELECT DISTINCT vbug_severity.severitynamevbug_type.typenamevbug_version.versionnamevbug_status.statusnamevbugs.*, admin.username AS adminnameuser.usernameuser.usertitlelastreply.username AS lastreplyname 
    FROM vbugs
    LEFT JOIN vbug_status ON 
(vbugs.vbug_statusid vbug_status.vbug_statusid)
    
LEFT JOIN user AS admin ON (vbugs.adminid admin.userid)
    
LEFT JOIN user ON (vbugs.userid user.userid)
    
LEFT JOIN user AS lastreply ON (vbugs.lastreplyuid lastreply.userid)
    
LEFT JOIN vbug_type ON (vbugs.vbug_typeid vbug_type.vbug_typeid)
    
LEFT JOIN vbug_version ON (vbugs.vbug_versionid vbug_version.vbug_versionid)
    
LEFT JOIN vbug_severity ON (vbugs.vbug_severityid vbug_severity.vbug_severityid)
    
    
WHERE 1
    ORDER BY lastedit desc
    LIMIT 0

    
mysql errorYou have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13

mysql error number
1064 

and

PHP Code:

WarningDivision by zero in /home/methlabs/domains/methlabs.org/public_html/forums/admincp/vbugs_admin.php on line 177 

ect, any help would be really apreciated.

You didn't set the vBug Options in the admin control panel

Dark_Wizard 09-21-2004 10:04 AM

Quote:

Originally Posted by Scutter
Nice work dark, that got it. I now have the following problem, it displays fine when logged on as admin, but when logged on as a user with view and add permissions only, the screen looks like this...

Edit your VBUGS template with the following:

find this:
Code:

$buglist
</tr></table>

change to this:
Code:

$buglist
</table>

Replace the entire contents of the vbugs_listbit with the following:
Code:

<tr>
        <if condition="$admin">
        <td class="alt1">$vbugs_id</td>
        <td class="alt2">
                <div>
                <span style="float:right"></span>
                <a href="vbugs.php?do=view&amp;vbugs_id=$bug[vbugs_id]">$title</a></span>
                $moderateicon $privateicon $unassignedicon
                </div>
        <else />
        <td class="alt1">$vbugs_id</td>
        <td class="alt2">
                <div>
                <span style="float:right"></span>
                <a href="vbugs.php?do=view&amp;vbugs_id=$bug[vbugs_id]">$title</a>
                </div>
        </if>
                <div class="smallfont">
                        <span style="float:right">$date <span class="time">$time</span></span>
                        <strong onclick="window.location='member.php?u=$bug[userid]';" style="cursor:pointer">$username</strong>
                </div>
        </td>
        <td class="alt1"><span class="smallfont">$typename: <strong>$statusname</strong><br /><em><if condition="$bug[adminid]">$adminname<else />$vbphrase[vbugs_unassigned]</if></em></span></td>
        <td class="alt2"><div class="smallfont" style="white-space:nowrap">$lastreplydate <span class="time">$lastreplytime</span></div><div class="smallfont">by <a href="member.php?u=$bug[lastreplyuid]">$lastreplyname</a></div></td>
</tr>


Scutter 09-21-2004 10:33 AM

thanks vm

Dark_Wizard 09-21-2004 10:48 AM

Quote:

Originally Posted by Scutter
thanks vm

your welcome....

Boofo 09-21-2004 10:55 AM

When I try to upgrade from version 1.0, I keep getting db errors for tables and settings and phrases that are already there. Duplicate. How do I upgrade without getting those? ;)

It seems I am running 1.0 beta version for some reason. How do I upgrade from that? ;)

Dark_Wizard 09-21-2004 11:01 AM

Quote:

Originally Posted by Boofo
When I try to upgrade from version 1.0, I keep getting db errors for tables and settings and phrases that are already there. Duplicate. How do I upgrade without getting those? ;)


You shouldn't be getting that...it detects you earlier version and upgrades only whats needed...I just ran the script on another site and it works for me...can you PM me with more details?


All times are GMT. The time now is 03:30 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.01247 seconds
  • Memory Usage 1,788KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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