Ignore:
Timestamp:
5/25/2012 1:35:32 AM (2 years ago)
Author:
lowjoel
Message:

Use the lowercase table names, following our schema.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/website/scripts/blackbox/upload.php

    r2688 r2689  
    5656         
    5757        //Query for the list of exceptions containing the given functions 
    58         $statement = $pdo->prepare(sprintf('SELECT DISTINCT(BlackBox_Exceptions.ID) FROM BlackBox_StackFrames 
    59             INNER JOIN BlackBox_Exceptions ON BlackBox_StackFrames.ExceptionID=BlackBox_Exceptions.ID 
     58        $statement = $pdo->prepare(sprintf('SELECT DISTINCT(blackbox_exceptions.ID) FROM blackbox_stackframes 
     59            INNER JOIN blackbox_exceptions ON blackbox_stackframes.ExceptionID=blackbox_exceptions.ID 
    6060            WHERE (%s) AND ExceptionDepth=? AND ExceptionType=?', 
    6161            substr($stackFrames, 0, strlen($stackFrames) - 4))); 
     
    7878    $pdo->beginTransaction(); 
    7979 
    80     $statement = $pdo->prepare('INSERT INTO BlackBox_Reports SET IPAddress=?'); 
     80    $statement = $pdo->prepare('INSERT INTO blackbox_reports SET IPAddress=?'); 
    8181    $statement->bindParam(1, sprintf('%u', ip2long($_SERVER['REMOTE_ADDR']))); 
    8282    try 
     
    9090 
    9191    $reportId = $pdo->lastInsertId(); 
    92     $exceptionInsert = $pdo->prepare('INSERT INTO BlackBox_Exceptions 
     92    $exceptionInsert = $pdo->prepare('INSERT INTO blackbox_exceptions 
    9393        SET ReportID=?, ExceptionType=?, ExceptionDepth=?'); 
    9494    $exceptionInsert->bindParam(1, $reportId); 
    95     $stackFrameInsert = $pdo->prepare('INSERT INTO BlackBox_StackFrames SET 
     95    $stackFrameInsert = $pdo->prepare('INSERT INTO blackbox_stackframes SET 
    9696        ExceptionID=?, StackFrameIndex=?, Function=?, File=?, Line=?'); 
    9797    foreach ($stackTrace as $exceptionDepth => $exception) 
Note: See TracChangeset for help on using the changeset viewer.