:cry:
I hate it when this happens.
Netrosis
Quote:mySQL error: 1054
Unknown column 'version' in 'field list'
Query: INSERT INTO mybb_templates(title, template, sid, version, status, dateline) VALUES ('cm_main', '\r\n\r\n\r\n$headerinclude\r\n\r\n\r\n$header\r\n$cash_mod_main\r\n$footer\r\n\r\n', -2, '100.07', '', 1139669698)
Erm... you have the right version of MyBB right? 1.0x?... Version is a standard column the template tables. Check phpmyadmin for me to see if it's in the template table.
To get rid of the 'new' errors on activation you should open the cash_mod.php plugin and comment out line 950 (in version 1.1)
cm_addSettings();
If you manage to activate it then you should uncomment the line I just showed you so it can be used if you activate the cash mod again.
Then execute the following SQL commands (make sure that you have the version column in your templates table)
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_main', '<html>\r\n<head>\r\n<title>$settings[bbname]</title>\r\n$headerinclude\r\n</head>\r\n<body>\r\n$header\r\n$cash_mod_main\r\n$footer\r\n</body>\r\n</html>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate', '<table border="0" cellspacing="$theme[borderwidth]" cellpadding="$theme[tablespace]" class="tborder">\r\n<tr>\r\n<td class="thead">\r\n<div><strong>$lang->cm_donate</strong></div>\r\n</td>\r\n</tr>\r\n<tr class="trow1">\r\n<td>\r\n$cash_mod_donate_user\r\n$cash_mod_donate_found\r\n$cash_mod_donate_cash_user\r\n</td>\r\n</tr>\r\n</table>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_error', '<div align="center"><h4>$message</h4></div>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate_user', '<form action="$cm_file_name" method="post">\r\n<input type="hidden" name="action" value="donate_find_user" />\r\n$lang->cm_find_user\r\n <input type="text" name="username" value="$username"/> <input type="submit" value="$lang->cm_find_user" />\r\n</form>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate_found', '<br/>$lang->cm_exact_match: $user_exact\r\n<br/>$lang->cm_partial_match: $user_partial', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate_user_link', '<a href="$cm_file_name?action=donate&username=$username_url">$username</a>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate_cash_user', '<br/><br/>\r\n<form action="$cm_file_name" method="post">\r\n<input type="hidden" name="action" value="donate_confirm" />\r\n<input type="hidden" name="uid" value="$uid" />\r\n<input type="hidden" name="username" value="$username" />\r\n{$lang->cm_donating_to}<br/>\r\n{$lang->cm_user_amount}<br/>\r\n{$lang->cm_enter_donate_amount} <input\r\n type="text" name="amount" size="4" />\r\n<br/><br/>\r\n<input type="submit" value="{$lang->cm_donate}" />\r\n</form>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_donate_confirm', '<div align="center">\r\n{$lang->cm_donate_confirm_1}\r\n{$lang->cm_donate_confirm_2}\r\n<br/><br/>\r\n<form action="$cm_file_name" method="post">\r\n<input type="hidden" name="action" value="donate_confirmed" />\r\n<input type="hidden" name="amount" value="$amount" />\r\n<input type="hidden" name="trans_id" value="$trans_id" />\r\n<input type="hidden" name="uid" value="$uid" />\r\n<input type="submit" name="donate_button" value="{$lang->yes}" /> <input type="submit" name="donate_button" value="{$lang->no}" />\r\n</div>\r\n<br/>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement', '<html>\r\n<head>\r\n<title>$lang->user_cp</title>\r\n$headerinclude\r\n</head>\r\n<body>\r\n$header\r\n<table width="100%" border="0" align="center">\r\n<tr>\r\n$usercpnav\r\n<td valign="top">\r\n<table border="0" cellspacing="$theme[borderwidth]" cellpadding="$theme[tablespace]" class="tborder">\r\n<td class="thead" colspan="$colspan"><strong>$lang->cm_statement</strong></td>\r\n</tr>\r\n<tr class="trow1">\r\n<td>\r\n$donations\r\n$interest\r\n$referrers\r\n<br/>\r\n</td>\r\n</tr>\r\n</table>\r\n</td>\r\n</tr>\r\n</table>\r\n$footer\r\n</body>\r\n</html>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_donation', '<br/>$page_bar\r\n<table border="0" cellspacing="1" cellpadding="4" class="tborder">\r\n<tr>\r\n<td colspan="3" class="thead">$lang->cm_donations</td>\r\n</tr>\r\n<tr class="tcat">\r\n<td>$lang->cm_date</td>\r\n<td>$lang->cm_username</td>\r\n<td>$lang->cm_amount</td>\r\n</tr>\r\n$rows\r\n</table>\r\n$page_bar<br/>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_donation_row', '<tr class="$altbd">\r\n<td>$date</td>\r\n<td><a href="member.php?action=profile&uid=$uid">$username</a></td>\r\n<td>$amount</td>\r\n</tr>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_interest', '<br/>$page_bar\r\n<table border="0" cellspacing="1" cellpadding="4" class="tborder">\r\n<tr>\r\n<td colspan="4" class="thead">$lang->cm_interest</td>\r\n</tr>\r\n<tr class="tcat">\r\n<td>$lang->cm_date</td>\r\n<td>$lang->cm_interest_rate</td>\r\n<td>$lang->cm_interest_added</td>\r\n<td>$lang->cm_after_interest</td>\r\n</tr>\r\n$rows\r\n</table>\r\n$page_bar<br/>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_interest_row', '<tr class="$altbd">\r\n<td>$date</td>\r\n<td>{$amount_percent}%</td>\r\n<td>$amount_added</td>\r\n<td>$amount_final</td>\r\n</tr>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_ref', '$lang->cm_referrers: $ref_links ($amount)', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_ref_link', '<a href="member.php?action=profile&uid=$uid">$username</a>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_page_link', '<a href="$cm_file_name?action=$action&page=$page&action2=$action2">$page</a>', -2, '100.07', '', 1139669698);
INSERT INTO `mybb_templates`(title, template, sid, version, status, dateline) VALUES ('cm_statement_page_bar', '$lang->cm_page : $page_bar', -2, '100.07', '', 1139669698);
Boring dude, to fix the signature problem open usercp.php
find
eval("$editsig = \"".$templates->get("usercp_editsig")."\";");
replace with
eval("\$editsig = \"".$templates->get("usercp_editsig")."\";");
But I _strongly_ suggest you try to update it using advanced plugins. The upgrade also solves a few little bugs (people can use [cash] even if you disallow it). You should be apply to apply the patch manually and it should be ok if you manage to upgrade properly through advanced plugins. My site might have been down when you tried. Try it again.
