Help with this error

[RZ500]

I keep geting this error when I try to activate a pay subscription and I can not make it work, any help please?.


Database error in vBulletin 3.6.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO subscription
(`active`, `displayorder`, `nusergroupid`, `options`, `adminoptions`, `cost`, `membergroupids`, `forums`)
VALUES
('1', '1', '-1', '0', '0', 'a:1:{i:0;a:5:{s:4:\"cost\";a:5:{s:3:\"usd\";s:5:\ "33.00\";s:3:\"gbp\";s:4:\"0.00\";s:3:\"eur\";s:4: \"0.00\";s:3:\"aud\";s:4:\"0.00\";s:3:\"cad\";s:4: \"0.00\";}s:6:\"length\";i:1;s:5:\"units\";s:1:\"Y \";s:11:\"ccbillsubid\";s:0:\"\";s:9:\"recurring\" ;i:0;}}', '', '');

MySQL Error : Unknown column 'active' in 'field list'
Error Number : 1054
Date : Wednesday, May 2nd 2007 @ 05:12:37 PM
Script : http://7000rpm.com/forum/admincp/sub....php?do=update
Referrer : http://7000rpm.com/forum/admincp/sub...ons.php?do=add
IP Address : 189.137.114.72
Username : RZ500
Classname : vb_database

[WetWired]

You are missing a field named active in the subscription table. No clue as to why, but it's a smallint unsigned. If you add it to the table in phpAdmin, the error should stop.

[RZ500]

Originally Posted by WetWired

You are missing a field named active in the subscription table. No clue as to why, but it's a smallint unsigned. If you add it to the table in phpAdmin, the error should stop.

I;m not to good at this where can I find it?

And thanks for your help.

I Think I know where, but I do not know thw information that is asking

Thanks I have it runing now.

Now a new one, how can I activate my subscription, so the users can acces to it?

Now I have this problem:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT status, regdate, expirydate, subscriptionlogid, subscription.subscriptionid
FROM subscriptionlog AS subscriptionlog
INNER JOIN subscription AS subscription USING (subscriptionid)
WHERE userid = 2
ORDER BY status DESC, regdate;

MySQL Error : Unknown column 'expirydate' in 'field list'
Error Number : 1054
Date : Friday, May 11th 2007 @ 02:43:16 PM
Script : http://www.7000rpm.com/forum/admincp...hp?do=edit&u=2
Referrer : http://www.7000rpm.com/forum/admincp/user.php?do=modify
IP Address : 189.137.116.159
Username : RZ500
Classname : vb_database


And I can't find the fild list table

Never Mind I found it, next time you are in Mexico City I pay the Tequila or the Beers or bouth.

1000 gracias