Resource icon

[SurreyForum] XenKingDir: Link / Business Directory (Directory) 1.2.0.8

No permission to download
Overview Updates (16) Reviews (21) History Discussion
Is anyone here using this for a typical "Dealer Directory" type of setup in the states?

What I am referring to is a setup when dealers can be listed or easily found on a map or in a zip code order listing.....

The add-on is very full featured by maybe too much so for my use - Im not sure if I want to see if I can make it fit or get a custom script...
 
When you add to the already existing under the topic category directory, then an error occurs:

Mysqli statement execute error : Incorrect string value: '\xD0\x9C\xD0\xBE\xD1\x81...' for column 'cat1title' at row 1

When creating a new directory entry fine. And this error is shown, if only the name is not written in Latin characters.
 
I think I have discovered a bug of sorts: I want to configure it so that the "unregistered / unconfirmed" usergroup can submit listings, but despite having ticked "Allow" on the "Can Submit Listing" permission, it still won't let me submit a new listing when I'm not logged in.

These are my permissions for the "unregistered / unconfirmed" usergroup:

Can Edit Own Listing Details: No​
Can View Directory: Allow​
Can View Reviews: Allow​
Can Submit Listing: Allow​
Can Claim Listing: No​

(I have also given the "unregistered / unconfirmed" usergroup "start thread" etc. permissions for the forum associated with the directory, but I suppose that shouldn't have any effect on this anyway?)
 
It would be nice if this addon would have rating functionality and if business owners would be able to claim listings.
 
Alfa1 said:
It would be nice if this addon would have rating functionality and if business owners would be able to claim listings.
Click to expand...


They can claim, but you are right, rating functionality would be good (I'll get back to this add-on, but the anti-spam / security is taking more priority right now)... I'll try to update it again in a few weeks
 
Another function that I would really like to see, is the function for businesses to purchase expanded listings. This would be a real money maker.
 
Hi all! i have trouble with pagination of thread in xenkingdir-forum.
thread id duplicate in url for every link
 

Attachments

  • reviews.jpg.webp
    reviews.jpg.webp
    7.9 KB · Views: 2
karll said:
I think I have discovered a bug of sorts: I want to configure it so that the "unregistered / unconfirmed" usergroup can submit listings, but despite having ticked "Allow" on the "Can Submit Listing" permission, it still won't let me submit a new listing when I'm not logged in.

These are my permissions for the "unregistered / unconfirmed" usergroup:

Can Edit Own Listing Details: No
Can View Directory: Allow
Can View Reviews: Allow
Can Submit Listing: Allow
Can Claim Listing: No

(I have also given the "unregistered / unconfirmed" usergroup "start thread" etc. permissions for the forum associated with the directory, but I suppose that shouldn't have any effect on this anyway?)
Click to expand...

Can they created a thread on the Directory Forum (don't forget, this runs off of an existing hidden Forum, so you need to give permissions to that too)
 
olegus-78 said:
Hi all! i have trouble with pagination of thread in xenkingdir-forum.
thread id duplicate in url for every link
Click to expand...

Can you send me a link to the directory via PM and to the page where this exists (I'm currently not sure where/what this issue is)
 
olegus-78 said:
When you add to the already existing under the topic category directory, then an error occurs:

Mysqli statement execute error : Incorrect string value: '\xD0\x9C\xD0\xBE\xD1\x81...' for column 'cat1title' at row 1

When creating a new directory entry fine. And this error is shown, if only the name is not written in Latin characters.
Click to expand...


This sounds like you were using an old version, can you have a look at the tables for XenKingDir, they should all be UTF-8 now
 
olegus-78 said:
Hi all! i have trouble with pagination of thread in xenkingdir-forum.
thread id duplicate in url for every link
Click to expand...


You are right, its only the top pagination (not the bottom)

I'll have to make a fix (why didn't anyone else spot this, including myself?)
 
When trying to upgrade
Server Error

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 '// ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=ut' at line 18
  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 XenKingDir/Install.php at line 105
  5. XenKingDir_Install::installCode()
  6. call_user_func() in XenForo/Model/AddOn.php at line 214
  7. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  8. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 212
  9. XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 310
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  11. XenForo_FrontController->run() in /home/z22se/public_html/forum/admin.php at line 13
 
Line 103 of the Install.php

PHP: 
                $db->query("
                CREATE TABLE IF NOT EXISTS `sf_xenkingdir_thread_map` (
                  `directory_category` int(10) NOT NULL,
                  `thread_id` int(10) NOT NULL,
                  `telephone` varchar(100) NOT NULL,
                  `address_line_1` varchar(100) NOT NULL,
                  `address_line_2` varchar(100) NOT NULL,
                  `town_city` varchar(100) NOT NULL,
                  `postcode` varchar(100) NOT NULL,
                  `website_url` varchar(200) NOT NULL,
                  `website_anchor_text` varchar(100) NOT NULL,
                  `deeplink1_url` varchar(200) NOT NULL,
                  `deeplink1_anchor_text` varchar(100) NOT NULL,
                  `deeplink2_url` varchar(200) NOT NULL,
                  `deeplink2_anchor_text` varchar(100) NOT NULL,
                  `deeplink3_url` varchar(200) NOT NULL,
                  `deeplink3_anchor_text` varchar(100) NOT NULL,
                  PRIMARY KEY (`thread_id`)
//              ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
                ");

Presuming the double // is supposed to be commenting that line out?
 
Error during upgrade
Code: 
Server Error
 
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 '//    ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=ut' at line 18
 
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenKingDir/Install.php at line 105
XenKingDir_Install::installCode()
call_user_func() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 212
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/mike/public_html/admin.php at line 13
 
yes, it's the same that MattW mentioned ... something that I changed but forget to reset in the install.php

I'll add the update now
 
You must log in or register to reply here.

Similar threads

A
Add-on edit [SurreyForum] XenKingDir - Business / Links Directory ?
Replies
1
Views
2K
wang
wang
Back
Top Bottom