Support Resolved Unknown column 'xfa_rmmp_purchases' in 'where clause'

[Thunderbelly]

How do I fix this. been trying for hours, tried reinstalling everything. no such luck.


Mysqli prepare error: Unknown column 'xfa_rmmp_purchases' in 'where clause'

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
5. XenForo_Model->fetchAllKeyed() in XenResource/Model/Resource.php at line 112
6. XenResource_Model_Resource->getResources() in XFA/RMMarketPlace/Extends/XenResource/ControllerPublic/Resource.php at line 277
7. XFA_RMMarketPlace_Extends_XenResource_ControllerPublic_Resource->actionIndex() in XenForo/FrontController.php at line 369
8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
9. XenForo_FrontController->run() in /home/mctradeo/public_html/index.php at line 13

 

[Clement]

Strange, was that a clean install ? Or an upgrade ?

Please tell me which columns starting by xfa_rmmp you have in the xf_resource table ?

You should have the followings :

ALTER TABLE xf_resource
ADD xfa_rmmp_type ENUM('none','digital','physical','service') NOT NULL DEFAULT 'none',
ADD xfa_rmmp_amount DECIMAL( 10, 2 ) UNSIGNED NOT NULL DEFAULT '0.00',
ADD xfa_rmmp_currency varchar(3) NOT NULL DEFAULT '',
ADD xfa_rmmp_paypal varchar(250) NOT NULL DEFAULT '',
ADD xfa_rmmp_accept_other tinyint(1) NOT NULL DEFAULT 0,
ADD xfa_rmmp_purchases INT(10) UNSIGNED NOT NULL DEFAULT 0,
ADD xfa_rmmp_cgv MEDIUMTEXT NOT NULL DEFAULT '',
ADD xfa_rmmp_img_date INT UNSIGNED NOT NULL DEFAULT 0

So basically we need to find out which are missings and modify that query accordingly.

Clément

 

[Thunderbelly]

Strange, was that a clean install ? Or an upgrade ?

Please tell me which columns starting by xfa_rmmp you have in the xf_resource table ?

You should have the followings :

ALTER TABLE xf_resource
ADD xfa_rmmp_type ENUM('none','digital','physical','service') NOT NULL DEFAULT 'none',
ADD xfa_rmmp_amount DECIMAL( 10, 2 ) UNSIGNED NOT NULL DEFAULT '0.00',
ADD xfa_rmmp_currency varchar(3) NOT NULL DEFAULT '',
ADD xfa_rmmp_paypal varchar(250) NOT NULL DEFAULT '',
ADD xfa_rmmp_accept_other tinyint(1) NOT NULL DEFAULT 0,
ADD xfa_rmmp_purchases INT(10) UNSIGNED NOT NULL DEFAULT 0,
ADD xfa_rmmp_cgv MEDIUMTEXT NOT NULL DEFAULT '',
ADD xfa_rmmp_img_date INT UNSIGNED NOT NULL DEFAULT 0

So basically we need to find out which are missings and modify that query accordingly.

Clément

No tables exist with xfa_rmmp_* name
and it was a clean install.

 

[Clement]

Read back my message, I asked you to look if columns exist in the xf_resource table.

Though it's odd you should be having some xfa_rmmp tables:
xfa_rmmp_transaction
xfa_rmmp_purchase
xfa_rmmp_purchase_add_info
xfa_rmmp_digital_product
xfa_rmmp_physical_product
xfa_rmmp_license
xfa_rmmp_seller_info
xfa_rmmp_featuring_purchase
xfa_rmmp_featuring_duration

 

[Thunderbelly]

the table xf_resource table does not seem to exist at all either.

 

[Clement]

???

You don't have the Resource Manager add-on ?

It's a pre requisite, refer to our product page regarding dependencies.

Clement

 

[Thunderbelly]

for whatever reason, the resource manager plugin seemed to magically work after another reinstall. thanks anyway!