Re: Restore the database of NGL

Posted by Verus Open Source Support on
URL: http://ngl.70.s1.nabble.com/Restore-the-database-of-NGL-tp7573375p7573380.html

Hi,
Your database must be upgraded. Since you have restored the database after installation, your database schema is still old. Please follow the below steps.
Step 1: Copy the below 3 files into C: drive
1. C:/InstallNGL3.0/scripts/AddedScripts.sql
2. C:/InstallNGL3.0/upgrade303/V304AddedScripts.sql
3. C:/InstallNGL3.0/upgrade303/SearchForm.sql


Step 2: Open your Command Prompt (Start->Run->Type command cmd-> Press Enter)
1. Type the following commands one after one
C:
cd \
cd "Program Files"
cd Postgresql
cd 8.3
cd bin
psql -d newgenlib -U postgres

The last command will prompt you to enter password. Enter newgenlib as password. This will connect you to newgenlib database using psql tool. Now type the following commands

\i C:/AddedScripts.sql
\i C:/V304AddedScripts.sql
\i C:/SearchForm.sql

Now Refresh your OPAC. I also hope you have run Indexer

Regards
NewGenLib Open Source Support Team

On 12/20/2012 07:46 AM, saren [via NewGenLib] wrote:

Thank for your assist,
That is great that I have successfully restore all backup data.
But I have one more problem, I got the error when I go to http://localhost:8080/newgenlibctxt.
Please see the screen shot bellow.Error_NGL.png

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Restore-the-database-of-NGL-tp7573375p7573379.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML