vb.org Archive
Page 2 of 9 1 2 34 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   vB Affiliates for 3.5 (https://vborg.vbsupport.ru/showthread.php?t=96485)

Impreza04 09-21-2005 02:21 PM
Nope.. Ive tried re-installing with overwrite on and its not creating the tables.. :ermm:

Guest190829 09-21-2005 06:00 PM
If you already have the affiliates database, I'll make a product for just the two plugins in the product.

Also, that was the fix for the affiliate admin page...are there any other errors?

Hawkbizkit 09-22-2005 12:48 AM
well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run... ;) and let you know of any problems

Guest190829 09-22-2005 12:49 AM
Quote:
Originally Posted by Hawkbizkit
well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run... ;) and let you know of any problems
Okay, thanks. I'll fix that tonight, and upload the new zip file. :)

Protoman 09-23-2005 08:03 PM
I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

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 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date        : Friday, September 23rd 2005 @ 01:45:58 PM
Script      : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer    : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address  : XXXXXX
Username    : admin
Classname    : vB_Database

Dark_Wizard 09-23-2005 08:28 PM
Quote:
Originally Posted by corollasbest
I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

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 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date        : Friday, September 23rd 2005 @ 01:45:58 PM
Script      : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer    : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address  : XXXXXX
Username    : admin
Classname    : vB_Database
The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.

Guest190829 09-24-2005 02:44 AM
Quote:
Originally Posted by Dark_Wizard
The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.
Okay, I pmed you.

Once I get this sorted out, I will fix the other bugs and do another update to BETA 1.0.5.

Hawkbizkit 09-24-2005 04:03 PM
Line 308 affiliates.php you are missing the " . TABLE_PREFIX . ". Other than that i think i fixed the installing/uninstalling and using functionallity so if you wanna take a look at the code or the pages i have fixed feel free to hit me up in the vb.org chat system or over MSN/Yahoo/AIM messanger.

Edit: Here are a few links to it up and running just fine
http://forum.overhauledpc.com/affili...listaffiliates
http://forum.overhauledpc.com/affiliate.php?do=apply
http://forum.overhauledpc.com/affiliate.php

ReadOrDie 09-25-2005 02:38 AM
I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.

Guest190829 09-25-2005 04:02 AM
Quote:
Originally Posted by ReadOrDie
I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.
In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.

ReadOrDie 09-25-2005 05:49 PM
Quote:
Originally Posted by Danny.VBT
In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.
Could you be more specific? Or provide screenshots? Because I'm looking everywhere in the Admin CP and I can't find something that says "Affiliate Setting"

Guest190829 09-26-2005 01:22 AM
AdminCP -> Affiliates -> General Settings -> Is the Affiliates Addon Active? If not, no one can view this addon - > Set to yes

If you can't see Affiliates category in the admincp, make sure you upload the cpnav_affiliates.xml file to your includes/xml directory.

Guest190829 09-26-2005 01:25 AM
Okay, thanks to Dark_Wizard for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

ReadOrDie 09-26-2005 02:42 AM
Now I'm getting this error: Parse error: parse error, unexpected ',' in /www/g/************/htdocs/forum/admincp/affiliateadmin.php on line 193

Guest190829 09-26-2005 03:19 AM
Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

Impreza04 09-26-2005 02:22 PM
Everything is working on my test board apart from when trying to view affiliate.php

PHP Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error  : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date         : Monday, September 26th 2005 @ 04:22:45 PM 
EDIT: Actually I see the problem myself and its fixed..
PHP Code:
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings"); 
Has a space..
Replace with
PHP Code:
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings"); 
Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is :rolleyes:

and
PHP Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause
Error Number : 1109
Date         : Monday, September 26th 2005 @ 09:05:35 AM
Script       : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates 

ReadOrDie 09-26-2005 07:07 PM
Quote:
Originally Posted by Danny.VBT
Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?
I don't get what you mean...

Dark_Wizard 09-26-2005 07:46 PM
Quote:
Originally Posted by Danny.VBT
Okay, thanks to Dark Visor for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)
LOL...close enough. Although Dark Visor may like it... ;)

loneranger 09-26-2005 07:48 PM
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota  lrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause
i am getting this error too is there a solution yet as i need this

ReadOrDie 09-26-2005 07:59 PM
This hack is becomming very troublesome...

Dark_Wizard 09-26-2005 09:43 PM
Quote:
Originally Posted by ReadOrDie
This hack is becomming very troublesome...

Try this file overwriting the one you have now..

Guest190829 09-26-2005 09:58 PM
Quote:
Originally Posted by Dark_Wizard
LOL...close enough. Although Dark Visor may like it... ;)
Lol, Sorry I changed I the it, and put you as a supporter. Is their a Dark Visor on vb.org?

And to everyone getting annoyed, or irratated by the errors and updates of the hack. Please realize that this is only in the BETA stages without these errors the hack would not progress!

Hawkbizkit 09-26-2005 10:28 PM
Quote:
Originally Posted by loneranger
Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota  lrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause
i am getting this error too is there a solution yet as i need this
very simple fix on line 309 in the affiliate.php change this
PHP Code:
                                        ON affiliates.type = affiliates_types.id 
with this
PHP Code:
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 

Dark_Wizard 09-26-2005 11:00 PM
I have already changed the file in the post above and it's better to do it this way:

PHP Code:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota    lrating,totalvotes  
                                        FROM vB_affiliates AS affiliates LEFT JOIN vB_affiliates_types  AS affiliates_type
                                        ON affiliates.type = affiliates_types.id  
                                        WHERE active='1' AND approved='1'  
                                        ORDER BY sitename DESC  
                                        LIMIT 0,20; 

Impreza04 09-27-2005 05:11 AM
Nope sorry. None of those fixes work. Same error still occurs :ermm:

Guest190829 09-27-2005 05:10 PM
This should be a simple fix, by combining both of the suggested fixes..I'll do this later tonight and upgrade the hack with the new affiliate file.

ReadOrDie 09-27-2005 10:39 PM
delete this post plz.

ReadOrDie 09-27-2005 10:42 PM
Sorry about that, It's working now. I reinstalled the adminaffiliate.php thing! I'm clicking install!

ReadOrDie 09-27-2005 10:48 PM
Now it says I don't have permission...How do I not have permission? I'm the administrator. When I click on the affiliates in the forum it says you may not have enough priviledges blah blah blah...

Guest190829 09-28-2005 12:24 AM
You have to set permissions in the usergroup manager

ReadOrDie 09-28-2005 01:38 AM
Quote:
Originally Posted by Danny.VBT
You have to set permissions in the usergroup manager
Nothing in the usergroup manager says anything about affiliates...

Guest190829 09-28-2005 02:00 AM
Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?

Impreza04 09-28-2005 05:08 AM
Has the affiliate file been updated yet..?

ReadOrDie 09-28-2005 10:58 AM
Quote:
Originally Posted by Danny.VBT
Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?
Alright I installed it, but yet again I'm getting another error:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

Guest190829 09-28-2005 02:51 PM
What page are you getting that error? I think I filtered out a integer type variable, that's what is causing the error.

bi11i 09-28-2005 04:39 PM
Quote:
Originally Posted by Impreza04
Everything is working on my test board apart from when trying to view affiliate.php

PHP Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error  : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date         : Monday, September 26th 2005 @ 04:22:45 PM 
EDIT: Actually I see the problem myself and its fixed..
PHP Code:
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings"); 
Has a space..
Replace with
PHP Code:
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings"); 
Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is :rolleyes:

and
PHP Code:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause
Error Number : 1109
Date         : Monday, September 26th 2005 @ 09:05:35 AM
Script       : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates 
thanks, that fixed my SQL error, also.

Are the General Settings optimally configured by default?

bi11i 09-28-2005 04:45 PM
Quote:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM opio_affiliates AS affiliates_types
LEFT JOIN opio_affiliates_types AS affiliates_type
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown table 'opio_affiliates' in on clause
Error Number : 1109
Date : Wednesday, September 28th 2005 @ 11:45:15 AM
Script : http://forum.opiophile.org/affiliate...listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi
I'm still getting this error no matter which hack to the mod I try. Any definitive solution?

Hawkbizkit 09-28-2005 04:53 PM
Quote:
Originally Posted by bi11i
I'm still getting this error no matter which hack to the mod I try. Any definitive solution?
you are missing the who affiliates table it's self it looks like try runing the query to install the table
Quote:
CREATE TABLE `opio_affiliates` (
`affiliate_id` int(10) NOT NULL auto_increment,
`sitename` varchar(50) NOT NULL default '',
`siteurl` varchar(250) NOT NULL default '',
`sitedesc` mediumtext NOT NULL,
`buttonurl` varchar(150) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`email` varchar(250) NOT NULL default '',
`clicksout` int(20) NOT NULL default '0',
`clicksin` int(20) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
`totalrating` bigint(20) NOT NULL default '0',
`totalvotes` bigint(20) NOT NULL default '0',
`approved` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`),
KEY `sitename` (`sitename`),
KEY `siteurl` (`siteurl`),
KEY `email` (`email`)
) ;

bi11i 09-28-2005 06:14 PM
Quote:
Originally Posted by Hawkbizkit
you are missing the who affiliates table it's self it looks like try runing the query to install the table
Quote:
error number: 1050
error desc: Table 'opio_affiliates' already exists
when running the query...

Hawkbizkit 09-28-2005 06:22 PM
oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)
PHP Code:
            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types  AS affiliates_type
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 
Replace with: on the first line in this code there is a space between tota lrating just remove the 2 spaces and it should work just fine.
PHP Code:
            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types 
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 
Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...

EDIT: Fix down in post #88


All times are GMT. The time now is 07:40 AM.
Page 2 of 9 1 2 34 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.04815 seconds
  • Memory Usage 1,904KB
  • 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
  • (4)bbcode_code_printable
  • (13)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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