I got this error message when I tried to replace an ad in the ad management section.
Unknown column 'CATEGORY' in 'field list'
File: c:\hosting\webhost4life\member\slmbodywork1\forum\Sources\Ads.php
Line: 289
Line 289 : $adsUpdate[] = 'show_topofpage = ' . (empty($_POST['show_topofpage']) ? '0' : '1');
Default theme, SMF 1.1.2. Ad mod 2.3
Any ideas?
Is the Ads.php file in the Sources directory. ???
Yep.
re-upload it and see what happens. If that doesn't work this is probably a database error. I will have to let Jerm know.
Done, no change.
Could there be an issue in that the ads were originally from an earlier version of the ad mod? Perhaps they're not completely compatible with this newest version.
The ads you place yourself and they should have nothing to do with the version of ad mod you are running.
The table didn't get created properly. You can try uninstalling the mod and reinstalling it.
what table was not created properly. the mod i downloaded did not create any tables ... help !!
Quote from: jerm on March 18, 2007, 12:16:12 AM
You can try uninstalling the mod and reinstalling it.
There is no Table 'CATEGORY' in the DB.
if (!defined('SMF'))
die('Hacking attempt...');
function loadads()
{
global $db_prefix;
global $adverts;
$query = db_query("
SELECT *
FROM {$db_prefix}ads
order by ADS_ID", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($query))
{
$adverts[] = array(
'id' => $row['ADS_ID'],
'name' => $row['NAME'],
'content' => $row['CONTENT'],
'boards' => $row['BOARDS'],
'posts' => $row['POSTS'],
'category' => $row['CATEGORY'], // <-- there is no table 'CATEGORY' in the DB
'hits' => $row['HITS'],
Look into the install.php
<?php
/*
Installing the ad mod for the first time
*/
db_query("
CREATE TABLE IF NOT EXISTS {$db_prefix}ads (
ADS_ID mediumint(8) unsigned NOT NULL auto_increment,
NAME tinytext NOT NULL,
CONTENT text NOT NULL,
BOARDS tinytext,
POSTS tinytext,
HITS mediumint(8) NOT NULL default '0',
TYPE smallint(4) NOT NULL default '0',
show_index smallint(4) NOT NULL default '0',
show_board smallint(4) NOT NULL default '0',
show_threadindex smallint(4) NOT NULL default '0',
show_lastpost smallint(4) NOT NULL default '0',
show_thread smallint(4) NOT NULL default '0',
show_bottom smallint(4) NOT NULL default '0',
show_welcome smallint(4) NOT NULL default '0',
show_topofpage smallint(4) NOT NULL default '0',
show_towerright smallint(4) NOT NULL default '0',
show_towerleft smallint(4) NOT NULL default '0',
show_betweencategories smallint(4) NOT NULL default '0',
show_underchildren smallint(4) NOT NULL default '0',
PRIMARY KEY (ADS_ID)
)", __FILE__, __LINE__);
i start to build a new Table in the DB
<?php
/*
Installing the ad mod for the first time
*/
db_query("
CREATE TABLE IF NOT EXISTS {$db_prefix}ads (
ADS_ID mediumint(8) unsigned NOT NULL auto_increment,
NAME tinytext NOT NULL,
CONTENT text NOT NULL,
CATEGORY text, // <-- this will install the new table
BOARDS tinytext,
POSTS tinytext,
HITS mediumint(8) NOT NULL default '0',
TYPE smallint(4) NOT NULL default '0',
show_index smallint(4) NOT NULL default '0',
show_board smallint(4) NOT NULL default '0',
show_threadindex smallint(4) NOT NULL default '0',
show_lastpost smallint(4) NOT NULL default '0',
show_thread smallint(4) NOT NULL default '0',
show_bottom smallint(4) NOT NULL default '0',
show_welcome smallint(4) NOT NULL default '0',
show_topofpage smallint(4) NOT NULL default '0',
show_towerright smallint(4) NOT NULL default '0',
show_towerleft smallint(4) NOT NULL default '0',
show_betweencategories smallint(4) NOT NULL default '0',
show_underchildren smallint(4) NOT NULL default '0',
PRIMARY KEY (ADS_ID)
)", __FILE__, __LINE__);
now it runs on pragmamx with smf 1.1.2
I will have one problem to.
After the install of this mod.
When i will go to the admin section of the forum, there is no link for administration in my adminprofile.
I tipp manually Forum&action=admin in the browser, then i will get the forum admin page.
Anyone a Idee where i can change this.
P.s. sorry for my english ;)
i get the same problem, and i have run the queries in the db, i did a complete manual install and this is what i get
Unknown column 'CATEGORY' in 'field list'
File: /var/www/vhosts/seasonedtradelines.net/httpdocs/community/Sources/Ads.php
Line: 289
this is line 289
WHERE ADS_ID = '$_REQUEST[ad]'", __FILE__, __LINE__);
smf 1.1.2 smfad 2.3