Comments (5)
Hi
Can you provide more info like sqlite and php version?
$filterArray should contain the table column names like this
$filterArray = [
'admin_id' => [
't' => 'INTEGER',
'd' => NULL,
'n' => true,
],
'username' => [
't' => 'TEXT',
'd' => '',
'n' => true,
],
'role_id' => [
't' => 'INT',
'd' => 'NULL',
'n' => true,
],
'token' => [
't' => 'TEXT',
'd' => '',
'n' => true,
],
];
$params['admin']= $this->db->filter($params['admin'], $filterArray,false);
I think there is a problem with system/db/sqlite->getColumnsMeta
with your sqlite version.
getColumnsMeta
runs this query to get column names
SELECT type as t, name, dflt_value as d, `notnull` as n FROM pragma_table_info('admin');
The code will be pushed to github after beta is over and bug fixes, refactoring and code cleanup is complete.
from vvveb.
it's PHP 8.2.10 (cli) (built: Sep 4 2023 08:11:43) (NTS)
with php8.2-sqlite3 8.2.10-1+0~20230904.33+debian11~1.gbp2dc84c
i deleted storage/model/install/adminsql.sqlite.php
and it got re-generated with $filterArray
filled up.
from vvveb.
…but now it gives this on the admin panel:
Call to undefined method Vvveb\Sql\StatSQL::getOrdersCount()
/srv/web/vvveb/hmvhp/admin/controller/base.php on line 453
Code
$orderCount = $stats->getOrdersCount($this->global); // <==
$menu = array_insert_array_after('edit', $menu, $posts_menu);
//products -- add to menu
$products_menu = $this->customProducts();
$menu = array_insert_array_after('sales', $menu, $products_menu);
$stats = new StatSQL();
$orderCount = $stats->getOrdersCount($this->global); // <==
$orderStatsusNew = 1;//get from site config
$newOrders = ($orderCount['orders'][$orderStatsusNew]['count'] ?? 0);
if ($newOrders > 0) {
$menu['sales']['badge'] = $newOrders;
$menu['sales']['badge-class'] = 'badge bg-primary-subtle text-body float-end';
Trace
#0 /srv/web/vvveb/hmvhp/system/core/frontcontroller.php(209): Vvveb\Controller\Base->init()
#1 /srv/web/vvveb/hmvhp/system/core/frontcontroller.php(297): Vvveb\System\Core\FrontController::call()
#2 /srv/web/vvveb/hmvhp/system/core/frontcontroller.php(362): Vvveb\System\Core\FrontController::redirect()
#3 /srv/web/vvveb/hmvhp/system/core/startup.php(365): Vvveb\System\Core\FrontController::dispatch()
#4 /srv/web/vvveb/hmvhp/index.php(144): Vvveb\System\Core\start()
#5 /srv/web/vvveb/hmvhp/admin/index.php(41): include('...')
#6 /srv/web/vvveb/hmvhp/public/admin/index.php(28): include('...')
#7 {main}
from vvveb.
Thanks for feedback, I updated the generated model for sqlite install.
The code for getOrdersCount
was not updated for sqlite, please redownload the zip and update vvveb/admin/sql/sqlite/stat.sql
from vvveb.
works. cool.
from vvveb.
Related Issues (20)
- Permissions for files and folders HOT 3
- Two Homepages in editor ? HOT 9
- Currency rates are US Centric HOT 1
- Filter on Regions no working HOT 1
- Create Product Categories assigned wrong taxonomy ID HOT 1
- Unable to deploy docker image HOT 10
- Product Attributes - only one Attribute from each Group is displayed HOT 1
- Creating a new Option group fails HOT 1
- Got Internal Server Error 500 on my first login. HOT 4
- Delete from Cart add one product on HOT 4
- Filter by Brand not working HOT 8
- Is there a way to export the site as static pages? HOT 2
- Scrolling product pages on mobile devices brings header down the page HOT 2
- Persistent storage volumes HOT 5
- Multi-vendor plugin error HOT 3
- CSS error (maybe) HOT 4
- Reusable blocks are not available HOT 1
- Menus on all links off index.html show same error HOT 5
- Multiple products added to a Category, but only one shows in when filtering products by category HOT 1
- [HELP NEEDED] Subfolder installation wrong URL's HOT 4
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 vvveb.