vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Nu Torrent Tracker 0.74 (https://vborg.vbsupport.ru/showthread.php?t=82635)

yoyoyoyo 06-08-2005 02:27 PM

Everything seemed to install fine, however when I went to upload a torrent file I got this error:

Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE threadid = 2165 AND post.visible = 1
ORDER BY dateline ASC
LIMIT 1

mysql error: Unknown column 'level' in 'field list'

mysql error number: 1054

Date: Wednesday 08th of June 2005 10:23:31 AM
Script: http://mysite.com/nutt/details.php?t=1&uploaded=1
Referer: http://mysite.com/nutt/upload.php
Username: ADMINISTRATOR
IP Address: 67.00.200.205

afusion 06-08-2005 02:38 PM

try the details.php in the new zip

Outdoor 06-08-2005 04:30 PM

in NUTT template you still have 1 hard coded link, it is who's online that links back to your website.

afusion 06-08-2005 04:44 PM

Thanks for the notice, updated the zip.

Outdoor 06-08-2005 05:11 PM

having one other problem, in the navbar on the Nutt pages it always has mywebsite/nutt/index.php when trying to get back into the forum, mywebsite/nutt/memberlist.php when trying to access my forum memberlist. Not sure what setting to change for it.

thanks again, looks very nice, can't wait to get a torrent going

afusion 06-08-2005 05:28 PM

Ok, I added a function to fix the urls. Update to 0.72 with functions.php and nutt_global.php changed.

Outdoor 06-08-2005 05:47 PM

looks good, thanks again

yoyoyoyo 06-08-2005 06:16 PM

that fixed the errors.. thanks much! works great! However, I tried deleting the upload that got a database error via the NUTT maintenance php, but nothing was deleted, it was still listed as an "unseeded" torrent. Is there any way to reset all of the uploads, including unseeded torrents? Also the ability to add comments, etc. seems to be not working in this version for some reason.

afusion 06-08-2005 06:25 PM

The only deletion option in nutt_maintenance is to delete all threads generate by NuTT. To delete the torrent itself you have to make sure you got the permissions to do so (Usergroup Permissions) and do it via the details page, in the bottom there should be an edit area.

And the comments don't work how exactly? The New Comment link is broken or... ?

yoyoyoyo 06-08-2005 06:39 PM

Quote:

Originally Posted by afusion
The only deletion option in nutt_maintenance is to delete all threads generate by NuTT. To delete the torrent itself you have to make sure you got the permissions to do so (Usergroup Permissions) and do it via the details page, in the bottom there should be an edit area.

And the comments don't work how exactly? The New Comment link is broken or... ?

When I click on the "new comment" link I am taken back to the main NuTT page instead. Also- I tried logging in to the tracker from a remote computer to test the download/connection, and when I click on the NUTT forum link I am taken to a login page, and when I enter the login details I am taken to an error page.


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.01261 seconds
  • Memory Usage 1,741KB
  • 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_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