View Issue Details

IDProjectCategoryView StatusLast Update
0009579phpList 3 application[All Projects] Generalpublic22-08-18 16:35
Reporterhola 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
Product Version2.10.4 
Target Versionnext majorFixed in Version 
Summary0009579: adodb.inc missing code
DescriptionThis is why the reindex.php in the 2.11.3 didn't work and the convertstats.php. In 2.10.4 the adodb.inc is not the same as the mysql.inc - one function is causing tables from being created after registration. Below is the function - the commented part is the current code in 2.10.4 adodb.inc. I copied the new code within the function from the mysql.inc - all seems to work now with convertstats.php

function Sql_Create_Table ($table,$structure) {
 /* $query = "CREATE TABLE $table (\n";
  while (list($column, $val) = each($structure)) {
    $query .= "$column " . $structure[$column][0] . ",";
  }
  # get rid of the last ,
  $query = substr($query,0,-1);
  $query .= "\n)";
  # submit it to the database
  logEvent($query);
  $res = Sql_Verbose_Query($query);
  */

   $query = "CREATE TABLE $table (\n";
  while (list($column, $val) = each($structure)) {
    if (preg_match('/index_\d+/',$column)) {
      $query .= "index " . $structure[$column][0] . ",";
    } elseif (preg_match('/unique_\d+/',$column)) {
      $query .= "unique " . $structure[$column][0] . ",";
    } else {
      $query .= "$column " . $structure[$column][0] . ",";
    }
  }
  # get rid of the last ,
  $query = substr($query,0,-1);
  $query .= "\n)";
  # submit it to the database
  $res = Sql_Query($query);
}
TagsNo tags attached.

Activities

michiel

04-06-13 14:09

manager   ~0052084

superceded by the intention to start working towards the use of PDO