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)
-   -   Referral Statistics (https://vborg.vbsupport.ru/showthread.php?t=64469)

Jason McConnell 04-20-2005 08:56 AM

Quote:

Originally Posted by gspot
Make sure you started with a new installation and not an upgrade. Run the install again even if it asks you to perform an uninstall. Then let me know what you get.

OK I went back thru, uninstalled and reinstalled, and now it works fine... just as long as I'm using my site's default style. Any other style loaded and I get a blank referrals.php page.

BradM 04-20-2005 04:35 PM

I am getting a DB crash on my forum. http://www.tgpelite.com/board/referrals.php
It worked fine, then randomly it crashed?

BradM 04-20-2005 04:40 PM

I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(distinct referrerid) AS ttl FROM user
WHERE referrerid > 0 AND usergroupid NOT IN id:6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'id:6' at line 2

mysql error number: 1064

I apologise if I am an idiot. LOL

gspot 04-21-2005 04:16 AM

Quote:

Originally Posted by BradM
I get this error:



Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(distinct referrerid) AS ttl FROM user
WHERE referrerid > 0 AND usergroupid NOT IN id:6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'id:6' at line 2

mysql error number: 1064



I apologise if I am an idiot. LOL

on the referral statistics configuration in the admincp you dont type in (id:6) it would be just the (6) that will fix your problem. :)

brianstevz 04-24-2005 12:08 AM

Quote:

Originally Posted by gspot
If you will wait for me one week, I will release the new version and that should fix your issue... It seems to me that the database fields never got updated in your sql. :( I havent had anyone with this issue besides u. Please wait.. :)

Mine still doesn't work. Any ideas?

gspot 04-24-2005 11:49 PM

Quote:

Originally Posted by brianstevz
Mine still doesn't work. Any ideas?

I can try to help you - can you post an image of whay your mysql table for referrals looks like? If not, then I need to gain access somehow or someway in order to see this structure.

artonex 04-28-2005 02:10 PM

just installed this over at my forums :)

womensden 04-28-2005 03:51 PM

I'm having a problem.

My referral page isn't showing most of my images. My background is missing, as well as other things. It seems anything that was in there without the entire link isn't showing properly. Even the links aren't going to the correct places.

http://www.womensden.com/forums/referrals.php/

gspot 04-28-2005 07:21 PM

Quote:

Originally Posted by womensden
I'm having a problem.

My referral page isn't showing most of my images. My background is missing, as well as other things. It seems anything that was in there without the entire link isn't showing properly. Even the links aren't going to the correct places.

http://www.womensden.com/forums/referrals.php/

You are having this problem do to adding your own personal images not correctly in the navigation bar. Have you installed any other hacks? Also when you add your own images into the navbar make sure you type in their absolute paths example: http://www.test.com/header.gif

No one else has ever had this issue so I believe this is the reason and the problem that you are having. :)

womensden 04-28-2005 08:06 PM

so where can I edit those image paths?

Also, the links are screwed up. What would that have to do with the way my images are ?


All times are GMT. The time now is 05:09 PM.

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.01365 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
  • (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