News:

Help keep this project going by donating or buying adseller pro

Main Menu
Coinbase

Strange display with ads installed

Started by cdntrucky, February 17, 2017, 02:37:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

cdntrucky

I recently had to move my SMF forum from a shared server to a VPS server. But in the migration process something got messed up. So this morning I made sure that SMF was at the most recent version (2.0.13). I then installed ad_mod_v3.2_SMF_v2-0. It gave no errors so I installed it after modifying all the needed php files.

So when I go into my Forum I basically get a Forum in a Forum. I am attaching a screen capture to show what I mean.

Can someone please assist me in what needs to be fixed?

Thanks.

vbgamer45

Run this query on your database

alter table smf_ads HITS HITS BIGINT NOT NULL default '0';
Like what I do please support me on https://www.patreon.com/vbgamer45

cdntrucky

No still getting the same issue.

It is still telling me that the database is at version 2.0.4. But I would have thought that applying the updates to SMF would have resolved that.

vbgamer45

Like what I do please support me on https://www.patreon.com/vbgamer45

cdntrucky


cdntrucky

When I tried to run your SQL query, I got an error. Was "HITS" suppose to be in there twice? I deleted on of them and still got an error. So I just modified the field in phpMyAdmin.

vbgamer45

Like what I do please support me on https://www.patreon.com/vbgamer45

cdntrucky

Not sure if you noticed on the screen capture, but when I install the Ad Manager the content of my Forum is in two places? How can installing the Ad Management do that? I realize I had to edit a bunch of php files before installing Ad Management. But seems so strange.

Any idea of what database structure changes are made in the different versions?

cdntrucky

I just realized that when they migrated my database over to the new server that I had two copies and I changed the field properties in the wrong database. So now it works properly.

Thank you SO much.

vbgamer45

Like what I do please support me on https://www.patreon.com/vbgamer45