Query failed: (5)

[mtgotraders]

What does this mean when i'm regenerating?

[mtgotraders]

I also have Loren who works for support looking into this but was hoping someone else might have some insight on my unique problem.

We rebuilt the shopsite_db file and got it moved over to a new node and it’s running very fast now but it’s still getting tons of error(5)’s. I found out that that error is unique to sqlite and is when something is trying to do 2 concurrent things to the database file. I’m not sure why this error is unique to my site especially after redoing the entire database and moving it over to a much faster node. I get error(5) when doing anything from searching on the front end to creating coupons.

On a positive note once I moved to the new node shopsite is blazing fast and i'm loving it. My searches are probably even faster than they would be on a php/mysql driven database. Once I get error(5) fixed it will be all peaches and cream. If your having problems regenerating due to your host check out www.lexiconn.com.

[mtgotraders]

Ignore everything I just said i'm back to database malformed(11).

/me blows up sqlite

[mtgotraders]

Just wanted to update you all that shopsite fixed the problem and everything is really great. The support that shopsite gave me was good and the guys at lexiconn.com were awesome also. I can't tell you enough of how happy I am that I moved to them and it now takes me maybe 5 minutes to do a full regen on 12k+ products where as before it took 30min-1hour. Thanks again guys for the great support and it's awesome to see how well shopsite can really run on a good server.