vb.org Archive
Page 9 of 26 « First 78 9 101119 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)
-   -   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


All times are GMT. The time now is 05:30 PM.
Page 9 of 26 « First 78 9 101119 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.02098 seconds
  • Memory Usage 1,747KB
  • 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
  • (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