Page 1 of 1

Upgrade problem

Posted: Sun Oct 12, 2003 6:17 am
by rbrugman
Hello,
I tried upgrading from a pre-release cvs version of 0.3, and I when I try to run the updater SQL file, I get these errors:

Code: Select all

You have an error in your SQL syntax near ''comments'' at line 1
You have an error in your SQL syntax near ''categoryid'' at line 2
You have an error in your SQL syntax near ''type'' at line 4
Duplicate entry 'template' for key 1
Duplicate entry 'embed' for key 1
Duplicate entry 'indexFile' for key 1
Duplicate entry 'blockReferer' for key 1
You have an error in your SQL syntax near '; 
' at line 2
What can I do to fix this? I really would like to use the latest version.

Thanks,
Robert

Posted: Sat Nov 29, 2003 11:39 am
by jhermanns
I'm afraid you might have to do a fresh install and then import your data manually. I am thinking about writing an import-module that can connect to a given database and fetch the data from user-defined fields. Would come in handy...

Posted: Sat Nov 29, 2003 4:08 pm
by rbrugman
That's what I had to do. A nice upgrade option like phpbb uses would be great, and easy.

Robert