jusas / sqlite3ue4 Goto Github PK

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)?

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!

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!

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!

Hi.

@Jusas, can you explain, how you have built libs SQLite3.x64.lib and SQLite3.x86.lib ?
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.

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.