I’m preparing to write a script to extract data from the LCP data base for ingestion into Dspace.<\/p>\n
While looking at the raw contents of the database using CocoaSQL, I noticed a bunch of records from the last few days, all with the same LS#: namely, LS00001<\/p>\n
This is bad.<\/p>\n
Go to Advanced search<\/a>, search for LS0001, see what happens.<\/p>\n Looks like the maximum LS# is 10000, as in LS10000 . I’m guessing something in the old code goes whack at that magic number.<\/p>\n Finally found the offensive line of code in \/:\/perkins\/landscape\/WORKING_FOLDER\/LS_PROCESS3.php<\/p>\n Former programmer had<\/p>\n $query="SELECT RECID,FILENAME FROM VTLANDSCAPEDB ORDER BY FILENAME";<\/span> Then, once a filename name was found, say<\/p>\n \nor<\/p>\n \nsubstr($LFN,3,10) <\/span>should then yield<\/p>\n 0000_000.jp or even <\/span>9000_001.jp . How adding 1 to that ever worked, I dunno<\/p>\n New code:<\/p>\n $query="SELECT RECID,FILENAME FROM VTLANDSCAPEDB ORDER BY FILENAME desc limit 1";<\/span> This fix should prevent further instances of FILENAME = LS00001_000.jpg records; however, fixing the damage done is another story.<\/p>\n","protected":false},"excerpt":{"rendered":" I’m preparing to write a script to extract data from the LCP data base for ingestion into Dspace. While looking at the raw contents of the database using CocoaSQL, I noticed a bunch of records from the last few days, … Continue reading
$result=mysql_query($query) or die("Problem Here");<\/span>
While ($line= mysql_fetch_array($result)){<\/span>
$LFN=$line[FILENAME];<\/span>
};<\/span>
$NFN=substr($LFN,3,10)+1;<\/span>
\nWell, first off, selecting 10,000 (or even 1000) records and looping through them all just to find the last used FILENAME is wicked inefficient — both for the PHP code and the mySQL server.<\/p>\n
$result=mysql_query($query) or die("Problem Here");<\/span>
While ($line= mysql_fetch_array($result)){<\/span>
$LFN=$line[FILENAME];<\/span>
};<\/span>
$NFN=substr($LFN,2,5)+1;<\/span>
<\/p>\n