OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Need help with "ALTER TABLE; use DROP TABLE instead"

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Need help with "ALTER TABLE; use DROP TABLE instead"

Postby strangelove » Sun Mar 02, 2008 8:36 am

I am very new to MySQL. I am installing ojs at iipj.org/ojs. I cannot divine what to do in response to this error:

Errors occurred during installation:

* A database error has occurred: You can't delete all columns with ALTER TABLE; use DROP TABLE instead


I am installing to an existing mysql database that already has files related to the installation of my CMS software, Joomla!. I am assuming (hoping!!) that the ojs install process does not overwrite an existing DB but simply adds new entires under ojs_ or such.

Hopefully, it is a straightforward matter to fix this. Any assistance will be welcome.

Thank you,

Dr. Strangelove
University of Ottawa
http://www.strangelove.com
strangelove
 
Posts: 14
Joined: Sun Mar 02, 2008 8:27 am

Re: Need help with "ALTER TABLE; use DROP TABLE instead"

Postby asmecher » Sun Mar 02, 2008 11:01 am

Hi Dr. Strangelove,

You almost certainly have a table naming conflict -- and installing OJS over an existing database with tables of the same name will probably destroy the existing tables, so beware! I'd suggest creating a new database for OJS.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8453
Joined: Wed Aug 10, 2005 12:56 pm

Re: Need help with "ALTER TABLE; use DROP TABLE instead"

Postby strangelove » Sun Mar 02, 2008 8:36 pm

Thank you,

Fortunately OJS appears to have stopped short of installing over the existing database. The OJS team may want to add an additional alert at the install instructions, as for someone very new such as I it poses a risk -- for example, previously installing the Joomla! CMS system, which made it clear that it was going to create tables (?) under the jos_ name -- so I wrongly assumed that OJS would do likewise, and install within a database under some form of identified files such as ojs_. In other words -- to a VERY new user, it is unclear in the lexicon as to whether an install will 'wipe' a database or simply install within a database along side existing progs. Joomla!, for example, does the latter -- I am not experienced enough to be aware of the typical install situation. But thank you again.

Obviously, I am EXTREMELY new to db loading and such, so thank you for your guidance thus far.

My Web host, Blacksun.Ca will provide me with an upgrade that will enable two databases.

Is it possible to run a journal off one web server and have the ojs system installed at another location but 'pointing' to the journal's home server?

Michael
strangelove
 
Posts: 14
Joined: Sun Mar 02, 2008 8:27 am

Re: Need help with "ALTER TABLE; use DROP TABLE instead"

Postby asmecher » Sun Mar 02, 2008 10:08 pm

Hi Michael,

Agreed -- optional support for table prefixes would be nice, and we've got a Bugzilla entry for this at [url]http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2287[url]. However, I suspect we won't get to this in the near future. In general, I'd strongly suggest installing each application in a separate database; it makes processes like backups, restores, and upgrades much easier. Please let us know if you have any trouble with OJS once you've got a second database.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8453
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 4 guests