Tables Doesnt Exist

[Carrilero21]

Hi, I started trying to us WURFL in my website, so I was reading the Installation Guide in the wiki, but I cant seem to make it work.

When I run the 'check_wurfl.php' it shows me this error
"Error: Table 'iwana_mobile.TeraWurflCache' doesn't exist"
I tried reinstalling the whole this like 4-5 times and following the guide word by word but it doesnt seem to work for me.

Also I noticed that if go to the Cpanel of my website, look for the database I am using and Check the database it appears as if there was nothing, so I dont know why it isnt creating it.
I am really sure I have the correct database, user, password, and connector correct because when I run the 'install.php' everything runs smoothly.

HELP PLEASE!!

[kamermans]

Since the error is that the table TeraWurflCache could not be found, I know that you are getting connected to the database server (otherwise it would say "cannot connect..."). If you go into cpanel / phpMyAdmin and look at the database, do you see the TeraWurflCache table in there? Please make sure that you have loaded the WURFL file by using the Tera-WURFL admin page (http://yourdomain/admin/) and clicking on "Update database from local file". This will recreate all the tables in the database and load the WURFL file into them. If this is working, can you please look at the TeraWurflMerge table and see if there is any data in it?

[kamermans]

I received this reply over email:

In the Cpanel there is no tables. Theres nothing.
And yes, i went to "http://myDomain.com/Tera-Wurfl/admin/updatedb.php?source=remote"
and updated there, and it didn't work, and then I download it manually and installed it with an FTP client with no success.
Any ideas?

It sounds like the user you created for Tera-WURFL doesn't have the CREATE TABLE permission, and it is likely that they are missing a lot of other required permissions as well.

Please take a look at the following page to see what permissions are required for that user on that database:
http://www.tera-wurfl.com/wiki/index.php/Installation#Database_Configuration

[Carrilero21]

Ok now I went to http://myDomain.com/Tera-Wurfl/admin and click on every link there is, apparently when I clicked on the "Rebuild the device cache" it created the "TeraWurflCache" table. But now I ONLY have that table.
Now when I run the "check_wurfl.php" this is the error it tells me:
Fatal error: Call to a member function close() on a non-object in /home/MyDomain/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 89

And to add extra info, my MySQL version is 5.1.30

And when I run the "stats.php" this is the error it shows me:
Fatal error: Call to a member function fetch_assoc() on a non-object in /home/MyDomain/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 443

[kamermans]

Are there any error messages in the log file? Do you have any other applications that are using MySQL? Is this MySQL server on the same physical machine as the web server (localhost)?

[Carrilero21]

I just created the SQL database from the Cpanel, so I dont think any other application is using it. And as I said(that the database was created with Cpanel) I assume that it is in the same physical machine as the web server (localhost), right?

I don't know which log file is the one you are looking for, but I found 2 of them and Ill copy what they say here:

The "error_log" says this:

[16-Apr-2010 16:39:56] PHP Fatal error: Call to a member function close() on a non-object in /home/iwana/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 89
[17-Apr-2010 13:03:25] PHP Fatal error: Call to a member function close() on a non-object in /home/iwana/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 89
[17-Apr-2010 13:07:21] PHP Fatal error: Call to a member function close() on a non-object in /home/iwana/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 89

And the "wurfl.log" says this:

Mon, 15 Feb 2010 14:46:28 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 15 Feb 2010 14:46:28 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Mon, 15 Feb 2010 14:46:36 +0000 [STEVELAPTOP 15196][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 15 Feb 2010 14:46:36 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 16.68 seconds
Wed, 17 Feb 2010 14:09:23 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (device_claims_web_support), returning NULL
Wed, 17 Feb 2010 14:09:31 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (device_claims_web_support), returning NULL
Wed, 17 Feb 2010 14:12:08 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (device_claims_web_support), returning NULL
Wed, 17 Feb 2010 14:12:35 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (device_claims_web_support), returning NULL
Wed, 17 Feb 2010 14:20:16 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (device_claims_web_support), returning NULL
Wed, 17 Feb 2010 14:21:41 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (brand_name), returning NULL
Wed, 17 Feb 2010 14:21:41 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (model_name), returning NULL
Wed, 17 Feb 2010 14:32:35 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Wed, 17 Feb 2010 14:32:35 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 17 Feb 2010 14:32:41 +0000 [STEVELAPTOP 15196][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Wed, 17 Feb 2010 14:32:41 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 14.17 seconds
Wed, 17 Feb 2010 14:43:13 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: I could not find the requested capability (fallback_tree), returning NULL
Wed, 17 Feb 2010 16:02:32 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Wed, 17 Feb 2010 16:02:32 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 17 Feb 2010 16:02:42 +0000 [STEVELAPTOP 15196][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 17.52 seconds
Tue, 23 Feb 2010 13:00:46 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Tue, 23 Feb 2010 13:00:46 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Tue, 23 Feb 2010 13:00:53 +0000 [STEVELAPTOP 2240][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Tue, 23 Feb 2010 13:00:53 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 14.25 seconds
Tue, 23 Feb 2010 14:59:46 +0000 [STEVELAPTOP 2240][TeraWurflWebservice] WARNING: Denied webservice access to client 172.16.10.133
Tue, 23 Feb 2010 15:03:34 +0000 [STEVELAPTOP 2240][TeraWurflWebservice] WARNING: Denied webservice access to client 172.16.10.133
Wed, 24 Feb 2010 07:16:50 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Wed, 24 Feb 2010 07:16:50 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 24 Feb 2010 07:16:56 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 14.01 seconds
Wed, 24 Feb 2010 07:18:37 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Wed, 24 Feb 2010 07:18:37 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 24 Feb 2010 07:18:46 +0000 [STEVELAPTOP 2240][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 16.33 seconds
Thu, 25 Feb 2010 13:25:38 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 25 Feb 2010 13:25:38 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 25 Feb 2010 13:25:47 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 15.89 seconds
Thu, 25 Feb 2010 13:31:38 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 25 Feb 2010 13:31:38 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 25 Feb 2010 13:31:49 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 19.17 seconds
Thu, 25 Feb 2010 13:33:57 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 25 Feb 2010 13:33:57 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 25 Feb 2010 13:34:08 +0000 [STEVELAPTOP 5100][Tera-WURFL] WARNING: Finished loading WURFL http://www.wurflpro.com - 2010-02-03 10:31:00 (Wed Feb 03 10:35:26 -0600 2010) in 18.19 seconds
Sat, 17 Apr 2010 13:03:15 -0500 [caliber.websitewelcome.com 2552][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.

And thanks again!
I really appreciate your help

[kamermans]

The wurfl.log file is what is strange to me. "STEVELAPTOP 5100" is my development machine, so those entries in the logfile are not related to you, they just came with the distribution. The only line that is related is the last one:

Sat, 17 Apr 2010 13:03:15 -0500 [caliber.websitewelcome.com 2552][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.

This is simply a warning letting you know that the cache table was empty when you updated it. This is normal if you haven't detected any devices yet. I expected to see some indication that the WURFL file was being loaded, but I did not.
When you go to the Tera-WURFL admin page and click on Update database from local file, do you see just a blank page, or does it show you statistics about the number of devices that were added? Are there any error messages? This one link is supposed to recreate all the database tables and load them with data. I know you already clicked on that link, but can you do it again and tell me what you see?

[Carrilero21]

Yes, no problem. Maybe I should have started there. It does show me an error with the title: 500 Internal Server Error
And it says this:

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@MyDomain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at MyDomain.com Port 80

And I checked the "wurfl.log" and it hasn't change.

I also tried this with Safari and Firefox, and I use iMac, if that makes any difference.

[kamermans]

Apparently you're using a Windows server, what webserver are you using - IIS? What version, and did you attempt to secure the admin directory with anything like a .htaccess file?

[Carrilero21]

Based on what the CPanel tells me it says:
"Operating system: Linux"
I dont know where to see what webserver is.

And no, I didn't make the .htaccess yet, because I wanted it to be working first