Changeset 148

Timestamp:

04/01/2009 11:14:55 AM (3 years ago)

Author:

ofer

Message:

Fix for the mysql 4.1 bug

Location:

trunk/WordPress/plugin/transposh

Files:

• build.sh (modified) (2 diffs)
• readme.txt (modified) (1 diff)
• transposh_db.php (modified) (4 diffs)

trunk/WordPress/plugin/transposh/build.sh

@@ -60 +60 @@
   echo "Adding .php files (with logging)"
   for file in `find . -maxdepth 2 -iname '*.php'`; do 
-    cp $file > $TRANSPOSH_DIR/$file
+    cp $file $TRANSPOSH_DIR/$file
     echo "added $file"
   done;
@@ -91 +91 @@
 # 
 if [ "$ZIPME" == 'zip' ]; then
-  cd $TMP_DIR
+  cd $TRANSPOSH_DIR
   zip -rq "transposh.$VERSION.zip" .
   cd - >/dev/null
-  mv "$TMP_DIR/transposh.$VERSION.zip" . 
+#  mv "$TRANSPOSH_DIR/transposh.$VERSION.zip" . 
   echo
   echo "transposh.$VERSION.zip is ready"

trunk/WordPress/plugin/transposh/readme.txt

@@ -88 +88 @@
 == Release notes ==
 
+* 2009/04/02 - 0.1.3
+ * Fix for mysql 4.1 (thanks [Amit](http://landscaping-blog.com/))
 * 2009/03/31 - 0.1.2
  * Made sure our code passes w3c validation

trunk/WordPress/plugin/transposh/transposh_db.php

@@ -37 +37 @@
 
 //Database version
-define("DB_VERSION", "1.02");
+define("DB_VERSION", "1.03");
 
 //Constant used as key in options database
@@ -174 +174 @@
         {
                 logger("Error !!! failed to insert to db $original , $translation, $lang," , 0);
-                header("HTTP/1.0 404 Failed to update language database");
+                header("HTTP/1.0 404 Failed to update language database ".mysql_error());
         }
 
@@ -226 +226 @@
 
                 logger("Attempting to create table $table_name", 0);
-                $sql = "CREATE TABLE $table_name (original VARCHAR(256) NOT NULL,".
+                $sql = "CREATE TABLE $table_name (original VARCHAR(255) NOT NULL,".
                                 "lang CHAR(5) NOT NULL,".
-                                "translated VARCHAR(256),".
+                                "translated VARCHAR(255),".
                                 "source TINYINT NOT NULL,".
                                 "PRIMARY KEY (original, lang)) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci";
@@ -238 +238 @@
 
                 logger("Attempting to create table $table_name", 0);
-                $sql = "CREATE TABLE $table_name (original VARCHAR(256) NOT NULL,".
+                $sql = "CREATE TABLE $table_name (original VARCHAR(255) NOT NULL,".
                                 "lang CHAR(5) NOT NULL,".
-                                "translated VARCHAR(256),".
+                                "translated VARCHAR(255),".
                                 "translated_by VARCHAR(15),".
                                 "source TINYINT NOT NULL,".