4203 Error during the database updateTable

southcot · 2007-05-03 15:41:26

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

MoYo · 2007-05-03 15:53:58

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

southcot · 2007-05-03 18:29:19

Thanks for such a swift response.

This is a new install, version 0.68.3.

Charlie

MoYo · 2007-05-03 19:14:55

and you choose install on the first step ?

southcot · 2007-05-03 21:41:53

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

MoYo · 2007-05-03 23:22:22

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

JMD · 2007-05-03 23:45:48

I think that you Mysql version is too old for GLPI

GLPI needs Mysql version >4.23

southcot · 2007-05-04 08:10:11

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?

MoYo · 2007-05-04 08:42:30

> 4.1.13 but you used a 4.0.24

southcot · 2007-05-04 08:47:37

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?

southcot · 2007-05-04 08:49:31

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)

southcot · 2007-05-04 08:52:37

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

MoYo · 2007-05-04 08:52:43

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.

southcot · 2007-05-04 08:53:42

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

southcot · 2007-05-04 11:23:46

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?

MoYo · 2007-05-04 12:05:18

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

southcot · 2007-05-04 12:20:27

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

southcot · 2007-05-08 08:10:47

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)

southcot · 2007-05-08 08:24:00

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

JMD · 2007-05-08 12:41:41

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

southcot · 2007-05-08 12:53:56

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.

Forum GLPI-Project

Announcement

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

4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

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

Re: 4203 Error during the database updateTable

Board footer