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?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
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.
3.23.10-alpha (Suse 7.0) - never bothered with an update.
hmm...seems to me that temporary tables doesn't work correctly under 3.23.10. Unfortunately you have to update to use phpInv.