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)
-   -   vBadvanced Homepage (https://vborg.vbsupport.ru/showthread.php?t=59803)

Alien 03-21-2004 04:58 AM

No problem at all! :)

deathemperor 03-21-2004 10:20 AM

I haven't changed anything of the installation steps, just do the 3rd step and reinstall the template and Vbadvanced is ready for Gold ^ ^

hockyfan 03-21-2004 01:54 PM

So installing this clean on Gold should work fine?

h

a43079 03-21-2004 02:14 PM

I installed VBA but i cant login via VBA would anyone be able to point me in the right direction i login and it accepts my name but it resets back as if i am a guest the rest of the board works fine..

SnowBot 03-21-2004 02:30 PM

aarrggg on a hacked board im having a problem :(

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
,thread.iconid
,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
WHERE forumid IN(27,28,29,30)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous




Any help would be great.

It installs fine but as soon as i put the NEWS forum ID's in i get this error :(

LeeCHeSSS 03-21-2004 03:27 PM

Quote:

Originally Posted by SnowBot
aarrggg on a hacked board im having a problem :(

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
,thread.iconid
,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
WHERE forumid IN(27,28,29,30)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous




Any help would be great.

It installs fine but as soon as i put the NEWS forum ID's in i get this error :(

For all the other folks running Tigga's vBadvanced: change filesize to attachment.filesize

Or use a better portal...

Tigga 03-21-2004 03:35 PM

Quote:

Originally Posted by LeeCHeSSS
For all the other folks running Tigga's vBadvanced: change filesize to attachment.filesize

Or use a better portal...

Or use the latest version, rather than an older one that was designed for vB3 Beta. :rolleyes:

SnowBot 03-21-2004 03:36 PM

THANKS to LeeCHeSSS its all fixed :)

SnowBot 03-21-2004 03:38 PM

Quote:

Originally Posted by Tigga
Or use the latest version, rather than an older one that was designed for vB3 Beta. :rolleyes:

I used version 1.1

Is this not the latest?

Tigga 03-21-2004 03:46 PM

That couldn't be v1.1 if you were getting that error. That query was changed for v1.1 (IIRC) after vB3 Gamma was released and the filesize column was added to the customavatar table, and was no longer unique to the attachment table.


All times are GMT. The time now is 03:27 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.01979 seconds
  • Memory Usage 1,740KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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