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)

kneesparx 02-18-2004 10:01 AM

im getting these errors:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('home_navbar', 'vbadv_index', '1', '1', 'yesno', '33', '0', '0')
mysql error: Duplicate entry 'home_navbar' for key 1

mysql error number: 1062

and

Database error in vBulletin 3.0.0 Release Candidate 4:

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(124)
GROUP BY post.postid
ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous

mysql error number: 1052

Tigga 02-18-2004 02:37 PM

RaZor Edge - I believe this mod at vBa.com would help you - http://www.vbadvanced.com/forum/showthread.php?t=145

Arura - Yes, this uses the vB database and user accounts.

kneesparx - You should upgrade to the latest version of vBa Homepage. Or, if you search this thread for filesize then you will find your answer. ;)

kneesparx 02-18-2004 07:42 PM

look like i have to uninstall this hack after my upgrade to Rc4 :( my board is down, i cant afford the downtime :( it was cool when it lasted, when this hack gets updated to work with RC4 better, i might give it a shot..

Tigga 02-18-2004 07:54 PM

The hack has been updated to work with RC4. Read my previous reply.

kneesparx 02-18-2004 08:00 PM

sorry tigga, i missed that! looks like im back in the game with VBA :youDaMan

kneesparx 02-18-2004 08:54 PM

i just checked and in featured it says:
Tested and stable with vBulletin 3.0 RC1, RC2, and RC3.

not RC4

i tried to install the newest version 1.1 but its not working for me

im getting this error:

Parse error: parse error in /home/db99/public_html/db1/includes/functions.php on line 1795

Fatal error: Call to undefined function: exec_nocache_headers() in /home/db99/public_html/db1/admincp/global.php on line 37

Mellow 02-18-2004 09:01 PM

Quote:

Originally Posted by kneesparx
i just checked and in featured it says:
Tested and stable with vBulletin 3.0 RC1, RC2, and RC3.

not RC4

i tried to install the newest version 1.1 but its not working for me

im getting this error:

Parse error: parse error in /home/db99/public_html/db1/includes/functions.php on line 1795

Fatal error: Call to undefined function: exec_nocache_headers() in /home/db99/public_html/db1/admincp/global.php on line 37

it's working for me but I had to uninstall first then re-install it.

Hope that helps

kneesparx 02-18-2004 09:09 PM

yup, thats the first thing i did, i noticed when i do the includes/functions.php edit as said in the help file,

Find:if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

Replace it with:if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'adv_index' AND $vboptions['showcalendar']) OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

my entire forum goes down.

but without that edit, the install page shows up fine,

i dont want to proceed with the install if im missing something..

please help..

ks

Mellow 02-18-2004 09:30 PM

Quote:

Originally Posted by kneesparx
yup, thats the first thing i did, i noticed when i do the includes/functions.php edit as said in the help file,

Find:if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

Replace it with:if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'adv_index' AND $vboptions['showcalendar']) OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

my entire forum goes down.

but without that edit, the install page shows up fine,

i dont want to proceed with the install if im missing something..

please help..


ks

Try using this:
if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

You needed to rename the adv_index to index if that's what you're gonna use.

Now that I look at it, I don't even have that part of the mod changed.... but the site still works... go for it

Mellow 02-18-2004 09:42 PM

Quote:

Originally Posted by Mellow
Try using this:
if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

You needed to rename the adv_index to index if that's what you're gonna use.

Now that I look at it, I don't even have that part of the mod changed.... but the site still works... go for it

Okay... I guess I should drink before posting, might make more sense...

I used this:
if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND

$vboptions['showcalendar']) OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

replacing the adv_index with index and everything is fine.. I would try that unless someone has other suggestions.


All times are GMT. The time now is 05:38 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.01970 seconds
  • Memory Usage 1,746KB
  • 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
  • (4)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