(how to fix) PDOException thrown with message "SQLSTATE[HY000]: General error: 1 no such table: info"

trilbymedia / grav-plugin-tntsearch

Powerful indexed-based full text search engine powered by the TNTSearch library

https://trilby.media

MIT License

61 stars 23 forks source link

(how to fix) PDOException thrown with message "SQLSTATE[HY000]: General error: 1 no such table: info" #80

Open m33m33 opened 4 years ago

m33m33 commented 4 years ago

Hi,

I am running Grav v1.6.19 - Admin v1.9.12 php v7.2 tntsearch v3.0.0.

After a simple page update (a few lines added) I was kicked out of the admin console and can't login again. The website runs fine in user mode, pages displays well, including the one that was bein edited.

tntsearch re index

To fix this I was forced to run a

bin/plugin tntsearch index

from command line.

After that the admin console login was OK.

Full error stack on https://pastebin.com/Af5ryYqd

Kind regards

rhukster commented 4 years ago

I really need to replicate this in order to determine what causes it. Is it possible to zip up your site and send it to me so i can try to recreate?

m33m33 commented 4 years ago

Unfortunately I am not allowed to export the content.

The good news is : I can't reproduce it. It may be a single time event.

rhukster commented 4 years ago

Actually I’ve run into this myself now. Quick fix was to delete the data/tntsearch folder and reindex. Need to work out what’s happening though.

mahagr commented 4 years ago

Quick look into PDO issues says that this happens when the file cannot be accessed.