vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - SponsorIt (https://vborg.vbsupport.ru/showthread.php?t=152866)

SLY LS1 07-23-2007 08:15 AM

1. Yeah another error when editing a sponsor

Quote:

MySQL Error : Unknown column 'sclicks' in 'field list'
2. Deleting seems to work ok now...

3. Adding a sponsor works but now nothing is showing up..

4. You really need to add an instruction page with the download

5. Surely you are running/testing it on your own site before releasing it?

principino1984 07-23-2007 08:17 AM

When i try to upgrade from 1.2 ...

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE `vb_usergroup` ADD `sponsors` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';;

MySQL Error  : Duplicate column name 'sponsors'
Error Number : 1060

Marco

principino1984 07-23-2007 08:33 AM

now it gaves me this error...

MySQL Error : Unknown table 'vb_tfw_sponsors'

Could you please do something that instead of tryin to modify the vb_tfw_sponsor if it doensn't exist it create a new table?

Cause I dont' have that table in my db...thats why I cannot neither uninstall it or upgrade it.

thanks a lot!

Marco

waller99 07-23-2007 12:06 PM

Same for me.


Code:

Invalid SQL:

MySQL Error  : Unknown column 'sclicks' in 'field list'
Error Number : 1054


BadgerDog 07-23-2007 01:01 PM

Well , installed v1.3 .... but it has issues when trying to edit an entry .... :eek:

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE tfw_sponsors SET title="Riflechair\'s Links", url="http://xxxxx.com/", image="http://www.xxxx.com/sponsors/xxxx.jpg", description="", sclicks="", inactive="0" WHERE sid=2;

MySQL Error : Unknown column 'sclicks' in 'field list'
Error Number : 1054
Date : Monday, July 23rd 2007 @ 09:57:42 AM
Script : http://www.xxxx.com/admincp/tfw.php?do=editsave
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username : Badger
Classname : vB_Database
How do I uninstall this mod without screwing up things?

Thanks.... :)

Regards,
Badger

BadgerDog 07-23-2007 01:21 PM

This is brutal .... :D

I managed to get it to show image by not leading with a path... hope that helps someone...

However, once displayed in forums and you click on image, I get:

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE `tfw_sponsors` SET sclicks=sclicks + 1 WHERE sid='4';

MySQL Error : Unknown column 'sclicks' in 'field list'
Error Number : 1054
Date : Monday, July 23rd 2007 @ 10:17:07 AM
Script : http://www.xxxxx.com/sponsor.php?id=...riflechair.com
Referrer :
IP Address : xxxxx.xxxx.xxxx.xxxx
Username : Badger
Classname : vB_Database

For some reason, it will accept a new entry, but as soon as you go back to test an existing entry, it starts giving database errors. In trying to figure out what it wants in the fields, I have been only able to get this far by adding new entires, then deleting them to start over with new tests, as the edit doesn't seem to work all....

Has anyone got this working? :erm:

Regards,
Badger

BadgerDog 07-23-2007 01:59 PM

UNINSTALLED ...........

Besides all of the errors, we found that it corrupted our VBadvanced Home Page "News" display. For some reason, when this mod is turned ON, it creates an inability to find attachment images, when turned OFF, the "News" display instantly returns to normal. The news display slideshow I'm referring to can be seen here: www.milsurps.com

Anyway, nice idea , but I'm not sure it's ready for prime time, although thanks for the coder's efforts... :up:

Can anyone recommend another mod that can do something similar to this, locating a sponsor page at the bottom of the Forum Home Page?

Regards,
Badger

principino1984 07-23-2007 02:00 PM

how did you uninstall it?

Yours 07-23-2007 02:08 PM

Quote:

Originally Posted by BadgerDog (Post 1299206)
UNINSTALLED ...........

Besides all of the errors, we found that it corrupted our VBadvanced Home Page "News" display. For some reason, when this mod is turned ON, it creates an inability to find attachment images, when turned OFF, the "News" display instantly returns to normal. The news display slideshow I'm referring to can be seen here: www.milsurps.com

Anyway, nice idea , but I'm not sure it's ready for prime time, although thanks for the coder's efforts... :up:

Can anyone recommend another mod that can do something similar to this, locating a sponsor page at the bottom of the Forum Home Page?

Regards,
Badger

Most of the issues should have been fixed in 1.3
The mod is an independent mod so it is not supported by nor possibly integratable with vBAdvanced. The issue may be something to do with your vBAdvanced settings. For News/recent posts make sure you select a category instead of it just pulling things from all categories as it may be reading the Sponsors as a whole other Forum Category, which it should not be

BadgerDog 07-23-2007 03:17 PM

Quote:

Originally Posted by principino1984 (Post 1299207)
how did you uninstall it?

There were no instructions on how to remove it, so I simply used the standard AdminCP function for un-installng the XML file, then deleted all of the uploaded files that came with the mod. There was some vague references in the INSTALL.TXT file about the FORUMHOME template, but it seemed to be related to what the author called "upgrading". Since I never did those template mods, I never bothered with the FORUMHOME template as the hack didn't seem to be in it anyway.... :)

Regards,
Badger

Quantnet 07-23-2007 03:25 PM

Give Steve some time,
He will come up with the fix in the new version.

for those who looking for a similar mod, you can look at this one https://vborg.vbsupport.ru/showthread.php?t=152350

BadgerDog 07-23-2007 03:38 PM

Quote:

Originally Posted by Yours (Post 1299215)
Most of the issues should have been fixed in 1.3
The mod is an independent mod so it is not supported by nor possibly integratable with vBAdvanced. The issue may be something to do with your vBAdvanced settings. For News/recent posts make sure you select a category instead of it just pulling things from all categories as it may be reading the Sponsors as a whole other Forum Category, which it should not be

It was v1.3 that I installed and the errors I was getting seem to be the same as everyone else was reporting, so I think there's something else wrong.

As far as the News Forum negative effects, it's a simple mod based upon the Joomla java code and this mod:

https://vborg.vbsupport.ru/showthread.php?t=139529

The News Reader mod is ONLY reading from one forum which doesn't have anything to do with the TFW implementation.

Whatever the TFW mod is doing, it's definitely interacting badly with the News Reader mod, creating an error message:

Warning: Attempt to assign property of non-object in /modules/mod_fpslideshow.php on line 281

That line is attempting to read attachments in posts and it works fine unless TFW is turned ON, then the error starts. To be honest, I really don't want to spend a lot of time figuring it out, as it's not a religious experience. :D

The News Reader mod is excellent for our forums and works fine now, so it's easier for me to find some kind of a sponsor mod (or commercial add-on) that does what TFW does.

Thanks for the feedback... appreciate it... :up:

Regards,
Badger

Mythotical 07-23-2007 04:18 PM

Everyone please be patient, I do need to sleep, I do have to work.

Yes I run this mod on my test site, I don't understand where the problem could be coming from when I have been running it fine. I will double check that I included the right xml file.

With regards to your news reader mod, I will attempt to modify my code to work with that mod. I will have to get ahold of it and install it so that I can properly test it.

If you click install then you will know when I have released the fix for this. I am gonna try to get it done before I head to work or as soon as I get off tonight.

Mythotical 07-23-2007 05:10 PM

Testing new version now.

hardiono 07-23-2007 05:19 PM

I got this message when trying to change option in usergroup

MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Tuesday, July 24th 2007 @ 12:57:41 AM
Script : http://forum.xxx.com/admincp/usergroup.php?do=update
Referrer : http://forum.xxx.com/admincp/usergro...&usergroupid=5
IP Address : xxxx
Username : xxxx
Classname : vb_database

Please help.

Mythotical 07-23-2007 05:27 PM

That is from another mod, check to make sure your chatbox is fully installed.

That means when your installed your chatbox it didn't add that column for the usergroup permission of your chat. I suggest you uninstall it or check where you downloaded that mod to make sure there is not an update.

Mythotical 07-23-2007 06:39 PM

I have released the updated version. If you had errors please download the new version and overwrite your existing product install.

Tonight I will be working on a work around for the news mod issue.

Quantnet 07-23-2007 07:05 PM

Still have problem with custom style. WOL put it below WOL
Forum put it on top of WOL but it broke the style
Navbar did not display.

principino1984 07-23-2007 07:12 PM

Could you please make one version that doesn't have to DROP the table? Cause with the first version you uploaded and that I installed it didn't create anyt table..so anytime I try to overwrite the old one i get this DB error:

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE `vb_tfw_sponsors` DROP `image_type`;;

MySQL Error  : Table 'Sql76565_3.vb_tfw_sponsors' doesn't exist
Error Number : 1146
Date        : Monday, July 23rd 2007 @ 10:04:40 PM

Or, at least let me know what can I do to uninstall the 1.2 version i've on.

I'll appreciate it.

thanks a lot
Marco

edit: nevermind.. .i solved it creating a table called vb_tfw_sponsors by myself and it let me uninstal then....

Mythotical 07-23-2007 07:39 PM

Its the fact that its not creating the table. That was the only problem. Glad you got it fixed though.

Quantnet.org: I will take a look at it tonight.

principino1984 07-23-2007 07:58 PM

Quote:

Originally Posted by Steve M (Post 1299499)
Its the fact that its not creating the table. That was the only problem. Glad you got it fixed though.

Quantnet.org: I will take a look at it tonight.

yup...anyway since I really need this hack I will wait for the final version of it to install it, since this version is still not workin. And it doesn't modify my styles.

Marco

BadgerDog 07-23-2007 10:45 PM

Quote:

Originally Posted by Steve M (Post 1299314)
If you click install then you will know when I have released the fix for this. I am gonna try to get it done before I head to work or as soon as I get off tonight.

Roger that ... :)

Clicked installed, although I haven't....

Thank for your efforts... :up:

Regards,
Badger

SLY LS1 07-24-2007 12:05 AM

Ok version 1.3.1 is getting there, I have it installed and it seems to work fine "except" a couple of little bugs

1. The link doesn't redirct to the sponsors URL

2. It changes Capitals to 1st letter capital only in description, that could be a pain if your trying to display something like "LS1" it shows as "Ls1"

Oh steve, can you alter this in your instal instructions, number 7 as its not very clear "cant you put the setting in the "TFW Sponsors" drop down list instead of the "vBulletin Options" ?

If you cant do that I would change it from

7. Edit your vBulletin Settings for TFW Sponsors

I would say should read

7. Go to your 'vBulletin Options" in your "ACP" and find "TFW Sponsors" to turn the sponsors on.

SLY LS1 07-24-2007 12:17 AM

whoops no, still a problem editing a sponsor

MySQL Error : Unknown column 'sclicks' in 'field list'

Line 29 of sponsors.php

waller99 07-24-2007 12:41 AM

Quote:

Originally Posted by SLY LS1 (Post 1299694)
whoops no, still a problem editing a sponsor

MySQL Error : Unknown column 'sclicks' in 'field list'

Line 29 of sponsors.php


Still same problem here, too.

Mythotical 07-24-2007 02:30 AM

For those with errors of sclicks, you need to reimport the xml file included otherwise you will continue to get that error.

Mythotical 07-24-2007 02:40 AM

There will be no final version, this will continue to be developed. The link redirection should be working fine, I will make sure I didn't give you my test file. Not sure on the capitalization issue.

I will get started on 1.3.2.

Mythotical 07-24-2007 04:46 AM

Quantnet.org: Your problem was one I had to fix manually as your using a heavily modified style. Now I'm gonna redo the mod to look for specific code and at the same time I'm gonna try to make a remove file that will remove all instances of the plugins and products.

Everyone else: I am gonna work on the current fixes, I hope to have it solved by tomorrow about noon.

principino1984: this mod automatically alters your templates. You have to import the product xml file overwriting enabled otherwise it will error out and you will still have the remaining version on your site.

adc-arab 07-24-2007 05:35 AM

hi steve ^^ i tried to uninstall TFW and i have this problem on my admin panel i still see TFW options see screenshot

https://vborg.vbsupport.ru/attachmen...1&d=1185258787

Mythotical 07-24-2007 05:38 AM

You need to remove the xml files from includes/xml directory. That will remove the options, but if you are reinstalling then removing that file you don't have to worry about.

adc-arab 07-24-2007 05:42 AM

k thx alot steve and i'm waiting for ur update take ur time ur mod is really great and i love it ;)

edit: one more thing :p can u add an option to show the Sponsors on the header :) ( lol i asked alot XD)

Mythotical 07-24-2007 05:46 AM

Thanks, I will hopefully have 1.3.2 ready tomorrow with a few fixes and alterations to how things are set. I am gonna try to add a custom settings page so that would make it easier.

BadgerDog: Unfortunately the news mod you have installed requires me to pay for it which I don't have the funds at this time to purchase and install along with the vBa addon for it. Therefore I will not be able to create a work around for it. I do apologize, if you wish, enable TFW Sponsor, take a screenshot of the news mod as its not working then post that, I should be able to get a pretty good idea of the problem from there so I might be able to make a work around for it that way, otherwise, I am sorry.

EDIT: If you like my mod please nominate for MOTM, trust me, it will only get better from here on out and I wish to see at least one of my mods get voted for MOTM.

adc-arab 07-24-2007 05:59 AM

clicked :p just hurry up and do the fixs :p and the header option on where to show it :p

Mythotical 07-24-2007 06:00 AM

Where to show is done, I am gonna redo it all so its on its own custom settings page leaving out vBulletin Options stuff, makes it easier for using radio buttons instead of drop down. Trust me, this next version might become 1.4 by the time I'm done. :D

Quantnet 07-24-2007 06:13 AM

Steve,
Clicked MOTM.

My suggestions:

Drop the Click idea. I will be using OpenAds code there so i can track the stats instead of having the Clicks shown.

I edited the template bit to remove it.

You should look at this mod https://vborg.vbsupport.ru/showthread.php?t=152350
and maybe incorporate some ideas into your mod. Something like highlighted when mouse hover the ads?

BadgerDog 07-24-2007 09:34 AM

Quote:

Originally Posted by Steve M (Post 1299828)
BadgerDog: Unfortunately the news mod you have installed requires me to pay for it which I don't have the funds at this time to purchase and install along with the vBa addon for it. Therefore I will not be able to create a work around for it. I do apologize, if you wish, enable TFW Sponsor, take a screenshot of the news mod as its not working then post that, I should be able to get a pretty good idea of the problem from there so I might be able to make a work around for it that way, otherwise, I am sorry.

Thank you for looking at it Sir.... :)

Appreciate your efforts.... :up:

At this time, I'll look for another sponsor link option...

Uninstalled....

Regards,
Badger

waller99 07-24-2007 12:06 PM

Still the same error. I uploaded the newest xml file too. I get this error when I click on the banner. Also I get a similar error when I try and edit the banner in the admincp.

Code:

Invalid SQL:
UPDATE `vbtfw_sponsors` SET sclicks=sclicks + 1 WHERE sid='8';

MySQL Error  : Unknown column 'sclicks' in 'field list'


Mythotical 07-24-2007 02:36 PM

waller: I'm gonna see if somehow its not getting inserted properly or something.

Everyone: Clicks I think I will make optional where as the person can click yes to use and it will use the click program otherwise it will just redirect without adding a click count.

BadgerDog: I believe there is vbSponsor, check it out, it does pretty much the same as mine but I think it has less options.

Quantnet.org: I took a look at the mod you pointed out, I decided that I will not add any of those type of features just yet. I want to get a more stable release before I go to add any big features like that. Thanks for the suggestion tho, I will say its accepted.

Yours 07-24-2007 03:06 PM

Quote:

Originally Posted by waller99 (Post 1300097)
Still the same error. I uploaded the newest xml file too. I get this error when I click on the banner. Also I get a similar error when I try and edit the banner in the admincp.

Code:

Invalid SQL:
UPDATE `vbtfw_sponsors` SET sclicks=sclicks + 1 WHERE sid='8';

MySQL Error  : Unknown column 'sclicks' in 'field list'


The error you are receiving is not one that we can replicate on a test forums. You must be upgrading it incorrectly. My suggestion is uninstall the product completely, delete files that you uploaded it for this, and re-install it all over again. The issue you are receiving is due to the upgrade not going correctly on your end.

BadgerDog 07-24-2007 11:13 PM

Quote:

Originally Posted by Steve M (Post 1300224)
BadgerDog: I believe there is vbSponsor, check it out, it does pretty much the same as mine but I think it has less options.


Thanks, I'll check it out.... :up:

BTW, I re-installed your latest version as a test and it still has conflicts with attachments, for whatever reason.

I'll check back now and then for subsequent versions....

Regards,
Badger


All times are GMT. The time now is 01:36 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.01506 seconds
  • Memory Usage 1,848KB
  • 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_code_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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