just try: temp = mySQL_GetVal(100,100);
crash because that field doesn't exist.

That will return 0 and doesn't crash engine in Lite-C. Are you using CSMySQL.dll for C-Script?

Quote:

---

Here are the current A7 MySQL beta engine extensions for A7 C-Script and Lite-C. Tonight i'll update the downloads with clean examples.

---

ROCK AND RULE!
Testing them out today!
Thanks, D3D!

The link to most current files are stored here. The zipped upload for C-Script/Lite-C will also be moved to those directories.

SETUP

1)I'm using your latest version, the one posted up on saturday. Both dll files are in my projects folder. I'm using A7.07.4b, C-script, and Mysql 5.1

2) My system has 7 applications that connect to the Database, each under a different username but same password.

3) The queries, when they work, work fine

PROBLEMS

1) HOWEVER, I'm getting an intermittent error where I connect to the database (I can see my user connected on the MySql Administrator) but when the application runs, it crashes because mysql_rownum() returns zero and this is later used as a get call.

Code:

---

 	
	num_rows = mySQL_RowNumber(); <--- num_rows == 0 on failure
	randomize();
	
	//get Id from Id_List
	id_chose = int(random(num_rows));  <--- id_chose == 0 on failure
	
	mySQL_GetStr(Physics1_ID,0,id_chose); <--- CRASH

---

2) This error does not happen all the time and sometimes it happens with different applications (though it seems to occur more often to applications/connections that connect later to the database).

3) We never encountered this problem with A6.6

SOLUTION

In every case, if I go into the MySql Administrator, delete the offending user, and remake him, on the next run it will work (until it or another application fails).

SUMMARY

Intermittently (ie: we can reproduce the error on demand), the user will connect to the DB but the mysql_rownumber will return a zero down the line. Upon deletion and recreation of the user (same name; same password), the mysql_rownumbers() works fine again.

COMMENT

This sounds similar to the problem Samb was having with mysql_rownumbers(). Samb, if you get the crash, try what I did and redo the user. See if that clears it up. I would be nice to have the same error across the board.

Any idea what could be causing this?

UPDATE
I am definitely getting an error with mysql_rownumbers(). I leave my application running after a successful load in. It runs and runs mysql_rownumbers several times. Then all of the sudden the system crashes when this call is made:

Code:

---

                 diag("mysql row 1");
			mySQL_execQuery(sql_cmd);
                        diag("mysql row 1.1");
			if (mySQL_RowNumber() == 1)
			{			
                               diag("mysql row 1.2");		
				mySQL_getStr(id, 0, 0);
                                diag("mysql row 1.3");
				playerType = mySQL_getVal(1, 0);
			}
			diag("mysql row 2");

---

We get to 1.1 but do not get to 1.2 or 2.0. Hence the crash is distinctly when the mysql_rownumbers() call is made.

I will take a look at CSMySQL today, but I can only test on MySQL 5.0.45 server with A7.06.1 Public release.

Using the public version "shouldn't" change things. I'm pretty sure we got the same behaiviour but after so much testing, who knows. We have to use the beta because of an ent_create problem that keeps cropping up. However, I thought we had to be on server 5.1... would that make a huge difference difference?

We'll revert to your settings tomorrow and test it out. I would ask you to upgrade to 5.1 to match our version and since it's the latest free version (unless you know of a reason why it would be a problem).

Furthermore, if you release the source code to me, I can have my people look it over and we can both work towards this. If you don't want to release the source publically, I can send you an email to send it to us privately.

I really want to extend my heartfelt thanks to you, D3D. As you can tell, this is a REALLY big deal for us. Our entire MMOG runs off of MySQL and thus any problems with the plugin grinds our development to a halt! Anything you can do to help us is greatly appreciated!

@Fastlane: If needed I can setup database on my server and PM you the code. Only it will be MySQL 4.1.xx, but enough for testing..

Note: Make sure you're using the libmysql.dll included in the download. Do not use older/newer version or the one that is inside VC directory. You could test my database file with demo and rows to see how things are working. The source code for Destops MySQL engine extension can be found here and is open source. The plan is to rewrite the DLL for MySQL 6.0+ and A7 next year.

Reason for me using 4.1+ and 5.0.45 is that my website offers 4.1+ and for offline testing i'm using WAMP server which comes with 5.0.45. Not really like to install the latest because it might break my WAMP installation, but I remember that libmysql worked up to MySQL 5.1 when creating PHP frontend for A6MySQL last year..

Guess if you really need reliable MySQL support right now. Best thing would be to rewrite with current MySQL SDK. Or you could wait until I find some help to do the same. I did test the current DLL with the samples included and not encountered problems with either C-Script/Lite-C A7.06.1 at this moment though.

Let me know what happens if you try with my database and C-Script samples. I don't understand the random function with rows. From what I understood, there are no 1.0,2.0 rows. Only row1, row2, etc etc. If i'd inserted the first user into a clean database in the rxplayers table, it gets row 1 and if I add another it will be on row 2 and so on. In my samples I have used all functions of the MySQL engine extension, although the query and actual data handling can be changed in many different ways.




A7 C-Script MySQL
A7 Lite-C MySQL
A7 MySQL Source
PHP FrontEnd in development.
MySQL C/C++ Forum
MySQL++

Thanks D!

I'll give these a look see over the next few days and see if we can track down the issue.

Just tested MySQL 5.1.22-rc-community Server. Have not noticed any problems using release 5.1.22 or 5.0.45, which is installed by default as WAMP addon. Tried with both demo.wdl and rows.wdl from the CSMySQL Demo.