Queries to shopsite_db Copy Returns Empty Resultsets

[OldSalt]

Hello,

I am debugging an issue with duplicate orders and tried to query a copy of shopsite_db.

Here's the results:
-sh-3.00$ sqlite3 ./shopsite_db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> .mode line
sqlite> select * from ss_Order where ss_Name='anita samuel';
sqlite> select * from ss_Order where ss_OrderNum='3131';
sqlite> select * from ss_Order where ss_OrderID='3131';
sqlite> select * from Purchase where ShipGivenName='anita' and ShipFamilyName='samuel';
sqlite> select * from Purchase where OrderNum='3131';
sqlite> select * from Purchase where PurchaseID='3131';
sqlite> select OrderDate from Purchase limit 5;
sqlite> select ss_Date from ss_Order limit 5;
sqlite> select * from ss_Order;
sqlite> select * from Purchase;
sqlite> .q
-sh-3.00$ ls -l shopsite_db
-rwxr-xr-x 1 waterwor waterwor 124928 Dec 18 13:23 shopsite_db

Any idea why this is happening?

Thanks!

[loren_d_c]

Direct access to the shopsite_db file isn't recommended or supported, but that being said, it's possibleyou may have some problem with your sqlite3 command shell. It says it's version 3.4.1, which is fairly old, so maybe try upgrading it?

-Loren