Installation fails with InnoDB engine (fulltext index unsupported) (#774)

NashM

Joined: 2009-10-06
Posts: 2

Posted: Tue, 2009-10-06 10:56

Have replaced the install.sql file with the one located on the bug fix for this error and there seems to be a flaw in one of the SQL statements as I'm getting a syntax error from phpMyAdmin when I run the install scripts. Can you offer any advice please?

Many thanks in advance.

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Tue, 2009-10-06 15:42

G2 or G3?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

NashM

Joined: 2009-10-06
Posts: 2

Posted: Tue, 2009-10-06 17:52

This would be a vanilla install of G3. I have G2 operational locally for the time being for review purposes and on first impressions I'm delighted. There seems to be two issues. When I run the install of G3 I get the 'fulltext' index error. This I believe was the issue resolved by your trouble ticket #774 to which I am referring to. When I run the install script with the new .sql file I get a syntax message. I will of course, have dropped the original table from the prior attempt at installing G3.

I note that the G2 installation has created some 63 tables after the implementation of images and further modifications so I'm unable to comment as to whether the 15 tables created when running the G3 install script is the complete set required for a vanilla install.

Because of the usual poor reporting of SQL syntax errors in such statements I thought I would ask yourselves if you were aware of this issue. At this stage I haven't analysed your .'sql' to see if I can locate the error on your behalf.

Again I thank you for your assistance

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Tue, 2009-10-06 18:05

That install.sql was added by the user who submitted the bug report. I know know nothing about that. Here is the fix in the code that the developer used:
http://github.com/gallery/gallery3/commit/9d76797b17d65540a903ef37eee6edca3e83108b

Get the latest experimental code and try installing again:
http://codex.gallery2.org/Gallery3:Upgrading
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

rstander

Joined: 2009-10-10
Posts: 1

Posted: Sat, 2009-10-10 16:02

I had the same problem when I installed. For me the problem was that my default table type was INNODB. I just changed my default table type to MyIsam. That sorted it out.
You can change it in the mysql config file. If that's not an option you'll have to change the scripts to specify the table type as myisam.

horustwohawks

Joined: 2009-12-13
Posts: 6

Posted: Sun, 2009-12-13 18:34

It appears the commits listed in your posted link are not included in gal3 Beta 3, which is weird because the date is relevant.
??? why ???

horustwohawks

Joined: 2009-12-13
Posts: 6

Posted: Sun, 2009-12-13 18:49

Followup... okay, not sure if its the links on the main page, but here's the deal...
I had to go to the github tree and download the latest release (beta 3 in swing).
Here's the link..
http://github.com/gallery/gallery3/tree/

This not only has all the sept changes, but its current thru today, and it installs just fine ;^)

Cheers.

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Mon, 2009-12-14 14:31

please don't post the same post in multiple theads:

Beta3 was a milestone release and was released on 9/12. The fixes you linked to were done on 9/16. So there's no way they could have ever made it into B3. What probably happened is that once B3 was released, more people tried it, someone found the bug, reported it, and it was fixed a few days later.

http://codex.gallery2.org/Gallery3:Upgrading

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

NashM Joined: 2009-10-06 Posts: 2	Posted: Tue, 2009-10-06 10:56
	Have replaced the install.sql file with the one located on the bug fix for this error and there seems to be a flaw in one of the SQL statements as I'm getting a syntax error from phpMyAdmin when I run the install scripts. Can you offer any advice please? Many thanks in advance.
	XUser login Username: * Password: * Create new account Request new password
nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Tue, 2009-10-06 15:42
	G2 or G3? ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

NashM Joined: 2009-10-06 Posts: 2	Posted: Tue, 2009-10-06 17:52
	This would be a vanilla install of G3. I have G2 operational locally for the time being for review purposes and on first impressions I'm delighted. There seems to be two issues. When I run the install of G3 I get the 'fulltext' index error. This I believe was the issue resolved by your trouble ticket #774 to which I am referring to. When I run the install script with the new .sql file I get a syntax message. I will of course, have dropped the original table from the prior attempt at installing G3. I note that the G2 installation has created some 63 tables after the implementation of images and further modifications so I'm unable to comment as to whether the 15 tables created when running the G3 install script is the complete set required for a vanilla install. Because of the usual poor reporting of SQL syntax errors in such statements I thought I would ask yourselves if you were aware of this issue. At this stage I haven't analysed your .'sql' to see if I can locate the error on your behalf. Again I thank you for your assistance

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Tue, 2009-10-06 18:05
	That install.sql was added by the user who submitted the bug report. I know know nothing about that. Here is the fix in the code that the developer used: http://github.com/gallery/gallery3/commit/9d76797b17d65540a903ef37eee6edca3e83108b Get the latest experimental code and try installing again: http://codex.gallery2.org/Gallery3:Upgrading ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

rstander Joined: 2009-10-10 Posts: 1	Posted: Sat, 2009-10-10 16:02
	I had the same problem when I installed. For me the problem was that my default table type was INNODB. I just changed my default table type to MyIsam. That sorted it out. You can change it in the mysql config file. If that's not an option you'll have to change the scripts to specify the table type as myisam.

horustwohawks Joined: 2009-12-13 Posts: 6	Posted: Sun, 2009-12-13 18:34
	It appears the commits listed in your posted link are not included in gal3 Beta 3, which is weird because the date is relevant. ??? why ???

horustwohawks Joined: 2009-12-13 Posts: 6	Posted: Sun, 2009-12-13 18:49
	Followup... okay, not sure if its the links on the main page, but here's the deal... I had to go to the github tree and download the latest release (beta 3 in swing). Here's the link.. http://github.com/gallery/gallery3/tree/ This not only has all the sept changes, but its current thru today, and it installs just fine ;^) Cheers.

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Mon, 2009-12-14 14:31
	please don't post the same post in multiple theads: Beta3 was a milestone release and was released on 9/12. The fixes you linked to were done on 9/16. So there's no way they could have ever made it into B3. What probably happened is that once B3 was released, more people tried it, someone found the bug, reported it, and it was fixed a few days later. http://codex.gallery2.org/Gallery3:Upgrading ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

Installation fails with InnoDB engine (fulltext index unsupported) (#774)

XUser login