You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2007-05-03 15:41:26

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

4203 Error during the database updateTable

Using Mysql 4.0.24_Debian-10ubuntu2.1-log

I have started the install process but it falls over at stage 3, it passes the diagnostics on all checks. The process fails to create the tables with an error:-

4203 Error during the database updateTable 'SSLInventory.glpi_config' doesn't exist.

Can anyone advise as to what is happening?

Charlie


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#2 2007-05-03 15:53:58

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

install process but you have an update process error ?
which version do you try to use ?
Do you make an installation or an update ?


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#3 2007-05-03 18:29:19

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

Thanks for such a swift response.

This is a new install, version 0.68.3.

Charlie


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#4 2007-05-03 19:14:55

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

and you choose install on the first step ?


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#5 2007-05-03 21:41:53

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

When I first browse to the URL I get the page GLPI SETUP- Language
I choose English (en_BR) and OK

Then I get the page GLPI SETUP - Licence
I accept and Continue

Then I get the Page GLPI SETUP - Beginning of the installation
I choose Installation

Then I get the page Beginning of the installation - Step 0
All tests perfect ! I choose Continue

Then I get the Page GLPI SETUP - Step 1
I enter the server ip address, the mysql user and password and then click continue

Then I get the Page GLPI SETUP - Step 2
It offers me a number of data bases including the one I created called SSLInventory. I select this one and Continue

Then I get the error:-
4203 Error during the database updateTable 'SSLInventory.glpi_config' doesn't exist

This also happens if instead of choosing a database I created I choose to create one and step 2


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#6 2007-05-03 23:22:22

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

hummm...
Are the tables created in the databases ?


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#7 2007-05-03 23:45:48

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: 4203 Error during the database updateTable

I think that you Mysql version is too old for GLPI

GLPI needs Mysql version >4.23


JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

#8 2007-05-04 08:10:11

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

No the tables do not get created. However if I choose to create a database rather then en existing one the data base gets crated but not the tables. As mentioned before this leads to the same error message.

I have to admin I had missed the version info. When I originally checked the readme it said version 4.1.13. My production server is 4.1.19 and I though OK that's fine. My test server is this one  4.0.24 and I hadn't registered that it was below the required version.

I have tried the same using the production server and version 4.1.19 and I get the same error.

Are you sure it requires 4.23? I can see nothing on the website to say this (I might have missed this though) and as I say the readme says >4.1.13?


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#9 2007-05-04 08:42:30

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

> 4.1.13 but you used a 4.0.24 smile


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#10 2007-05-04 08:47:37

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

Perhaps I'm being a bit stupid here but I can't see any MySQL version 4 above .1 at http://downloads.mysql.com/archives.php and the highest version of that is 4.1.21. Am I missing something?


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#11 2007-05-04 08:49:31

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

As mentioned above, this morning I also tried it using the production server and version 4.1.19 and I get the same error.

Sorry it seems as though our postings crossed.

Last edited by southcot (2007-05-04 08:51:05)


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#12 2007-05-04 08:52:37

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

One thing that puzzles me is where SSLInventory.glpi_config ought to be?


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#13 2007-05-04 08:52:43

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

The update of the default database don't seems to work.
It was the first time I see such a thing.
The mysql version does not seem to be a problem for such a thing.
You could try to do a manual import of the default database.


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#14 2007-05-04 08:53:42

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

I'd be happy to do that, can you point me to how I do this?


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#15 2007-05-04 11:23:46

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

I have looked all through the files and I can see glpi-0.68-empty.sql and glpi-0.68.1-empty.sql. Presumably it is the second one I use?


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#16 2007-05-04 12:05:18

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: 4203 Error during the database updateTable

the second one yes. Sorry I have to give you this information.


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#17 2007-05-04 12:20:27

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

Ok let you know how it goes. Thanks for the help.


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#18 2007-05-08 08:10:47

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

OK I have run the import manually and at first it didn't work. On investigation it failed on the alerts table creation.

Changing the line:-
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,

To:-
`date` timestamp NOT NULL,

Sorted it and checking the table after the current date and time get saved by default.

If you want to look at it, I have posted the full SQL dump from my database at:-

http://southcot.com/assets/glpi.txt

I've yet to start trying GLPI but am hopeful that all will go OK now. I will let you know.

Charlie

Last edited by southcot (2007-05-08 08:11:52)


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#19 2007-05-08 08:24:00

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

The web interface looks fine. Thanks for the help, sorry my French isn't up to this situation and glad your English was so good!

Charlie


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

#20 2007-05-08 12:41:41

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: 4203 Error during the database updateTable

Huml i think your probleme provide from your mysql version.

Current_Timestamp is supported only by Mysql version >4.1.2

http://dev.mysql.com/doc/refman/4.1/en/news-4-1-2.html


JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

#21 2007-05-08 12:53:56

southcot
Member
From: Gloucester UK
Registered: 2007-05-03
Posts: 43
Website

Re: 4203 Error during the database updateTable

OK problem is that on none of the sites I am running do I have access to MySQL later than 4.1.19. Presumably this is purely an issue of the dump, is there anything else that is broken by using the earlier version? As pointed out earlier readme says > 4.1.13.


Charlie - I'm in  love with GLPI

OS         : Windows 2003 Server
GLPI      : 0.70.2

Offline

Board footer

Powered by FluxBB