Menu

mySQL install errors

Help
Anonymous
2002-04-27
2002-05-05
  • Anonymous

    Anonymous - 2002-04-27

    When I try running the installation of phpwsgallery, I get an error that reads:

    mySQL says: Error number - 1146
    Table 'smotts.modules' doesn't exist
    There was an error in the install process.

    I made sure all configuration settings were set and correct. If I try running the instal again I get the following:

    mySQL says: Error number - 1146
    Table 'smotts.modules' doesn't existmySQL says: Error number - 1050
    Table 'mod_gallery_galleries' already existsmySQL says: Error number - 1050
    Table 'mod_gallery_albums' already existsmySQL says: Error number - 1050
    Table 'mod_gallery_media' already exists
    There was an error in the install process.

    Is there a table I should have created? Also, what is necessary to make the tables fit into my current DB table naming scheme?

    I apologize if this is answered elsewhere - I had no luck it if it is.

     
    • Andrew Fisher

      Andrew Fisher - 2002-04-27

      phpWebSite comes with a table named modules and the error says that table is missing. You'll have to recreate that table in order to stop seeing the error.

      The current table naming scheme in gallery is documented in phpWebSite like that for plug-ins. So there's no changing it.

       
    • Anonymous

      Anonymous - 2002-04-30

      I have the same errors, naturally... except that my table has a different name, of course...

      I am new to phpWebSite and also SQL, so bear with me.

      First I think this happened because I set up pspWebSite using the default table naming recommended for a new site... so my table is named...

      user.phpws_insert table name here.

      So when trying to install or use set up, naturally it is not finding

      user.modules

      because that happens to be named...

      user.phpws_modules   instead...

      So what is the best attack here?
      Rename the table for modules, or change the config or set up files to fine phpws_modules?

      Which documents for gallery will have to be altered, or will changing or creating a new table fix this problem?(if so how does one change the tables in phpMyAdmin(very new to this... will a simple edit of name do the trick?)
      FAQ installed fine, so it must be finding the phpws_ prefix on the sql tables... just need to change the gallery set up and install to do the same, somehow?

      thanks.

       

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.