Tables Doesnt Exist

Installing and configuring Tera-WURFL on your server.

Re: Tables Doesnt Exist

Postby kamermans » Wed May 12, 2010 2:46 pm

I would recommend that you find some way to protect your admin directory so random people don't clear your cache and reload the WURFL file :D .htaccess is one way to do it, yes; however, I'm assuming you are using a control panel for your hosting provider like Plesk or Cpanel. There should be an easy-to-use method of password-protecting directories within the control panel. I just did this for a client using Cpanel the other day and it was very easy.

These links might be helpful to you:
http://www.siteground.com/tutorials/cpa ... tories.htm
http://download1.sw-soft.com/Plesk/Ples ... 03s68.html
Thanks,

Steve Kamerman
Tera-WURFL Author
COO of ScientiaMobile

IMPORTANT ANNOUNCEMENT! Tera-WURFL and WURFL have joined forces! We have launched ScientiaMobile to provide commercial support for our device detection solutions.

Tera-WURFL.com | Device Explorer
kamermans
Site Admin
 
Posts: 323
Joined: Wed Mar 10, 2010 12:06 pm
Location: Fort Worth, TX

Re: Tables Doesnt Exist

Postby Carrilero21 » Wed May 12, 2010 3:17 pm

sweet! Took me 2 minutes with the first guide! :D
Thanks a lot!! :D
Carrilero21
 
Posts: 18
Joined: Fri Apr 16, 2010 6:36 pm

Re: Tables Doesnt Exist

Postby Carrilero21 » Fri May 14, 2010 12:01 am

Another question :D

I've seen in other mobile sites that there is always an option in the bottom that lets you go to the Desktop Version of the site. How can I do that?? I tried adding a link to "www.MyDomain.com/index.php" but this always takes me to the mobile site. So, is it now impossible for a mobile to see the Desktop Version??
Carrilero21
 
Posts: 18
Joined: Fri Apr 16, 2010 6:36 pm

Re: Tables Doesnt Exist

Postby kamermans » Fri May 14, 2010 7:37 am

You would need to know a little about PHP Sessions or Cookies. Typically when users click on the Desktop Version link, a script will set a variable like force_desktop=true in the user's cookie, then in the redirection script they will check for that setting, and if present, they will not send the user to the mobile site, but instead they will just show a link to the mobile site.
Thanks,

Steve Kamerman
Tera-WURFL Author
COO of ScientiaMobile

IMPORTANT ANNOUNCEMENT! Tera-WURFL and WURFL have joined forces! We have launched ScientiaMobile to provide commercial support for our device detection solutions.

Tera-WURFL.com | Device Explorer
kamermans
Site Admin
 
Posts: 323
Joined: Wed Mar 10, 2010 12:06 pm
Location: Fort Worth, TX

Re: Tables Doesnt Exist

Postby Carrilero21 » Sat May 22, 2010 12:28 am

How can I make a filter for the iPhone or other high-end devices?? What do I modify in here:

Code: Select all
if($wurflObj->getDeviceCapability("is_wireless_device")){
   header("Location: http://mobile.MyDomain.com/");
}



Thanks again! :D
Carrilero21
 
Posts: 18
Joined: Fri Apr 16, 2010 6:36 pm

Re: Tables Doesnt Exist

Postby kamermans » Sat May 22, 2010 12:37 am

I would probably go for something like this:
Code: Select all
if($wurflObj->getDeviceCapability("is_wireless_device") && ($wurflObj->getDeviceCapability("brand_name") == "Apple"|| $wurflObj->getDeviceCapability("device_os") == "Android")){
   header("Location: http://mobile.MyDomain.com/");
}

That would capture all the iPhones, iPods, iPads and Android devices that are out. There is a bit of a discussion about how we should approach this very question among the WURFL community right now ;)
Thanks,

Steve Kamerman
Tera-WURFL Author
COO of ScientiaMobile

IMPORTANT ANNOUNCEMENT! Tera-WURFL and WURFL have joined forces! We have launched ScientiaMobile to provide commercial support for our device detection solutions.

Tera-WURFL.com | Device Explorer
kamermans
Site Admin
 
Posts: 323
Joined: Wed Mar 10, 2010 12:06 pm
Location: Fort Worth, TX

Re: Tables Doesnt Exist

Postby blickwerker » Wed May 11, 2011 12:31 am

Hi, same problem here …
Blank page on “admin/updatedb.php?source=local” and no tables has been created in MySQL.

TeraWURFL 2.1.4.0
MySQL5-connector in use
„Checking Installation“ without errors
required MySQL privileges are granted
php_value memory_limit 768M in htaccess (regular 128M)
default wurfl.xml or minified wurfl.xml containing only “is_wireless_device” with about 2MB

What could I try next?

Thanks
Remi
blickwerker
 
Posts: 4
Joined: Wed May 11, 2011 12:26 am

Re: Tables Doesnt Exist

Postby kamermans » Fri May 13, 2011 1:24 pm

Have you tried the latest copy of Tera-WURFL from https://github.com/kamermans/Tera-WURFL? I believe this problem should be fixed.
Thanks,

Steve Kamerman
Tera-WURFL Author
COO of ScientiaMobile

IMPORTANT ANNOUNCEMENT! Tera-WURFL and WURFL have joined forces! We have launched ScientiaMobile to provide commercial support for our device detection solutions.

Tera-WURFL.com | Device Explorer
kamermans
Site Admin
 
Posts: 323
Joined: Wed Mar 10, 2010 12:06 pm
Location: Fort Worth, TX

Re: Tables Doesnt Exist

Postby blickwerker » Fri May 13, 2011 1:37 pm

version 2.1.4.0 downloaded 3 days ago:
kamermans-Tera-WURFL-v2.1.4-0-g4bd2c9d

but i'm updating now once more.
lets see.
blickwerker
 
Posts: 4
Joined: Wed May 11, 2011 12:26 am

Re: Tables Doesnt Exist

Postby kamermans » Fri May 13, 2011 1:39 pm

Hmmm - I haven't committed any changes that would fix this in the last week. What OS, PHP version and MySQL version are you on? Also, you said you are using the MySQL5 connector - do you have the MySQLi PHP extension enabled?
Thanks,

Steve Kamerman
Tera-WURFL Author
COO of ScientiaMobile

IMPORTANT ANNOUNCEMENT! Tera-WURFL and WURFL have joined forces! We have launched ScientiaMobile to provide commercial support for our device detection solutions.

Tera-WURFL.com | Device Explorer
kamermans
Site Admin
 
Posts: 323
Joined: Wed Mar 10, 2010 12:06 pm
Location: Fort Worth, TX

PreviousNext

Return to Installation / Configuration

Who is online

Users browsing this forum: No registered users and 1 guest

cron