MySQL Code Generator code won't work

[j]

hi there

this is my first go at using ripe and no matter what i do, the mysql
code generated just doesn't run on mysql, i've tried through multiple
sql interfaces including the command line and always get the same
errors.

unkown command '\"'
unkown command '\''
if i remove all " it complains about ;

this is ripe run out of the box on mysql 5.1.53, no funny business, i
don't understand what's going on....

also, if i try to use odbc for the connection, it always times out
saying the connection has fallen away, i can't see where to set any
timeout options

although i was really excited to give this a go, i'm actually starting
to wonder how i can get the model i've put all my effort into, out of
rise and into something else that can generate more syntactically
acceptable mysql

i would really appreciate some help here, thank you in advance :)

[HOlsen]

Hi,
Please have a look at the "MySQL code generation" message from
September 2010, and let us know if this does not help you solve the
problem.

Best regards,
RISE to Bloome Software

[j]

hi again

thanks for getting back to me so quickly.. i gave that a go, but i'm
getting the same sort of errors, i even upgraded mysql to 5.5.16...

here's the output

>>

mysql> \. model.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\"'.
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 20
Current database: test

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 21
Current database: test

ERROR 2006 (HY000): MySQL server has gone away
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 22
Current database: test

ERROR 1305 (42000): PROCEDURE test.sp_install_rise_model does not
exist
mysql>

[j]

hi

the script actually seems to be corrupting the mysql.proc table on
multiple servers.. again, this is straight out of rise without any
alterations.

ERROR 1547 (HY000) at line 4: Column count of mysql.proc is wrong.
Expected
20,
found 16. The table is probably corrupted

a check reveals the following..

WARNING: NULL values of the 'character_set_client' column
('mysql.proc' table) have been updated with a default value (latin1).
Please verify if necessary.
WARNING: NULL values of the 'collation_connection' column
('mysql.proc' table) have been updated with a default value
(latin1_swedish_ci). Please verify if necessary.
WARNING: NULL values of the 'db_collation' column ('mysql.proc' table)
have been updated with default values. Please verify if necessary.

and then, we run the script again..

ERROR at line 6: Unknown command '\"'.

more specifically

Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\"'.
ERROR:
Unknown command '\"'.

ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet'
bytes

ERROR 1305 (42000): PROCEDURE test.sp_install_rise_model does not
exist

could it be that the storedproc def is too long?
or some funny auto gen'd comment somewhere?
could it be something to do with model notes not handling data
properly maybe?

cheers

[j]

see http://groups.google.com/group/riseeditor/browse_thread/thread/8015acfe51b694a1?hl=en