notebook.sql for MySQL #132

New issue

Closed

opened 2026-02-26 01:35:14 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 01:35:14 +03:00

Owner

Originally created by @loifarn on GitHub (Apr 25, 2016).
Original GitHub issue: https://github.com/JLiscom/OpenNote/issues/150

Having some issues running the notebook.sql to setup the tables in MySQL.

If I run the script through Ajenti V's MySQL Interface receive this message:

error 1005 (HY000) at line 55 in file /srv/OpenNote/Service/model/sql/notebook.sql

If I try to run it via the MySQL command line I get the following message:

mysql> source /srv/OpenNote/Service/model/sql/notebook.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

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

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

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

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

ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121)
ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121)
ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121)
ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121)
mysql>

Any help would be greatly appriciated.

Originally created by @loifarn on GitHub (Apr 25, 2016). Original GitHub issue: https://github.com/JLiscom/OpenNote/issues/150 Having some issues running the notebook.sql to setup the tables in MySQL. If I run the script through Ajenti V's MySQL Interface receive this message: > error 1005 (HY000) at line 55 in file /srv/OpenNote/Service/model/sql/notebook.sql If I try to run it via the MySQL command line I get the following message: > mysql> source /srv/OpenNote/Service/model/sql/notebook.sql > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121) > ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121) > ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121) > ERROR 1005 (HY000): Can't create table 'OpenNote.#sql-29b6_5d' (errno: 121) > mysql> Any help would be greatly appriciated.