LiveCode Forums.

I have made same tests and I have got the following results:
-the error doesn't depend by the socket timeout;
-the error doesn't depend by the server OS (I have tried with windows server 2003 and MacOS X);
-the error doesn't depend by the client OS (I have tried with windows XP and MacOS X);
-I get ...

Do you know if there is a relationship between the socket timeout and the connection to a MySQL server with the revOpenDatabase function?
When I stay connect from a remote machine to the server and I don't send a query for more than 5 minutes, I obtain the error "MySQL has gone away".
PS
I have ...

Hi, all
I have to upload a file from a client Revolution application to a MySQL server, but I obtain the following error:
"ERROR 1148: The used command is not allowed with this MySQL version"
If I try with another client application (i.e. MySQL Query Browser) from the same machine it works.
In mySQL ...

I agree
it's an important feature with the full justified text in a paragraph.

Riccardo

Thanks Jan,
I found the error and I hope that it can help others.

The problem is in the following code located in the openstack handler of the main stack:

put the substacks of stack "Xdent" into lista
repeat with i=1 to the num of lines of lista
put line i of lista into finestra
set the ...

I have checked the external files and they are OK.
As Jan suggested, I have verified the open connections before the query and I have discovered that I have no active connections.
It is very strange because the same app worked same days ago and in IDE environment it works again now.
I don't have any ...

Hi Jan,
the script is correct (it is like yours) and it works in other platformors without any problem.
It also works if I use it in IDE environment, but it doesn't work only in standalone.

Riccardo

Hi,
I am trying a query to MySQL database using MacOS X 10.4.6 and Rev 2.6.1.
When I am in IDE environment all works fine, but when I make a standalone application I have the following error:
-the connection is OK
the revOpenDatabase returns a connection ID
-the first query returns the error ...

Hi Rishi,
Thanks to you for your contribute too.
Finally I solved my connection problem to MySQL DBNS with the help of Runtime Support.

As Rishi suggested it was due to the dipendencies of dbmysql.so library used by revolution.
Using ldd command you can discover what modules are not present in the ...

Hi Jan,
As you suggest I have tried too:
put revdb_connect("mysql","localhost","test","root","",false) into tConnectionID
but the result is always:
revdberr,invalid database type

Can I try anything else?
Thanks

BvG, you are right, I have made a mistake in copy and past the command string.
I beleave that the exact string for an user with no password is "", but I have made a lot of attempts and I have noted that the error depends only by the first parameter of the command. (it doesn'nt change if I use ...

Hi Jan
Thanks for your reply.

I had tried this command:
revSetDatabaseDriverPath "/home/amministratore/Desktop/Revolution-2.6.1/components/global environment/database_drivers/Linux/"
but the revOpenDatabase ("mysql","localhost","test","root",""") returns always the same result: revdberr, invalid ...

When I try to connect to MySQL on a Linux machine, I have this result:
revdberr.invalid database type.

Where can be the problem?
MySQL runs correctly and I can connect it with 'mysql query browser' application.

WIth rev I can't.
Is a drive problem?If yes, where have I get and install the MySQL ...