Database / Installation FYI with Xampp

I just started playing with Qcodo today. I ran into a problem when trying the examples where the one to many and many to many examples were failing.

I am using Xampp. With Xampp MySQL is set-up with Innodb disabled. The test db for the examples was created and the tables were MyIsam.

To correct the problem I had to alter the mysql\bin\my.cnf file to enable Innodb.

Here is the Innodb portion of the file as delivered:

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/xampp/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/
#innodb_log_arch_dir = C:/xampp/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

Here is the code modified to enable Innodb:***Make sure you comment out the “skip-innodb” line.

#skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = C:/xampp/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/xampp/xampp/mysql/data/
innodb_log_arch_dir = C:/xampp/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

I hope this is of some help to other newcomers.

Mike

Alex / Mike, could you guys post here any error message/strings that showed up before you made the my.cnf change in the forum?  THat way, if newbies do searches on the error string, they'll be able to find your post. =)

Mike,

I will re-configure and load Qcodo again to replicate the configuration I had before I got it working. Probably tomorrow. I'll post the errors then.

Thanks,
Mike

Alex... it's a good suggestion, but unfortunately it's a workaround that is very specific to mysql... and qcodo (including the QCodeGen object, itself, which would be responsible for reporting such an error) is completely database agnostic.  (it uses the QDatabaseBase API to access the individual database(s)).

But it's an interesting idea... and one possible workaround would be to have the codegen reporting give a count as to how many relationships, in general, it thinks it has for each table... e.g.:

Successfully generated class:       Login (with 1 relationship)
Successfully generated class:       Person (with 1 relationship)
Successfully generated class:       PersonWithLock (with no relationships)
Successfully generated class:       Project (with 2 relationships)
Successfully generated TYPE class:  ProjectStatusType

So, at the very least, you get immediate feedback that something's not quite right when you see all your classes generated with no relationships.

what do you think?

Here are the errors I received when trying the individual examples-

When selecting “* Relationships (Foreign Keys)”

Undefined GET property or variable in 'Project' class: ManagerPerson

When selecting “* Reverse Relationships (One-to-One and One-to-Many)”

Listing of the Project(s) that This Person Manages

Fatal error: Call to undefined method Person::GetProjectAsManagerArray() in C:\xampp\xampp\htdocs\qcodo\wwwroot\examples\code_generator\reverse_relationships.php on line 87

When selecting “* Many-to-Many Relationships”

Listing of the Project(s) that This Person is a Team Member of

Fatal error: Call to undefined method Person::GetProjectAsTeamMemberArray() in C:\xampp\xampp\htdocs\qcodo\wwwroot\examples\code_generator\relationships_many.php on line 69
.bc