#80 SQLite: SQLSTATE[HY000]: General error: 17 database schema has changed

[Anonymous]

Hi,

I've a very strange bug with SQLite. When I start my crawler in multi-process mode, there is a regular warning: Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 17 database schema has changed in /Users/remimichel/PhpstormProjects/crawler_torrent_websites/libs/php-crawl/UrlCache/PHPCrawlerSQLiteURLCache.class.php on line 128

This warning is triggered when I start the crawler from my Mac (Yosemite) and from Ubuntu 14.04 (with PHP 5.3 and 5.5). The strange thing is that it works pretty well when I start it from Ubuntu 12.04 (PHP 5.3.10)

The bad news is that the crawler stops within 1 or 2 minutes (when too many warnings are triggered I guess!! :) )

Do you have any idea? Is it related to my version of PHP?

THanks!

[Anonymous]

It works for me also!

[Anonymous]

it worked when setFollowMode(2) but if you change it to setFollowMode(3) your fix throws the error 17 message.

[Anonymous]

I had the same error. I tried the new PHPCrawlerSQLiteURLCache.class.php. This fixed the problem for me.

[Anonymous]

Is there going to be a new release including the fix?

[MadEgg]

I had the same issue, and the attached PHPCrawlerSQLiteURLCache.class.php fixes the problem for me, too.

[Anonymous]

thanks so much!I had the same issue too, and the attached PHPCrawlerSQLiteURLCache.class.php fixes the problem for me, too.

[Anonymous]

Had the same Problem with a Mac 10.10, php 7.0. Your fix did work - thank you!

[Anonymous]

Yes it solves the problem

[Anonymous]

It works for me to, on Uberspace

[Anonymous]

couple of years later but it works for me too. :-)