Radicore Forum: RADICORE Installation Issues » Error in SQL installation script

Home » RADICORE » RADICORE Installation Issues » Error in SQL installation script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in SQL installation script [message #1254]

Wed, 20 February 2008 14:22

Jovan
Messages: 24
Registered: February 2008
Location: Serbia

Junior Member

When I start upgrade my instalation on 1.33, I found in
/radicore/menu/sql/mysql/alter_table(2008-01-03).sql
sql instruction :

ALTER TABLE 'mnu_role_taskfield' DROP INDEX task_id_2;
Parser could not execute this ALTER TABLE because couldn't find task_id_2!

In /radicore/menu/sql/mysql/menu-shema.sql I found
CREATE TABLE ......
KEY 'task_id' ('task_id')

Is it necessary to drop index ('task_id') ????

Jovan

Report message to a moderator

Re: Error in SQL installation script [message #1255 is a reply to message #1254]

Wed, 20 February 2008 14:40

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

I only put that in there because somewhere along the line a second index was accidentally created on task_id with the name 'task_id_2'. It is not necessary to delete 'task_id', only 'task_id_2'. If this index does not exist then it does not matter.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Error in SQL installation script [message #1256 is a reply to message #1255]

Wed, 20 February 2008 19:38

Jovan
Messages: 24
Registered: February 2008
Location: Serbia

Junior Member

Thank you, I am testing dbprefix, I made two set of databases and use these databases with two different project, it works.

Jovan

Report message to a moderator

Previous Topic:	Problem with Dbprefix
Next Topic:	need some help here

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 11:14:13 EST 2024

Total time taken to generate the page: 0.01035 seconds