vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vB.Sponsors - Forum and Category Sponsorship with Statistics (https://vborg.vbsupport.ru/showthread.php?t=103327)

Zilvia 12-25-2005 09:00 PM

Im getting an error. I am running MySQL 5, donno if thats a problem.

MySQL said: Documentation

#1064 - 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 'ALTER TABLE Zilvia2K3_forum ADD (sponsor_banner_enabled INT(6) U

That error say this in the docs.

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

Message: %s near '%s' at line %d

Deviation 12-26-2005 02:37 PM

Quote:

Originally Posted by hornstar1337
Also I just noticed you added your link on the bottom of the forum lol, very sly lol

Powered by vBulletin Version 3.5.2
Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.
vB.Sponsors 0.1.0

;) I figured its a freebie, so that wouldn't be a huge deal ;) THough it loos like you may be using the older version. Be sure to update.


Quote:

Originally Posted by Zilvia
Im getting an error. I am running MySQL 5, donno if thats a problem.


MySQL said: Documentation

#1064 - 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 'ALTER TABLE Zilvia2K3_forum ADD (sponsor_banner_enabled INT(6) U

That error say this in the docs.

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

Message: %s near '%s' at line %d

Is this the full error from vB? Looks like it doesn't like the SQL string I'm using. I'll have to look into this one some more and get back to you. I've not used mysql 5 yet.

Ole_Chilli 12-27-2005 02:30 AM

worked perfectly no problems .... I havetried many of these sponsor programs all hurt my head .. this was flawless

Hornstar 12-27-2005 08:37 AM

Yeah i updated and changed the link to one of my other sites as i still dont know how to remove phases only edit them lol, but its cool. I guess its just more sponsorship for that site :D

Zilvia 12-28-2005 02:24 AM

Quote:

Is this the full error from vB? Looks like it doesn't like the SQL string I'm using. I'll have to look into this one some more and get back to you. I've not used mysql 5 yet.
This is the code I get from PHPMyAdmin after entering the query. The other error was from mysql.com when I looked up error #1064. Thanks!

MySQL said: Documentation

#1064 - 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 'ALTER TABLE Zilvia2K3_forum ADD (sponsor_banner_enabled INT(6) U

djmini 12-28-2005 06:38 AM

I installed and have tried to use.

I can add the sponsors easily enough, but for some reason the actual links are not correct when clicked on.

Sponsored by - ThatGuy (http://www.thatguy.com) But when clicked the url = http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12

So how do I remove the /forum/vB.Sponsors/link.php?f=12 part???

PennylessZ28 12-28-2005 07:45 AM

works great on my end

Deviation 12-28-2005 10:47 AM

Quote:

Originally Posted by Zilvia
This is the code I get from PHPMyAdmin after entering the query. The other error was from mysql.com when I looked up error #1064. Thanks!

MySQL said: Documentation

#1064 - 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 'ALTER TABLE Zilvia2K3_forum ADD (sponsor_banner_enabled INT(6) U

I'm still looking into this one. I haven't had a chance to sit down and disect it yet though. I should have some time tonight.

Quote:

Originally Posted by djmini
I installed and have tried to use.

I can add the sponsors easily enough, but for some reason the actual links are not correct when clicked on.

Sponsored by - ThatGuy (http://www.thatguy.com) But when clicked the url = http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12

So how do I remove the /forum/vB.Sponsors/link.php?f=12 part???

The sponsorship links will always appear in the following format:
Code:

http://www.yoursite.com/yourforum/vB.Sponsors/link.php?f=#
# being the id of your forum (automatically generated).

So if your forum is in fact thatguy.com, its appearing correctly. You do not need to add the actual URL after the sponsor's name. In fact, I would suggest you not do that. Its more beneficial to use the link generated by vB.Sponsors as it tracks the hits.

Hope that helps.

djmini 12-28-2005 04:57 PM

Quote:

Originally Posted by Deviation
I'm still looking into this one. I haven't had a chance to sit down and disect it yet though. I should have some time tonight.


The sponsorship links will always appear in the following format:
Code:

http://www.yoursite.com/yourforum/vB.Sponsors/link.php?f=#
# being the id of your forum (automatically generated).

So if your forum is in fact thatguy.com, its appearing correctly. You do not need to add the actual URL after the sponsor's name. In fact, I would suggest you not do that. Its more beneficial to use the link generated by vB.Sponsors as it tracks the hits.

Hope that helps.

ThatGuy.com was an example, not my forum.
I did not add the actual URL when adding the sponsor name, I placed the url in the space that asks for it in the CP.

It is clickable but this is the address, http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12 , which does nto take a visitor to the Sponsor's site at all.

Still confused.

Deviation 12-28-2005 06:40 PM

Quote:

Originally Posted by djmini
ThatGuy.com was an example, not my forum.
I did not add the actual URL when adding the sponsor name, I placed the url in the space that asks for it in the CP.

It is clickable but this is the address, http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12 , which does nto take a visitor to the Sponsor's site at all.

Still confused.

Does it just not do anything (blank page)? Or does it error out? Can you show me a screenshot of the settings your entering as well as the actual address (either by PM or here)?

Has to be something simple that's been overlooked. :ermm:


All times are GMT. The time now is 01:45 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.01467 seconds
  • Memory Usage 1,752KB
  • 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
  • (2)bbcode_code_printable
  • (7)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