Menu

Database error after clean installation

foschi
2003-01-29
2003-02-03
  • foschi

    foschi - 2003-01-29

    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

      Stefan Cyris - 2003-01-30

      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

      foschi - 2003-01-30

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

       
      • Stefan Cyris

        Stefan Cyris - 2003-02-03

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

         

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.