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.
Run this query on your database
alter table smf_ads HITS HITS BIGINT NOT NULL default '0';
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.
That query should do it.
Here is a more recent screen capture
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.
Yes because it is changing the column
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?
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.
Glad to help.