Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘simple_commerce_m_Purchase_simple_commerce_purchases.paypal_subscriber_id’ in ‘field list’:
SELECT simple_commerce_m_Purchase_simple_commerce_purchases.purchase_id as simple_commerce_m_Purchase__purchase_id, simple_commerce_m_Purchase_simple_commerce_purchases.txn_id as simple_commerce_m_Purchase__txn_id, simple_commerce_m_Purchase_simple_commerce_purchases.member_id as simple_commerce_m_Purchase__member_id, simple_commerce_m_Purchase_simple_commerce_purchases.paypal_subscriber_id as simple_commerce_m_Purchase__paypal_subscriber_id, simple_commerce_m_Purchase_simple_commerce_purchases.item_id as simple_commerce_m_Purchase__item_id, simple_commerce_m_Purchase_simple_commerce_purchases.purchase_date as simple_commerce_m_Purchase__purchase_date, simple_commerce_m_Purchase_simple_commerce_purchases.item_cost as simple_commerce_m_Purchase__item_cost, simple_commerce_m_Purchase_simple_commerce_purchases.paypal_details as simple_commerce_m_Purchase__paypal_details, simple_commerce_m_Purchase_simple_commerce_purchases.subscription_end_date as simple_commerce_m_Purchase__subscription_end_date, Item_simple_commerce_items.item_id as Item__item_id, Item_simple_commerce_items.entry_id as Item__entry_id, Item_simple_commerce_items.item_enabled as Item__item_enabled, Item_simple_commerce_items.item_regular_price as Item__item_regular_price, Item_simple_commerce_items.item_sale_price as Item__item_sale_price, Item_simple_commerce_items.item_use_sale as Item__item_use_sale, Item_simple_commerce_items.recurring as Item__recurring, Item_simple_commerce_items.subscription_frequency as Item__subscription_frequency, Item_simple_commerce_items.subscription_frequency_unit as Item__subscription_frequency_unit, Item_simple_commerce_items.item_purchases as Item__item_purchases, Item_simple_commerce_items.current_subscriptions as Item__current_subscriptions, Item_simple_commerce_items.new_member_group as Item__new_member_group, Item_simple_commerce_items.member_group_unsubscribe as Item__member_group_unsubscribe, Item_simple_commerce_items.admin_email_address as Item__admin_email_address, Item_simple_commerce_items.admin_email_template as Item__admin_email_template, Item_simple_commerce_items.customer_email_template as Item__customer_email_template, Item_simple_commerce_items.admin_email_template_unsubscribe as Item__admin_email_template_unsubscribe, Item_simple_commerce_items.customer_email_template_unsubscribe as Item__customer_email_template_unsubscribe, ChannelEntry_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_titles.site_id as ChannelEntry__site_id, ChannelEntry_channel_titles.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_titles.author_id as ChannelEntry__author_id, ChannelEntry_channel_titles.forum_topic_id as ChannelEntry__forum_topic_id, ChannelEntry_channel_titles.ip_address as ChannelEntry__ip_address, ChannelEntry_channel_titles.title as ChannelEntry__title, ChannelEntry_channel_titles.url_title as ChannelEntry__url_title, ChannelEntry_channel_titles.status as ChannelEntry__status, ChannelEntry_channel_titles.status_id as ChannelEntry__status_id, ChannelEntry_channel_titles.versioning_enabled as ChannelEntry__versioning_enabled, ChannelEntry_channel_titles.view_count_one as ChannelEntry__view_count_one, ChannelEntry_channel_titles.view_count_two as ChannelEntry__view_count_two, ChannelEntry_channel_titles.view_count_three as ChannelEntry__view_count_three, ChannelEntry_channel_titles.view_count_four as ChannelEntry__view_count_four, ChannelEntry_channel_titles.allow_comments as ChannelEntry__allow_comments, ChannelEntry_channel_titles.sticky as ChannelEntry__sticky, ChannelEntry_channel_titles.entry_date as ChannelEntry__entry_date, ChannelEntry_channel_titles.year as ChannelEntry__year, ChannelEntry_channel_titles.month as ChannelEntry__month, ChannelEntry_channel_titles.day as ChannelEntry__day, ChannelEntry_channel_titles.expiration_date as ChannelEntry__expiration_date, ChannelEntry_channel_titles.comment_expiration_date as ChannelEntry__comment_expiration_date, ChannelEntry_channel_titles.edit_date as ChannelEntry__edit_date, ChannelEntry_channel_titles.recent_comment_date as ChannelEntry__recent_comment_date, ChannelEntry_channel_titles.comment_total as ChannelEntry__comment_total, ChannelEntry_channel_data.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_data.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_data.site_id as ChannelEntry__site_id, ChannelEntry_channel_data.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_data.site_id as ChannelEntry__site_id, ChannelEntry_channel_data.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_data.field_id_221 as ChannelEntry__field_id_221, ChannelEntry_channel_data.field_ft_221 as ChannelEntry__field_ft_221, ChannelEntry_channel_data.field_id_222 as ChannelEntry__field_id_222, ChannelEntry_channel_data.field_ft_222 as ChannelEntry__field_ft_222, ChannelEntry_channel_data.field_id_223 as ChannelEntry__field_id_223, ChannelEntry_channel_data.field_ft_223 as ChannelEntry__field_ft_223, ChannelEntry_channel_data.field_id_224 as ChannelEntry__field_id_224, ChannelEntry_channel_data.field_ft_224 as ChannelEntry__field_ft_224, ChannelEntry_channel_data.field_id_225 as ChannelEntry__field_id_225, ChannelEntry_channel_data.field_ft_225 as ChannelEntry__field_ft_225, ChannelEntry_channel_data.field_id_226 as ChannelEntry__field_id_226, ChannelEntry_channel_data.field_ft_226 as ChannelEntry__field_ft_226, ChannelEntry_channel_data.field_id_227 as ChannelEntry__field_id_227, ChannelEntry_channel_data.field_ft_227 as ChannelEntry__field_ft_227, ChannelEntry_channel_data.field_id_230 as ChannelEntry__field_id_230, ChannelEntry_channel_data.field_ft_230 as ChannelEntry__field_ft_230, ChannelEntry_channel_data.field_id_231 as ChannelEntry__field_id_231, ChannelEntry_channel_data.field_ft_231 as ChannelEntry__field_ft_231, ChannelEntry_channel_data.field_id_232 as ChannelEntry__field_id_232, ChannelEntry_channel_data.field_ft_232 as ChannelEntry__field_ft_232, ChannelEntry_channel_data.field_id_233 as ChannelEntry__field_id_233, ChannelEntry_channel_data.field_ft_233 as ChannelEntry__field_ft_233, ChannelEntry_channel_data.field_id_234 as ChannelEntry__field_id_234, ChannelEntry_channel_data.field_ft_234 as ChannelEntry__field_ft_234, ChannelEntry_channel_data.field_id_235 as ChannelEntry__field_id_235, ChannelEntry_channel_data.field_ft_235 as ChannelEntry__field_ft_235, ChannelEntry_channel_data.field_id_236 as ChannelEntry__field_id_236, ChannelEntry_channel_data.field_ft_236 as ChannelEntry__field_ft_236, ChannelEntry_channel_data.field_id_237 as ChannelEntry__field_id_237, ChannelEntry_channel_data.field_ft_237 as ChannelEntry__field_ft_237, ChannelEntry_channel_data.field_id_238 as ChannelEntry__field_id_238, ChannelEntry_channel_data.field_ft_238 as ChannelEntry__field_ft_238, ChannelEntry_channel_data.field_id_239 as ChannelEntry__field_id_239, ChannelEntry_channel_data.field_ft_239 as ChannelEntry__field_ft_239, ChannelEntry_channel_data.field_id_240 as ChannelEntry__field_id_240, ChannelEntry_channel_data.field_ft_240 as ChannelEntry__field_ft_240, ChannelEntry_channel_data.field_id_241 as ChannelEntry__field_id_241, ChannelEntry_channel_data.field_ft_241 as ChannelEntry__field_ft_241, ChannelEntry_channel_data.field_id_242 as ChannelEntry__field_id_242, ChannelEntry_channel_data.field_ft_242 as ChannelEntry__field_ft_242, ChannelEntry_channel_data.field_id_243 as ChannelEntry__field_id_243, ChannelEntry_channel_data.field_ft_243 as ChannelEntry__field_ft_243, ChannelEntry_channel_data.field_id_244 as ChannelEntry__field_id_244, ChannelEntry_channel_data.field_ft_244 as ChannelEntry__field_ft_244, ChannelEntry_channel_data.field_id_245 as ChannelEntry__field_id_245, ChannelEntry_channel_data.field_ft_245 as ChannelEntry__field_ft_245, ChannelEntry_channel_data.field_id_246 as ChannelEntry__field_id_246, ChannelEntry_channel_data.field_ft_246 as ChannelEntry__field_ft_246, ChannelEntry_channel_data.field_id_247 as ChannelEntry__field_id_247, ChannelEntry_channel_data.field_ft_247 as ChannelEntry__field_ft_247, ChannelEntry_channel_data.field_id_248 as ChannelEntry__field_id_248, ChannelEntry_channel_data.field_ft_248 as ChannelEntry__field_ft_248, ChannelEntry_channel_data.field_id_249 as ChannelEntry__field_id_249, ChannelEntry_channel_data.field_ft_249 as ChannelEntry__field_ft_249, ChannelEntry_channel_data.field_id_250 as ChannelEntry__field_id_250, ChannelEntry_channel_data.field_ft_250 as ChannelEntry__field_ft_250, ChannelEntry_channel_data.field_id_251 as ChannelEntry__field_id_251, ChannelEntry_channel_data.field_ft_251 as ChannelEntry__field_ft_251, ChannelEntry_channel_data.field_id_252 as ChannelEntry__field_id_252, ChannelEntry_channel_data.field_ft_252 as ChannelEntry__field_ft_252, ChannelEntry_channel_data.field_id_253 as ChannelEntry__field_id_253, ChannelEntry_channel_data.field_ft_253 as ChannelEntry__field_ft_253, ChannelEntry_channel_data.field_id_254 as ChannelEntry__field_id_254, ChannelEntry_channel_data.field_ft_254 as ChannelEntry__field_ft_254, ChannelEntry_channel_data.field_id_255 as ChannelEntry__field_id_255, ChannelEntry_channel_data.field_ft_255 as ChannelEntry__field_ft_255, ChannelEntry_channel_data.field_id_256 as ChannelEntry__field_id_256, ChannelEntry_channel_data.field_ft_256 as ChannelEntry__field_ft_256, ChannelEntry_channel_data.field_id_257 as ChannelEntry__field_id_257, ChannelEntry_channel_data.field_ft_257 as ChannelEntry__field_ft_257, ChannelEntry_channel_data.field_id_258 as ChannelEntry__field_id_258, ChannelEntry_channel_data.field_ft_258 as ChannelEntry__field_ft_258, ChannelEntry_channel_data.field_id_259 as ChannelEntry__field_id_259, ChannelEntry_channel_data.field_ft_259 as ChannelEntry__field_ft_259, ChannelEntry_channel_data.field_id_260 as ChannelEntry__field_id_260, ChannelEntry_channel_data.field_ft_260 as ChannelEntry__field_ft_260, ChannelEntry_channel_data.field_id_261 as ChannelEntry__field_id_261, ChannelEntry_channel_data.field_ft_261 as ChannelEntry__field_ft_261, ChannelEntry_channel_data.field_id_263 as ChannelEntry__field_id_263, ChannelEntry_channel_data.field_ft_263 as ChannelEntry__field_ft_263, ChannelEntry_channel_data.field_id_264 as ChannelEntry__field_id_264, ChannelEntry_channel_data.field_ft_264 as ChannelEntry__field_ft_264, ChannelEntry_channel_data.field_id_265 as ChannelEntry__field_id_265, ChannelEntry_channel_data.field_ft_265 as ChannelEntry__field_ft_265, ChannelEntry_channel_data.field_id_266 as ChannelEntry__field_id_266, ChannelEntry_channel_data.field_ft_266 as ChannelEntry__field_ft_266 FROM (exp_simple_commerce_purchases as simple_commerce_m_Purchase_simple_commerce_purchases) LEFT JOIN exp_simple_commerce_items AS Item_simple_commerce_items ON Item_simple_commerce_items.item_id = simple_commerce_m_Purchase_simple_commerce_purchases.item_id LEFT JOIN exp_channel_titles AS ChannelEntry_channel_titles ON ChannelEntry_channel_titles.entry_id = Item_simple_commerce_items.entry_id LEFT JOIN exp_channel_data as ChannelEntry_channel_data ON ChannelEntry_channel_data.entry_id = ChannelEntry_channel_titles.entry_id ORDER BY ChannelEntry_channel_titles.title asc LIMIT 25
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error
Simple Commerce V: 2.2.1
Please advise on how to get this fixed as I would like to use Simple Commerce with PayPal. Thanks, Dave
ExpressionEngine implements Markdown Extra and BBCode. Please see the Markdown Extra docs and the BBCode Wikipedia article for a full reference.
**bold**, __bold__, *italics*, _italics_, ~strike/del~, `code()`
bold, italics, strike/del, code()
Link: [link title](https://example.com)
Image: 
[blockquote]...[/blockquote], [quote]...[/quote], and Markdown style:
> Some quoted text. > > This is all one quote.
[code]...[/code], and you can also specify the language for syntax highlighting, [code=php]...[/code]
GitHub flavored Markdown code fences are also supported:
```
public function decoderRing($str)
{
return str_rot13($str);
}
```