Skip to content

db.sqlite.SQLError on Windows 11 by download from releases #20744

Closed
Closed
db.sqlite.SQLError on Windows 11 by download from releases#20744
Labels
BugThis tag is applied to issues which reports bugs.OS: WindowsBugs/feature requests, that are specific to Windows OS.
@sanrentai

Description

@sanrentai
sanrentai
opened on Feb 7, 2024

Describe the bug

copy codes from tutorials/building_a_simple_web_blog_with_vweb/README.md

v run .

SQLError

Reproduction Steps

study by read this https://github.com/vlang/v/blob/master/tutorials/building_a_simple_web_blog_with_vweb/README.md

// blog.v

import db.sqlite
import vweb

struct App {
	vweb.Context
pub mut:
	db sqlite.DB
}

fn main() {
	mut app := App{
		db: sqlite.connect(':memory:')!
	}
	sql app.db {
		create table Article
	}!

	first_article := Article{
		title: 'Hello, world!'
		text: 'V is great.'
	}

	second_article := Article{
		title: 'Second post.'
		text: 'Hm... what should I write about?'
	}

	sql app.db {
		insert first_article into Article
		insert second_article into Article
	}!
	vweb.run(app, 8080)
}

pub fn (app &App) index() vweb.Result {
	articles := app.find_all_articles()
	return $vweb.html()
}

// article.v
module main

struct Article {
	id    int    @[primary; sql: serial]
	title string
	text  string
}

pub fn (app &App) find_all_articles() []Article {
	return sql app.db {
		select from Article
	} or { panic(err) }
}

<html>
  <head>
    <title>V Blog</title>
  </head>
  <body>
    @for article in articles
    <div>
      <b>@article.title</b> <br />
      @article.text
    </div>
    @end
  </body>
</html>

Expected Behavior

no panic

Current Behavior

V panic: db.sqlite.SQLError: near "FROM": syntax error (1) (SELECT FROM Article;); code: 1
v hash: a374d25
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:14501: at _v_panic: Backtrace
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:41298: by main__App_find_all_articles
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:41443: by main__App_index
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:40841: by vweb__handle_route_T_main__App
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:40721: by vweb__handle_conn_T_main__App
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:41252: by vweb__Worker_T_main__App_process_incoming_requests_T_main__App
D:/AppData/Local/Temp/v_0/blog.01HP11QX23SP6K5M8YZ3QN00NF.tmp.c:8423: by vweb__Worker_T_main__App_process_incoming_requests_T_main__App_thread_wrapper
0092b3c : by ???
009275fe : by ???
0092b408 : by ???
7ff8a3df53e0 : by ???

Possible Solution

orm.SelectConfig{
table: 'Article'
is_count: false
has_where: false
has_order: false
order: ''
order_type: asc
has_limit: false
primary: ''
has_offset: false
fields: []
types: []
}

I found the fields is empty.
I do not know how to resolve this bug?
pub fn (db DB) @select(config orm.SelectConfig, data orm.QueryData, where orm.QueryData) ![][]orm.Primitive
how the config come here?

Additional Information/Context

I compile v.exe from source code.
It is ok now!
weekly.2024.06 cannot work on windows 11

V version

V 0.4.4 a374d25

Environment details (OS name and version, etc.)

V full version: V 0.4.4 a374d25
OS: windows, Microsoft Windows 11

Note

You can use the 👍 reaction to increase the issue's priority for developers.

Please note that only the 👍 reaction to the issue itself counts as a vote.
Other reactions and those to comments will not be taken into account.

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugThis tag is applied to issues which reports bugs.OS: WindowsBugs/feature requests, that are specific to Windows OS.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions
      ⚡