3marlyn14 years, 6 months ago
arggghh seems no one can help me...........
okay thanks.....
okay thanks.....
3marlyn14 years, 6 months ago
dryabov14 years, 6 months ago
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.
PS. Also check that you don't have restriction on DB size from hoster side.
3marlyn14 years, 6 months ago
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?
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?
asder9914 years, 5 months ago
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).
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).
riefvan14 years, 2 months ago
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
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
dryabov14 years, 2 months ago
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.
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.
laskobernard14 years, 2 months ago
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
en installant en locale sur mon pc avec xampp comme serveur, je n'ai rien changé et sa marche nickel