Community @ The Turning Gate

Hi Oliver,

if I get You right, the problem concerns only the display of umlauts in search results.
Can You provide an example search stirng?

Did You set the language code at settings->languages to "German - de"?
Did You provide a Google Site Verification ID in BL settings?

Hi Daniel,

I wish it had been so easy for me.

I had first tried to copy all the content. The new provider even has a tool for that.
But my .htaccess files did not work well with the new server.
I had made some changes when I switched from http to https on the old domain.
And trying to fix that I messed up completly

Also, the new site has a different domain name too and the old site has been quite a mess after moving from ce3 to ce4 and then to BL.
So I have already done a fresh install of BL2 and transferred all my templates via ex- and import.

So now it's "only" the albums left.

Yes. Exporting to WP worked alright. It's just the saving to Backlight that results in this message. Also it seems as if despite the error message, the items I changed are being saved correctly.
After I imported the template settings that I exported from my old site I was warned, that this templated had been created by an older version of BL and that I should better open it and the save again. This was when I first saw the message.
As I started writing this, I tried to reproduce again. the message is gone.

Hi again,

I finally have an answer from Hosteurope. They have not set a separate space quota for the user_tmp. It is accounted on my regular quota. Since > 10 GB of my Webspace are free, space should not be the cause of the problem.
They put in place a test script that allows me to verifiy that my user tmp is indeed writeable and also that it is empty. No left over stuff cluttering around.

I had proposed them to point the environment variable TEMPDIR which SQLite uses to find a place for temporary stuff to a location within my webspace where I could monitor what is going on there.
They refused that and proposed I should change to a dedicated Server or vServer. 

@Ben: I would be glad if You could point out what steps it takes to switch back to Backlight 1:
Restoring the original content of the backlight directory is trivial. I already did that.
Which of the Database Backups must be reinstalled and what else has to be done to rollback the steps performed by the installer?

I want ot rollback and regret having applied the installer on my live site without testing.

@Alfred: Hosteurope weren't service oriented in my perception. They also weren't impressed by the fact that I'm not their only customer experiencing the problem. I have not yet decided what is best: switching to a virtual server or just trying another hoster. I feel like trying another shared hosting offer by all-inkl with a test domain first. I will keep You updated.

Cheers for now
Michael

Hi Ben,

55% of my quota is unused.
I read something about a transaction. Can it have to do with journal settings?

When I open the log in backlight/data/admin/logs. I don't read about the I/O error. But in my browser I see both.

[14-Sep-2018 10:23:25] ERROR: SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active|#0 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericUpgradeHelper.php(111): PDO->rollBack()#1 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/helpers/GenericApplicationHelper.php(138): GenericUpgradeHelper->upgradeIfNeeded()#2 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(440): GenericApplicationHelper->checkUpgrade(Array)#3 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(151): Framework->initApplication()#4 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/modules/module-framework/Framework.php(41): Framework->init()#5 /is/htdocs/wp1139230_3D4UV0VX43/www/fotos/backlight/index.php(31): Framework->__construct('..', Array)#6 {main}|URL: /backlight/index.php

That reminds me of an issue I had with my provider after they had been acquired by GoDaddy.

It turned out that the provider changed the setup up in a way that sqlite tried to write te,porary stuff to a path it did not have permission for. (/var/tmp/). My stuff is on shared hosting and customer scripts should not be allowed to write outside the customers home directory. SQLite3 has a sequence of possible locations for temporary stuff. Setting the environment variable $TMPDIR to an apropriate path might help:
putenv("TMPDIR=/some/path/within/userspace/");

In my case this had to be done by the provider's support desk.

Wish You success.

Full Thread is here: http://community.theturninggate.net/vie … hp?id=8723

Hi Ben,

deleting the additional galleries went well. I downloaded and inspected publisher's database. There was no further debris left from my numerous test uploads.

The earlier proposal of the providers support to add some "sleep" to sqlite calls might be a hint that they are harmonizing standards to facilitate synergies.

I have always been content with them in the past. But in the past it was easier to reach a competent person on the telephone hotline. I liked being able to listen to and talk with people who are about to help me with problems.
That was why I have paid above average price for a hosting service for more than 15 years. They seem to have given away that distinguishing feature they had in the past. I have high respect for standardized and well documentetd processes. Having experts spend parts of their time in smalltalk and kindness isn't the route a profitable business should take. But in my case that led to a problem has not been handled. That signal "we screen our valued experts, don't call us, wee call you" made me guess I should better take the time to prepare the written information well and be precise.

in the end insisting that running a service as common as sqlite according to spec should be regarded as an exception and an act of courtesy gives me a strange feeling.

I had recommendations for all-inkl in the past from a friend who hosts multiple high traffic sites based on wordpress and phpBB there. But he does it on dedicated servers instead of a shared hosting enviroment, which will be configured differently. It would half my cost from the start. I could use a let's encrypt certificate instead of the one I now pay for. This means further savings when the current one expires. In a year or two I will run out of space. With HE I would have to switch to another contract AND to another physical server which had been some work and configuration trouble the last time I did that. They offer test accounts at all-inkl. I will get one as soon as work gets less ;-)

I still have some time to decide.

A fine weekend again.
Sent from the garden
Michael

Hi Ben, hi Alfred,
I see, You're being optimistic ;-)

No, it still doesn't work for me. I believe, what we see in phpinfo() is the apache's server environment which is different from the system environment. I will ask them to do me the same favour they did for Alfred.
But I can be convincing towards hosteurope. If neccessary I will just offer them to stay their customer.

I'll drop them a line tomorrow and will report after success.
Alfred, thank You for dealing with the ticket.

Michael

Hi Ben,
what I don't really understand is that i can publish an album with the minimal database in place, but as soon as I restore the regular version I get the error again as soon as I clear the template cache. There must be a difference between the two versions that causes the regular one to produce an error the minimal one does not produce.

Yes indeed. I'm with Hosteurope too. I had two contacts with their telephone hotline. In the second contact their second level support was involved. Unfortunately they did not put me through directly but the agent switched lines between us.
They claimed everything to be OK on their side and the cause of the database being a frequency of database accesses to high for sqlite. They proposed switching to mysql and as I told them that this would be far out of scope they proposed to add a "sleep" command in appropriate  places.

I precisely aked them to have a look at the file /backlight/data/designer/master.sql with the "fuser" command to find out which process keeps the database locked and possibly kill that process, which they refused. I tried that myself on the ssh console, but I have no permissions to execute "fuser". They asked me to open a ticket with support@hosteurope.de first. I had been very occupied last week and did not yet do that because I want to make certain that I will be reachable for requests and questions which was not given last week.

Alfred: I first noticed the problem on June 4th. If You log into backlight now and try to clear the template cache, You will probably get the same error message. If You download and read the recent logfiles in /backlight/data/designer/logs/ You will also find entries like

[11-Jun-2018 18:17:52] ERROR: Update query failed with error: SQLSTATE[HY000]: General error: 10 disk I/O errorsql:'UPDATE `engine_view` SET`name`=\'loop.php\',`type`=\'dynamic\',`path`=\'\',`rename`=\'\',`passthrough`=\'no\',`modified`=\'2018-06-11 18:17:51\'WHERE `engine_id`=\'99\' AND `view_id`=\'view.loop\''params:array () in PdoExtended.php on line 551

You will also find entries beginning like

[05-Jun-2018 00:00:32] ERROR: SQLSTATE[HY000]: General error: 5 database is locked|#

Just use the search string "error".

If You contact them and want to refer to me in case they recorded my calls in their support database: My hosting package is a shared hosting plan with the package number 1139230, so the virtual server is http://wp1139230.server-he.de/
If You mail me at ttg@michilge.de, I will tell You my Kundennummer. I will not find the time to open a ticket before Thursday.

Good luck so far
Michael