[Gambas-user] Problem with MySQL LONGTEXT field type (Null data)
I have changed the heading of the mail, because I have noticed that
sometimes it does not come received from the mailing list.
In any case, this continuous speech approximately the problem of the
fields “longtext” in MySQL.
...
I have executed of the tests, to line of commando from Linux, in order
to understand the reason for which in Gambas they do not come loaded the
fields “longtext” from the database “information_schema” with MySQL.
The error, to how much seems, does not seem derived from an anomaly of
Gambas, but from an anomaly of MySQL, that is, executing the logon and
the query on the table “information_schema”, like customer root (and
with the commando “mysql”), the data come extracted all in complete and
corrected way; if the same operation comes carried out with an other
customer (not administrative), the type fields “longtext” they turn out
NULL.
I have verified the same thing with Gambas and, in effects, it is
behaved in the same way.
I have controlled the MySQL logon parameters, so as to verify if some
various formulation between the several customers exists, but have not
found some difference.
I have verified if the behavior were identical in phpMyAdmin (a program
PHP of management for MySQL), but strangely, the data comes always
visualized in corrected way, with any customer.
I have controlled code PHP, but some formulation does not exist, that it
can condition such behavior.
To this point, the anomaly sure is caused from MySQL, but I do not
succeed to understand like resolving the problem.
Also I have tried to give GRANT to the customers, but for the outline
“information_schema” it is not possible, since this is a database of
system.
Examples:
USER: root (mysql --host=localhost --port=5432 --user=root
--password=xyz --database=test)
mysql SELECT routine_name, routine_type, routine_definition FROM
information_schema.routines WHERE routine_name = 'hello' AND
routine_type = 'FUNCTION' AND routine_schema = 'test';
+--+--++
| routine_name | routine_type | routine_definition |
+--+--++
| hello| FUNCTION | return concat('Hello, ',s,'!') |
+--+--++
1 row in set (0.00 sec)
mysql
USER: test (mysql --host=localhost --port=5432 --user=test
--password=xyz --database=test)
mysql SELECT routine_name, routine_type, routine_definition FROM
information_schema.routines WHERE routine_name = 'hello' AND
routine_type = 'FUNCTION' AND routine_schema = 'test';
+--+--++
| routine_name | routine_type | routine_definition |
+--+--++
| hello| FUNCTION | NULL |
+--+--++
1 row in set (0.00 sec)
mysql
How it is possible to resolve this problem?
--
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] XML library with xml multilevel tags (EndElement)
Il giorno dom, 28/12/2008 alle 02.14 +0100, Luigi Carlotto ha scritto: Il giorno sab, 27/12/2008 alle 20.04 +0100, Luigi Carlotto ha scritto: I do not comprise the reason, but mine precedence post has been included like answer in an other mail. … however… Gambas 2.9.0 Using the gb.xml library, me they are shrewed that the reading can be carried out single on files xml to 2 levels. I explain myself in better way… I have necessity to read xml files, that it contains a composed structure from elements, structured in hierarchical way on more levels, as an example: ?xml version=1.0 encoding=UTF8? pgDesigner Version=2.0.0 PROJECT Name=bible PageFormat=A4 PageOrientation=0 Revision=14/03/2008 14:44:03 Description=bible Driver=8.2 Author=mgm Display=0 TABLE Name=tb_log X=10 Y=6 ColorBack=230,230,230 ColorText=0,0,0 ColorBackTitle=230,230,230 ColorBackTitleSelected=76,89,166 ColorForeTitle=0,0,0 ColorForeTitleSelected=255,255,255 Comment=006C006F0067 Option=false PrimaryKey=tb_log_pk TABLEFIELD Name=id Table=tb_log Comment=006900640065006E00740069006600690061006E0074 Length=0 NullCheck=true PrimaryKey=true Type1=serial/ INDEX Name=tb_type_personne_idx1 Table=tb_type_personne Unique=true/ /TABLE questa è una prova /PROJECT /pgDesigner In the example, the hierarchy of the rows xml is composed gives: 1) a main element (root) “pgDesigner”; 2) inside of the root, the element is present “PROJECT”; 3) under “PROJECT” the element is present “TABLE”; 4) in its turn, the element “TABLE” contains a series of other heterogenous elements. Through the gb.xml library, the reading of the file does not notice of the closing of tag (Node.Type=XmlReaderNodeType.EndElement), if these are sluices on the same definition of the tag, like as an example: INDEX Name=tb_type_personne_idx1 Table=tb_type_personne Unique=true/ the reading evidences the opening of tag, but the not its closing, for which it renders impossible to ago understand if tag following the part of a advanced element, or is to the same level of the element precedence. The behavior is various in phase of writing where, through the methods “StartElement” and “EndElement”, it is possible to define complex structures. This logic, currently, only forces the use of structures xml on two levels. The spaces contained in the strings do not have particolary functions, but they make part of the name of the object, and it is not possible to eliminate them. In other cases, use the comma in order to separate a list of elements (es. an Array, Join function), than in reading comes reconverted in Array (Split function). With regard to the levels, I have resolved, constructing a series of classes, based on the objects XmlReader and XmlWriter. Logic of these objects allows to only read to rows xml multilevel, but if the tag they are not sluices on if same. In contrary case, the gb.xml library does not notice of the closing of the tag, for which the hierarchy it does not come constructed in correct way. These classes directly work in memory, loading the xml files in a structure, that it can be read inside of a program. The writing comes carried out through the same structure of memory. This logic me slightly seems or faster, and fastly releases the connections to the file. Only problem, perhaps, could be the management of large files; I have tried with xml of 2Mbyte, and I am fast. Perhaps he can be useful in Gambas… The structure follows logic, also applied in other languages, than part from an object Document (pgXmlDocument), that a Root element contains; like then for all the other elements (pgXmlElement), it contains an Array of elements and an Array of attributes (pgXmlAttribute). The connection with the object father, comes managed from the property Parent (Root does not have Parent, obviously). It makes me to know if it can interest. Like the last ones, also this mail has not arrived in the mailing list… However, I have uncovered qual'è the problem with the management of tag the multilevel. If the tag it comes closed, immediately after the list of the attributes, like as an example: tag attribute=/ the variable “XmlReaderNodeType.EndElement” does not come set up. If the tag it comes in this way closed: tag attribute=/tag the closing comes found, and the variable “XmlReaderNodeType.EndElement” works correctly; in this way it can be understood if the tag it contains other elements, and this allows to manage a document xml in modality multilevel. I have executed some modifications to my code, and the xml files, and all it works like previewed. At the same time, I have constructed to a series of generic classes, that they join the functionalities of the two classes XmlReader and XmlWriter, and that they work directly in memory, loading an inner structure given (Array with objects), the reading
[Gambas-user] Release of Gambas 2.10.2
Hi, Some things were broken yet in the 2.10, so I made a new release. Fixed things mainly are: * The HttpClient.Async and FtpClient.Async properties. * The Balloon class, that was freezing the GUI. * The XSLT.Transfrom() method. Here is the full ChangeLog: --- [GB.DB] * BUG: Correctly check that table name are not void in Create(), Find(), Edit() and Delete() methods. [GB.NET.CURL] * BUG: HttpClient and FtpClient Async property are now correctly initialized to TRUE. [GB.QT] * BUG: Showing balloons does not freeze the GUI in some case anymore. * BUG: Setting the Menu.Shortcut property to NULL now correctly removes the shortcut. [GB.QT.EXT] * BUG: Editor.Print() method now can deal with strings having null character inside. [GB.XML.XSLT] * BUG: XSLT.Transform() now works correctly again. --- Happy new year 2009 with Gambas! -- Benoit Minisini -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 USB detect !!??
drive. I haven't hooked any USB drives up to my Ubuntu server since I upgraded so I don't know if every distro has logs that look like that, or just Mandriva. Rob Good idea - /var/log/messages should be present on every linux looking in there can provide interesting infos... (be base for usefull GUI apps). May be coupled with comparing current time / log time in order to look only for current events... The problem ist - as normal user you are not allowed to read it... regards Emil -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] TableView Editing
Gambas 2.8... I've slightly modified Fabien's example posted on August 13, 2008. 1) I'm getting a Null Object when attempting to execute the following line inside a TableView Click event: TableView1.Edit([a, b, c, d], FALSE) 2) Say I click on Col 0, Row 0. The contents of that cell are selected. I edit the cell contents then press TAB and it appears the contents are apparently saved, but the next column's cell does not get selected. In other words, I click on 0,0 then press TAB. I expect Col 1, Row 0 to be selected. But it is not. Using the left and right arrow keys, I can cursor through the cells and their contents (but none is selected)--which is as expected. Just wondered if the TAB functionality was a feature or a bug? Or possibly something that has been addressed more recently. Thanks, Jason -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 USB detect !!??
Am Samstag, 3. Januar 2009 schrieb Emil Tchekov: drive. I haven't hooked any USB drives up to my Ubuntu server since I upgraded so I don't know if every distro has logs that look like that, or just Mandriva. Rob Good idea - /var/log/messages should be present on every linux looking in there can provide interesting infos... (be base for usefull GUI apps). May be coupled with comparing current time / log time in order to look only for current events... The problem ist - as normal user you are not allowed to read it... You (or better the administrator) can create a named pipe (with mknod) and direct parts of the log infos additionally to this named pipe. So the syslog.conf needs to be edited and a line like kern.info | YourNamedPipe may be added, which say, the all the log messeages from the kernel shout additional go throug the named pipe. Of course the syslog-daemen needs to be restartet or instructed to reread its config file. Hope that helps Rolf signature.asc Description: This is a digitally signed message part. -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] create gambas component
hi I new in gambas. I try to create a simple gambas component , a project with only a class and a function . I read from wiki that all I need to do is 1. on the project option set the this project is component to true 2. on make executable option tick Install in the user component directory after I click ok to generate , I get error CComponet.load.353 file or directory does not exist I load another project , from the project component I see the component I created . I tick my component to enable it then press ok button . I get the same error CComponet.load.353 file or directory does not exist am I missing something? -- View this message in context: http://www.nabble.com/create-gambas-component-tp21271068p21271068.html Sent from the gambas-user mailing list archive at Nabble.com. -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] create gambas component
I using opensuse 11.1 (64 bit) . I download gambas from http://download.opensuse.org/repositories/home:/gbvalor/ I using gambas 2.9 . I also try update to 2.10 and recompile but still get the same error Benoit Minisini wrote: On dimanche 4 janvier 2009, kobolds wrote: hi I new in gambas. I try to create a simple gambas component , a project with only a class and a function . I read from wiki that all I need to do is 1. on the project option set the this project is component to true 2. on make executable option tick Install in the user component directory after I click ok to generate , I get error CComponet.load.353 file or directory does not exist I load another project , from the project component I see the component I created . I tick my component to enable it then press ok button . I get the same error CComponet.load.353 file or directory does not exist am I missing something? Do you use the latest version of Gambas ? -- Benoit Minisini -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- View this message in context: http://www.nabble.com/create-gambas-component-tp21271068p21272347.html Sent from the gambas-user mailing list archive at Nabble.com. -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] TableView Editing
Just wondered if the TAB functionality was a feature or a bug? Or possibly something that has been addressed more recently. This happens in qt and gtk. -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] 1755 build failed! (Solved sort of)
On Thu, 1 Jan 2009 10:33:02 am richard terry wrote: On Tue, 30 Dec 2008 07:43:04 pm David Paleino wrote: On Tue, 30 Dec 2008 17:33:54 +1100, richard terry wrote: /usr/bin/ld: cannot find -lqt-mt Do you have qt3 headers installed? On Debian (and -like) systems it would be libqt3-mt-dev. Just my two cents, David I'll look at that - I've really had gambas build failing before and I've done it probably hundreds of times now. These files seem to be there: /opt/qt/lib/libqt-mt.prl /opt/qt/lib/libqt-mt.so /opt/qt/lib/libqt-mt.so.3 /opt/qt/lib/libqt-mt.so.3.3 /opt/qt/lib/libqt-mt.so.3.3.8 Benoit suggested doing : First, do a ./reconf ./configure -C. Then check that the qt 3 library is installed on your system. As I don't understand scripting etc, I wonder if anyone could look at my package build file and tell me what to insert where, or which directory to go to to type what. Regard Richard Seem have solved this by adding LDFLAGS+=-L/opt/qt/lib after my make statement in my PKGBUILD file, and finally it worked. Love to know why, but I guess thats what comes of being computer illiterate. Regards Richard -- ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
