Hello Herman,

The message "Incorrect arguments to mysql_stmt_execute" is from the mysql driver and not somewhere in MMBase.

Which mysql version and driver are you using? There are several issues reported on server/driver versions. See for example http://bugs.mysql.com/bug.php?id=11084 Some of the issues were resolved by adding ?useServerPrepStmts=false to the url string.

Just to be sure it isn't a mmbase issue I downloaded the 1.7.4 release and deployed it on my system. I have a WinXP SP2 with java 1.4.2_03, tomcat 5.0.28, mysql-connector-java-3.1.10-bin and mysql 4.1.14-nt

I was able to create an alias on several nodes. While clicking around in the mmexamples and editors I was missing several things so I installed the latest from the CVS mmbase-1_7 branch. On the same database the things show up so I think there are some issues with the 1.7.4 final release. I compared the two versions in cvs and there are several changes in the storage layer. It might be good to use a more recent version from http://www.mmbase.org/download/builds/

Regards,

Nico Klasens

Herman Reintke wrote:
Henk,
I used mmbase 1.7.4 final (fresh/clean install) when I got the error. Using java 1.4.2_05, tomcat 5.0.30 on WinXP SP2.
I used the standard supplied my_editor when trying to add aliases.
As there is a 1.8 on its way I downloaded this morinig the jan 16 nightly build and did the same try. This build has some trouble getting the basic examples running (no such resource applications/Community.xml and other identical messages) but I could create a alias on some of the objects which were available. Kind regards, Herman

    ----- Original Message -----
    *From:* Henk Hangyi <mailto:[EMAIL PROTECTED]>
    *To:* 'Discussion list for developers'
    <mailto:[email protected]>
    *Sent:* Monday, January 16, 2006 11:09 AM
    *Subject:* RE: [Developers] Fw: Saving Alias in mysql

    Hi Herman,
How do you create the alias and what version of MMBase are you using? Kind regards, Henk. T. +31-(0)6-29054903
    I. http://www.mmatch.nl

        -----Original Message-----
        *From:* [EMAIL PROTECTED]
        <mailto:[EMAIL PROTECTED]>
        [mailto:[EMAIL PROTECTED] *On Behalf Of
        *Herman Reintke
        *Sent:* Monday, January 16, 2006 10:06 AM
        *To:* mmbase developers
        *Subject:* [Developers] Fw: Saving Alias in mysql

        LS,
I posted this message last week on tyhe users list but did not
        get response.
        Is any of the developers using mysql as the database and/or
        encounterd the issue below ?
The only change I made to get mmbase using mysql was that I
        changed the jdbc.xml file to work with mysql. I do not get any
        errors starting up and I can create nodes using the editors
        without any problem.
But.. when trying to set an alias and saving the node I get the
        error :
2006-01-11 17:12:38,341 ERROR mmbase.module.core.MMObjectBuilder - Failure(org.mmbase.storage.Stor
        ageException: Incorrect arguments to mysql_stmt_execute)
        inserting node:
        
prefix='',destination=9:'138',otype=2:'19',owner=1:'system',name=1:'y',number=9:'139'
        org.mmbase.storage.StorageException: Incorrect arguments to
        mysql_stmt_execute
                at
        
org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageM
        anager.java:672)
Do I have to update addtional config files to use mysql ? Kind regards, Herman Reintke
    ------------------------------------------------------------------------

    _______________________________________________
    Developers mailing list
    [email protected]
    http://lists.mmbase.org/mailman/listinfo/developers


------------------------------------------------------------------------

_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers


_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers

Reply via email to