You are not logged in.
I imported a GLPI dump database from an old GLPI site into my new database for my new GLPI site.
I went to localhost/glpi and got the screen that said GLPI needs to be updated to be combatible with my new files. So, I click Update.
When I click Update, I receive an error (shown below). I am very new to everything, so I am unsure what to do. Any help? Thanks.
---
GLPI SETUP
Update
Database connection successful
Work in progress...
0.71 add active in glpi_rules_descriptions if not present Error during the database updateTable 'glpi.glpi_rules_descriptions' doesn't exist
Offline
It seems that this table doesn't exist in 0.83.x
I've 0.83.7 and there is no glpi_rules_descriptions
Ubuntu Server 11.04
Apache2 2.2.17
MySQL 5.1.63 PHP5.3.5
GLPI 0.83.7
Offline
It seems that this table doesn't exist in 0.83.x
I've 0.83.7 and there is no glpi_rules_descriptions
Gotcha. Yeah I am trying to upgrade to 0.71 since that is what the previous site used. Is there anything I can do to correct the error?
Offline
I don't know what glpi_rules_description was what for. But if I have to pass the error my first idea will be to remove the table. It's just an idea i've nerver tried, I began with the 0.83.7.
Ubuntu Server 11.04
Apache2 2.2.17
MySQL 5.1.63 PHP5.3.5
GLPI 0.83.7
Offline
Okay, I checked PHPMyAdmin. There is no table called glpi_rules_description. I guess I'd have to add it, but I have no idea what the structure should be or if this is the solution.
Offline
I've added the following code, which worked.
CREATE TABLE `glpi_rules_descriptions` (
`ID` int(11) NOT NULL auto_increment,
`FK_entities` int(11) NOT NULL default '-1',
`rule_type` smallint(4) NOT NULL DEFAULT '0',
`ranking` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`match` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
)
I guess I have to add a bunch of tables, but I don't get why this isn't done for me in the update. Now I'm getting this error:
.71 add recursive in glpi_reminder Error during the database updateTable 'glpi.glpi_reminder' doesn't exist.
Offline
I added these to solve the next error:
ALTER TABLE `glpi_reminder`
ADD `recursive` TINYINT( 1 ) NOT NULL DEFAULT '0'
and
ALTER TABLE `glpi_reminder`
ADD `private` TINYINT( 1 ) NOT NULL DEFAULT '1'
--------------------------
... new error:
0.7 alter ocs_link add index on last_ocs_update Error during the database updateTable 'glpi.glpi_ocs_link' doesn't exist
--- solved by renaming the table from ocslinks to ocs_links
--------------------------
... new error:
0.71 add flags_pivot in glpi_monitors Error during the database updateUnknown column 'flags_dvi' in 'glpi_monitors'
--- solved with this code:
ALTER TABLE `glpi_monitors`
ADD `flags_pivot` SMALLINT( 6 ) NOT NULL DEFAULT 0
--------------------------
... new error:
0.71 add FK_entities in glpi_kbitems Error during the database updateTable 'glpi.glpi_kbitems' doesn't exist
--- solved by renaming knowbaseitems to kbitems and adding this code:
ALTER TABLE `glpi_kbitems`
ADD `FK_entities` INT(11) NOT NULL DEFAULT 0 AFTER `ID`
-------------------------
... new error:
0.71 delete helpdesk injector user profile Table 'glpi.glpi_users_profiles' doesn't exist
Last edited by xx3ddfan (2013-04-18 17:46:59)
Offline
Hello
Did you try to update glpi version by version?
Ubuntu Server 11.04
Apache2 2.2.17
MySQL 5.1.63 PHP5.3.5
GLPI 0.83.7
Offline