GoodForNothing Classifieds [Paid] [Deleted]

and the checks I've done myself
Code:
[root@li958-32 bdCache]# cd EWRporta/ControllerPublic/
[root@li958-32 ControllerPublic]# md5sum Articles.php
5081e35ee8cc64433429056c1255c2bc  Articles.php
[root@li958-32 ControllerPublic]# md5sum Portal.php
6fecc2fc9debb502718003fc6709f4a5  Portal.php
[root@li958-32 ControllerPublic]#

PHP:
<?php

class bdCache_FileSums
{
        public static function getHashes()
        {
                return array (
  // 'library/bdCache/FileSums.php' => '299a23a2291e2126b91d54f3601ec162',
  'library/bdCache/ControllerHelper/Cache.php' => 'fe7ed1cbbf7e2cb6e7d46acf4a49d96b',
  'library/bdCache/Core.php' => 'eafafa307c21e705a1d6fe7936770cbf',
  'library/bdCache/CronEntry/CleanUp.php' => '1ee84e5f8fdaf9fa461e21adc507a352',
  'library/bdCache/Crypt.php' => '4eaf25d745eae9b60a90b88758e5ac95',
  'library/bdCache/Css.php' => '6e90a448ec1baf3238003e60c5cacde3',
  'library/bdCache/EWRPorta/ControllerPublic/Articles.php' => '5081e35ee8cc64433429056c1255c2bc',
  'library/bdCache/EWRPorta/ControllerPublic/Portal.php' => '6fecc2fc9debb502718003fc6709f4a5',
  'library/bdCache/File.php' => '2c87b1a93bf1f0d89db09de4430b2f6f',
  'library/bdCache/Installer.php' => '7808c10673c7fc7bf52290ccdae1837d',
  'library/bdCache/Js.php' => '0bc06e472848de514c067d21594fa884',
  'library/bdCache/Listener.php' => '10870c6d6f295d2316c012f667aefc92',
  'library/bdCache/Model/Cache.php' => 'aa8a82d31f0a9e492006e7c13607919d',
  'library/bdCache/Option.php' => '4c278624247705c9ce6f7f12776b7b3c',
  'library/bdCache/ShippableHelper/TempFile.php' => 'cac49e7a9dd4eaca7ac61c059e207547',
  'library/bdCache/ShippableHelper/Updater.php' => '0df7d7c7951368188be49cc5b254e7f7',
  'library/bdCache/XenForo/ControllerPublic/Forum.php' => '668e734167368af0f97b8a526b2a6db4',
  'library/bdCache/XenForo/ControllerPublic/Index.php' => '42c957ec603b0ea84802c508cf0be8f5',
  'library/bdCache/XenForo/ControllerPublic/Member.php' => 'cb9f0c198eb67458e1fa3070c3e585fa',
  'library/bdCache/XenForo/ControllerPublic/Misc.php' => 'cce6a572c51188c20c3244d0fc3deefd',
  'library/bdCache/XenForo/ControllerPublic/Thread.php' => 'b4ac6768cdd3d3e6e94343eac475d086',
  'library/bdCache/XenForo/DataWriter/DiscussionMessage/Post.php' => '9a9c677d5d90e26772064e82a586e832',
  'library/bdCache/XenForo/Model/Permission.php' => 'c4700fac55a2d8de27e6d65cdd93b26c',
  'library/bdCache/XenForo/Model/Thread.php' => 'e4670fc770e3cd418d7382342db53171',
  'library/bdCache/XenForo/Model/User.php' => '2c61f5749f749e70c2796f41b99ee79f',
  'library/bdCache/XenResource/ControllerPublic/Author.php' => '5501531fb866a9f5933efe8c863eec83',
  'library/bdCache/XenResource/ControllerPublic/Resource.php' => 'e108da77af135379c04b210337d4bbf9',
);
        }
}

New version has been made available on xfrocks.com to address the file health check issue. Please contact me directly to obtain the fix manually if you cannot download the patched version.

No, of course.
If you interesting with this problem, i can enable your plugin then give you the my URL so you can look on the source code what happen. Second refresh everytime looking two .css files from bdcache directory but others everytime i see one php file, one css file.

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column 'user_id' cannot be null - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Nels, 9 minutes ago
Stack Trace
#0 /home/hobbymac/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/hobbymac/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/hobbymac/public_html/library/XenForo/Model/UserGroupPromotion.php(372): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...', Array)
#3 /home/hobbymac/public_html/library/XenForo/Model/UserGroupPromotion.php(319): XenForo_Model_UserGroupPromotion->insertPromotionLogEntry(2, NULL, 'automatic')
#4 /home/hobbymac/public_html/library/XenForo/Model/UserGroupPromotion.php(289): XenForo_Model_UserGroupPromotion->promoteUser(Array, NULL)
#5 /home/hobbymac/public_html/library/XenForo/Deferred/UserGroupPromotion.php(48): XenForo_Model_UserGroupPromotion->updatePromotionsForUser(Array, Array, Array)
#6 /home/hobbymac/public_html/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_UserGroupPromotion->execute(Array, Array, 7.99999809265, '')
#7 /home/hobbymac/public_html/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.99999809265, '', false)
#8 /home/hobbymac/public_html/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#9 /home/hobbymac/public_html/library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, '', false)
#10 /home/hobbymac/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#11 /home/hobbymac/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/hobbymac/public_html/admin.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
["url"] => string(59) "http://www.hobby-machinist.com/admin.php?tools/run-deferred"
["_GET"] => array(1) {
["tools/run-deferred"] => string(0) ""
}
["_POST"] => array(5) {
["execute"] => string(1) "1"
["_xfRequestUri"] => string(19) "/admin.php?add-ons/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}




Hi,

This appears to be caused by GFN Classifieds, which is modifying the query but not accounting for situations where users are missing from its table. The author will need to adjust the query to be more resilient in this scenario. The only recommend I could make for a current workaround would be to disable the add-on.

Regards,
Mike

The support people confirmed that this addon is the source of server errors on my server.
Please repair these errors so that I can use it.

"Hi,

It appears that you disabled the Classifieds add-on while I was attempting to disable all add-ons to confirm. However, with that add-on disabled, I have confirmed that the user group promotion rebuild can now be completed successfully, which confirms that as the underlying cause.

Regards,
Mike
20 minutes ago"

I believe the specific issue is this query:
Code:
SELECT user.*
                    ,
                    user_profile.*,
                    user_option.*,
                    user_privacy.*, trader.*
                FROM xf_user AS user
              
                    LEFT JOIN xf_user_profile AS user_profile ON
                        (user_profile.user_id = user.user_id)
                    LEFT JOIN xf_user_option AS user_option ON
                        (user_option.user_id = user.user_id)
                    LEFT JOIN xf_user_privacy AS user_privacy ON
                        (user_privacy.user_id = user.user_id) LEFT JOIN gfn_classifieds_trader AS trader ON (trader.user_id = user.user_id)

The query needs to be rewritten so it does not overwrite user_id.

Upgrade this addon every time wondering if the errors I reported are fixed but sadly disable it again seeing they are not.
I'm also getting some errors related to user_id after enabling this addon.
Code:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column 'user_id' cannot be null - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 12 minutes ago
Stack Trace
#0 /var/www/xxx.com/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/xxx.com/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/xxx.com/library/XenForo/Model/UserConfirmation.php(100): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT INT...', Array)
#3 /var/www/xxx.com/library/XenForo/Model/UserConfirmation.php(231): XenForo_Model_UserConfirmation->generateUserConfirmationRecord(NULL, 'password')
#4 /var/www/xxx.com/library/XenForo/ControllerPublic/LostPassword.php(84): XenForo_Model_UserConfirmation->sendPasswordResetRequest(Array)
#5 /var/www/xxx.com/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_LostPassword->actionLost()
#6 /var/www/xxx.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /var/www/xxx.com/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(48) "http://www.movilesdualsim.com/lost-password/lost"
  ["_GET"] => array(1) {
    ["/lost-password/lost"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["username_email"] => string(25) "xxx@gmail.com"
    ["g-recaptcha-response"] => string(953) "xxxxxx"
    ["_xfToken"] => string(8) "********"
  }
}
Hope it can be solved soon.
 
Suggestion:

Classified Edit History
  1. public/private(usergroup permission) to view the edit history and differences
  2. usergroup permission to restore a classified state before and edit
  3. notify people that follow the classified if there's a change and what's changed (before/after)
  4. moderate edits (moderation queue)
 
Hi! I was trying to add the "Add Classified" button in the associated forum, so instead of having the "Create Thread" button, the "Add Classified" button shows. I can't find the way to do so.

At "edit category" I already associated a forum at "utomatically Create Thread in Forum" option.
It creates a new thread correctly using classified system, but there's no "Add Classified" button at the subforum.

I looked for an option at "Edit Forum" and at Options/Threads and Messages
@Mr. Goodie2Shoes any idea what I'm missing?

PS: it was a problem with permissions related to another plugin... https://xenforo.com/community/threads/quick-reply-for-guest-pro-paid.102429/page-4#post-1069999
 
Last edited:
been out of the loop for a while, hey Mr.G2S

Will we be getting a decent search bar or search functionality on the classifieds homepage. And have it turn up listings and let the user sort by most recent etc?

I am hoping to implement an eBay/Gumtree like search bar that sits above the classifieds page.

chrome_2016-05-24_21-35-28.webp
 
template "classifieds_item_description" 1.0.0 Beta 10 syntax error classified :
Code:
<xen:container var="$head.canonical">
    <link rel="canonical" href="{xen:link canonical:classified, $classified}" />
</xen:container>
right: classifieds
Code:
<xen:container var="$head.canonical">
    <link rel="canonical" href="{xen:link canonical:classifieds, $classified}" />
</xen:container>
 
Last edited:
Can anyone advise if there is a way that a user could use POA (Price On Application) instead of inserting a price?
 
Is anyone using RC6 live on a website? How's it working? Any major bugs that prevent it from going live? I purchased a license a while ago but have been holding back implementing it until a gold mostly bug-free release. I'm so tired of waiting.
 
Top Bottom