Installation OK but testing gives a error

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Installation OK but testing gives a error

Postby Piratenhits » Sun Jul 21, 2013 10:36 am

Hi all,

The installation went very well only now while testing i get a error.

[Sun Jul 21 17:15:55 2013] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Uncaught exception 'TeraWurflException' with message 'Invalid device in fallback tree for generic_web_browser' in /var/www/virtual/piratenhits/htdocs/mobile-detect/TeraWurfl.php:259\nStack trace:\n#0 /var/www/virtual/piratenhits/htdocs/mobile-detect/TeraWurfl.php(224): TeraWurfl->getFullCapabilities('generic_web_bro...')\n#1 /var/www/virtual/piratenhits/htdocs/mobile-detect/test.php(9): TeraWurfl->getDeviceCapabilitiesFromRequest()\n#2 {main}\n thrown in /var/www/virtual/piratenhits/htdocs/mobile-detect/TeraWurfl.php on line 259

Code: Select all

Database Table	Statistics
MERGE
TeraWurflMerge	Rows: 0
Actual Devices: 0 
Table Size: 0 B

INDEX	
TeraWurflIndex	Rows: 19666
Table Size: 555.96 KB

CACHE	
TeraWurflCache	Rows: 0
Table Size: 0 B
If you need more info please let me know.
Help is appreciated very much.

Best regards,
Piratenhits
Last edited by kamermans on Mon Jul 22, 2013 9:30 pm, edited 1 time in total.
Reason: Added code block syntax

kamermans
Posts: 393
Joined: Mon Jun 06, 2011 9:50 am

Re: Installation OK but testing gives a error

Postby kamermans » Sun Jul 21, 2013 10:57 pm

It looks like something failed while loading the WURFL database. Can you try to load the WURFL data again and paste the resulting page here?
Thanks,

Steve Kamerman
ScientiaMobile

Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Re: Installation OK but testing gives a error

Postby Piratenhits » Mon Jul 22, 2013 11:33 am

Hi Kamermans,

thanks for the reply, this is the output i receive.

Code: Select all

Database Update OK
Total Time: 50.456753015518
Parse Time: 2.6136541366577 (TeraWurflXMLParser_XMLReader)
Validate Time: 0.049066781997681
Sort Time: 3.4151802062988
Patch Time: 0.029515027999878
Database Time: 44.345412015915
Cache Rebuild Time: 0.0039248466491699
Number of Queries: 403
PHP Memory Usage: 50.72 MB
--------------------------------
WURFL Version: 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013)
WURFL Devices: 19666
PATCH New Devices: 0
PATCH Merged Devices: 0
Last edited by kamermans on Mon Jul 22, 2013 9:30 pm, edited 1 time in total.
Reason: Added code block syntax

kamermans
Posts: 393
Joined: Mon Jun 06, 2011 9:50 am

Re: Installation OK but testing gives a error

Postby kamermans » Mon Jul 22, 2013 9:29 pm

The output looks correct, but the database stats from your previous post show that the database is empty, which is not good:

Code: Select all

Database Table	Statistics
MERGE
TeraWurflMerge	Rows: 0
Actual Devices: 0 
Table Size: 0 B
Are you still having the same problem?
Thanks,

Steve Kamerman
ScientiaMobile

Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Re: Installation OK but testing gives a error

Postby Piratenhits » Tue Jul 23, 2013 5:23 am

Yes indeed, the problem is still present.

Code: Select all

Mon, 22 Jul 2013 18:35:29 +0200 [TeraWurflDatabase_MySQL5::getDeviceFallBackTree] ERROR: WURFL Error: device falls back on an inexistent device: 
Mon, 22 Jul 2013 18:35:25 +0200 [TeraWurflDatabase_MySQL5::getDeviceFallBackTree] ERROR: WURFL Error: device falls back on an inexistent device: 
Mon, 22 Jul 2013 18:31:35 +0200 [Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 50.46 seconds 
Mon, 22 Jul 2013 18:30:47 +0200 [Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Last edited by Piratenhits on Tue Jul 23, 2013 11:08 am, edited 1 time in total.

sm_support2
Posts: 294
Joined: Mon Jun 20, 2011 5:04 pm

Re: Installation OK but testing gives a error

Postby sm_support2 » Tue Jul 23, 2013 5:31 am

What does the custom web patch contain? I have a sneaking suspicion that the problem may be there.

For the record, we removed the web patch a long time back (the info in it was consolidated within the big WURFL and newer versions of the API, so the API is no)w fully able to detect desktop web browsers)

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Re: Installation OK but testing gives a error

Postby Piratenhits » Tue Jul 23, 2013 5:53 am

From the data dir:

custom_web_patch.xml

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<wurfl_patch>
	<devices>
	</devices>
</wurfl_patch>
Last edited by Piratenhits on Tue Jul 23, 2013 11:07 am, edited 1 time in total.

sm_support2
Posts: 294
Joined: Mon Jun 20, 2011 5:04 pm

Re: Installation OK but testing gives a error

Postby sm_support2 » Tue Jul 23, 2013 6:00 am

I suggest that you remove the file and any references to it and try again. Thanks

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Re: Installation OK but testing gives a error [solved]

Postby Piratenhits » Tue Jul 23, 2013 7:31 am

hi, i removed the files. output of loading data to the database is the same except from the errors.

Code: Select all

Warning: XMLReader::open(): Unable to open source data in /var/www/virtual/piratenhits/htdocs/mobile-detect/TeraWurflXMLParsers/TeraWurflXMLParser_XMLReader.php on line 35
Warning: XMLReader::read(): Load Data before trying to read in /var/www/virtual/piratenhits/htdocs/mobile-detect/TeraWurflXMLParsers/TeraWurflXMLParser_XMLReader.php on line 40
I did some more research and the problem is solved now by adding ALL rights to the database user.

Before a lot of filled _TEMP tables were present and the "normal" tables were empty. After the change and a reload to the database the _temps were gone.
btw: before the problem was solved the TeraWurflIndex table was filled with no errors.

Problem solved and i' m happy..

Thank you very much for your time Kamermans and sm_support2

Regards,
Piratenhits
Last edited by Piratenhits on Tue Jul 23, 2013 11:08 am, edited 1 time in total.

kamermans
Posts: 393
Joined: Mon Jun 06, 2011 9:50 am

Re: Installation OK but testing gives a error

Postby kamermans » Tue Jul 23, 2013 7:34 am

Sorry for the confusion, this file is included in DB API distribution by us as part of the GUI-based patching system. It is no longer relevant and will be removed in future versions, but it will not have any effect on your installation.

There is something else going on here, something systemic. Perhaps the DB is not really MySQL, or the database or underlying filesystem has some sort of quota which prevents all the devices from being added, or something else. I think the only way we will make sense of this is for you to test the API in another environment. It seems likely to me that the problem is with the database.

EDIT: I'm glad to see it was indeed a database issue - very strange. I'm very curious to know what permissions you had :)
Thanks,

Steve Kamerman
ScientiaMobile

Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!

Piratenhits
Posts: 6
Joined: Sun Jul 21, 2013 10:25 am

Re: Installation OK but testing gives a error

Postby Piratenhits » Tue Jul 23, 2013 11:05 am

Hi, as i recall it was like this.

Code: Select all

Data
 SELECT  set
 INSERT  set
 UPDATE set
 DELETE set

Structure
 CREATE set
 ALTER set
 INDEX set
 DROP unset
 CREATE TEMPORARY TABLES set
 SHOW VIEW unset
 CREATE ROUTINE  set
 ALTER ROUTINE set
 EXECUTE set
 CREATE VIEW unset
 EVENT unset
 TRIGGER unset

Administration
 GRANT unset
 LOCK TABLES unset 
 REFERENCES  unset
So now i think i forgot the DROP option for the user.

kamermans
Posts: 393
Joined: Mon Jun 06, 2011 9:50 am

Re: Installation OK but testing gives a error

Postby kamermans » Tue Jul 23, 2013 3:16 pm

Ok, thanks for the info, and I'm glad you've got it working!
Thanks,

Steve Kamerman
ScientiaMobile

Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!


Who is online

Users browsing this forum: No registered users and 3 guests