Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Mobile Joomla!
Mobile Joomla! Forum
Bug reports

TeraWurflCache error
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1
  • 2

TOPIC: TeraWurflCache error

TeraWurflCache error 14 years, 3 months ago #2063

  • 3marlyn
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
arggghh seems no one can help me...........
okay thanks.....
Reply Quote

TeraWurflCache error 14 years, 3 months ago #2067

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4867
  • Karma: 105
3marlyn, try MJ 0.9.7. In this version the procedure of DB populating was improved and requires less time to finish.

PS. Also check that you don't have restriction on DB size from hoster side.
Reply Quote

TeraWurflCache error 14 years, 3 months ago #2089

  • 3marlyn
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
actually .. I've managed to solve it last night..
just add something in the script DB connector that you created ..
precisely in line 491 mysql5 ..
but I do not understand how these components work on sub domains .. Can you show me or the thread that discusses this problem?
Reply Quote

TeraWurflCache error 14 years, 2 months ago #2206

  • asder99
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi!
I've installed the 0.9.7 on my pc, and if works fine.

When I put everything on the provider's server, I got the same error:
jos_TeraWurflCache doesn't exist

But the table exists, like all the other MJ's tables, and it's got the same record (only one) of the same table in my local server.

If I unactivate Mobile - TeraWURFL (just this one, the other's MJ's plugins are active), everything works fine (except the mobile version, I haven't tried it yet).
Reply Quote

TeraWurflCache error 13 years, 11 months ago #2712

  • riefvan
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
This is my fix (temporary perhaps),

1. Open TeraWurlfConfig.php and make adjustment like this
my public static $TABLE_PREFIX = "terawurfl";

2. Open TeraWurlfDatabase_MySQL5.php and make changes
$TABLE_PREFIX="terawurfl";
$query = "SELECT `deviceID` FROM `".'jos_terawurflmerge'."` WHERE `user_agent`=".$this->SQLPrep($userAgent);

That's working for now. I know that's not neat but i didn't have much time to dive deeper into the codes. I hope the fix useful somehow and will lead to better solution
Reply Quote

TeraWurflCache error 13 years, 11 months ago #2713

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4867
  • Karma: 105
It seems that the problem may arise when you backup and move DB tables between different OSes (actually different file systems with different case-sensitivity rules).

Quote from dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database and table names. This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix. One notable exception is Mac OS X, which is Unix-based but uses a default file system type (HFS+) that is not case sensitive. However, Mac OS X also supports UFS volumes, which are case sensitive just as on any Unix. See Section 1.8.4, “MySQL Extensions to Standard SQL”. The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section.
Reply Quote

TeraWurflCache error 13 years, 11 months ago #2760

sur certain site comme sfr les bases de données sont bridées. A savoir la fonction LOCK TABLES j'ai du les effacer de la base de donnée tera_dump.sql.bz2, de plus le fichier ne doit pas dépasser 5mega octet , néanmoins j'ai réussis a l'installer en bricolant le fichier fournis avec mobile joomla j'ai créer 45 tables différentes que j'ai installer au dessus des autres tables après installation normale, long mais sa marche la table la plus grande en octet et TeraWurflMerge elle fait quand même 11 méga que j'ai du couper en trois fichiers .

en installant en locale sur mon pc avec xampp comme serveur, je n'ai rien changé et sa marche nickel
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
  • 2
Mobile Joomla!
Mobile Joomla! Forum
Bug reports
Powered by Kunena
Time to create page: 0.10 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.