SMF Ads Support Forum

Support => Ad Support => Topic started by: IndiaDawn on December 22, 2008, 11:45:19 PM

Title: Error After installation of Ad Management in 1.1.7
Post by: IndiaDawn on December 22, 2008, 11:45:19 PM
Hello Sir
I am facing a problem that I have installed ad management as per instructions
but when I run query(in phpmyadmin) as given at last in instructions than this error comes
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 '{$db_prefix}ads ( ADS_ID mediumint(8) unsigned NOT NULL auto_increment, NAME t' at line 1

and now my forum is also not opening. error comes
Quote(Database Error
Table 'host0_2742574_INDIADAWN_FOT.smf_ads' doesn't exist
File: /home/vol1/000hosted.com/host0_2742574/htdocs/Sources/LoadAds.php
Line: 33)
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

pls help

Thanks In Advance
Title: Re: Error After installation of Ad Management in 1.1.7
Post by: ccbtimewiz on December 23, 2008, 09:41:46 AM
Replace {$db_prefix} with your actual db prefix.