#69 SQLite Problem!

[Anonymous]

Hi, today I tried using SQLite caching to crawl some websites. Some work great, but there's some that return error like "gamek.vn". When I tried to crawl this page with SQLite caching, it returned
Warning: PDO::query() [pdo.query]: SQLSTATE[HY000]: General error: 1 SQL logic error or missing database in C:\AppServ\www\PHPtest\PHPCrawl_082\libs\UrlCache\PHPCrawlerSQLiteURLCache.class.php on line 70

Fatal error: Call to a member function fetch() on a non-object in C:\AppServ\www\PHPtest\PHPCrawl_082\libs\UrlCache\PHPCrawlerSQLiteURLCache.class.php on line 71

[Anonymous]

Hi!

Thanks for the report!

Do you have some more detailed information about where and when this error occurs so that i'm able to reproduce this error?

What URL did you try to crawl?

And what do you mean with "some that return error like "gamek.vn""?
WHat is gemek.vn and what returned this "error"?

Thanks!

[Anonymous]

When I tried to crawwl the website http://gamek.vn using the example.php in your project, after crawling some URL, it returned that error and stop the crawling.

[Uwe Hunfeld]

Hi!

Thanks! I'll take a look at it soon and gonna try to reproduce the bug!

[Uwe Hunfeld]

Hi again.

So far i wasn't able to reproduce the error.

But just an idea: Did you check the harddrive-space of the drive or partition containing the sqlite-file?
Maybe the sqlite-db is growing to big during your crawling-process.