vb.org Archive - vBug Tracker 1.0.3

Page 14 of 20

« First

Last »

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)

- - vBug Tracker 1.0.3 (https://vborg.vbsupport.ru/showthread.php?t=69600)

tkeil69575

11-26-2004 11:27 PM

as far as I can see this line

LEFT JOIN user ON (vbugs.userid = user.userid)

should read

LEFT JOIN user AS user ON (vbugs.userid = user.userid)

at least it fixed the mysql error I got when I first called vbugs.php

regards
Tina

ps. has to be fixed in 2 instances in vbugs.php

peterska2

11-26-2004 11:33 PM

I've tried that already but it didn't have any effect

tkeil69575

11-27-2004 12:44 AM

Quote:

Originally Posted by peterska2

I've tried that already but it didn't have any effect

peterska2 ... the fix i mention does not relate to your problem. i'd say you have missing templates or something like that ... id probably uninstall and try again ... probably something went wrong during the install.

tina

The Wise One

11-27-2004 01:22 AM

Quote:

Originally Posted by tkeil69575

thanks for that :) unfortunately...it didnt fix my problem (thats assuming you posted that possible fix in response to my post).

peterska2

11-27-2004 09:13 PM

Quote:

Originally Posted by tkeil69575

Damn,

I guess I'd best drop the table prefix throughout the vB and start again from scratch eh?

john_rsd

11-28-2004 01:27 AM

I have set general permissions in usergroups for those who can / cannot post to bugtracker.

but I would have liked to have kept it private using forum password or just using custom usergroup settings on that forum pointing to vbugs.php

If i tell the forum to have password it is not applied. I can access the forum anytime even with password set.

I cannot define custom usergroup settings either per forum. So it is not possible for me to exclude groups.

Is this by design?

Small example 1. I have guests set in default usergroup premissions as being able to add bugs/see bugs.

For now i want to keep forum private for testing.

So I edit the guest usergroup in that forum and change the forum permissions to custom and leave only view forum=yes, but turn off all other options (see others threads, post et all)

I do not see any possiblity for custom settings for vbugs here.

Guests can still see, post, add bugs without a problem!

Small example 2. I have password set for forum to which points to vbugs.php.

For now i want to keep forum private for testing.

So I set password

Guests can still see, post, add bugs without a problem! No password required.

Possible I am missing something simple here?

Dark_Wizard

01-06-2005 06:32 PM

Ok...I'm back, after my cruise and the holidays I will start on the next version for those few little bugs. I am also going to complete the Pro version which can be obtained only from vbwar.com...

Next release will have all of the table prefixes redone....

PixelFx

01-06-2005 07:49 PM

Please let me know as soon as its out, and what paypal to use... glad ya had a good vacation.

if you need beta testers my team is very good at finding bugs...

Abe1	01-07-2005 01:13 AM

Here is a real bug:

When an admin chooses to make a bug 'private' when he is making a new bug, it doesn't make the bug private. You have to edit the bug after to make it private.

Here is the solution to fix it:

Find:

PHP Code:


		
			
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT));

Replace with:

PHP Code:


		
			
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT, 'private' => INT));

Find:

PHP Code:


		
			
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid) 

    VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid])

Replace with:

PHP Code:


		
			
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid, private) 

    VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid], '$private')

Basicly, you forgot to make the 'do=insert' add the private variable.

For thouse who don't realize, the file I'm talking about is: vbugs.php

Eric1776

01-07-2005 04:39 PM

When trying to do a search I get this error.

Code:

Database error in vBulletin 3.0.5:



Invalid SQL: 

        SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.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 AND MATCH (title, description) LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'

        ORDER BY lastedit desc

        LIMIT 0, 20

        

mysql error: You have an error in your SQL syntax near 'LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'

        ORDER' at line 12



mysql error number: 1064



Date: Friday 07th of January 2005 01:43:20 PM

Script: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=test&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc

Referer: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc

Username: Aragorn

IP Address: 160.136.49.104

All times are GMT. The time now is 10:51 PM.

Page 14 of 20

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01150 seconds Memory Usage 1,770KB 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 (4)bbcode_php_printable (3)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
Messages: