Advertisement:

Author Topic: Ad Management mod  (Read 1683379 times)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,078
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Ad Management mod
« Reply #7680 on: July 16, 2017, 08:07:48 PM »
Make sure you are doing it on right database for your forum and right database prefix.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline virtualdave

  • Jr. Member
  • **
  • Posts: 121
Re: Ad Management mod
« Reply #7681 on: July 16, 2017, 08:29:33 PM »
OK I did a bit of studying and tried it again with this message as a result.

Quote
#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 'HITS HITS BIGINT NOT NULL default '0'' at line 1

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,078
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Ad Management mod
« Reply #7682 on: July 16, 2017, 08:32:07 PM »
What's the exact sql query you used?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline virtualdave

  • Jr. Member
  • **
  • Posts: 121
Re: Ad Management mod
« Reply #7683 on: July 16, 2017, 08:34:14 PM »
I copied this from the post I quoted and changed the table prefix to match mine as follows:

alter table ice_ads HITS HITS BIGINT NOT NULL default '0';

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,078
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Ad Management mod
« Reply #7684 on: July 16, 2017, 08:58:26 PM »
Change to
Quote
alter table ice_ads change HITS HITS BIGINT NOT NULL default '0';
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline virtualdave

  • Jr. Member
  • **
  • Posts: 121
Re: Ad Management mod
« Reply #7685 on: July 16, 2017, 09:03:20 PM »
That did the trick! thanks for your assistance.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,078
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Ad Management mod
« Reply #7686 on: July 16, 2017, 09:40:59 PM »
glad to help
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro