Page 1 of 1

Errors opening SID and CRUD

PostPosted: 27. December 2018 17:24
by planodebbie
I am going through Bill Weinman's SQL training. I successfully installed XAMPP; however, I installed to my D:\ drive instead of my C:\ drive.

I am getting an error upon startup that says:
Warning: dir(../db,../db): The system cannot find the file specified. (code: 2) in D:\xampp\htdocs\SID\sid.php on line 368
Warning: dir(../db): failed to open dir: No such file or directory in D:\xampp\htdocs\SID\sid.php on line 368
Fatal error: Call to a member function read() on a non-object in D:\xampp\htdocs\SID\sid.php on line 370

The section of the sid.php file that are generating this error is listed below - specific lines are bolded:
case 'sqlite3':
// use all the databases in DBDIR
$d = dir(DBDIR);
$a = "<option>:memory:</option>\n"; // start list with in-memory db
while(($fn = $d->read()) !== FALSE) {
if(substr($fn, 0, 1) == '.') { continue; }
$selected = ($fn == $database) ? ' selected' : '';
$a .= "<option$selected>$fn</option>\n";
}

I am also getting this error when trying to open CRUD - any ideas?
SQLSTATE[HY000] [14] unable to open database file

Re: Errors opening SID and CRUD

PostPosted: 27. December 2018 18:42
by Altrea
Ask the author of this book/tutorial.
Obviously this is a typo in your or his code.