Welcome, Guest
Username Password: Remember me

Inconsistent Detection for MSIEMobile?
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Inconsistent Detection for MSIEMobile?

Inconsistent Detection for MSIEMobile? 13 years, 1 month ago #3678

  • EricT
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hello, I have the strangest circumstance. With a project that we are working on I have confirmed that a device with the UA: Mozilla/4.0 (compatible; MSIE 6.0; Windows CE; IEMobile 8.12; MSIEMobile 6.0) will be routed to the mobilized site on the test server but not on the production server.

Both servers are identical Hostgator servers with identical hosting plans and the files/database are an exact copy of each other.

This is the result i get from the plugins/mobile/terawurfl/data/wurfl.log log file:

 
// Good (test server)Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Applying WindowsCEUserAgentMatcher Conclusive Match: LD with threshold 3 on UA: Mozilla/4.0 (compatible; MSIE 6.0; Windows CE; IEMobile 8.12; MSIEMobile 6.0)
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for is_wireless_device as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 1
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for device_os as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is Windows Mobile OS
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for preferred_markup as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is html_wi_oma_xhtmlmp_1_0
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for max_image_width as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 168
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for max_image_height as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 180
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for png as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 1
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for gif as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 1
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for jpg as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 1
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] Searching for wbmp as a capability
Fri, 11 Mar 2011 18:43:25 -0600 [gator804.hostgator.com 32184][Tera-WURFL] I found it, value is 1
 
// BAD (production server)
Fri, 11 Mar 2011 18:41:38 -0600 [gator1260.hostgator.com 880][Tera-WURFL] Applying WindowsCEUserAgentMatcher Conclusive Match: LD with threshold 3 on UA: Mozilla/4.0 (compatible; MSIE 6.0;
Windows CE; IEMobile 8.12; MSIEMobile 6.0)
Fri, 11 Mar 2011 18:41:38 -0600 [gator1260.hostgator.com 880][TeraWurflDatabase_MySQL5::getDeviceFallBackTree] ERROR: Tera-WURFL Error: database fallback procedure returned no records,
verify that jos_TeraWurfl_FallBackDevices exists.
Fri, 11 Mar 2011 18:41:38 -0600 [gator1260.hostgator.com 880][Tera-WURFL] Searching for is_wireless_device as a capability
Fri, 11 Mar 2011 18:41:38 -0600 [gator1260.hostgator.com 880][Tera-WURFL] WARNING: I could not find the requested capability (is_wireless_device), returning NULL
 

I am currently tearing through the terawurfl code to try and trace the origin of the failure to detect a mobile device but if any one knows whats going on and can help that would immensely appreciated.

- Eric
Last Edit: 13 years, 1 month ago by EricT.

Re: Inconsistent Detection for MSIEMobile? 13 years, 1 month ago #3679

  • EricT
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
I have found something interesting, after finding the error in the joomla base error_log file:
[11-Mar-2011 20:33:54] Caught exception 'Exception' with message 'Error in DB RIS Query: PROCEDURE username_testdb.jos_TeraWurfl_RIS does not exist. Query: CALL jos_TeraWurfl_RIS('Mozilla/5.0 (Linux; U; Android 2.2; xx-xx; DROIDX Build/VZW) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1',49,'Android')' in /home/username/public_html/_test/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:116


It occurred to me that by using MySQL 5 in the Mobile - TeraWURFL Plugin that it was asking for use of stored procedures. HostGator does not support use of user created stored procedures so i set the "Force to use mysql4-compatible version" to "Yes (mysql4)" and now I am getting consistent support for mobile devices.
  • Page:
  • 1
Time to create page: 0.34 seconds

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.