xfrocks
Well-known member
Just answered your question here https://xfrocks.com/api-support/thr...er-upgrades-between-multiple-xf-installs.557/
Awesome work
![[bd] API](/community/data/resource_icons/1/1732.jpg?1592293908){kind=icon}
[bd] API 1.6.3
- Thread starter xfrocks
- Start date
FloV
Well-known member
[bd]API 1.5.1: i have Millions of this in the error log:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Column 'user_id' in field list is ambiguous - library/Zend/Db/Statement/Mysqli.php:77
#0 /var/www/xxx/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT * FROM `...')
#1 /var/www/xxx/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT * FROM `...')
#2 /var/www/xxx/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT * FROM `...')
#3 /var/www/xxx/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('SELECT * FROM `...', Array)
#4 /var/www/xxx/api.php(4426): Zend_Db_Adapter_Abstract->fetchRow('SELECT * FROM `...')
#5 /var/www/xxx/api.php(2106): XenAPI->getGroup('?' UNION ALL SE...')
#6 /var/www/xxx/api.php(56): RestAPI->processRequest()
#7 {main}
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Column 'user_id' in field list is ambiguous - library/Zend/Db/Statement/Mysqli.php:77
#0 /var/www/xxx/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT * FROM `...')
#1 /var/www/xxx/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT * FROM `...')
#2 /var/www/xxx/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT * FROM `...')
#3 /var/www/xxx/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('SELECT * FROM `...', Array)
#4 /var/www/xxx/api.php(4426): Zend_Db_Adapter_Abstract->fetchRow('SELECT * FROM `...')
#5 /var/www/xxx/api.php(2106): XenAPI->getGroup('?' UNION ALL SE...')
#6 /var/www/xxx/api.php(56): RestAPI->processRequest()
#7 {main}
xfrocks
Well-known member
Those are not from this add-on FYI.
xfrocks
Well-known member
So I have just played around with IFTTT Maker channel and this is how I configured IFTTT to create a new thread every time I like a tweet:
Basically you just need to select POST as method, and application/x-www-form-urlencoded as content type. Then enter the API url, here I used "https://xfrocks.com/api/index.php?threads/&forum_id=23&oauth_token=xxx" which is the url to create a new thread for forum #23 (the IFTTT demo forum) and a valid oauth_token. In the body, I used the tweet link as the new thread title and the full tweet text as the first post body.
See the threads created with this applet here: https://xfrocks.com/api-support/forums/bd-api-ifttt-demo.23/
xfrocks
Well-known member
xfrocks updated [bd] API with a new update entry:
Feature Update
Read the rest of this update entry...
Feature Update
Read the rest of this update entry...
Keep up the great work, I'll be installing this update soon.
DeltaHF
Well-known member
Could you update the bundled copy of oauth2-server-php? 1.7.0 is two years old, and I just ran into a problem caused by deprecation of mcrypt_create_iv in PHP 7.1 (fixed in https://github.com/bshaffer/oauth2-server-php/pull/773).
It would also be a good idea to move away from mcrypt altogether at some point.
It would also be a good idea to move away from mcrypt altogether at some point.
xfrocks
Well-known member
That bug has been fixed, future release should have those displaying correctly.
That pull request was actually made by us. New release should be available soon and include that fix.
Just use standard OAuth requests for tokens and you should be fine. Also, the url should be /api/index.php?oauth/authorize, /api/index.php?oauth/token unless you setup url rewrite yourself. But normally the system will use full url for best compatibility.
vlom31
Member
Just installed it, can you tell me why the information of this url for example is public ?
https://mywebsite.com/api/index.php?users/
How do I hide this please ?
Mehdi
https://mywebsite.com/api/index.php?users/
How do I hide this please ?
Mehdi
SeToY
Well-known member
Are you logged in while browsing to this site? Because I get a "Invalid or expired access-token" when browsing this endpoint on my forum.
DeltaHF
Well-known member
Same here; I don't see a list of users.
xfrocks
Well-known member
If you remove member list permission from the guest / unregistered group, it will stop returning users.
xfrocks
Well-known member
If you want to prevent people from getting your public data, it's best to turn on the option Restrict Access. That way only app that has valid client will be able to access.
