Openbravo Forum End of Life Notice

Dear Openbravo Forum User,

Because of continued very low usage we decided to stop the forums on 31st of August 2017

In case of questions: webmaster "at" openbravo.com

Error in mySQL installation

<<

Mario Fernandez

Posts: 22

Joined: Fri Sep 18, 2009 8:02 pm

Post Sat May 07, 2011 11:45 am

Error in mySQL installation

Hello all,


When I try to create a new database from scratch with OpenPOS 2.30 and mySQL 5.1.16 i get the following error:


com.openbravo.basic.BasicException:

java.sql.SQLException: Can't create table 'openpos.subgroups' (errno: 150)


com.openbravo.basic.BasicException:

java.sql.SQLException: Can't create table 'openpos.subgroups_prod' (errno: 150)


It seems as every table was created, except these 2. Any ideas?


Best regards,


Mario.


 


 

<<

Andrii Pertsiukh

Posts: 8

Joined: Thu Feb 24, 2011 2:00 pm

Post Sun Jul 31, 2011 4:35 pm

Re: Error in mySQL installation

Hi Mario,

I have different problem with MySQL installation. It was about maximum key field length (1000). I found that problems appears if I use UTF-8 encoding. If you use UTF8, then first install DB with default latin1 and then, after successful installation change encoding of DB and each table (field if needed).

Hope it helps.

Return to Open discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Website Terms


Designed by ST Software for PTF.