Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » Error in SQL installation script
Error in SQL installation script [message #1254] Wed, 20 February 2008 14:22 Go to next message
Jovan is currently offline  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
Re: Error in SQL installation script [message #1255 is a reply to message #1254] Wed, 20 February 2008 14:40 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
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.

Re: Error in SQL installation script [message #1256 is a reply to message #1255] Wed, 20 February 2008 19:38 Go to previous message
Jovan is currently offline  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
Previous Topic: Problem with Dbprefix
Next Topic: need some help here
Goto Forum:
  


Current Time: Tue Mar 19 06:51:09 EDT 2024

Total time taken to generate the page: 0.03093 seconds