MySQL Connect error

[Guest]

Hi. I have an Autoplay Media Studio Project with a external database in db4free.net. I connected the database to the project via script (The project is a Login/Register form) and when I register a new user always goes ok, but the user doesn't appears in the database. What can i do?

[charliechaps]

Hi and welcome to the forum.
As we are not Mindreaders here , the 1st thing would be either place your code or an example apz
so that someone can view and check for you
Cheers

[Guest]

Hi and welcome to the forum.
As we are not Mindreaders here , the 1st thing would be either place your code or an example apz
so that someone can view and check for you
Cheers

Yes, you're right, I'm so sorry

[Guest]

The project is this.

[charliechaps]

Hi found an apz in my collection similar to your one also uses mysql
Noted a few calls are different , as I'm not good with Spanish or MySQL try this
ChatAMS.apz

[Guest]

Hi found an apz in my collection similar to your one also uses mysql
Noted a few calls are different , as I'm not good with Spanish or MySQL try this
[ATTACH]n303811[/ATTACH]

Hi, when I opened the proyect and tried to execute it as a program, it gave me MySQL errors like "nil value". I don't know what to do.

[charliechaps]

Hi , I think you would have to change to your server settings

from

MySQLConnection = MySQL:connect('chatams','chatams','xatams','db4free.net','3306')

To

MySQL = luasql.mysql(); -- Carga la libreria MySQL
-- Datos de conexion a la base de datos         
MySQLConnection, err = [COLOR=#FF0000]MySQL:connect('systemdb', 'domenicogoya', 'B04M30103V', 'db4free.net', '3306')[/COLOR]; -- Conecta a la base de datos
if not MySQLConnection and err then -- Verifica si hay algun error al conectar
   Dialog.Message("Error",err.."\n\nThe program will be closed"); -- Si hay error que mande un mensaje
   Application.Exit(0);
end