jusas / sqlite3ue4 Goto Github PK
View Code? Open in Web Editor NEWSQLite3 Database Plugin for Unreal Engine 4
License: MIT License
SQLite3 Database Plugin for Unreal Engine 4
License: MIT License
Hi I'm using SQLite3UE4 plugin and I have a strange problem with SQLITE queries if they are more complex (longer). In addition, if the column name has more than 10 characters, for example, query SELECT colum10characters FROM table ORDER BY column10characters ASC does not work.
If I change column10characters name to column query SELECT column FROM table ORDER BY ASC column works correctly.
Alias do not help.
GOAL:
I need to use longer SELECT queries on SQLite composed of AND OR etc, and even if the column names 1 character after a certain length do not work properly and the project hangs. Does anyone have any idea why this is happening ?? Thanks!
Hello.
In my previous bug report https://answers.unrealengine.com/questions/253236/hot-reload-seems-broken-in-project-with-plugin-pos.html I reported to your team that Project with plugin after compilation from UE Editor can't be saved - it's gets errors on save.
But that's not the end of the story of the Project with plugins...
After packaging of that Project - game exe crashed with no errors in logs. It's not generated log files, it just silently chashes...
Project sources: https://goo.gl/SKV0nm
Packaged result: https://goo.gl/5mG36b
Can you explain, why it crashed without no information about crash?
But in Windows logs I found error:
Контейнер ошибки 120274677119, тип 4
Имя события: APPCRASH
Отклик: Нет данных
Идентификатор CAB: 0
Сигнатура проблемы:
P1: HOTRELOADTEST.exe
P2: 4.8.1.0
P3: 559e3d04
P4: HOTRELOADTEST.exe
P5: 4.8.1.0
P6: 559e3d04
P7: c0000005
P8: 000000000036501c
P9:
P10:
Вложенные файлы:
C:\Users\ArtUrlWWW\AppData\Local\Temp\WER5266.tmp.WERInternalMetadata.xml
Эти файлы можно найти здесь:
C:\Users\ArtUrlWWW\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_HOTRELOADTEST.ex_750ea75e2f08ec17ab687f4a959ccc46c914271_d98a345c_20425748
Символ анализа:
Повторный поиск решения: 0
Идентификатор отчета: 25d6cac3-261d-11e5-bf13-fc4dd451925d
Состояние отчета: 0
Хэшированный контейнер: 687a870ec593dd3bb0c879926259f561
Имя сбойного приложения: HOTRELOADTEST.exe, версия: 4.8.1.0, метка времени: 0x559e3d04
Имя сбойного модуля: HOTRELOADTEST.exe, версия: 4.8.1.0, метка времени: 0x559e3d04
Код исключения: 0xc0000005
Смещение ошибки: 0x000000000036501c
Идентификатор сбойного процесса: 0x23f0
Время запуска сбойного приложения: 0x01d0ba29e820328f
Путь сбойного приложения: C:\temp\MyGameBuild\qqq\WindowsNoEditor\HOTRELOADTEST\Binaries\Win64\HOTRELOADTEST.exe
Путь сбойного модуля: C:\temp\MyGameBuild\qqq\WindowsNoEditor\HOTRELOADTEST\Binaries\Win64\HOTRELOADTEST.exe
Идентификатор отчета: 25d6cac3-261d-11e5-bf13-fc4dd451925d
Полное имя сбойного пакета:
Код приложения, связанного со сбойным пакетом:
Thank you!
I had download SQLite3UE4-master.zip file.
After extracting it. I tried to launch SQLite.uproject.
And found:
Press 'Yes'
It goes to start building project.
After that comes Error
If I launch project again below message pop-up and asking to rebuild.
But "SQLite3UE4-master\Plugins\SQLite3UE4Plugin\Binaries\Win64" contains two files
My Unreal Engine Version : 4.8.2
My Visual Studio :
I am stuck here since 3 days.
Kindly Help me out of it.
Hi.
@Jusas, can you explain, how you have built libs SQLite3.x64.lib and SQLite3.x86.lib ?
Thank you.
I had downloaded SQLiteUE4 from : https://github.com/KhArtNJava/SQLite3UE4
I am able to build the project successfully. I am able to see the database content in editor play. But whenever i try to launch/package the project it fails.
Here is the log file.
http://shrib.com/see/AyNEcEsOXfTQHHJIxjyjxLkQgOIbT0AUpNYHSHVpmo6twF2joq?v=nc
Hi.
I found, that max possible query length for sqlite3_exec may be 127 symbols.
For example:
code:
ANSICHAR* dbNameAsUtf8 = TCHAR_TO_UTF8(*Databases[DatabaseName]);
int32 i = sqlite3_open(dbNameAsUtf8, &db);
if (i == SQLITE_OK){
ANSICHAR* queryAsUtf8 = TCHAR_TO_UTF8(*query);
int32 k = sqlite3_exec(db, queryAsUtf8, NULL, 0, &zErrMsg);
if (i == SQLITE_OK){
success = true;
}
else {
LOGSQLITE(Warning, TEXT("CreateTable - Query Exec Failed.."));
}
Query with string length 127 worked well:
CREATE TABLE IF NOT EXISTS dsfsdfdfDFDFDFADSFADSFASFSDFSAFASFASFASDFSADFSDFSD777(F1 INTEGER , F2 TEXT , F3 REAL , f4 NUMERIC );
But same query, but with 128 symbols
CREATE TABLE IF NOT EXISTS dsfsdfdfDFDFDFADSFADSFASFSDFSAFASFASFASDFSADFSDFSD777A(F1 INTEGER , F2 TEXT , F3 REAL , f4 NUMERIC );
Executes without error, but table not created.
Can you explain, how to fix this (possible bug)?
If I want to enable this plugin from KhArtNJava's fork it tells me that it is not useable.
"Missin gor incompatible modules in SQLite3UE4Plugin plugin - would you like to disable it? You will no longer be able to open any assets created using it."
In 4.10 and in 4.11 is this error shown but because KhArtNJava forked it from here I must open the ticket here.
Please help me to get it working in 4.10 because other plugins/mods/... are not ported to the latest preview actually.
In SQLite.h you need to add #include "sqlite3.h" or the project won't build.
// Fill out your copyright notice in the Description page of Project Settings.
#pragma once
#include "Engine.h"
#include "sqlite3.h"
Hiho,
As I needed this code, but also wanted to fix the "static library" situation (so the requirement to precompile the lib), enforced me a bit to make an own version which I would like to continue working on. As it is nearly all based on your previous code, I just wanted to ask if that is ok with you? I already added and filled (with working version of how i need it) under https://github.com/cindustries/unreal-sqlite3 I also took your image for now, but I target to make a new one. I didn't promoted it yet.
Thanks in advance for the reply!
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.