XenCentral Feedback System [Paid] 1.15.0

[XCentral]

Hello, @Marcel

Unfortunately it is very hard to reproduce and fix the problem locally, so please contact us at https://desk.xencentral.com and provide the details of the board (FTP/Admin) and we will try ourselves and see why it happens in your case.

Thank you!

 

[Marcel]

Thanks @XCentral I'll open a ticket later this evening

 

[Brent W]

I have an import issue. Posted on your official forum.

 

[XCentral]

XCentral updated XenCentral Trading System with a new update entry:

Bug-fix release for XenCentral Trading System

Hello everyone,

This is a bug-fix release recommended for everyone to apply, as it fixes a permission problem, allowing regular users to edit feedback.

Please login to your Client Area to download the package.

Thank you!

Read the rest of this update entry...

 

[Stuart Wright]

Had a couple of these just now. Is it a bug?

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Chris Deeming, 3 minutes ago
Stack Trace
#0 /home/sites/avforums/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?? ...')
#1 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?? ...')
#2 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?? ...')
#3 /home/sites/avforums/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?? ...', Array, 2)
#4 /home/sites/avforums/public_html/library/XenCentral/Trade/Model/Conversation.php(43): XenForo_Model->fetchAllKeyed('?? ...', 'user_id')
#5 /home/sites/avforums/public_html/library/XenForo/ControllerPublic/Conversation.php(315): XenCentral_Trade_Model_Conversation->getConversationMessages(3446118, Array)
#6 /home/sites/avforums/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_Conversation->actionView()
#7 /home/sites/avforums/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/sites/avforums/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(89) "http://www.avforums.com/conversations/re-he-discount.3446118/?conversation_user_id=115728"
["_GET"] => array(1) {
["conversation_user_id"] => string(6) "115728"
}
["_POST"] => array(0) {
}
}

 

[Chris D]

Had a couple of these just now. Is it a bug?

Just to further expand on that:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: bighfishing, Today at 6:44 PM
Stack Trace
#0 /home/sites/avforums/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?? ...')
#1 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?? ...')
#2 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?? ...')
#3 /home/sites/avforums/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?? ...', Array, 2)
#4 /home/sites/avforums/public_html/library/XenCentral/Trade/Model/Conversation.php(43): XenForo_Model->fetchAllKeyed('?? ...', 'user_id')
#5 /home/sites/avforums/public_html/library/XenForo/ControllerPublic/Conversation.php(315): XenCentral_Trade_Model_Conversation->getConversationMessages(3446118, Array)
#6 /home/sites/avforums/public_html/library/ConvEss/ControllerPublic/Conversation.php(394): XenForo_ControllerPublic_Conversation->actionView()
#7 /home/sites/avforums/public_html/library/XenForo/FrontController.php(337): ConvEss_ControllerPublic_Conversation->actionView()
#8 /home/sites/avforums/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/sites/avforums/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(61) "http://www.avforums.com/conversations/re-he-discount.3446118/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

There are two participants in this conversation, one of them has been deleted. When the other guy tries to get into it, he gets this error.

 

[Brent W]

Having problems importing data:

Ok I am trying to wrap my head around this:
I have two databases. One database is the current xenForo database I want to import into. The other database is the vBulletin database I want to import from.

How do I go about importing when my import log table in the xenForo database is called archived_import_log_v6online

 

[Marcel]

Hi

We also have a bit of a problem

One particular user, when trying to have feedback left *for* him, the "Add feedback" button just times out when clicked.
I noticed that turning off "Check Thread Starter" in the admin panel stops this.

 

[AzzidReign]

Having problems importing data:

Still waiting on your answer? Or did they answer else where? I'm thinking about buying this but it seems support isn't around here.

 

[Brent W]

Still waiting on your answer? Or did they answer else where? I'm thinking about buying this but it seems support isn't around here.

You have to keep the import log table named xf_import_log or whatever it is by default. I renamed it and then once the import was done I renamed it back to the archived one I was using.

 

[XCentral]

Hello everyone,

The issues reported above are being addressed and a bug-fix release will be released soon.

@Marcel , could you please contact us at http://desk.xencentral.com and provide more information about your problem? It does not seem to be common problem, and is showhow specific to your setup.

Thank you!

 

[drifter4ever]

How does Xencentral Trading System count feeback scores? A user's all 116 feedbacks are positive, however his feedback score is only 87.

 

[XCentral]

How does Xencentral Trading System count feeback scores? A user's all 116 feedbacks are positive, however his feedback score is only 87.

It seems you have activated Unique Ratings option, and there are multiple positive feedback from the same user, that is why the numbers are different. You can try try deactivate unique ratings and see if it works for you.

Thank you!

 

[Marcel]

.

@Marcel , could you please contact us at http://desk.xencentral.com and provide more information about your problem? It does not seem to be common problem, and is showhow specific to your setup.

Thank you!

Done!

 

[XCentral]

XCentral updated XenCentral Trading System with a new update entry:

XenCentral Trading System 1.3.5 released

Hello everyone,

This is a bug-fix release for XenCentral Trading System that addresses the following issues:
1. Adding feedback on big-boards with "Check Thread Starter" option enabling taking too long and timing-out. The product was checking for all possible threads that match apprpriate criteria - are in configured forums, are started by one of feedback parties and the other party has a post in it. A new option is now implemented to avoid this pre-check partially if it takes too long on your...

Read the rest of this update entry...

 

[Stuart Wright]

Can you expand please on how the user now finds the trading thread? If it's a big SQL statement which is the problem, can we help optimise it at all?

 

[XCentral]

Can you expand please on how the user now finds the trading thread? If it's a big SQL statement which is the problem, can we help optimise it at all?

Here are the conditions applied when looking for possible deal threads:

1. Thread is in configured forums
2. Thread starter is one of feedback parties
3. Thread title matches search query (when using Find Thread link)
4. Both parties have a post in the thread (e.g. if one started it, another has a reply there).

The first 3 conditions work on large number of rows without a problem. The last condition requires joining post table to thread table two times. Join uses indexes, however, when there are many threads matching the first 3 criteria, and there are millions of rows in post table, this join becomes very resource-intensive. So, with new option implemented, this last check will not be done while suggesting threads (when user uses Find Thread link and starts typing thread title). Other 3 conditions will still apply, so almost always users will see correct results anyway (especially as they know for which thread they are actually leaving feedback). If user chooses a thread, where he/she does not have any reply (so it does not satisfy the last condition), and tries to leave a feedback, they will see regular error message that thread selected is not valid deal thread.

So, the 4th condition will be checked only when submitting feedback, and not while suggesting threads. No interface changes in the way thread is selected/entered are implemented with this version.

Let us know if you have any other questions.

Thank you!

 

[Stuart Wright]

Thanks for the clarification.

I haven't actually used the feedback system myself, though hundreds of our users have successfully done so.
So I don't know the answer to this. Do people still have to type the title of the thread? If so, why?
Why not just do the search and show them all appropriate threads? In reverse date order? Surely this will be much easier for people?

 

[XCentral]

Thanks for the clarification.

I haven't actually used the feedback system myself, though hundreds of our users have successfully done so.
So I don't know the answer to this. Do people still have to type the title of the thread? If so, why?
Why not just do the search and show them all appropriate threads? In reverse date order? Surely this will be much easier for people?

The product already has this feature, when there are less than 10 threads matching all criteria the list of threads is shown and user can just select one. When there are more threads, user can just paste thread URL (assuming they leave feedback for a real thread, they know where that thread is) or typing its name with autosuggestion (again, if they are leaving feedback for something they have been dealing with, they will easily remember what the the title of the thread, at least parts of it).

Let us know if you have any suggestions on this matter.

Thank you!

 

[Stuart Wright]

That's good because we allow one thread per person per forum, so the number of threads should theoretically be less than 10 most of the time. If you want feedback, you are very welcome to ask our trading community and our moderators. They have been using iTrader on vBulletin for years, and will be happy to give suggestions, I'm sure.