Comments (12)
Any retour specific config set? Can you check if site/config/retour.yml
exists when the error appears?
from retour-for-kirby.
@distantnative, I didn't add any specific retour to the config file, It's a clean install.
The retour.yml didn't exist after installation, I hoped adding it would solve the error. But sadly not.
(I tried an empty retour.yml file and one with a redirect set manually)
from retour-for-kirby.
After some digging I found out that de dates table doesn't exist in the log.sqlite, which makes the database query in the stats function in src/classes/Log.php fail. When I disable the log feature, the page is working again.
from retour-for-kirby.
@timluigjes do you know if the log.sqlite
file was there before? or did Retour create it from scratch with that flaw?
from retour-for-kirby.
@distantnative, It was created from scratch. This morning I tried it with a fresh Kirby CMS install and I got the same error.
from retour-for-kirby.
I'm sorry that this hasn't been fixed yet but still haven't been able to reproduce it on my end
from retour-for-kirby.
I am getting this error too. Locally everything works.
Apache server production and localhost, PHP 8.0.24, Kirby 3.7.3, Retour 4.2.0
All the same, as @timluigjes noted.
from retour-for-kirby.
Updated a client's website earlier this week to the latest version of Kirby 3.7 with Retour 4.2.0.
Sadly the error still occurs, When the logging functionality is disabled, the panel is viewable.
@mynameisfreedom if you add the following to the Kirby config, it will work again: 'distantnative.retour' => ['logs' => false]
I was quite busy the last couple of months, but later this week I'll try to resolve this error and provide a PR if I found a solution.
from retour-for-kirby.
I'm digging into this error now... as far is I could get, there is an issue with the SQL here. The error is Error: near "with": syntax error
The reason is, that the ability for "recursive-select" was introduced in sqlite 3.34.0. The host I'm running is only capable of sqlite 3.7... I'm not able to get an update for that so I guess one needs to alter the query...?
from retour-for-kirby.
@gerricom first of all thanks a lot for getting to the bottom of this. I think this explains it!
I'd need help to see if there is a different sql statement that achieves the same.
Or if there is a way I can check the SQLite version in PHP and throw an error if it doesn't support the required functions.
from retour-for-kirby.
I run into the same issue. It works fine on my localhost. On my production server it creates the database in the logs folder, but I get the error Call to a member function toArray() on bool
I have Kirby 3.9.4 and retour 4.4.2 installed. I can't figure out which sqlite version is running on my production sever. How can i get this to work?
from retour-for-kirby.
@movingwater As you probably read this seems to be really about the SQLite version, so probably getting in touch with your provider and figuring out if you/they can update it
from retour-for-kirby.
Related Issues (20)
- [v5] Typo in creator empty state
- [v5] Redirects doesn't work if they contain a trailing slash HOT 2
- Use `k-link-field-preview` for `to` column when available HOT 1
- `Created by` field gets emptied when route is edited HOT 1
- Import redirects from CSV HOT 3
- Display error on mobile device.
- Cannot redirect to a page's content representation HOT 2
- PHP8.3 support on Retour v4
- Redirect URL with query strings HOT 4
- Lack of compatibility with Kirby 4.1.0 HOT 6
- Redirect To field missing HOT 2
- Flag for adding Wordpress routes
- Order by Date in Table HOT 5
- Accept closure for config storage path HOT 2
- Sorting columns in table in version 4.4 for kirby 3 websites HOT 1
- Fix test setup
- Redirect with sub-domain fails due to dual-parsing of target URL HOT 5
- No menu item in panel is created HOT 4
- Call to undefined method Kirby\Retour\Panel\FailureResolveDrawer::creator() HOT 1
- Warning when user dismisses drawer with unsaved changes to route HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from retour-for-kirby.