vb.org Archive
Page 20 of 50 « First 101819 20 212230 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)
-   -   Referral Statistics (https://vborg.vbsupport.ru/showthread.php?t=64469)

MajorFm.com 01-16-2005 11:58 AM
Got the following error on the auto installation on step 2...

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
            CREATE TABLE referrals (
                  `date` text NOT NULL
                ) TYPE=MyISAM
mysql error: Table 'referrals' already exists

mysql error number: 1050

Date: Sunday 16th of January 2005 08:55:51 AM
Script: http://www.majorfm.com/forum/admincp/install_referrals.php
Referer: http://www.majorfm.com/forum/admincp/install_referrals.php
Username: *****
IP Address: 80.42.131.***
I have masked the username and part of the IP

Please advise...

gspot 01-16-2005 04:54 PM
Major - please re-download the package and re-upload all the files again for the upgrade process. I have created an upgrade script in the auto installer. This should take care of your problem. Good Luck. :)

Megareus Rex 01-16-2005 09:33 PM
Ok, problem. I use table prefixes at my forum. The original version didn't have them, so I added em in manually, but I see this version does. However....there's a problem with one bit of coding in it.

Its this block

PHP Code:
$result = $DB_site->query_first("SELECT COUNT(*) as ttl, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY ttl DESC"); 
I have to add the table prefix to every single instance of 'user' in the entire block, or else it gives me errors such as "Unknown table 'user' in field" and stuff. And when I add the prefix to all instances of it, for some reason it acts like there's no prefix on ANY of it! So I can't get it to work at all.

Any help?

T3MEDIA 01-16-2005 09:50 PM
Quote:
Originally Posted by gspot
EVERYONE THE NEW RELEASE IS HERE.. :)

LET ME KNOW WHAT YOU THINK :)

:):):):):):):):):):)
I dont know if you remember I was asking for the referal hack to check for a pertiular setup.

each user has to refer 5 users. Those five have to refer 5 as well and the orignal user gets paid.

can this baby do that yet?

its like free ipods for members kinda thing.

gspot 01-16-2005 09:56 PM
REX - It was an error in the referrals.php page. IT HAS BEEN FIXED.

gspot 01-16-2005 09:57 PM
Quote:
Originally Posted by T3MEDIA
I dont know if you remember I was asking for the referal hack to check for a pertiular setup.

each user has to refer 5 users. Those five have to refer 5 as well and the orignal user gets paid.

can this baby do that yet?

its like free ipods for members kinda thing.
Sorry this hack doesnt do that. And It might in the future, just not at this time. :( sorry

Megareus Rex 01-17-2005 04:53 AM
Quote:
Originally Posted by gspot
REX - I see this on your referrals.php page:

mysql error: Table 'lancetjades.user' doesn't exist

Are you using the prefix = 'lancetjades'? Because somehow thats what it is trying to use... This hack seems to work fine on my board and others, so it must be a conflict with another hack you might have installed previously. If this hack worked prior to this release, then try not using the prefix at all and just use the table user delete the " . TABLE_PREFIX ." part.
:( sorry not much help here...
No, lancetjades is the name of the database my forum uses. The prefix I use is vb3_

It gives that error because the "LEFT JOIN user AS user ON" part of the code doesn't have a table prefix code on it, or so I've deduced.

Here is the error text:
PHP Code:
Database error in vBulletin 3.0.5:

Invalid SQL: SELECT COUNT(*) as ttl, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY ttl DESC
mysql error: Table 'lancetjades.user' doesn't exist

mysql error number: 1146

Date: Sunday 16th of January 2005 10:49:54 PM
Script: http://www.evermoreforums.com/forums/referrals.php
Referer: http://www.evermoreforums.com
Username: Blaze
IP Address: ***** 
As you see, the part of the code that has the table prefix code on it shows the vb3_. Once I attached the prefix to all the blank 'user' instances, it says "Unknown table 'user' in field set, and so on until ALL instances of 'user' have a prefix. Then, it drops the prefix from all of the instances, and it still refuses to work.

gspot 01-17-2005 02:03 PM
Rex - try changing this:
PHP Code:
////////////////////////////////////////////
$result = $DB_site->query_first("SELECT COUNT(*) as ttl, user.username, user.userid FROM ". TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY ttl DESC"); 
///////////////////////////////////////////////// 
To this:
PHP Code:
////////////////////////////////////////////////
$result = $DB_site->query_first("SELECT COUNT(*) as ttl, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY ttl DESC"); 
//////////////////////////////////////// 
AND THIS:
PHP Code:
////////////////////////////////////////
$referrers = $DB_site->query("SELECT COUNT(*) AS number, user.username, user.userid, user.referrals FROM " . TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY number DESC 
                   LIMIT $from, $max_results");
///////////////////////////////////// 
To this:
PHP Code:
/////////////////////////////////////
$referrers = $DB_site->query("SELECT COUNT(*) AS number, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN " . TABLE_PREFIX . "user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY number DESC 
                   LIMIT $from, $max_results"); 
///////////////////////////////
/////////////////////////////// 
This should fix anyones problem who is having the same issue as REX - sorry all.. :) Make these changes is the referrals.php file.

Megareus Rex 01-17-2005 05:34 PM
Yes, that fixed it! Thanks a lot!!! :):):)

James Goddard 01-17-2005 05:50 PM
Great hack, but the pagination stuff is not quite working for me:

I have $max_results set to 10 and 1 user with any referrals (new board), however I still get 2 pages?

Here is an example:

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

James


All times are GMT. The time now is 01:58 PM.
Page 20 of 50 « First 101819 20 212230 Last »
Show 40 post(s) from this thread on one page

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.01476 seconds
  • Memory Usage 1,773KB
  • 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
  • (6)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
  • (2)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