Database error after clean installation

[foschi]

I get the following message after a clean install:

Database error in phpInv: Invalid SQL: CREATE TEMPORARY TABLE phpinv_tt06143b2422a94a80fb9af8ea2e403c1b (itemid INT (10) UNSIGNED not null, colid10 TEXT not null, colid9 TEXT not null, colid8 TEXT not null) TYPE=MyISAM
mysql error: You have an error in your SQL syntax near 'TEMPORARY TABLE phpinv_tt06143b2422a94a80fb9af8ea2e403c1b (itemid INT (10) UNSIG' at line 1
mysql error number: 1064
Date: 29.01.2003 @ 15:59
Script: /inventory/entry.php?hash=161a0a6373cd551ed22bde73a1660c31&categoryid=6
Referer: http://frank.essen.loca.net/inventory/category.php?hash=c57472f052ddd6aa0ebbf168b736cbfa

and wonder why.

Login/logout and configuration as admin works, but once I click on any item (eg. 'Rooms' in main screen using the  database included) I get the error above.

Any ideas+help?

[Stefan Cyris]

Which mysql version are you using ? You have to use at lease (as far as I know) 3.23.10 cause phpInv has to be able to create temporary tables.

[foschi]

3.23.10-alpha (Suse 7.0)  - never bothered with an update.

[Stefan Cyris]

hmm...seems to me that temporary tables doesn't work correctly under 3.23.10. Unfortunately you have to update to use phpInv.