Okay.....what in the world did I do wrong! lol
I copied the query in and ran it against the 'subscriptions' table, and after applying all the php edits, I get this when I attempt to update the subscriptions area in the admin cp.
Quote:
Invalid SQL: UPDATE subscription SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Silver Subscriber Monthly',
description = 'Thank you for your interest in subscribing to WotR. Forum Benefits for the Silver Subscriber are:
A custom Avatar of your choice
A custom title of your choice
An additional avatar showing their status as subscribers and supporters of the site.',
length = '30',
units = 'D',
cost = 'a:3:{s:3:\"usd\";s:4:\"5.00\";s:3:\"gbp\";s:4:\"0 .00\";s:3:\"eur\";s:4:\"0.00\";}',
nusergroupid = '9',
active = '0',
reoccur = '0',
membergroupids = '',
forums = 'N;'
WHERE subscriptionid=1
mysql error: Unknown column 'reoccur' in 'field list'
mysql error number: 1054
Date: Friday 01st of October 2004 07:01:28 PM
|