-
  What steps will reproduce the problem?
  1. Installed MySQL (5.1.35-community) and PHP (5.2.10)
  2. Configured the php.ini file
----------------------------------------
  Since I'm not getting that ... well... I'm not sure, my PHP is weakFu.

  This is an install on an XP machine and it is quite clear that the code is written for *nix but php should be portable enough to not require a platform.
+
+ You can find my phpinfo here ... http://www.immortalunion.org/info.php
+

You must login to post a comment. Don't have an account? Register to get one!

• 

  • #4

  tinlar Sat, 27 Jun 2009 19:21:29

  Okay so that appears to have everything up and running as far as I know to test. To recap the changes I made.

  In uploader.php I changed line 104 from

  $rollListSQL = "INSERT INTO skg_list_rolllists (id, listName, position, main_id, lastUpdate) values ('', '".addslashes($rollList)."', '".$position."', '".$main_id."', '".$updateTime."');";

  to

  $rollListSQL = "INSERT INTO skg_list_rolllists (listName, position, main_id, lastUpdate) values ('".addslashes($rollList)."', '".$position."', '".$main_id."', '".$updateTime."');";

  in functions.php change the case statements to be all lower case as follows

  if ($forceInstall !== "forceInstall" OR $forceInstall == ''){
      $sql = "SHOW TABLES FROM ".MYSQL_DB;
      $result = mysql_query($sql);
      while ($row = mysql_fetch_array($result)){
          switch ($row['Tables_in_'.MYSQL_DB]){
              case "skg_list_alts":
                  $check1 = true;
                  break;
              case "skg_list_log":
                  $check2 = true;
                  break;
              case "skg_list_players":
                  $check3 = true;
                  break;
              case "skg_list_rolllists":
                  $check4 = true;
                  break;
              case "skg_list_users":
                  $check5 = true;
                  break;
              case "skg_list_admin":
                  $check6 = true;
                  break;
          }
      }
  }
  

• 

  • #3

  tinlar Sat, 27 Jun 2009 18:54:24

  next obsticle is indeed the insert into the skg_list_rolllists

  adding this to the code...

  $result = mysql_query($rollListSQL); if (!$result) { die('Invalid query: ' . mysql_error());}

  shows the problem as this

  INSERT INTO skg_list_rolllists (id, listName, position, main_id, lastUpdate) values ('', '25-Man Raids', '1', '54696E6C6172323232323232', '1246127587'); Invalid query: Incorrect integer value: '' for column 'id' at row 1

  So we are passing a big fat nothing to a database that is expecting an Int there... no good.

  in uploader.php I changed line 104 from

  $rollListSQL = "INSERT INTO skg_list_rolllists (id, listName, position, main_id, lastUpdate) values ('', '".addslashes($rollList)."', '".$position."', '".$main_id."', '".$updateTime."');";

  to

  $rollListSQL = "INSERT INTO skg_list_rolllists (listName, position, main_id, lastUpdate) values ('".addslashes($rollList)."', '".$position."', '".$main_id."', '".$updateTime."');";

  That seemed to do the trick

• 

  • #2

  tinlar Sat, 27 Jun 2009 18:18:52

  The dirty hack only fixes one problem, others appear after that which I'm now looking into.

  It appears that the switch is case sensitive so changing all the case statements to be lower case gets you past the checkInstall without my original dirty hack.

  I was able to get a lua file imported but the akg_lists_rolllists table is still empty which doesn't seem correct to me and is pretty much keeping anything from being displayed properly I suspect. I'll keep digging.

• 

  • #1

  tinlar Sat, 27 Jun 2009 02:33:36

  If it helps it is the while loop and switch check in the checkInstall function that is failing. The cases appear to never be triggers so it try's to send you back through an install.

  a _dirty_dirty_dirty_ hack to get around this is to insert a return; on line 89 before the return 'InstallSystem';

  You would, of coarse, need to have completed the install at least once before making this change.