luasql

luasql copied to clipboard

It trouble us for a long time . When there are a lot connections and there may be an error LuaSQL: error connecting to database. MySQL: Can't initialize character set...

yujiaao100

I have an script on lua. Which works just fine using the luasql-mysql 2.3.0-1 rock, since the update to luasql-mysql 2.3.5-1 the close() methods create a delay (more like a...

fabianloayzarivera

Seemly there is no way to set the encoding settings

3

I have a program here using LuaSQL that keeps getting mojibake out of the server, I am in Brazil, and it return brazillian-related stuff wrong. raw byte dumps of the...

speeder

Out of Memory

7

I am receiving Out of Memory issue while executing queries using LuaSQL. Can any one please help me on this. I have closed the connection properly, but still i am...

kirubz

I have a mysql stored procedure like this: _`CREATE DEFINER=`root`@`localhost` PROCEDURE `get_record`( In mKey varchar(300) ) BEGIN Select * from table_name where column_name = mkey; END`_ And in LUA, I...

samlevi1981

luasql.postgres: SIGSEGV and crash if conn:escape(string) and returned string >8199 bytes

7

This sample script ``` lua local luasql = require "luasql.postgres" local env = assert(luasql.postgres()) local conn = assert(env:connect()) for i=4080,5000,1 do local s1 = string.rep("'", i) local s2 = conn:escape(s1)...

shripchenko

Error: "LINK: fatal error LNK1181: cannot open input file 'C:\gcc-lua-install\lua\bin\lua53.lib'."

1

Hello . I have a problem. Hope you can help me. Here is the problem: I need to install luasql in my computer for my data in MySQL. I already...

bonez001

About LuaSQL, SQLite3, FireBird and ODBC

2

Hello, friends. This message is for the team in charge of LuaSQL, specifically SQLite3, FireBird and ODBC connection. I am interested in make tests to **LuaSQL** using **SQLite3** and **FireBird**,...

jhernancanom

Fetching result of stored procedure returns single record

4

When I try to fetch the result of a stored procedure it returns only one record. res, err, errno, sqlstate = db:query("call icenter.queryUserOTHistorySessionRB(4780,'2016-03-01 00:00:00','2016-04-30 23:59:59');"); That's the result: [{"LogoffTime":"2016-04-14 07:30:00","user_id":4780,"resource_id":1335,"ResourceName":"WTH5401171","InuseTime":54000,"IdleTime":0,"LogonTime":"2016-04-13...

Paul-Wasilewski

Can not fetch result after calling procedure

1

local res=assert(con:execute("CALL `Procedure_name`('"..parameter.."')")) while row do row = res:fetch ({}, "a") end After this calling another query and see: LuaSQL: error executing query. MySQL: Commands out of sync; you can't...

ovoshlook