topic Alfresco worked, but now it don't in Alfresco Archive

Alfresco worked, but now it don't

joris — Fri, 23 Nov 2007 11:23:06 GMT

I've installed Alfresco/MySQL on a Windows2003 SBS server. Everything worked just fine after the installation, but when I checked back a few days later Alfresco would not start anymore.I've tried reÃƒÂ¯nstalling Alfresco and restarting with an empty database, but I cannot get it to run. I am running

Re: Alfresco worked, but now it don't

joris — Fri, 23 Nov 2007 11:29:08 GMT

One more thing: the db_remove script produces an error message. Could that be related to this problem?

C:\Alfresco\extras\DATABA~1\mysql>db_remove
Deleting Alfresco database and user…
Enter password: *******
ERROR 1051 (42S02) at line 1: Unknown table '#sql-1b38_82'
Deleting indexes…‍‍‍‍‍

MySQL Administrator shows that after running this script the catalog Alfresco still exists, but it contains no tables. The tables do get recreated when I start Alfresco again.
When I try to drop the schema from MySQL administrator I get the same error.

Re: Alfresco worked, but now it don't

aatamer — Thu, 29 Nov 2007 15:00:46 GMT

To delete the alfresco DB on mySQL thoroughly, you will need to login as root or an administrator account.

Re: Alfresco worked, but now it don't

steve — Thu, 29 Nov 2007 17:16:45 GMT

Hi,

Try dropping the whole catalog in the MySQL Administrator and recreating it.

Steve

Re: Alfresco worked, but now it don't

joris — Fri, 30 Nov 2007 08:31:20 GMT

I could not drop the whole catalog in MySQL administrator for some reason, even under the root account. I switched over to SQL server and recreated the Alfresco db. Everything works fine now.

Thanks for your input.
>Joris

Re: Alfresco worked, but now it don't

christinedy — Fri, 30 Nov 2007 08:57:27 GMT

Hi all,

I'm just wondering, if I have the same error but I would like to keep my previous database, how can I revert to the old one?

What I did was, I change the repository configuration in custom-repository.properties from /home/alfresco/AlfrescoRepo/alf-data to /usr/alfresco/AlfrescoRepo/alf-data. I have also copied the whole repository from /home to /usr. When I start Alfresco again, there was an error. Now reconfigure back the repo to /home where it previously was. But I got this exception saying previous schema upgrade failed, I need to revert back.

Can you help me please… Thank you.

Re: Alfresco worked, but now it don't

mikeh — Fri, 30 Nov 2007 09:44:58 GMT

HI

See if there's a table called "alf_bootstrap_lock" in the Alfresco database.

If there is, drop it and try starting Alfresco again.

Thanks,
Mike

Re: Alfresco worked, but now it don't

johnwalsh — Tue, 11 Dec 2007 14:13:52 GMT

I had the same problem. Removing that table fixed it.

Thanks,
John