Page 1 of 1
Installation OK but testing gives a error
Posted: Sun Jul 21, 2013 10:36 am
by Piratenhits
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
Re: Installation OK but testing gives a error
Posted: Sun Jul 21, 2013 10:57 pm
by kamermans
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?
Re: Installation OK but testing gives a error
Posted: Mon Jul 22, 2013 11:33 am
by Piratenhits
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
Re: Installation OK but testing gives a error
Posted: Mon Jul 22, 2013 9:29 pm
by kamermans
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?
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 5:23 am
by Piratenhits
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
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 5:31 am
by sm_support2
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)
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 5:53 am
by Piratenhits
From the data dir:
custom_web_patch.xml
Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<wurfl_patch>
<devices>
</devices>
</wurfl_patch>
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 6:00 am
by sm_support2
I suggest that you remove the file and any references to it and try again. Thanks
Re: Installation OK but testing gives a error [solved]
Posted: Tue Jul 23, 2013 7:31 am
by Piratenhits
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
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 7:34 am
by kamermans
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
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 11:05 am
by Piratenhits
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.
Re: Installation OK but testing gives a error
Posted: Tue Jul 23, 2013 3:16 pm
by kamermans
Ok, thanks for the info, and I'm glad you've got it working!