Need help.. Moved to new Server..

We just upgraged to a dedicated server and moved from Hostgator to FutureHosting…

We are now getting this error… Any Help is appreciated… I did go into file manager and delete all the cache files also with smart optimizer…



Fatal error: Uncaught exception 'SQLiteException' with message 'SQLiteDatabase::__construct() [sqlitedatabase.--construct]: unable to open database: /home/csd/public_html/var/cache/cache.db' in /home/csd/public_html/core/cache/class.cache_backend_sqlite.php:185 Stack trace: #0 /home/csd/public_html/core/cache/class.cache_backend_sqlite.php(185): SQLiteDatabase->__construct('/home/csd/publi...') #1 /home/csd/public_html/core/cache/class.cache_backend_sqlite.php(113): Cache_backend_sqlite::_db_init() #2 [internal function]: Cache_backend_sqlite::init() #3 /home/csd/public_html/core/class.registry.php(271): call_user_func_array(Array, Array) #4 /home/csd/public_html/core/class.registry.php(222): Registry::_cache_actions('init') #5 /home/csd/public_html/core/fn.control.php(144): Registry::register_cache('addons', Array, 'cache_customer') #6 /home/csd/public_html/init.php(140): fn_init_addons() #7 /home/csd/public_html/index.php(25): require('/home/csd/publi...') #8 {main} thrown in /home/csd/public_html/core/cache/class.cache_backend_sqlite.php on line 185

Ask Futuremotion to fix/integrate SQLite into EasyApache.

Now we are getting this error… Host integrated sqlite into easyapache…



Warning: SQLite3::query() [sqlite3.query]: attempt to write a readonly database in /home/csd/public_html/core/cache/class.cache_backend_sqlite.php on line 85

[quote name=‘CarStickersDecals’ timestamp=‘1336014165’ post=‘135753’]

Now we are getting this error… Host integrated sqlite into easyapache…


<br />
Warning: SQLite3::query() [sqlite3.query]: attempt to write a readonly database in /home/csd/public_html/core/cache/class.cache_backend_sqlite.php on line 85<br />

```<br />
[/quote]<br />
<br />
If you are running 2.2.4, then there is a definite bug when using sqlite as your cache method. I would suggest that you switch to a different cache type until you have your recently moved site up & running again.<br />
<br />
No doubt you have recently tried clearing your cache, so I won't suggest that as well.... <img src="upload://yuxgmvDDEGIQPAyP9sRnK0D0CCY.gif" class="bbc_emoticon" alt=":shock:">

[quote name=‘Struck’ timestamp=‘1336014596’ post=‘135755’]

If you are running 2.2.4, then there is a definite bug when using sqlite as your cache method. I would suggest that you switch to a different cache type until you have your recently moved site up & running again.



No doubt you have recently tried clearing your cache, so I won’t suggest that as well… :shock:

[/quote]



Can you pass me an example? I’ve got a dozen clients running 2.2.4 using sqlite without issues so I’m curious what these may affect if indeed a bug.



@CSD - Your host needs to be a little more proactive if you are planning to run a store efficiently…

[quote name='JesseLeeStringer' timestamp='1336018854' post='135757']



@CSD - Your host needs to be a little more proactive if you are planning to run a store efficiently…

[/quote]



Yeah… Starting to get a little worried… Its been 2 days now and they cannot get it working… And I by no means am a Web Server Admin… Hope I didn't make a bad decision…

[quote name=‘JesseLeeStringer’ timestamp=‘1336018854’ post=‘135757’]

Can you pass me an example? I’ve got a dozen clients running 2.2.4 using sqlite without issues so I’m curious what these may affect if indeed a bug.[/quote]

Finally we got completely migrated over to FutureHosting… Finally got a hold of a tech that knew what he was doing…

Moving from Hostgator VPS to a Dedicated server worth every penny… WOW… The site is amazingly fast now…

NIght and Day… Went from 4-5 second page loads down to under 1 second… Seriously impressive…

[quote name='CarStickersDecals' timestamp='1336138663' post='135835']

Finally we got completely migrated over to FutureHosting… Finally got a hold of a tech that knew what he was doing…

Moving from Hostgator VPS to a Dedicated server worth every penny… WOW… The site is amazingly fast now…

NIght and Day… Went from 4-5 second page loads down to under 1 second… Seriously impressive…

[/quote]



Weird! They moved my sites a couple of times and never had a problem. Am actually doing moving tonight to dedicated…hope I will see the same speed improvement. Your site is blazing fast!

Well, I'm having this exact same issue now, after moving to a dedicated. Have had 6 techs on it and nobody seems to be able to fix it. I cleared all cache by hand, which made the issue go away for some hours but as cache filled up it came back.



The weirdest things is that the account is an exact copy of my old vps (same host) that was running fine. The only difference is the PHP version (now 5.3, was 5.2x I think).



I had to switch back to disk cache for now because the errors were showing in both front and admin side every now & then.



Help would be greatly appreciated.

Hi Flow,



Considering the vast magnitude of potential issues associated with SQLite, it's really difficult to diagnose remotely.

If you want, I can take a look at it and more than likely resolve.



Email/Skype me if so.

(PS: I have 5.3 running without issue)



Regards,

J.

That’s really nice Jesse! Thanks!



I am on holiday now but will be back in 9 days… will contact you by then if that’s ok cause … well… ok i’ll admit, I promised the misses I would not be behind my laptop too much :D



Thanks again !

I've 100% resolved this issue by setting access rights 777 :full access for everybody for the cache directory and for the file cache.db.

3.0.3 Pro and 4.0.2 Ultimate: /var/cache/registry

2.1.4 MVE: /var/cache