Smf 1.1.11 Paid Subscriptions Problem

[blueking07]

i have a paid problem.
i see this problem.Please help me 

Database Error
Table 'smf.smf_subscriptions' doesn't exist
File: C:\Program Files\EasyPHP-5.3.2i\www\smf\Sources\ManagePaid.php
Line: 1067



this 1067 - 1183 code

// Find all the ones to remove.
   $request = db_query("
      SELECT ID_SUBSCRIBE, ID_MEMBER
      FROM {$db_prefix}log_subscribed
      WHERE status = 2
         AND endTime < " . time(), __FILE__, __LINE__);
   while ($row = mysql_fetch_assoc($request))
      removeSubscription($row['ID_SUBSCRIBE'], $row['ID_MEMBER']);
   mysql_free_result($request);



   // Store the next expire time.
   updateNextCheck();
}

?>

[YogiBear]

First prob is this is the 2x support section, blueking07. Is there a Mod in the house? 

[blueking07]

sorry i did see :S :S
but 2.0 RC3 same problem 

[smp420]

As 1.1.11 doesn't have paid subscriptions, as its a mod you should post in the mods support topic.

If your having the same problem in 2.0 RC3 then post the error message.

[JBlaze]

That error means that the smf_subscriptions table was never created.

[blueking07]

i created new table.but I dont know what to write in space :S :S

[Deaks]

if this is for 2.0 subscriptions you should run the following command in phpmyadmin

Code Select Expand

CREATE TABLE {$db_prefix}subscriptions(
  id_subscribe mediumint(8) unsigned NOT NULL auto_increment,
  name varchar(60) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  cost text NOT NULL,
  length varchar(6) NOT NULL default '',
  id_group smallint(5) NOT NULL default '0',
  add_groups varchar(40) NOT NULL default '',
  active tinyint(3) NOT NULL default '1',
  repeatable tinyint(3) NOT NULL default '0',
  allow_partial tinyint(3) NOT NULL default '0',
  reminder tinyint(3) NOT NULL default '0',
  email_complete text NOT NULL,
  PRIMARY KEY (id_subscribe),
  KEY active (active)
) ENGINE=MyISAM;


where {$db_prefix} you should change it to the prefix you use for your forum for example

smf_subscriptions