What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Support Resolved hi im getting error on my Mysqli (ForumSales)

jimmy

New Member
Mysqli prepare error: Unknown column 'xfa_fss_status' in 'field list'
  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 Zend/Db/Adapter/Abstract.php at line 574
  5. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
  6. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
  7. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
  8. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 830
  9. XenForo_ControllerPublic_Forum->actionAddThread() in XFA/ForumSales/Extends/ControllerPublic/Forum.php at line 33
  10. XFA_ForumSales_Extends_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 351
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in /home1/,,,,/public_html/index.php at line 13
 

Clement

Freaky Coder
Staff member
Hi,

It means it didn't install correctly for some reason.

Can you check if you have a table xfa_fss_transaction in the db.

Also if you have the fields xfa_fss_allow_sales, xfa_fss_percentage_conf and xfa_fss_percentage in the table xf_node of the db.

And check which fields you have in the xf_thread table with prefix xfa_fss.

Clément
 

jimmy

New Member
Hi,

It means it didn't install correctly for some reason.

Can you check if you have a table xfa_fss_transaction in the db.

Also if you have the fields xfa_fss_allow_sales, xfa_fss_percentage_conf and xfa_fss_percentage in the table xf_node of the db.

And check which fields you have in the xf_thread table with prefix xfa_fss.

Clément
hi yes i have xfa_fss_transaction but its emty
xfa_fss_allow_sales,xfa_fss_percentage_conf,xfa_fss_percentage i cant find in db
also i cant find the xf_thread table with prefix xfa_fss
 

Clement

Freaky Coder
Staff member
No no you misunderstood.

In the xf_node table, search for the fields I specified.

In the xf_thread table, search for the fields starting with the prefix I specified.
 

jimmy

New Member
No no you misunderstood.

In the xf_node table, search for the fields I specified.

In the xf_thread table, search for the fields starting with the prefix I specified.
sorry im bit new in all this do i find them in CP php myadmin
 

jimmy

New Member
hi yes ive find
xfa_fss_currency: - ] in the xf_thread table

[xfa_fss_allow_sales: ,xfa_fss_percentage_conf,[xfa_fss_percentage in xf_node table
 

Clement

Freaky Coder
Staff member
You only have xfa_fss_currency in the thread table ?

If so, run the following query:
Code:
                   ALTER TABLE xf_thread
                    ADD xfa_fss_status ENUM('nosale','forsale','onhold','sold') NOT NULL DEFAULT 'nosale',
                    ADD xfa_fss_quantity INT(10) UNSIGNED NOT NULL DEFAULT 1,
                   ADD xfa_fss_price DECIMAL( 10, 2 ) UNSIGNED NOT NULL DEFAULT  '0.00',
                   ADD xfa_fss_percentage DECIMAL( 10, 2 ) UNSIGNED NOT NULL DEFAULT  '0.00',
                    ADD xfa_fss_paypal varchar(250) NOT NULL DEFAULT '',
                    ADD xfa_fss_accept_manual TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
                    ADD xfa_fss_require_address TINYINT(1) UNSIGNED NOT NULL DEFAULT 0
 

jimmy

New Member
thx after running this query now i can create thread fine. But now when click to buy getting this error ( ive blank it the some directions)


Warning: Uncaught exception 'ErrorException' with message 'require_once(PPConfiguration.php): failed to open stream: No such file or directory' in /.../..../public_html/library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php:3 Stack trace: #0 /..../..../public_html/library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php(3): XenForo_Application::handlePhpError(2, 'require_once(PP...', '/..../.......', 3, Array) #1 /..../..../public_html/library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php(3): require_once() #2 /.../...../public_html/library/XFA/ForumSales/Extends/ControllerPublic/Thread.php(260): require_once('/...../.........') #3 /...../....../public_html/library/XenForo/FrontController.php(351): XFA_ForumSales_Extends_ControllerPublic_Thread->actionXfaFssPurchase() #4 /..../....../public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #5 /...../...../public_html/index.php(13): XenForo_FrontC in /...../...../public_html/library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php on line 3

Fatal error: main(): Failed opening required 'PPConfiguration.php' (include_path='/...../...../public_html/library:.:.:/opt/php56/lib/php') in /...../...../public_html/library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php on line 3
 

Clement

Freaky Coder
Staff member
Please follow the FAQ that is pointed on the product page.

It explains how to configure paypal to work with this add-on.
 

jimmy

New Member
Please follow the FAQ that is pointed on the product page.

It explains how to configure paypal to work with this add-on.
ive added 3 lines from paypal still getting error ,and on ACP error log says
Server Error Log
Error Info
ErrorException: Fatal Error: main(): Failed opening required 'PPConfiguration.php' (include_path='/......./........./public_html/library:.:.:/opt/php56/lib/php') - library/XFA/ThirdParty/AngellEye/paypal-php-library/autoload.php:3
Generated By: ...., 3 minutes ago
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
["url"] => string(66) "http://...../..php?threads/bbb.537/xfa-fss-purchase"
["_GET"] => array(1) {
["threads/bbb_537/xfa-fss-purchase"] => string(0) ""
}
["_POST"] => array(0) {
}
}
 

Clement

Freaky Coder
Staff member
In the FAQ, it is stated to to rename PPConfiguration.php.txt to PPConfiguration.php, I think you didn't do that.
 
Top